Shulou(Shulou.com)05/31 Report--

This article mainly introduces the common architecture of MySQL replication, which 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.

MySQL replication technology has a variety of implementation architectures in practical applications, and the common ones are as follows:

1)。 A set of one slave, that is, a master server and a slave server, is the most common architecture.

2)。 One master and multiple slaves, that is, one master server and two or more slave servers. It is often used in the business environment where the read and write operations are not frequent and the query volume is relatively large.

3)。 Master and master backup, also known as double master backup, that is, two MySQL servers regard each other as their own master server and replicate as each other's slave server at the same time. It is mainly used in the environment with high requirements for MySQL write operation to avoid the single point of failure of MySQL.

4)。 Double master and multi-slave means dual master and mutual backup, and then multiple slave servers, which are mainly used in business environments that require high MySQL write operations and a large number of queries at the same time.

In fact, the master / slave structure can be flexibly combined according to the specific situation, but it remains the same, and there are some rules that must be followed before various deployments of MySQL replication:

1)。 Only one master server can write at a time

2)。 A master server can have multiple slave servers

3)。 Whether it is the master server or the slave server, make sure that the ID of their respective servers is unique, otherwise there will be problems with the dual master and mutual backup.

4)。 A slave server can pass the update information it gets from the master server to other slave servers, and so on.

Thank you for reading this article carefully. I hope the article "what are the common structures of MySQL replication" shared by the editor will be helpful to you. At the same time, I also hope that you will support us 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.