|
While not strictly on topic wrt to LVS, with MySQL one can use
multi-master, shared-nothing replication or MySQL clustering (yes, these
are 2 separate methods for replicating data), with all nodes having read
and write access. I have implemented the former with LVS load balancing
the connections to the MySQL RSs with good success. I used these guides
to set this up:
http://www.howtoforge.com/mysql_database_replication
http://www.howtoforge.com/loadbalanced_mysql_cluster_debian
And I wrote up the whole procedure for our (grid) authentication and
authorization environment:
https://docs.google.com/View?docID=ddszv68g_19d88pzv&revision=_latest
Cheers,
Dan
Malcolm Turnbull wrote:
> Mehdi,
>
> Load balancing SQL server is no problem with LVS but just like every
> other database pretty difficult to get your application to work with
> it unless its a read only copy.
> Normal configuration is a shared storage twin-head write cluster +
> load balanced read-only clusters.
>
>
>
>
>
> 2008/12/10 Mehdi Ahmadi <ahmadi_mi@xxxxxxxxx>:
>> Hello,
>>
>> Since there is no load balancing for SQL Server, Is there any way to do the
>> load balancing with lvs? i.e. Is there any way of having some SQL Servers
>> that replicate the data between each other and the incoming request be
>> balanced between these servers?
>>
>> Regards
>>
>>
>>
>>
>>
>> _______________________________________________
>> Please read the documentation before posting - it's available at:
>> http://www.linuxvirtualserver.org/
>>
>> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
>> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
>> or go to http://lists.graemef.net/mailman/listinfo/lvs-users
>>
>
>
>
--
Dan Yocum
Fermilab 630.840.6509
yocum@xxxxxxxx, http://fermigrid.fnal.gov
Fermilab. Just zeros and ones.
_______________________________________________
Please read the documentation before posting - it's available at:
http://www.linuxvirtualserver.org/
LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
or go to http://lists.graemef.net/mailman/listinfo/lvs-users
|
