Master-slave Hot Standby (automatic synchronization) configuration of MySQL in Linux

Individuals configured successfully on 5.5

 

Environment Description: MASTER: 192.168.1.200slave: 192.168.1.132

 

MySQL master configuration: Configure My. CNF:

 

# Vi/etc/My. CNF

 

[Mysqld] datadir =/var/lib/mysqlsocket =/var/lib/MySQL. sockuser = MySQL # disabling symbolic-links is recommended to prevent assorted security groups-links = 0server-id = 200log-bin = mysql-binrelay-log = relay-binrelay-log-Index = relay-bin- index

 

* After configuration, restart the MySQL Service of the master !!!

 

Service mysqld restart

 

// -------------------------------------------------- MySQL slave configuration: Configure My. CNF:

 

# Vi/etc/My. CNF

 

[Mysqld] datadir =/var/lib/mysqlsocket =/var/lib/MySQL. sockuser = MySQL # disabling symbolic-links is recommended to prevent assorted Security riskssymbolic-links = 0server-id = 132log-bin = mysql-binreplicate-do-DB = testlog-slave-Updates =

 

* After configuration, restart the MySQL service of slave !!!

 

Service mysqld restart

 

// -------------------------------------------------- Log on to the slave and run the following command:

 

Mysql> stop slave; mysql> change master to master_host = '2017. 168.1.200 ', master_user = 'root', master_password = '000000'; mysql> Start slave; mysql> show slave status \ G;

 

Check whether the two items are yes and yes is normal. Slave_io_running: yesslave_ SQL _running: Yes