MySQL master-slave replication Solution

 

This is the configuration of the master database for master-slave replication in mysql:
 

 
 

  
  
server-id       = 1  
  
  
log-bin=/mysql_log/binlog/bin-log  
  
  
slave-skip-errors=1062,1205  
  
  
max_binlog_size = 500M  
  
  
binlog_cache_size = 128K  
  
  
relay-log =/mysql_log/relaylog/relaylog  
  
  
log-slave-updates 
 
 

The master-slave replication of MySQL built earlier has a problem and cannot be synchronized normally. Check the log and send the following error:

 
 

  
  
120726 13:20:36 Could not use /mysql_log/relaylog/relaylog for logging (error 2). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.  
  
  
120726 13:20:36 Failed in open_log() called from init_relay_log_info()  
  
  
120726 13:20:36 Failed to initialize the master info structure  
  
  
120726 13:20:36 Could not use /mysql_log/binlog/bin-log for logging (error 2). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.  
  
  
 
  
  
 
  
  
120801 17:53:00 Failed to open the relay log '/mysql_log/relaylog/relaylog.036' (relay_log_pos 4)  
  
  
120801 17:53:00 Could not find target log during relay log initialization  
  
  
120801 17:53:00 Failed to initialize the master info structure  
  
  
 
 
 

1. Disable mysql

 
 

  
  
[root@111_ddb ~]# mysqladmin -p shutdown  
  
  
Enter password:  
  
  
 
  
  
[root@111_ddb data]# tail -f /home/mysql/data/111_ddb.err  
  
  
120801 17:56:57 /usr/local/mysql/libexec/mysqld: Normal shutdown  
  
  
 
  
  
120801 17:56:58  InnoDB: Starting shutdown...  
  
  
120801 17:57:30  InnoDB: Shutdown completed  
  
  
120801 17:57:30 /usr/local/mysql/libexec/mysqld: Shutdown Complete  
  
  
 
  
  
120801 17:57:30  mysqld ended  
 
 

2. Delete the binlog record file, msater.info and relay-log.info on the master database

 
 

  
  
[root@111_ddb ~]# cd /home/mysql/data/  
  
  
[root@111_ddb data]# ls  
  
  
111_ddb.err  111_ddb-slow.log  ddb                     ibdata1      ib_logfile1  master.info  mysql_dd        slow.log  test  
  
  
111_ddb.pid  adb               ib_arch_log_0000000000  ib_logfile0  ib_logfile2  mysql        relay-log.info  tdb  
  
  
[root@111_ddb data]# ls *info  
  
  
master.info  relay-log.info  
  
  
[root@111_ddb data]# ls  
  
  
111_ddb.err  111_ddb-slow.log  ddb                     ibdata1      ib_logfile1  master.info  mysql_dd        slow.log  test  
  
  
111_ddb.pid  adb               ib_arch_log_0000000000  ib_logfile0  ib_logfile2  mysql        relay-log.info  tdb  
  
  
[root@111_ddb data]# rm -f master.info relay-log.info   
  
  
[root@111_ddb data]# cd /mysql_log/binlog/  
  
  
[root@111_ddb binlog]# ls  
  
  
bin-log.001  bin-log.index 
  
  
[root@111_ddb binlog]# rm -f *  
  
  
[root@111_ddb binlog]# cd ../relaylog/  
  
  
[root@111_ddb relaylog]# ls  
  
  
relaylog.001  relaylog.index 
  
  
[root@111_ddb relaylog]# rm -f *  
  
  
[root@111_ddb relaylog]# cd ../binlog/ 
 
 

3. Enable mysql

 
 

  
  
[root@111_ddb ~]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/etc/innodb.cnf --datadir=/home/mysql/data --user=mysql &  
  
  
 
  
  
[root@111_ddb data]# tail -f /home/mysql/data/111_ddb.err  
  
  
 
  
  
120801 17:58:21  mysqld started  
  
  
120801 17:58:23  InnoDB: Started  
  
  
/usr/local/mysql/libexec/mysqld: ready for connections.  
  
  
Version: '4.0.26-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution  
  
  
 
  
  
[root@111_ddb binlog]# ll  
  
  
total 13080  
  
  
-rw-rw---- 1 mysql mysql 13365795 Aug  1 17:59 bin-log.001  
  
  
-rw-rw---- 1 mysql mysql       30 Aug  1 17:58 bin-log.index  
  
  
[root@111_ddb binlog]# ll  
  
  
total 13828  
  
  
-rw-rw---- 1 mysql mysql 14132046 Aug  1 17:59 bin-log.001  
  
  
-rw-rw---- 1 mysql mysql       30 Aug  1 17:58 bin-log.index  
  
  
[root@111_ddb binlog]# ll  
  
  
total 15020  
  
  
-rw-rw---- 1 mysql mysql 15355877 Aug  1 17:59 bin-log.001  
  
  
-rw-rw---- 1 mysql mysql       30 Aug  1 17:58 bin-log.index 
 
 

By logging and viewing the binlog file, the configuration of the master database is restored to normal.
 

This article from the "open source one member" blog, please be sure to keep this source http://521cto.blog.51cto.com/950229/951776