# Master INSERT INTO test.person_01 (id, first_name, age, gender) VALUES (10, 'chenyuan', 20, 'M'); # Slave INSERT INTO test.person_01 (id, first_name, age, gender) VALUES (11, 'chenyuan11', 20, 'M'); # 2边数据一致就OK mysql>select*from person_01; +------+------------+------+--------+ | id | first_name | age | gender | +------+------------+------+--------+ |1| Bob |25| M | |2| Jane |20| F | |3| Jack |30| M | |4| Bill |32| M | |5| Nick |22| M | |6| Kathy |18| F | |7| Steve |36| M | |8| Anne |25| F | |1| Vernon |300| M | |10| chenyuan |20| M | |11| chenyuan11 |20| M | +------+------------+------+--------+ 11rowsinset (0.00 sec)
[root@a40a40c6bde7 mysql]# ip addr 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever 2: tunl0@NONE: <NOARP> mtu 1480 qdisc noop state DOWN group default qlen 1 link/ipip 0.0.0.0 brd 0.0.0.0 3: ip6tnl0@NONE: <NOARP> mtu 1452 qdisc noop state DOWN group default qlen 1 link/tunnel6 :: brd :: 21: eth0@if22: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default link/ether 02:42:ac:11:00:02 brd ff:ff:ff:ff:ff:ff link-netnsid 0 inet 172.17.0.2/16 brd 172.17.255.255 scope global eth0 valid_lft forever preferred_lft forever inet 172.17.0.99/32 scope global eth0 valid_lft forever preferred_lft forever
1 2 3 4 5 6 7 8 9 10 11 12 13
[root@a579aa381425 support-files]# ip addr 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever 2: tunl0@NONE: <NOARP> mtu 1480 qdisc noop state DOWN group default qlen 1 link/ipip 0.0.0.0 brd 0.0.0.0 3: ip6tnl0@NONE: <NOARP> mtu 1452 qdisc noop state DOWN group default qlen 1 link/tunnel6 :: brd :: 23: eth0@if24: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default link/ether 02:42:ac:11:00:03 brd ff:ff:ff:ff:ff:ff link-netnsid 0 inet 172.17.0.3/16 brd 172.17.255.255 scope global eth0 valid_lft forever preferred_lft forever
由此可见,现在172.17.0.99/32`是在master节点上。
验证
通过docker-mysql-client机器来登录数据库,下面显示登录成功。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
[root@8f31266d08fc bin]# ./mysql -h 172.17.0.99-u root -p Enter password: Welcome to the MySQL monitor. Commands endwith ; or \g. Your MySQL connection id is173 Server version: 5.6.45-log MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;'or'\h'for help. Type '\c'to clear the current input statement.
mysql>show variables like'server_id'; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>show variables like'server_id'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 62 Current database: ***NONE***