On 4 Jun 2010, at 05:42, Database System wrote:
> My two servers' ids are different. Since there is such setting,
> replicate-same-server-id=0 is that means server probably could execute its own updates by
That's not what it does. That setting says whether it should replicate statements that
match its own id. If server A runs a query, replicates to B and runs there. If the query
then somehow gets back to A, it won't run because the server ID matches, thus preventing
a replication loop.
There is some confusion about master-master terminology. Master-master is merely two sets
of master-slave replication, and each direction is identical to a master-slave config,
there's nothing magic or different about it.
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/
Attachment: [application/pkcs7-signature] smime.p7s