《Mysql-MHA高可用实验测试-主从复制搭建》由会员分享，可在线阅读，更多相关《Mysql-MHA高可用实验测试-主从复制搭建（6页珍藏版）》请在金锄头文库上搜索。
1、Mysql-MHA高可用实验测试-主从复制搭建Mysql-MHA高可用实验测试-主从复制搭建环境信息：1.安装mysql这里就不再介绍mysql的安装2.配置mysql主从a)配置fmaster上操作：?1rootmaster mysql# vi /etc/f添加如下：?123456789server_id =1log-bin=mysql-binbinlog_format=mixedslave1上操作rootslave1 # vi /etc/f添加如下：?1234567server_id =2log-bin=mysql-binbinlog_format=mixedrelay_log_purge
2、=0slave2上操作乐淘棋牌http:/添加如下：?123456789101112131415rootslave2 # vi /etc/fserver_id =3log-bin=mysql-binrelay_log=mysql-relay-binmax_relay_log_size=2Glog_slave_updates=1read_only=1relay_log_purge=0注意：以上配置完之后要重启数据库b)搭建master上操作：?12345678910111213141516171819202122232425262728293031mysql grant replication
3、slave on *.* to mysql192.168.180.% identified by mysql;mysql flush privileges;mysql stop slave;#设置复制权限账号mysql grant all privileges on *.* to mha192.168.180.% identified by mysql;mysql reset master;mysql show master statusG;* 1. row *File: mysql-bin.000001Position: 154Binlog_Do_DB:Binlog_Ignore_DB:Ex
4、ecuted_Gtid_Set:1 row in set (0.00 sec)ERROR:No query specifiedslave1 上操作：?123456789101112131415mysql grant replication slave on *.* to mysql192.168.180.% identified by mysql;mysql grant all privileges on *.* to mha192.168.180.% identified by mysql;mysql flush privileges;mysql reset master;mysql sto
5、p slave;mysql change master to master_host=192.168.180.56,master_port=3306,master_user=mysql,master_password=mysql;mysql start slave;mysql show slave statusG;slave2上操作:?12345678910111213mysql reset master;mysql stop slave;mysql grant all privileges on *.* to mha192.168.180.% identified by mysql;mysq
6、l flush privileges;mysql change master to master_host=192.168.180.56,master_port=3306,master_user=mysql,master_password=mysql;mysql start slave;mysql show slave statusG;3.测试：在master上创建一个test数据库，在test里创建一个test的表master上操作移动电玩城http:/?123456789101112131415161718192021222324252627282930313233343536373839
7、4041ysql create database test;Query OK, 1 row affected (0.14 sec)mysql use test;Database changedmysql show tables;Empty set (0.00 sec)mysql create table test(id int);Query OK, 0 rows affected (0.04 sec)mysql insert into test values(1);Query OK, 1 row affected (0.01 sec)slave1，slave2上查看是否同步过去mysql sh
8、ow databases;+-+| Database |+-+| information_schema | mysql | performance_schema | sys | test |+-+5 rows in set (0.00 sec)?12345678910111213141516171819202122232425262728293031323334353637mysql use test;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql show tables;+-+| Tables_in_test |+-+| test |+-+1 row in set (0.00 sec)mysql select * from test;+-+| id |+-+| 1 |+-+1 row in set (0.00 sec)mysql至此mha 主从同步配置成功
