MySQL Master-Slave introduction

Binlog file logging is a binary file
Master needs to open Binlog to start
Relaylog Final Log in

Application scenario make a backup of the data 1. Master Read and write operations if hardware is damaged you can provide services immediately
2. Do a backup from only read-only access
Preparatory work

Master and slave all start MySQL

Configure the Primary

A restart is required after modifying the configuration file/etc/my.cnf changes

/data/mysql next production of new documents

Data backup

Create a new database

Recovering a Database

The master-slave reference database is aming
Create a user-master synchronization

Lock table does not write first

Show Master status location filename

Do data synchronization
Configuration from

Editing a configuration file

Restart Service

Transferring files to the Lord's database file

Alias

Create a library

Recovering a Database

Log on from the database stop slave

Check whether the show slave status\g is successful two Yes

Status Error Information

In the Lord's execution

Test Master

Test

Query operations

Querying from a database

Delete data

From the data query

Delete a table

Query from top

Delete the error from the Lord after deleting the table directly from the top

Master-Slave disconnection
Try to fix

There's still a mistake.

From the new master view Fielname location

Stop slave first
In the re-change master

Re-View status

Common Configuration Parameters

In do-Define the library to be synchronized multiple separated by commas
From server do_table
Wild_do for aming libraries.
Ignore Ignore table
MySQL master-slave configuration UUID Same error resolution
When configuring MySQL master and slave, because it is a copy of the MySQL directory, resulting in the same master-slave MySQL uuid, slave_io can not start, error message as follows:
The slave I/O thread stops because master and slave have equal MySQL server UUIDs; These uuids must is different for replication to work.
Workaround: Modify the value of the UUID in the auto.cnf file in MySQL data directory, make the two MySQL different, modify and restart the MySQL service.

MySQL Master-Slave introduction