|
While I've been scared to try MySQL using Linux NFS because of the poor
locking facilities, I have been successful with the new replication. In
light of this, I'm not completely sure that it's best to use LVS.
A better solution (in my opinion) would be to have one server replicating to
the other. One one server dies, have a failover solution switch over to the
other server. This could be done with human interaction by changing a DNS
entry or perhaps changing an address in a library. This also would be
possible by using MON or FOS or any number of other solutions.
That way you aren't changing the database in two places... I just think
that's safer.
Now if you're trying to load balance the MySQL load then of course you're
going to need to access it in several places.
Oh well... maybe I'm being too cautious.
All the best --
Ted
----- Original Message -----
From: "raj dutt" <raj.l@xxxxxxxxx>
To: <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Thursday, March 22, 2001 8:05 AM
Subject: Re: MySQL Server
> Hi Manuel,
>
> Yes, it is definitely possible.
> Two options that I'd look into would be as follows:
>
> 1. Use a shared file system such as NFS
> so that you won't have any synchronization
> issues.
>
> 2. Use mySQL's new replication, and either build
> it into your application, or use heartbeat to
> have one database failover.
>
> We've had success with both of these methods.
>
> Hope this helps.
>
> Cheers,
> Raj Dutt
> Voxel dot Net, Inc.
>
> Manuel Jenne wrote:
> >
> > Hi,
> >
> > it is possibli to use a MySQL Server with the LVS System because of the
> > variable Database from the MySQL Server? How to sync the Databases from
> > the Different Servers?
> >
> > Best regards
> >
> > Manuel
> >
> > _______________________________________________
> > LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> > Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> > or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
> _______________________________________________
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
>
|
