mycat结合MySQL双主实现读写分离(2)

步骤省略,详细内容可以参考上面的MySQL安装

使用mysql的客户端连接mycat

cd /data/app/mysql/
./bin/mysql -uroot -p -P 8066 -h 192.168.56.11 ##连接mycat,初始密码123456
mysql> show databases;
+----------+
| DATABASE |
+----------+
| TESTDB ? |
+----------+
1 row in set (0.00 sec)

mysql> use TESTDB;

mysql> insert into temp2(nname) values('eee');
Query OK,1 row affected (0.09 sec)
mysql> insert into temp2(nname) values('ggg');
Query OK,1 row affected (0.01 sec)

linux-node3 slave端查看数据是否同步

mysql> select * from test.temp2;
+----+-------+
| id | nname |
+----+-------+
| ?1 | bbb ? |
| ?2 | ddd ? |
| ?4 | fff ? |
| ?5 | eee ? |
| ?7 | ggg ? |
+----+-------+
5 rows in set (0.00 sec)

（编辑：ASP站长网）