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

The following brings you the separation of MySQL master-slave replication type, process, reading and writing, hoping to bring some help to you in practical application. MYSQL involves more things, there are not many theories, and there are many books on the Internet. today, we use the accumulated experience in the industry to do an answer.

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 working process of row-based replication master-slave replication will be adopted.

MySQL principle of read-write separation is to write only on the master server and only read the master database on the slave server to process transactional queries, so that database processing select query database replication is used to synchronize changes caused by transactional queries to slave databases 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.