RE: mysql disaster recovery

2003-12-03 Thread Andrew Braithwaite
TED] Sent: Wednesday 03 December 2003 22:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: mysql disaster recovery This information may not be current, but I seem to remember hearing some really nasty stories about people putting MySQL data dirs on NFS exports

RE: mysql disaster recovery

2003-12-03 Thread JHDrexler
:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 5:10 PM To: halla3; mysql Cc: John.Griffin Subject: RE: mysql disaster recovery Hi Andrew, I am not a Guru. I would suggest that you look at MySQL's excellent replication facility rather than NFS mount a drive. Having your data on a

Re: mysql disaster recovery

2003-12-03 Thread walt
Andrew, Andrew Hall wrote: > > John, > > Thank you for your reply. I have read the replication chapter and this > seems to be easier, but I do have a few questions. > > 1. I am using InnoDB tables, at least there are innodb argument to > mysqld in the start script, so should I use mysqldump in

RE: mysql disaster recovery

2003-12-03 Thread Andrew Hall
Andrew Hall [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 02, 2003 4:51 PM > To: [EMAIL PROTECTED] > Subject: mysql disaster recovery > > > Greetings Gurus, > > I have a mysql server that I need to create a disaster recovery system > for. What I am planning on doing i

RE: mysql disaster recovery

2003-12-02 Thread John Griffin
ssage- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 4:51 PM To: [EMAIL PROTECTED] Subject: mysql disaster recovery Greetings Gurus, I have a mysql server that I need to create a disaster recovery system for. What I am planning on doing is putting the data dir on

mysql disaster recovery

2003-12-02 Thread Andrew Hall
Greetings Gurus, I have a mysql server that I need to create a disaster recovery system for. What I am planning on doing is putting the data dir on a NFS mounted directory so that I can start mysql on either of two servers in case one dies. The inbound connections would be load balanced in a fai