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 <[EMAIL PROTECTED]>: >> 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 - [email protected] >> Send requests to [EMAIL PROTECTED] >> or go to http://lists.graemef.net/mailman/listinfo/lvs-users >> > > > -- Dan Yocum Fermilab 630.840.6509 [EMAIL PROTECTED], 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 - [email protected] Send requests to [EMAIL PROTECTED] or go to http://lists.graemef.net/mailman/listinfo/lvs-users
