Advanced

Good article but...

Story: How To Back Up MySQL Databases Without Interrupting MySQLTotal Replies: 0
Author Content
rodeoclown

May 14, 2007
2:09 PM EDT 		Not everyone has the option or hardware capabilities to setup a slave MySQL database for every running instance they may have in a production or any type of environment.

I currently work in an environment where we have close to 90 production MySQL databases. Due to constraints, it would be a large overhead to run an additional 90 slave databases for each.

However I agree that critical systems should have a slave database, another option to use if you need to setup backups without interrupting would be to use something like MySQL ZRM, which enables incremental backups along with full backups, etc.

http://www.zmanda.com/backup-mysql.html

Post a reply to this thread:

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post