Problems with Master & Slave on same host
Hi!
Host #1 has our primary database and Master #1
Host #2 has Slave #1 for Master #1 on Host #1
Host #2 also has Slave #2 intended to replicate Slave #1 on same host
I've overcome other problems with same host mysql instance startup
NOW, SHOW SLAVE STATUS \G; in Slave #2 continuely shows:
Last_IO_Error: Fatal 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).
Indeed, inside both Slave #1 and Slave #2 both show same ID:
show variables like 'server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id | 2 |
+---------------+-------+
/etc/my.cnf (Slave #1) explicitly sets server-id=2
/etc/my02.cnf (Slave #2) explicitly sets server-id=3
What am I missing?
Thank you.
~Mike
Subject
Views
Written By
Posted
Problems with Master & Slave on same host
2016
October 29, 2012 03:29PM
942
October 30, 2012 01:01PM
987
October 30, 2012 02:04PM
928
November 01, 2012 12:46AM
951
November 01, 2012 07:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.