Search results for query: *

I set this up as a master-master system with IP failover. Both servers are more than capable of doing inserts and selects, but I'm giving the virtual IP to our developers so they can only talk to the acting master. I'm using the heartbeat utility to do the IP failover, and you can set whether it...

This is one of the ideas I pitched as a solution, and management didn't like that either server could be used to write to the database, even if we give the developers a virtual IP that floats between the servers. I see this as being the ideal solution, so I'll try to get buyoff again. Thanks for...

I'm assuming you use a virtual IP for your masters. Is there a way to prevent the backup master from accepting inserts unless the primary is offline?

Thanks for the info. Sounds like I have my work cut out for me regardless. :)

The headache is what I am trying to avoid. I thought about two way mirroring, but that's another headache waiting to happen.

So how does one typically handle the situation if the master goes down? Doesn't that take away the ability to write to the databse?

I've been reading that MySQL clustering using shared disk is a bad thing. Some of what I have read referrs specifically to NFS mounts being bad. I was considering using a SCSI attached array shared between two servers for storing the databases. Is this considered to be a no-no?