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
> mistake?
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.
http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html#option_mysqld_replicate-same-server-id
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.
Marcus
--
Marcus Bointon
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
