MySQL master/slave on the same host
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
Subject
Views
Written By
Posted
MySQL master/slave on the same host
2250
March 13, 2014 11:48AM
830
March 14, 2014 07:25AM
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.