MySQL Forums
Forum List  »  Backup

Re: Advice on backing up a 2 master system
Posted by: James McMillian
Date: July 01, 2012 10:10PM

The two server are configured in their respectice my.cnf file as follows:

#MYSQL Database Server #1
server-id = 10001
replicate-same-server-id = 0
auto-increment-increment = 10
auto-increment-offset = 1


#MYSQL Database Server #2
server-id = 10002
replicate-same-server-id = 0
auto-increment-increment = 10
auto-increment-offset = 2


As such, Server 1, uses unique id such as 11, 21, 31, ...., 1231, 1241, etc...
and Server 2, uses unique ids such as 12, 22, 32, ...., 1232, 1242, etc...

so even if the same data is written by two services simultaneously, the two MYSQL servers will assign different unique ID #'s.

And I have room to add 7 more... cause I think 'auto-increment-offset = 0' behaves strangely.

Unless Im missing something, anyone?

Going along with the initial question however, is it possible to shutdown the tcp stack in MYSQL while its running, so that MYSQLDUMP can perform its task through a local socket, and then turn the tcp stack back on when MYSQLDUMP finished? or does it require a restart after applying the variable to ther server?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Advice on backing up a 2 master system
1479
July 01, 2012 10:10PM


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.