Detailed analysis of MySQL replication settings

The following articles mainly introduce MySQL replication settings. We all know that MySQL replication settings often appear in practical use. If you are using MySQL replication settings, the following article will be meaningful to you.

1. Stop the MySQL Service

2. MySQL copies all files, including data files.

3. The my. ini of the master does not need to be modified. The master mode has been configured by default:

Log-bin = MySQL-bin

Binlog_format = mixed

Server-id = 1

4. modify my. ini of slave as follows:

Remove the master configuration in step 3 and add the following content:

Server-id = 2

Master-host = localhost

Master-user = replication

Master-password = replication

Master-port = 3306

Replicate-do-db = database to be copied by MySQL

Master-connect-retry = 10

Modify the port to 3307,

Add a replication user for MySQL replication.

5. Restart the master and slave databases.

6. If the master is successfully set, run the show master status Command to view the following information:

 
 

  
  
+------------------+----------+--------------+------------------+   
  
  
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |   
  
  
+------------------+----------+--------------+------------------+   
  
  
| MySQL-bin.000007 | 39259 | | |   
  
  
+------------------+----------+--------------+------------------+   
  
  
1 row in set (0.00 sec)  
 
 

7. If all settings are successful, run the show slave status command in slave. The corresponding configuration parameters are displayed, indicating that both the master and slave are set properly.

8. If you want TO use the change master to command TO modify the corresponding parameters, you must first use the stop slave command TO stop the slave. After the modification is successful, run start slave and start the slave service.

Note: It is most convenient to stop the MySQL service directly without the need to lock the table. The above content is an introduction to MySQL replication settings. I hope you will find some gains.