MySQL Master/Slave Failure Recovery using bin-log

MySQL Master/Slave Failure Recovery using bin-log

When MySQL Master/slave fails, first view the slave database show slave status \ G

Remember the pos and binlog files of the bin-log (usually select the last point of the last pos for recovery) or view the time point of the mysql error log,

Converts mysql-binlog to txt to view every operation of the database.

Mysqlbinlog/paths/mysql-bin.000xxx> txt1.txt

Use change master to master_host = 'xxxx', master_user = 'mysync', master_password = 'q123456 ',

Master_log_file = 'mysql-bin. XXX', master_log_pos = xxx;

The key lies in the ability to find the bin-log files of the pos and pos that are not synchronized in the mysql master database.

Summary of restoring MySQL master-slave Data Consistency

MySQL Master/Slave Database Configuration Guide and error handling

Subtotal on MySQL Master/Slave latency

MySQL master-slave synchronization in Linux -- Add a new slave Database

MySQL Master/Slave failure error Got fatal error 1236

MySQL master-slave replication, implemented on a single server

Build a MySQL proxy server for read/write splitting + Master/Slave Synchronization

MySQL 5.5 master-slave bidirectional Synchronization

MySQL 5.5 master-slave synchronization troubleshooting

MySQL master-slave replication asynchronous semi-sync instance

This article permanently updates the link address: