>From what I can tell MySQL can only have one master server that can take Status: O
writes but many slave replicating servers that can be used for reads. If I can only write to one then I would think to optimize performance I would want to only write to the master and do all my SELECTs to a cluster of slave replicating servers. Does dbmail support using 2 or more different IPs for reading vs. writing? Any suggestions on how to handle a master MySQL server failing and having a slave automatically taking over as master, or being able to write to any of the MySQL servers in the cluster? I'm trying to build a 99.999% (or better) uptime system. Oracle will let you write to any server in the cluster so you can use a Foundry switch or any layer 4 solution to load balance and handle failover..their SQL solution is awesome but at about $100K it is way out of my reach. Any suggestions would be VERY appreciated. Mike PS: Before I get told to look at the message archives Yes, I looked at them but I never actualy saw any specific answers.
