I have a master-slave replication setup. A scheduled backup script on
the slave runs automatically at regular intervals.
The script slave does this:
shutdown the mysql server on the slave
backup the mysql data directory to backup media
restart the mysql server on the slave.
Using a setup like this means that the master NEVER has to be stopped
or interrupted.
Jeremy Zawdowny's book Advanced MySQL has excellent information on
backup and the various ways to setup a backup strategy.
Regards, Kieran
-Kieran
________________________________________________________________
Blog: http://webobjects.webhop.org/
On Jun 16, 2005, at 11:06 AM, Jeff McKeon wrote:
Anyone using any third party products like Arkeia that enable you to do
a live backup of MySQL database?
I'm searching for a backup solution for our new data center and would
like to here what other people are using for MySQL.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]