mysql> CREATE TABLE `user` (
    -> `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> `name` varchar(255) NOT NULL DEFAULT '',
    -> `age` tinyint unsigned NOT NULL DEFAULT 0
    -> )ENGINE=BLACKHOLE charset=utf8mb4;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO `user` (`name`,`age`) values("itbsl", "26");
Query OK, 1 row affected (0.00 sec)

mysql> select * from user;
Empty set (0.00 sec)

$ cat /home/mysql/docker-data/3315/conf/my.cnf
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
symbolic-links=0
lower_case_table_names=1
server-id=1403314
log-bin=mysql-bin
binlog-format=ROW
auto_increment_increment=2 # 幾個(gè)主庫(kù)，這里就配幾
auto_increment_offset=1 # 每個(gè)主庫(kù)的偏移量需要不一致
gtid_mode=ON
enforce-gtid-consistency=true
binlog-do-db=order      # 要同步的數(shù)據(jù)庫(kù)

$ docker run --name mysql3314 -p 3314:3306 --privileged=true -ti -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=order -e MYSQL_USER=user -e MYSQL_PASSWORD=pass -v /home/mysql/docker-data/3314/conf:/etc/mysql/conf.d -v /home/mysql/docker-data/3314/data/:/var/lib/mysql -v /home/mysql/docker-data/3314/logs/:/var/log/mysql -d mysql:5.7

mysql> GRANT REPLICATION SLAVE,FILE,REPLICATION CLIENT ON *.* TO 'repluser'@'%' IDENTIFIED BY '123456';
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> change master to master_host='172.23.252.98',master_port=3315,master_user='repluser',master_password='123456',master_auto_position=1;
Query OK, 0 rows affected, 2 warnings (0.03 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

auto_increment_offset=2 # 每個(gè)主庫(kù)的偏移量需要不一致

mysql> create table t_order(id int primary key auto_increment, name varchar(20));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t_order(name) values("A");
Query OK, 1 row affected (0.01 sec)
mysql> insert into t_order(name) values("B");
Query OK, 1 row affected (0.00 sec)
mysql> select * from t_order;
+----+------+
| id | name |
|  2 | A    |
|  4 | B    |
2 rows in set (0.00 sec)

mysql> select * from t_order;
+----+------+
| id | name |
|  2 | A    |
|  4 | B    |
2 rows in set (0.00 sec)

mysql> insert into t_order(name) values("E");
Query OK, 1 row affected (0.00 sec)
|  5 | E    |
3 rows in set (0.00 sec)

$ sudo apt-get install -y keepalived

$ cat /etc/keepalived/keepalived3314.conf
! Configuration File for keepalived
#簡(jiǎn)單的頭部，這里主要可以做郵件通知報(bào)警等的設(shè)置，此處就暫不配置了；
global_defs {
        #notificationd LVS_DEVEL
}
#預(yù)先定義一個(gè)腳本，方便后面調(diào)用，也可以定義多個(gè)，方便選擇；
vrrp_script chk_haproxy {
    script "/etc/keepalived/chkmysql.sh"  #具體腳本路徑
    interval 2  #腳本循環(huán)運(yùn)行間隔
}
#VRRP虛擬路由冗余協(xié)議配置
vrrp_instance VI_1 {   #VI_1 是自定義的名稱；
    state BACKUP    #MASTER表示是一臺(tái)主設(shè)備，BACKUP表示為備用設(shè)備【我們這里因?yàn)樵O(shè)置為開啟不搶占，所以都設(shè)置為備用】
    nopreempt      #開啟不搶占
    interface eth0   #指定VIP需要綁定的物理網(wǎng)卡
    virtual_router_id 11   #VRID虛擬路由標(biāo)識(shí)，也叫做分組名稱，該組內(nèi)的設(shè)備需要相同
    priority 130   #定義這臺(tái)設(shè)備的優(yōu)先級(jí) 1-254；開啟了不搶占，所以此處優(yōu)先級(jí)必須高于另一臺(tái)

    advert_int 1   #生存檢測(cè)時(shí)的組播信息發(fā)送間隔，組內(nèi)一致
    authentication {    #設(shè)置驗(yàn)證信息，組內(nèi)一致
        auth_type PASS   #有PASS 和 AH 兩種，常用 PASS
        auth_pass asd    #密碼
    }
    virtual_ipaddress {
        172.23.252.200    #指定VIP地址，組內(nèi)一致，可以設(shè)置多個(gè)IP
    }
    track_script {    #使用在這個(gè)域中使用預(yù)先定義的腳本，上面定義的
        chk_haproxy
    }

    #notify_backup "/etc/init.d/haproxy restart"   #表示當(dāng)切換到backup狀態(tài)時(shí),要執(zhí)行的腳本
    #notify_fault "/etc/init.d/haproxy stop"     #故障時(shí)執(zhí)行的腳本
}

$ cat /etc/keepalived/chkmysql.s.sh
#!/bin/bash

mysql -uroot -proot -P 3314 -e "show status;" > /dev/null 2>&1
if [ $? == 0 ];
then
        echo "$host mysql login successfully"
        exit 0
else
        echo "$host login failed"
        killall keepalived
        exit 2
fi