List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:September 16 2001 4:36am
Subject:Re: Designing a recovery plan for MySQL
View as plain text  
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
-- 
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)
Thread
Designing a recovery plan for MySQLadam13 Sep
  • Re: Designing a recovery plan for MySQLDan Nelson13 Sep
  • Re: Designing a recovery plan for MySQLJeremy Zawodny16 Sep