MySQL Forums
Forum List  »  Replication

MySQL master/slave on the same host
Posted by: harry sheng
Date: March 13, 2014 11:48AM

Hi,

I'm testing the MySQL master/slave replication setup procedure; on one single linux host.
I use the Raw Data Files to clone the master database to the slave database. The master/slave database setup work well. But I get the following error message from "show slave status":

Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

The auto.cnf is copied from master to slave without change, so I kind of understand the error message from the slave instance.

My question is, can I change the server-uuid in auto.cnf in the slave instance? How does it affect the database data?

Harry

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL master/slave on the same host
2250
March 13, 2014 11:48AM


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.