Re: Can a server be both Master and Slave ?
It is perfectly legal to have a circular or ring type of replication. The requirement is that the server-id must be unique on all servers. This way, the originating transaction which gets replicated to other servers, does not end up on the same server where it originated from.
Also, you might want to set up log-slave-updates on each machine. You binary logs would grow larger, but you might find it useful if you hang a slave off one server, and then decide to move it over to another master server.
Partha Dutta
Senior Consultant, MySQL Inc.
http://www.mysql.com
Subject
Views
Written By
Posted
4739
July 18, 2005 01:04AM
2547
July 22, 2005 02:28PM
Re: Can a server be both Master and Slave ?
2601
July 26, 2005 08:20AM
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.