# 在服務(wù)器1初始化Swarm
docker swarm init --advertise-addr 172.25.0.19

# 執(zhí)行后會(huì)輸出類似以下內(nèi)容：
Swarm initialized: current node (hw0h813f85fgoonyifc5lsvpx) is now a manager.

To add a worker to this swarm, run the following command:

    docker swarm join --token SWMTKN-1-5jq69qtjwv9iod6hep02389p6lll2sa3grcp9xatnre15iwj33-7sr5tb2e9m28hbcztpe0qf5r3 172.25.0.19:2377

To add a manager to this swarm, run 'docker swarm join-token manager' and follow the instructions.

# 在服務(wù)器2加入Swarm
docker swarm join --token SWMTKN-1-5jq69qtjwv9iod6hep02389p6lll2sa3grcp9xatnre15iwj33-7sr5tb2e9m28hbcztpe0qf5r3 172.25.0.19:2377

# 加入成功后，會(huì)顯示：
This node joined a swarm as a worker.

# 創(chuàng)建overlay網(wǎng)絡(luò)
docker network create -d overlay --attachable mysql-cluster

docker run -d \
  --name mysql-master \
  --network mysql-cluster \
  -e MYSQL_ROOT_PASSWORD='8th3xY]:NA' \
  -e MYSQL_DATABASE=test \
  -e MYSQL_USER=replication \
  -e MYSQL_PASSWORD='@2X0wZY/rq' \
  -p 3307:3306 \
  mysql:8.0.35 \
  --server-id=1 \
  --log-bin=mysql-bin \
  --bind-address=0.0.0.0  # 允許所有IP連接

docker run -d \
  --name mysql-slave1 \
  --network mysql-cluster \
  -e MYSQL_ROOT_PASSWORD='8th3xY]:NA' \
  -e MYSQL_DATABASE=test \
  -e MYSQL_USER=replication \
  -e MYSQL_PASSWORD='@2X0wZY/rq' \
  mysql:8.0.35 \
  --server-id=2 \
  --log-bin=mysql-bin

docker run -d \
  --name mysql-slave2 \
  --network mysql-cluster \
  -e MYSQL_ROOT_PASSWORD='8th3xY]:NA' \
  -e MYSQL_DATABASE=test \
  -e MYSQL_USER=replication \
  -e MYSQL_PASSWORD='@2X0wZY/rq' \
  mysql:8.0.35 \
  --server-id=3 \
  --log-bin=mysql-bin

docker exec -it mysql-master mysql -uroot -p'8th3xY]:NA'

GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%';
FLUSH PRIVILEGES;

ALTER USER 'replication'@'%' IDENTIFIED WITH mysql_native_password BY '@2X0wZY/rq';
FLUSH PRIVILEGES;

mysql> SHOW MASTER STATUS;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000003 |     1007 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

docker exec -it mysql-slave1 mysql -uroot -p'8th3xY]:NA'

CHANGE MASTER TO
  MASTER_HOST='mysql-master',
  MASTER_USER='replication',
  MASTER_PASSWORD='@2X0wZY/rq',
  MASTER_LOG_FILE='mysql-bin.000003',
  MASTER_LOG_POS=1007;
START SLAVE;

docker exec -it mysql-slave2 mysql -uroot -p'8th3xY]:NA'

CHANGE MASTER TO
  MASTER_HOST='mysql-master',
  MASTER_USER='replication',
  MASTER_PASSWORD='@2X0wZY/rq',
  MASTER_LOG_FILE='mysql-bin.000003',
  MASTER_LOG_POS=1007;
START SLAVE;

SHOW SLAVE STATUS\G

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: mysql-master
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000003
          Read_Master_Log_Pos: 1007
               Relay_Log_File: acd704f632bf-relay-bin.000002
                Relay_Log_Pos: 326
        Relay_Master_Log_File: mysql-bin.000003
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1007
              Relay_Log_Space: 543
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 1
                  Master_UUID: dc75461f-f3e7-11ef-844a-02420a000202
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: 
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
       Master_public_key_path: 
        Get_master_public_key: 0
            Network_Namespace: 
1 row in set, 1 warning (0.00 sec)