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-----
From: Andrew Hall [mailto:halla3@stripped]
Sent: Tuesday, December 02, 2003 4:51 PM
To: mysql@stripped
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 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 fail
over scenario, so the IP that clients will connect to will be on the
load balancer.
I'm wondering if there is anything already developed that would test
mysql on the primary server, and if its not functioning, kill any
remaining mysql processes if necessary, and start it on the secondary.
This logic seems to be the biggest problem.
Any suggestions, or other methodologies to implement this would be
welcome.
Thank you for your time in advance,
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
