首先,我在Master上的复制configuration:
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)