On Jul 8, 2009, at 12:49 PM, Daevid Vincent wrote:
Ouch.
I know it comes a little too late, but as a preventive measure going
forward, I offer up my daily crontab backup script:
http://www.daevid.com/content/examples/daily_backup.php
They move a lot of data, so scheduled dumps were not really an
option. I wrote a proposal to use two databases, one is the primary
acting as a DNS 1, and the second is the slave, acting as DNS 2. I
then wanted to add a 3rd slave server, that was a hot standby, in case
the primary went down. It would hold copies of all databases.
This would be on a raid, and on a schedule, it would also do dumps,
which could take as long as they want, since this machine was not
being hit at all.
This was not implemented for some reason. I will look at your
scripts, thanks again.
--
Scott * If you contact me off list replace talklists@ with scott@ *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
