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

This article mainly introduces the type of MySQL master-slave replication and the principle of separation of reading and writing, which involves things, learned from the theoretical knowledge, there are many books, literature for your reference, in terms of practical significance, accumulated years of practical experience can be shared with you.

The type of MySQL master-slave replication (default) statement-based replication executed on the master cloud server, execute the same statement from the slave server to copy the changed content to the mixed type of replication from the slave server. Once it is found that the statement-based replication cannot be accurately replicated, the row-based replication master-slave replication will be adopted.

MySQL read-write separation principle read-write separation is the process of writing only on the master server, reading only the master database on the slave server to process transactional queries, while select query database replication is used to synchronize changes caused by transactional queries to the separation of read and write from the database in the cluster

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.