Complementing Chris :

<http://www.onlamp.com/lpt/a/6549>Asume that your Application Server is
Tomcat.

BALANCING SERVERS:

You can implement some servers or appliance only for balancing your primary
connections. This servers or appliance you must implement using Hearbeat (
only). For example one of the balancing servers fail.

APPLICATION SEVER

Your x ( quantity) of applications servers receive the connections from
Balancing Servers and distribute across the diferent nodes of MySQL using
LVS. You must implement Hearbeat for each application server too ( just in
case of failure of some app. server).


DATABASE SERVERS

MySQL and multimaster replication, please see below
http://www.onlamp.com/lpt/a/6549


Technology : for OS try to use Linux, for Hearbeat try to use UltraMonkey (
www.ultramonkey.org) for Balancing try to use LVS ( Linux).


I hope this help.

Regards.
Juan Eduardo


On 2/26/07, Chris McKeever <cgmckeever@gmail.com> wrote:
>
> On 2/26/07, Chris W < 2wsxdr5@cox.net> wrote:
>
> >
> > Can someone here give some insight and suggest other options I could
> > look into?
>
> you could replicate all the data between web/application servers, and
> use the local store as a read-only database, and push all your
> updates to a central update 'master' server. You could also play with
> multiple-master replication.
>
>
> >
> > --
> > Chris W
> > KE5GIX
> >
> > "Protect your digital freedom and privacy, eliminate DRM,
> > learn more at http://www.defectivebydesign.org/what_is_drm"
> >
> > Gift Giving Made Easy
> > Get the gifts you want &
> > give the gifts they want
> > One stop wish list for any gift,
> > from anywhere, for any occasion!
> > http://thewishzone.com
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=cgmckeever@gmail.com
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=j...domc@gmail.com
>
>