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
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 instead of tar-ing the data dir to create the b

RE: mysql disaster recovery

2003-12-02 Thread John Griffin
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 an NFS mounted drive will significantly degrade the performance of your database. Replication will not. John Griffin -Original Message