mysql5.7主从复制,基于GTID的复制,MysqlProxy实现读写分离

server10和server11安装mysql:

yum install -y mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-libs-5.7.17-1.el6.x86_64.rpm mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm /etc/init.d/mysqld start #初始化（方式一） grep password /var/log/mysqld.log mysql_secure_installtion mysql -p #初始化方式二： /etc/init.d/mysqld start mysql -p mysql> ALTER USER root@localhost identified by 'Workhard@345'; mysql> flush privileges; 主从复制 yum install -y mysql-com