mysql 主从分离5.6_MySQL5.6主从复制及读写分离的实现

MySQL5.6主从复制及读写分离的实现MySQL5.6基于GTID的主从复制及使用a..

MySQL5.6

一、amoeba

Amoeba

5.

+----+-------------+-----------+------+---------+---------+-----------------------------------------------------------------------------+------------------+

| Id | User        | Host      | db  | Command | Time    | State                                                                      | Info             |

+----+-------------+-----------+------+---------+---------+-----------------------------------------------------------------------------+------------------+

|  4| system user |           | NULL |Connect |     395 | Waiting for master tosend event                                           | NULL             |

|  5| system user |           | NULL |Connect |     225 | Slave has read allrelay log; waiting for the slave I/O thread to update it | NULL             |

|  6| system user |           | NULL |Connect | -252924 | Waiting for an event from Coordinator                                       | NULL             |

|  7| system user |           | NULL |Connect | -253320 | Waiting for an event from Coordinator                                       | NULL             |

|  9| root        | localhost | NULL |Query   |       0 | init                                                                        |show processlist |

+----+-------------+-----------+------+---------+---------+-----------------------------------------------------------------------------+------------------+

dbServers.xml

test

amoeba