我先贴下我的代码
主 192.168.0.32 版本5.1
被 192.168.0.128 版本5.5主my.cnf 添加代码
log-bin=/var/log/mysql/updatelog
server-id = 1
binlog-do-db=KAPAI
binlog-ignore-db=mysql从my.cnf 添加代码
server-id=2
log-bin=mysql-bin
master-host=192.168.0.32
master-user=testback
master-password=testback
master-port=3306
replicate-do-db=KAPAI #需要备份的数据库名
replicate-ignore-db=mysql #忽略的数据库
master-connect-retry=60 #如果从服务器发现主服务器断掉,重新连接的时间差(秒)
log-slave-updates #这个参数一定要加上,否则不会给更新的记录些到二进制文件里
slave-skip-errors #是跳过错误,继续执行复制操作
错误表现:
slave stopmysql> CHANGE MASTER TO MASTER_HOST='192.168.0.32',MASTER_USER='testback',MASTER_PASSWORD='testback',MASTER_LOG_FILE='log-bin.000018',MASTER_LOG_POS=106;
Query OK, 0 rows affected (0.10 sec)mysql> slave start;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.0.32
Master_User: testback
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: log-bin.000018
Read_Master_Log_Pos: 106
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: log-bin.000018
Slave_IO_Running: No
Slave_SQL_Running: No
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: 106
Relay_Log_Space: 106
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
求大神们看下 网上搜的都是 说添加 CHANGE MASTER TO MASTER_HOST='192.168.0.32',MASTER_USER='testback',MASTER_PASSWORD='testback',MASTER_LOG_FILE='log-bin.000018',MASTER_LOG_POS=106; 这段 但是我已经添加无数次了我看到状态 Last_IO_Error: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400 这个有错误 这个是连接不上的问题??
但我我也用这个账号远程登录主库了MySQL数据库主从备份不成功ERROR 1200 (HY000)
主 192.168.0.32 版本5.1
被 192.168.0.128 版本5.5主my.cnf 添加代码
log-bin=/var/log/mysql/updatelog
server-id = 1
binlog-do-db=KAPAI
binlog-ignore-db=mysql从my.cnf 添加代码
server-id=2
log-bin=mysql-bin
master-host=192.168.0.32
master-user=testback
master-password=testback
master-port=3306
replicate-do-db=KAPAI #需要备份的数据库名
replicate-ignore-db=mysql #忽略的数据库
master-connect-retry=60 #如果从服务器发现主服务器断掉,重新连接的时间差(秒)
log-slave-updates #这个参数一定要加上,否则不会给更新的记录些到二进制文件里
slave-skip-errors #是跳过错误,继续执行复制操作
错误表现:
slave stopmysql> CHANGE MASTER TO MASTER_HOST='192.168.0.32',MASTER_USER='testback',MASTER_PASSWORD='testback',MASTER_LOG_FILE='log-bin.000018',MASTER_LOG_POS=106;
Query OK, 0 rows affected (0.10 sec)mysql> slave start;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.0.32
Master_User: testback
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: log-bin.000018
Read_Master_Log_Pos: 106
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: log-bin.000018
Slave_IO_Running: No
Slave_SQL_Running: No
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: 106
Relay_Log_Space: 106
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
求大神们看下 网上搜的都是 说添加 CHANGE MASTER TO MASTER_HOST='192.168.0.32',MASTER_USER='testback',MASTER_PASSWORD='testback',MASTER_LOG_FILE='log-bin.000018',MASTER_LOG_POS=106; 这段 但是我已经添加无数次了我看到状态 Last_IO_Error: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400 这个有错误 这个是连接不上的问题??
但我我也用这个账号远程登录主库了MySQL数据库主从备份不成功ERROR 1200 (HY000)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货