Shulou(Shulou.com)06/01 Report--

Editor to share with you how to build MySQL master-slave synchronization operation, I believe that most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Master-slave synchronization of MySQL 8.0

The process of master-slave synchronization (principle):

Master records changes in binary log files (binary log), that is, files specified by log-bin in configuration files, which are called binary log events (binary log events)

Master sends binary log files to slave

Slave reads the contents of the file and writes them to the relay log through the Icano thread.

Slave executes the events in the relay log to complete the local storage of the data.

What should be paid attention to by the master and slave of the building:

The operating system version and number of bits of the master-slave server are the same.

Master and Slave database versions should be the same

Data in Master and Slave databases should be consistent

Master enables binary logging, and the server_id of Master and Slave must be unique within the LAN.

2. Operations on MySQL Master / Slave build 2.1 Master

Modify the configuration of master (my.cnf) by adding the following:

[mysqld] log-bin=mysql-bin # id must be unique! Server-id=1

Restart master:

Systemctl restart mysql

Create a user in master for master-slave synchronization:

Mysql > # create user mysql > CREATE USER 'hugh'@'%' IDENTIFIED WITH mysql_native_password BY' 123456 users MySQL > # authorized user mysql > GRANT REPLICATION SLAVE ON *. * TO 'hugh'@'%';mysql > # Refresh permission mysql > FLUSH PRIVILEGES

View the status of the primary server:

Show master status

Record the values of File and Position and use them later.

2.2 actions on Slave

Modify the configuration of slave (my.cnf) by adding the following:

[mysqld] # id must be unique! Server-id=2

Restart slave:

Systemctl restart mysql

Log in to MySQL and run the following command to set the primary node parameters:

IP address of mysql > CHANGE MASTER TOMASTER_HOST='master', MASTER_USER='hugh',MASTER_PASSWORD='123456',MASTER_LOG_FILE='binlog.000006',MASTER_LOG_POS=856

The last two lines are the values of File and Position that we recorded.

View the status of master-slave synchronization:

Mysql > show slave status\ G

Check the following information. "yes" indicates that the construction is successful:

Slave_IO_Running: YesSlave_SQL_Running: Yes above are all the contents of the article "how to build master-slave synchronization operations in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.