61.mysql Master-Slave Correlation (ii)

First, the main MySQL master

Both MySQL can read and write, the main preparation, the default is only one (Mastera) responsible for data writing, the other (Masterb) standby;

Second, MySQL read and write separation

First, the master and slave, the read operation will be executed from the top, write the operation in the Lord to execute

• Mysql-proxy MySQL official product.
• Mycat Open source distributed management middleware. Third, MySQL a master more from

  With one master one from similar, create multiple from library

  Iv. Ring Master and slave

  A>b>c>a
  Set separately
  A Master B from
  b Master C from
  C Master A From

61.mysql Master-Slave Correlation (ii)