MySQL Group Replication (referred to as MGR) is the MySQL official in December 2016 launched a new high availability and high expansion of the solution. MySQL group replication provides a highly available, highly scalable, highly reliable MySQL cluster service.
High consistency, Based on the original copy and paxos protocol group replication technology, and to provide a plug-in to provide consistent data security assurance;
High fault tolerance, As long as not most of the nodes can be broken to continue to work, there are automatic detection mechanism, when different nodes have a resource contention conflict, there will be no error, according to the first priority principle to deal with, and built-in automated brain crack protection mechanism ;
High scalabilityThe new nodes are automatically added. When the new node is added, it will automatically synchronize from other nodes until the new node and other nodes are consistent. If a node is removed, the other nodes will automatically update the group information. , Automatically maintain the new group information;
High flexibility, Single master mode and multi-master mode, single master mode, will automatically select the main, all the update operations are carried out on the main; multi-master mode, all servers can handle the update operation at the same time.
MGR is an important direction for the future development of MySQL database. Jingdong Mall basic platform database technology department to make a positive response to this, in the shortest time the project, the MGR research and testing. In order to make research and follow-up operation and maintenance promotion work more convenient, hereby the MGR official documents translated into Chinese, for the industry reference. As the content of this chapter is more, the translation time is urgent, although we try to be careful, but still difficult to avoid the wrong and unsatisfactory place, in this welcome the reader criticism.
Note: This article from the Jingdong basic platform. As the primary department of Jingdong and the cornerstone of technology, the basic platform department focuses on four technical directions: data center cluster management; storage and database technology; machine learning and knowledge engineering; mall overall structure. The underlying platform continues to operate multiple data centers, tens of thousands of servers, and a range of core systems. Jingdong Mall Chief Architect Liu Haifeng served as head of the department.