Re: Advice on backing up a 2 master system

[Rick James]

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

That takes care of AUTO_INCREMENTs, but not other UNIQUE keys.

> And I have room to add 7 more...

7 more what?

> cause I think 'auto-increment-offset = 0' behaves strangely.

So, do not use 0.

> 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?

(I don't know the answer to that specific question.) Why should you care? SLAVE STOP; or STOP SLAVE SQLTHREAD; will stop the writes that are arriving from the other Master. After START SLAVE, the writes will be applied.