Re: Advice on backing up a 2 master system
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?