CODEWITHSUNDEEP
mysqldatabasebackup
aartist
aartist

Reputation: 3236

How to create mirror of mysql database for switching purpose in case of emergency?

I have around 400 GB Live mysql Databases on one server and I like to create a mirror for this database. In the server I have database ranging from 1 GB to 100 GB. What are the best practices available that I can use? My purpose is that I should be able to switch in case of emergency. It should have all live data.

Thanks.

Upvotes: 5

Views: 8638

Answers (1)

Greg
Greg

Reputation: 321698

It depends on the emergency...

For live data, replication is the way to go, but an accidental DROP will be replicated straight across...

Also, are you looking to survive a building disaster, or just a server/drive/hardware crash?

Upvotes: 5

Related Questions