Hi List I have to set up a HA-Linux Server with Apache and mysql running on two machines over load balancing. Apache isn't a problem. But mysql. AFAIK it is impossible to cluster mysql - it "only" supports replication. As I've said already, we have only two machines, and two firewalls of course, for web and mysql server - but this two machines should for the best work load balanced and failsafe. So, if one machine fails because of a hardware fault - the other machine must be able to overtake the whole work. So it is necersary to install Apache and mysql on both server's. And, to get the best performance out of it, I've got the following idea: The whole WebApplication has an own db interface so that it should be possible to...
First Server runs: apache and mysql master <- all write Operations are done one the master <- read operations from the first server are also done one the master. Second Server runs: apache and mysql slave <- gets synchronized by the master <- read operations from the second server are done on the slave <- write operations are getting directed to the master -> which then synchronize the slave. Because of dynamic load balancing this should get a nice average load. If then one machine fails - then you have on both machines everthing you need to work in standalone mode. The only thing is, that you need some scripts which switches the databases from slave to master mode, doing synchronization after the are working again, redirecting all the read/write operations to one machine, and some additional work. So, after a long paragraph, what to you think - should this be possible or have you any better ideas ? With what I'am wrong ? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php