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

This article mainly introduces the advantages of mysql master-slave synchronization, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1. Read-write separation to relieve the pressure on the database (the main database is used for data writing and the database is used for data reading).

2. One master and multiple slaves, the system has high expansibility and availability.

3. Data backup and disaster recovery, double activity in different places, to ensure that the main database is abnormally switched at any time, and improve the fault tolerance of the system.

Example

From the execution of mysql-uroot show slave stauts\ G to see whether there is Slave_IO_Running: Yes Slave_SQL_Running: Yes also need to pay attention to Seconds_Behind_Master: 0 / / master-slave delay time Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: binlog-do-db= on the master server / / only synchronize the specified library binlog-ignore-db= / / ignore the specified library replicate_ on the slave server Do_db= / / only synchronize the specified library replicate_ignore_db= / / ignore the specified library replicate_do_table= replicate_ignore_table= replicate_wild_do_table= / / such as aming.% Support for mysql-uroot aming select count (*) from db on the wildcard% replicate_wild_ignore_table= host Truncate table db; to continue from mysql-uroot aming select count (*) from db; to continue to view the db form from above Thank you for reading this article carefully. I hope the editor's article "what are the advantages of mysql master-slave synchronization" will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.