已经成功2台mysql 复制(双向同步)。 现在马上搞3台机器
基本想法如下
a (2个库ccxyaccount,ccxydb)
b(1个库 ccxyaccount)
c (1个库 ccxydb)
为了简化难度,现在仅仅要求a b之间数据同步, c只要求实实时去取a更新的数据就可以拉
a的my.cnf如下 (现在质疑 复制是否支持多个库的数据同步)
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log_bin = /var/log/mysql/log_bin
server-id=1
#sql-bin-update-same
binlog-do-db = ccxyaccount,ccxydb
#binlog-ignore-db = mysql,testmaster-host = 10.0.4.150
master-user = back
master-password = back
master-port = 3306
replicate-ignore-db=mysql,test
replicate-do-db=ccxyaccount
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidb c 类似。
于以前的问题不同,现在没有报错(有一定经验)。
slave stop;
change master....;
slave start;
3台机器同时ok的,没有错误。可惜测试数据的时候发现,3台机器之间完全没有数据同步,甚至局部a b 之间数据也没有任何联系 。
问1现在质疑 复制是否支持多个库的数据同步
2 如何查找问题在哪里?
基本想法如下
a (2个库ccxyaccount,ccxydb)
b(1个库 ccxyaccount)
c (1个库 ccxydb)
为了简化难度,现在仅仅要求a b之间数据同步, c只要求实实时去取a更新的数据就可以拉
a的my.cnf如下 (现在质疑 复制是否支持多个库的数据同步)
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log_bin = /var/log/mysql/log_bin
server-id=1
#sql-bin-update-same
binlog-do-db = ccxyaccount,ccxydb
#binlog-ignore-db = mysql,testmaster-host = 10.0.4.150
master-user = back
master-password = back
master-port = 3306
replicate-ignore-db=mysql,test
replicate-do-db=ccxyaccount
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidb c 类似。
于以前的问题不同,现在没有报错(有一定经验)。
slave stop;
change master....;
slave start;
3台机器同时ok的,没有错误。可惜测试数据的时候发现,3台机器之间完全没有数据同步,甚至局部a b 之间数据也没有任何联系 。
问1现在质疑 复制是否支持多个库的数据同步
2 如何查找问题在哪里?
b 从 主(1个库 ccxyaccount)
c 从(1个库 ccxydb) 也就是说a b 是数据同步的ccxyaccount c 仅仅复制来自a的一个库ccxydb
a 分别有2个复制用户分别 back (对应 b机器) back2(都应c机器)
。 这样楼上应该清楚业务了吧。090626 11:00:24 mysqld started
090626 11:00:24 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 11:00:25 InnoDB: Started; log sequence number 1 2201759024
090626 11:00:25 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 11:00:25 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000006' (relay_log_pos 233)
090626 11:00:25 [ERROR] Could not find target log during relay log initialization
090626 11:00:25 [ERROR] Failed to initialize the master info structure
090626 11:00:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 11:05:22 [Note] /usr/libexec/mysqld: Normal shutdown090626 11:05:22 InnoDB: Starting shutdown...
090626 11:05:23 InnoDB: Shutdown completed; log sequence number 1 2201759024
090626 11:05:23 [Note] /usr/libexec/mysqld: Shutdown complete090626 11:05:23 mysqld ended090626 11:05:24 mysqld started
090626 11:05:24 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 11:05:24 InnoDB: Started; log sequence number 1 2201759024
090626 11:05:24 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 11:05:24 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000006' (relay_log_pos 233)
090626 11:05:24 [ERROR] Could not find target log during relay log initialization
090626 11:05:24 [ERROR] Failed to initialize the master info structure
090626 11:05:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 11:40:08 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000006' (relay_log_pos 233)
090626 11:40:08 [ERROR] Could not find target log during relay log initialization
090626 11:41:41 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000006' (relay_log_pos 233)
090626 11:41:41 [ERROR] Could not find target log during relay log initialization
090626 11:41:48 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000006' (relay_log_pos 233)
090626 11:41:48 [ERROR] Could not find target log during relay log initialization我复制了2天的错误日志 (a机器 ) 清只看 26号(今天的就可以拉)
090625 21:45:35 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090625 21:45:36 InnoDB: Started; log sequence number 0 46409
090625 21:45:36 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090625 21:45:36 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000002' (relay_log_pos 54
090625 21:45:36 [ERROR] Could not find target log during relay log initialization
090625 21:45:36 [ERROR] Failed to initialize the master info structure
090625 21:45:36 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090625 21:47:34 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000028' at position 413, relay log '/var/run/mysqld/mysqld-relay-bin.000002' position: 548
090625 21:47:34 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000028' at position 413
090625 22:48:47 [Note] Slave: received end packet from server, apparent master shutdown:
090625 22:48:47 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'log_bin.000030' position 310
090625 22:48:47 [ERROR] Slave I/O thread: error reconnecting to master '[email protected]:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' errno: 2013 retry-time: 120 retries: 86400
090625 22:49:47 [Note] /usr/libexec/mysqld: Normal shutdown090625 22:49:47 [Note] Slave I/O thread killed during or after a reconnect done to recover from failed read
090625 22:49:47 [Note] Slave I/O thread exiting, read up to log 'log_bin.000030', position 310
090625 22:49:47 [Note] Error reading relay log event: slave SQL thread was killed
090625 22:49:48 InnoDB: Starting shutdown...
090625 22:49:49 InnoDB: Shutdown completed; log sequence number 0 46409
090625 22:49:49 [Note] /usr/libexec/mysqld: Shutdown complete090625 22:49:49 mysqld ended090625 22:49:50 mysqld started
090625 22:49:50 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090625 22:49:50 InnoDB: Started; log sequence number 0 46409
090625 22:49:50 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090625 22:49:50 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090625 22:49:50 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000030' at position 310, relay log '/var/run/mysqld/mysqld-relay-bin.000006' position: 233
090625 22:49:50 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000030' at position 310
090625 22:53:44 [Note] Slave I/O thread killed while reading event
090625 22:53:44 [Note] Slave I/O thread exiting, read up to log 'log_bin.000031', position 98
090625 22:53:44 [Note] Error reading relay log event: slave SQL thread was killed
090625 22:56:45 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000031' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000001' position: 4
090625 22:56:45 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000031' at position 98
090625 23:37:21 [Note] Slave: received end packet from server, apparent master shutdown:
090625 23:37:21 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'log_bin.000031' position 98
090625 23:37:21 [ERROR] Slave I/O thread: error reconnecting to master '[email protected]:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' errno: 2013 retry-time: 120 retries: 86400
090625 23:37:41 [Note] /usr/libexec/mysqld: Normal shutdown090625 23:37:41 [Note] Slave I/O thread killed during or after a reconnect done to recover from failed read
090625 23:37:41 [Note] Slave I/O thread exiting, read up to log 'log_bin.000031', position 98
090625 23:37:41 [Note] Error reading relay log event: slave SQL thread was killed
090625 23:37:41 InnoDB: Starting shutdown...
090625 23:37:43 InnoDB: Shutdown completed; log sequence number 0 46409
090625 23:37:43 [Note] /usr/libexec/mysqld: Shutdown complete090625 23:37:43 mysqld ended090625 23:37:43 mysqld started
090625 23:37:43 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090625 23:37:43 InnoDB: Started; log sequence number 0 46409
090625 23:37:43 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090625 23:37:43 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090625 23:37:43 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000031' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000002' position: 233
090625 23:37:43 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000031' at position 98
090625 23:39:46 [Note] /usr/libexec/mysqld: Normal shutdown090625 23:39:46 [Note] Slave I/O thread killed while reading event
090625 23:39:46 [Note] Slave I/O thread exiting, read up to log 'log_bin.000032', position 98
090625 23:39:46 [Note] Error reading relay log event: slave SQL thread was killed
090625 23:39:46 InnoDB: Starting shutdown...
090625 23:39:48 InnoDB: Shutdown completed; log sequence number 0 46409
090625 23:39:48 [Note] /usr/libexec/mysqld: Shutdown complete090625 23:39:48 mysqld ended090626 14:35:27 mysqld started
090626 14:35:27 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 14:35:28 InnoDB: Started; log sequence number 0 46409
090626 14:35:28 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 14:35:28 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000005' (relay_log_pos 233)
090626 14:35:28 [ERROR] Could not find target log during relay log initialization
090626 14:35:28 [ERROR] Failed to initialize the master info structure
090626 14:35:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 14:38:22 [Note] /usr/libexec/mysqld: Normal shutdown090626 14:38:22 InnoDB: Starting shutdown...
090626 14:38:24 InnoDB: Shutdown completed; log sequence number 0 46409
090626 14:38:24 [Note] /usr/libexec/mysqld: Shutdown complete090626 14:38:24 mysqld ended090626 14:38:25 mysqld started
090626 14:38:25 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 14:38:25 InnoDB: Started; log sequence number 0 46409
090626 14:38:25 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 14:38:25 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000005' (relay_log_pos 233)
090626 14:38:25 [ERROR] Could not find target log during relay log initialization
090626 14:38:25 [ERROR] Failed to initialize the master info structure
090626 14:38:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 15:04:21 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000005' (relay_log_pos 233)
090626 15:04:21 [ERROR] Could not find target log during relay log initialization
090626 15:07:27 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000005' (relay_log_pos 233)
090626 15:07:27 [ERROR] Could not find target log during relay log initialization
090626 15:07:50 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000034' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000001' position: 4
090626 15:07:50 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000034' at position 98
90626 00:57:43 mysqld started
090626 0:57:44 InnoDB: Started; log sequence number 0 43655
090626 0:57:44 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 1:01:04 [Note] /usr/libexec/mysqld: Normal shutdown090626 1:01:04 InnoDB: Starting shutdown...
090626 1:01:07 InnoDB: Shutdown completed; log sequence number 0 43655
090626 1:01:07 [Note] /usr/libexec/mysqld: Shutdown complete090626 01:01:07 mysqld ended090626 02:33:18 mysqld started
090626 2:33:19 InnoDB: Started; log sequence number 0 43655
090626 2:33:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 3:33:17 [Note] /usr/libexec/mysqld: Normal shutdown090626 3:33:17 InnoDB: Starting shutdown...
090626 3:33:19 InnoDB: Shutdown completed; log sequence number 0 43655
090626 3:33:19 [Note] /usr/libexec/mysqld: Shutdown complete090626 03:33:19 mysqld ended090626 03:33:20 mysqld started
090626 3:33:20 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 3:33:20 InnoDB: Started; log sequence number 0 43655
090626 3:33:20 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 3:33:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 3:33:20 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/run/mysqld/mysqld-relay-bin.000001' position: 4
090626 3:33:20 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'FIRST' at position 4
090626 3:42:43 [Note] Slave I/O thread killed while reading event
090626 3:42:43 [Note] Slave I/O thread exiting, read up to log 'log_bin.000031', position 98
090626 3:42:43 [Note] Error reading relay log event: slave SQL thread was killed
090626 3:45:23 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000031' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000001' position: 4
090626 3:45:23 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000031' at position 98
090626 4:18:38 [Note] /usr/libexec/mysqld: Normal shutdown090626 4:18:38 [Note] Slave I/O thread killed while reading event
090626 4:18:38 [Note] Slave I/O thread exiting, read up to log 'log_bin.000031', position 98
090626 4:18:38 [Note] Error reading relay log event: slave SQL thread was killed
090626 4:18:38 InnoDB: Starting shutdown...
090626 4:18:39 InnoDB: Shutdown completed; log sequence number 0 43655
090626 4:18:39 [Note] /usr/libexec/mysqld: Shutdown complete090626 04:18:40 mysqld ended090626 04:18:41 mysqld started
090626 4:18:41 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 4:18:42 InnoDB: Started; log sequence number 0 43655
090626 4:18:42 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 4:18:42 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 4:18:42 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000031' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000002' position: 233
090626 4:18:42 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000031' at position 98
090626 4:18:59 [Note] /usr/libexec/mysqld: Normal shutdown090626 4:18:59 [Note] Slave I/O thread killed while reading event
090626 4:18:59 [Note] Slave I/O thread exiting, read up to log 'log_bin.000031', position 98
090626 4:18:59 [Note] Error reading relay log event: slave SQL thread was killed
090626 4:18:59 InnoDB: Starting shutdown...
090626 4:19:00 InnoDB: Shutdown completed; log sequence number 0 43655
090626 4:19:00 [Note] /usr/libexec/mysqld: Shutdown complete090626 04:19:00 mysqld ended090626 04:19:01 mysqld started
090626 4:19:01 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 4:19:01 InnoDB: Started; log sequence number 0 43655
090626 4:19:01 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 4:19:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 4:19:01 [Note] Slave SQL thread initialized, starting replication in log 'log_bin.000031' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000004' position: 233
090626 4:19:01 [Note] Slave I/O thread: connected to master '[email protected]:3306', replication started in log 'log_bin.000031' at position 98
090626 4:21:04 [Note] Slave: received end packet from server, apparent master shutdown:
090626 4:21:04 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'log_bin.000031' position 98
090626 4:21:04 [ERROR] Slave I/O thread: error reconnecting to master '[email protected]:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' errno: 2013 retry-time: 120 retries: 86400
090626 4:23:04 [Note] Slave: connected to master '[email protected]:3306',replication resumed in log 'log_bin.000031' at position 98
090626 4:23:20 [Note] /usr/libexec/mysqld: Normal shutdown090626 4:23:20 [Note] Slave I/O thread killed while reading event
090626 4:23:20 [Note] Slave I/O thread exiting, read up to log 'log_bin.000032', position 98
090626 4:23:20 [Note] Error reading relay log event: slave SQL thread was killed
090626 4:23:20 InnoDB: Starting shutdown...
090626 4:23:21 InnoDB: Shutdown completed; log sequence number 0 43655
090626 4:23:21 [Note] /usr/libexec/mysqld: Shutdown complete090626 04:23:21 mysqld ended090626 19:20:05 mysqld started
090626 19:20:06 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 19:20:08 InnoDB: Started; log sequence number 0 43655
090626 19:20:08 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 19:20:08 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000008' (relay_log_pos 233)
090626 19:20:08 [ERROR] Could not find target log during relay log initialization
090626 19:20:08 [ERROR] Failed to initialize the master info structure
090626 19:20:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 19:22:19 [Note] /usr/libexec/mysqld: Normal shutdown090626 19:22:19 InnoDB: Starting shutdown...
090626 19:22:20 InnoDB: Shutdown completed; log sequence number 0 43655
090626 19:22:20 [Note] /usr/libexec/mysqld: Shutdown complete090626 19:22:20 mysqld ended090626 19:22:21 mysqld started
090626 19:22:21 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090626 19:22:22 InnoDB: Started; log sequence number 0 43655
090626 19:22:22 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090626 19:22:22 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000008' (relay_log_pos 233)
090626 19:22:22 [ERROR] Could not find target log during relay log initialization
090626 19:22:22 [ERROR] Failed to initialize the master info structure
090626 19:22:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090626 19:51:51 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000008' (relay_log_pos 233)
090626 19:51:51 [ERROR] Could not find target log during relay log initialization
090626 19:53:48 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000008' (relay_log_pos 233)
090626 19:53:48 [ERROR] Could not find target log during relay log initialization
090626 19:55:37 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000008' (relay_log_pos 233)
090626 19:55:37 [ERROR] Could not find target log during relay log initialization