MySQL Forums
Forum List  »  Replication

Problems with Master & Slave on same host
Posted by: Mike Schleif
Date: October 29, 2012 03:29PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems with Master & Slave on same host
2016
October 29, 2012 03:29PM


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.