I've been setting up a
master->slave_a->slave_b relationship and having a little trouble. I currently have the
master->slave_a replication working fine.
Each of the two slaves have exactly the same configuration, other than the hostname,
server-id setting. When ever I try and start the slave on
slave_b I have the following error pop up:
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).
I really don't understand, because I have all of the server IDs miles apart
I'm setting them in my
/etc/mysql/conf.d/replication.cnf file - and it seems to be being included, but I have no idea how I can check which server id mysql is picking up.
Thanks in advance :) Tom.