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

Reply via email to