It’s all here! ! The principle and precautions of MySQL master-slave replication

Mysql TutorialThe column introduces the principle and precautions of master-slave replication Precautions (1) The operating system versions and digits of the master and slave servers are consistent; (2) The master and slave databases The versions must be consistent; (3) The data in the Master and Slave databases must be consistent; (4) The Master opens the binary log, and the server_id of the Master and Slave must be unique within the LAN; Configure master-slave replication steps Master database (1) Installation Database; (2) Modify the database configuration file, specify the server_id, open the binary log (log-bin); (3) Start the database, check which log is currently, position number How much is it; (4) Log in to the database and authorize the data replication user (the IP address is the IP address of the slave machine. If it is a two-way master-slave, here you also need to authorize the IP address of the machine. The IP address is the slave IP address); (5) Backup the database (remember to lock and unlock); (6) Send the backup data to the Slave; p>(7) Start the database; The above steps are successfully built for one-way master-slave, and the steps required to build a two-way master-slave: (1) Log in…