View Single Post
  #7  
Old 2nd July 2010, 11:54
black_magik black_magik is offline
Junior Member
 
Join Date: Jul 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In the /var/log/messages (both maste and slave) i didn't find anything about mysql but if i do the command:

tail -f /var/log/mysql/mysqd.err on the slave i receive:

100623 14:01:34 [ERROR] The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
100623 14:01:34 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000008', position 98
100623 14:02:10 [Note] Error reading relay log event: slave SQL thread was killed
100623 14:04:09 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000010' at position 98, relay log './mysqld-relay-bin.000001' position: 4
100623 14:04:09 [Note] Slave I/O thread: connected to master 'slave_user@192.168.3.16:3306', replication started in log 'mysql-bin.000010' at position 98
100623 14:04:09 [ERROR] The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
100623 14:04:09 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000010', position 98
100701 12:22:44 [Note] Slave I/O thread: connected to master 'slave_user@192.168.3.16:3306', replication started in log 'mysql-bin.000010' at position 98
100701 12:22:44 [ERROR] The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
100701 12:22:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000010', position 98

i didn't understand wich id is equal, because i've set:
server-id=1 on the master and:
server-id=2 on the slave (as you see in the previous post)
Reply With Quote