On Wed, Sep 12, 2001 at 09:35:37PM -0500, adam wrote:
> I got an idea and thought i would ask around about a recovery plan
> about databases? Currently all i do is dump the databases on to a
> share on an NT box thru a SMB share from the RH 7.1 Linux DB
> server. The NT box is a Compaq CL1850 which is 2 Compaq 1850 server
> with a shared SCSI array. The NT box is backed up on a 6 hour
> interval. I was just wondering any other ideas.
Depends on what you really want and need.
You can have a slave running on a separate machine in case the master
fails. You can back up the data on the fly using mysqlhotcopy or
mysqlsnapshot. You can do both.
If you're worried about locking, you can run the backups on the slave.
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 10 days, processed 184,512,916 queries (213/sec. avg)