主服务器（IP：*.206.247.69）设置
1. 配置 MySQL 以启用二进制日志

log-bin = mysql-bin
server-id = 1
binlog-do-db = zjcapp1

mysql -u root -p


USE zjcapp1;


2. 创建用于复制的用户

CREATE USER 'repl_user'@'%' IDENTIFIED BY 'mmbKcwAZtpCZm35S';
GRANT REPLICATION SLAVE ON *.* TO 'repl_user'@'%';
FLUSH PRIVILEGES;
3. 获取主服务器状态
SHOW MASTER STATUS;

+------------------+-----------+--------------+------------------+---------------------------------------------------------------------------------------------+
| File             | Position  | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set                                                                           |
+------------------+-----------+--------------+------------------+---------------------------------------------------------------------------------------------+
| mysql-bin.000007 | 31927|              |                  | 14e46eab-ebd5-11ef-9708-5c39bc000113:1-371649,
de558f31-f667-11ef-8806-5c39bc000113:1-74695 |
+------------------+-----------+--------------+------------------+---------------------------------------------------------------------------------------------+


从服务器（IP：*.206.247.61）设置
1. 配置从服务器的 server - id

server-id = 2
2. 配置从服务器连接主服务器
CHANGE MASTER TO
    MASTER_HOST = '45.153.131.78',
    MASTER_USER = 'repl_user',
    MASTER_PASSWORD = 'mmbKcwAZtpCZm35S',
    MASTER_LOG_FILE = 'mysql-bin.000009',
    MASTER_LOG_POS = 31927;

3. 启动从服务器复制进程
START SLAVE;

4. 检查从服务器复制状态
SHOW SLAVE STATUS\G;