Re: HA Setup for MySQL

2001-07-13 Thread Shon Stephens
I'm not sure if that was a problem or not. I am actually very interested in the second part of my query regarding replication. An earlier post mentioned that if I am using A -> B -> A replication behind a load-balancer, that I may lose performance. I am only slightly concerned with update perf

Re: HA Setup for MySQL

2001-07-13 Thread Gerald Clark
I don't believe NFS locking is reliable enough to allow two servers to serve the same databases. Shon Stephens wrote: > I recently started experimenting with a way to setup MySQL to be > load-balanced. I installed 2 servers with MySQL, NFS mounted the > /mysql/var directory, then moved the gra

HA Setup for MySQL

2001-07-13 Thread Shon Stephens
I recently started experimenting with a way to setup MySQL to be load-balanced. I installed 2 servers with MySQL, NFS mounted the /mysql/var directory, then moved the grant tables to /mysql/grant, and created a symbolic link from /mysql/var/mysql to /mysql/grant. This appeared to work correctl