主机 10。0。4。149mysql> show master status;
+----------------+----------+-------------------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+-------------------------+------------------+
| log_bin.000055 | 297 | ccxyaccount,ccxyaccount | |
+----------------+----------+-------------------------+------------------+
1 row in set (0.00 sec)mysql> show master status \G;
*************************** 1. row ***************************
File: log_bin.000055
Position: 416
Binlog_Do_DB: ccxyaccount,ccxyaccount
Binlog_Ignore_DB:
1 row in set (0.00 sec)ERROR:
No query specified
值得说明的是之前我配置10。。149 和10。。159的主 从复制成功 , 2机器主主复制也成功。
现在配置1主多从发现失败。不知道原因在哪。 另2台从机器的show salve status \G在下面;
(3台机器 的从机器slave start都是成功的 。 现在很困惑 如何找出毛病。 ---现在数据不能从主机到从机器)
+----------------+----------+-------------------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+-------------------------+------------------+
| log_bin.000055 | 297 | ccxyaccount,ccxyaccount | |
+----------------+----------+-------------------------+------------------+
1 row in set (0.00 sec)mysql> show master status \G;
*************************** 1. row ***************************
File: log_bin.000055
Position: 416
Binlog_Do_DB: ccxyaccount,ccxyaccount
Binlog_Ignore_DB:
1 row in set (0.00 sec)ERROR:
No query specified
值得说明的是之前我配置10。。149 和10。。159的主 从复制成功 , 2机器主主复制也成功。
现在配置1主多从发现失败。不知道原因在哪。 另2台从机器的show salve status \G在下面;
(3台机器 的从机器slave start都是成功的 。 现在很困惑 如何找出毛病。 ---现在数据不能从主机到从机器)
mysql> slave stop;
Query OK, 0 rows affected (0.01 sec)mysql> change master to master_host='10.0.4.149',master_user='back',master_password='back',master_log_file='log_bin.000055' ,master_log_pos=297;
Query OK, 0 rows affected (0.00 sec)mysql> slave start;
Query OK, 0 rows affected (0.00 sec)请注意 上面表示操作是成功 的 mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.0.4.149
Master_User: back
Master_Port: 3306
Connect_Retry: 120
Master_Log_File: log_bin.000055
Read_Master_Log_Pos: 297
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 233
Relay_Master_Log_File: log_bin.000055
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: ccxyaccount,ccxyaccount
Replicate_Ignore_DB: mysql,test,mysql,test
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: 297
Relay_Log_Space: 233
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
1 row in set (0.00 sec)ERROR:
No query specifiedmysql> 上面表示本台从机器是没有问题 (我是这样理解的俄)
mysql> slave stop;
Query OK, 0 rows affected (0.00 sec)mysql> change master to master_host='10.0.4.149',master_user='back',master_password='back',master_log_file='log_bin.000055',master_log_pos=297;
Query OK, 0 rows affected (0.02 sec)mysql> slave stop;
Query OK, 0 rows affected, 1 warning (0.00 sec)前面操作也是成功的俄
mysql> change master to master_host='10.0.4.149',master_user='back',master_password='back',master_log_file='log_bin.000055',master_log_pos=297;
Query OK, 0 rows affected (0.00 sec)mysql> slave start;
Query OK, 0 rows affected (0.00 sec)mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 10.0.4.149
Master_User: back
Master_Port: 3306
Connect_Retry: 120
Master_Log_File: log_bin.000055
Read_Master_Log_Pos: 297
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: log_bin.000055
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB: ccxyaccount,ccxyaccount
Replicate_Ignore_DB: mysql,test,mysql,test
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: 297
Relay_Log_Space: 98
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: NULL
1 row in set (0.00 sec)ERROR:
No query specifiedmysql> 可以知道这个从机器是失败的
Slave_IO_Running: No-------表示不能同步
Slave_SQL_Running: Yes
根据官方文档 ,是可以做到 俄。
现在不知道如何fix这个错误 ??当前问题: 主机器数据 不能单向同步到从机器(2台)
? (不知道如何改正错误 )
the third machine should be added user priviledges.