首先,我在 Master 上的复制配置:
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 1
auto-increment-offset = 1
log-bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 5
binlog_format = mixed
max_connections=500
innodb_buffer_pool_size=5G
tmpdir=/mnt/data_mysql/mysql_tmp
slow_query_log_file = /var/log/mysql_log/slow_query.log
slow_query_log = OFF
long_query_time = 50
sync_binlog = 1
innodb_flush_method = O_DIRECT
在从属服务器上:
server-id = 73
replicate-same-server-id = 0
replicate-do-db=rep_1624
auto-increment-increment = 1
auto-increment-offset = 1
#slave-skip-errors = 1062
binlog_format = mixed
long_query_time = 50
expire_logs_days = 5
所有表都使用 InnoDB。当我启动从属服务器时,它运行良好,IO 和 SQL 正在运行,bin 光标正确增加,但某些表未同步。mysql 日志中没有错误。表的大小超过 1GB。
从属状态:
Slave_IO_State: Waiting for master to send event
Master_Host: report.****
Master_User: replica
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.004153
Read_Master_Log_Pos: 96627039
Relay_Log_File: slave-relay.000002
Relay_Log_Pos: 10486693
Relay_Master_Log_File: mysql-bin.004153
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: rep_1624
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: 96627039
Relay_Log_Space: 10486862
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: baeb9b03-c1a3-11e4-b6e1-220b8ecd7e
Master_Info_File: /mnt/data_mysql/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
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
1 row in set (0.00 sec)