mysql replication guide

The most basic MMM installation must require at least 2 database servers and a monitoring server the MySQL cluster environment to be configured contains four database servers and a monitoring server, as follows: function IP

In the previous article, "MySQL database Transaction and Replication" analyzes how to ensure the consistency between binlog and transactional data during MySQL replication, this paper further analyzes the need to consider what aspects are needed to

First, the MySQL database master-slave replication principle process:MySQL's master-slave replication is an asynchronous replication process where data is copied from one MySQL database (master) to another MySQL database (slave), and the process of

In the previous article, "MySQL database Transaction and Replication" analyzes how to ensure the consistency between binlog and transactional data during MySQL replication, this paper further analyzes the need to consider what aspects are needed to

MySQL replication on Ubuntu12.04 I. Introduction MySQL Replication is based on the binnary logging mechanism to synchronize data between the master and slave. Both mechanism, configuration, and operation and maintenance are much simpler and more

Brief introduction I know there are a lot of articles and guidelines for implementing master-from replication on the Internet. In master-from replication, the host affects the machine. But any changes from the database will not affect the primary

MySQL replication Problem of the last one, on the two-way synchronous replication architecture design of some design points and constraints.Problems and constraintsThe two-master double-write and bidirectional synchronization scenarios of the

1. Set the Servie-id value of main Library master and turn on Bin-log function parameterVi/etc/my.cnfTo modify the parameters of the MY.CNF:[Mysqld]Server-id=1 //Each library must have a different Server-idLog-bin=mysql-bin2. Check that the

  [Content Overview] This book is designed and implemented by a MySQL expert from Sun's Chinese Engineering Institute. The author divides the complex MySQL kernel into multiple functional subsystems to resolve various difficulties in understanding

Haven't written technical articles for a long time, because have been thinking "back-end distributed" This series exactly how to write just right. Recently, the basic idea is that "back-end distributed" includes "Distributed Storage" and