Advice on backing up a 2 master system
I have a master-master setup. the entire database on each server is 500+ GB. I've been using automysqlbackup, but when mysqldump executes, the server being dumped tends to time out any incoming requests from clients. So I recently added code to the clients to make them auto switch to a different server when one becomes unavailable or busy. My question is, at this point, would it be faster and safer to take one database offline and archive the entire database directory, bin logs and all. And upon restore what kind of issues would I be looking at?
Taking both server down is not an option, but as I said, one or the other individually is no problem and the databases constantly have data being written to them, so there is no really safe time to take them both down.
Suggestions?
JD
Subject
Views
Written By
Posted
Advice on backing up a 2 master system
2424
June 19, 2012 10:38PM
1353
June 30, 2012 04:19AM
1345
July 01, 2012 06:55PM
1484
July 01, 2012 10:10PM
1487
July 03, 2012 02:03PM
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.