MYSQL 配置slave故障
来源:互联网 发布:玩具机械战警如何编程 编辑:程序博客网 时间:2024/06/05 01:02
之前为主从配置,后来分割成2个单实例。
现在环境需要,重新配置为主从,之前参数都已配置好,直接启动,如下:
mysql> change master tomaster_host='192.168.12.193',master_port=3306,master_user='master',master_password='123456',master_log_file='master-bin.000569',master_log_pos=107;
ERROR 29 (HY000): File './slave-relay-bin.000494' not found(Errcode: 2)
mysql>reset slave; 也不行
查看报错日志:
131210 10:56:44 [ERROR] Failed to open the relay log'./slave-relay-bin.000494' (relay_log_pos 591818895)
131210 10:56:44 [ERROR] Could not find target log during relay loginitialization
131210 10:56:44 [ERROR] Failed to initialize the master infostructure
[root@b28-12195 data]# rm -rf master.info relay-log.infoslave-relay-bin.*
mysql> change master tomaster_host='192.168.12.193',master_port=3306,master_user='master',master_password='123456',master_log_file='master-bin.000569',master_log_pos=107;
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: 192.168.12.193
Master_User: master
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000572
Read_Master_Log_Pos: 107
Relay_Log_File: slave-relay-bin.000002
Relay_Log_Pos: 254
Relay_Master_Log_File: master-bin.000572
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: 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: 107
Relay_Log_Space: 410
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
1 row in set (0.00 sec)
- MYSQL 配置slave故障
- mysql master/slave
- 一次mysql slave故障的解决过程
- mysql master slave 配置
- MySQL配置Master-Slave
- mysql master slave 配置
- mysql master slave 配置
- Mysql-Master与Slave配置
- Mysql Master/Slave的配置
- MySQL Master Slave Replication配置
- Mysql配置master-slave模式
- MySQL Master Slave同步配置
- MySQL Master Slave同步配置
- mysql 主从配置(master/slave)
- mysql配置master/slave模式
- MySQL-(Master-Slave)配置
- 处理MySQL复制环境Slave故障的一个案例
- MYSQL的master/slave数据同步配置
- Linux下安装firefox的flash插件
- oracle11g rman验证备份有效性
- oracle11g 数据文件误删恢复(…
- oracle 谁在用undo
- oracle 临时表空间
- MYSQL 配置slave故障
- socket编程之C语言一个简单监听程序
- RMAN 完全恢复
- show engine innodb status\G
- Oracle11g Install Bbed
- 误删system04.dbf 报:ORA-01…
- mysql无法创建数据库
- 删除redo所有日志,数据库无法启动
- 删除undotbs后,数据库无法启动