Linux/FreeBSD based loadbalancing frontend to MySQL - GoFuckYourself.com

Machete_ · 11-29-2006, 10:46 AM

I have a customer asking me about converting his current setup we made with two MS sharepoint servers behind a ISA server as load balancing and routing. I sold his this back in 2005, but he needs to upgrade the capacity, and the licences is getting pretty fucking expensive at these volumes.

Anyone know of a Proxy/routing/loadbalancing (with failover) that runs on Linux or FreeBSD ?

vending_machine · 11-29-2006, 10:56 AM

Linux high availability with keepalived.

Spudstr · 11-29-2006, 11:12 AM

ebus, look into SPLA licensing for windows licensing, as a service provider you now have to use SPLA for leased servers its cheaper anyway to do this.

as far as load balancing for mysql mysql 5.0 and 5.1 5.0 introduced replication but 5.1 is introducing clustering.

hit me up on icq and i can giveyou some exampls of some solutions for him that you can provide that are relatively inexpensive.

Machete_ · 11-29-2006, 02:40 PM

Quote:

Originally Posted by Spudstr

ebus, look into SPLA licensing for windows licensing, as a service provider you now have to use SPLA for leased servers its cheaper anyway to do this.

as far as load balancing for mysql mysql 5.0 and 5.1 5.0 introduced replication but 5.1 is introducing clustering.

hit me up on icq and i can giveyou some exampls of some solutions for him that you can provide that are relatively inexpensive.

Thanks for the reply. We looked at that as well, and it was one of the two solutions we presented to the customer. His only question we could not answer was "what would it cost to convert the frontend to Opensource/linux...."

I would emagine some of the large VOD and Cam sites use a setup like this

CS-Jay · 11-29-2006, 03:31 PM

I was looking into a freebsd webserver config awhile ago. this is what I found that was going to do it. http://siag.nu/pen/ and if I remember correctly, it would handle the php sessions correctly too, by sending the surfer to the same box every request. And you'd just connect to one mysql box in the back-end.

Machete_ · 11-29-2006, 04:47 PM

Quote:

Originally Posted by CS-Jay

I was looking into a freebsd webserver config awhile ago. this is what I found that was going to do it. http://siag.nu/pen/ and if I remember correctly, it would handle the php sessions correctly too, by sending the surfer to the same box every request. And you'd just connect to one mysql box in the back-end.

that's more like it, and the VRRPd part is compatible with the Cisco tool we use to monitor the whole setup. Appreciate the link m8 - this was a huge leap forward for us since we dont have a lot of in-house Linux knowledge

frankfortuna · 11-29-2006, 05:16 PM

We are about to evaluate uni/cluster from Continuent

http://www.continuent.com

Machete_ · 11-29-2006, 05:29 PM

Quote:

Originally Posted by frankfortuna

We are about to evaluate uni/cluster from Continuent

http://www.continuent.com

that works well with RedHat AS/ES 4.0, so that is a big plus since that is one of the OS's in our IBM service contract.

frankfortuna · 11-29-2006, 05:38 PM

Quote:

Originally Posted by ebus_dk

that works well with RedHat AS/ES 4.0, so that is a big plus since that is one of the OS's in our IBM service contract.

I neglected to mention that they have some open source projects at www.continuent.org. Good luck!

Machete_ · 11-29-2006, 05:43 PM

Quote:

Originally Posted by frankfortuna

I neglected to mention that they have some open source projects at www.continuent.org. Good luck!

It always put a smile on my face when you visit opensource or linux sites and see layouts CLEARLY made in Microsoft Office Visio

http://www.continuent.org/uploads/ww...g_projects.jpg

11-29-2006, 10:46 AM	#1
Machete_ WINNING! Industry Role: Join Date: Oct 2002 Posts: 14,579	Linux/FreeBSD based loadbalancing frontend to MySQL I have a customer asking me about converting his current setup we made with two MS sharepoint servers behind a ISA server as load balancing and routing. I sold his this back in 2005, but he needs to upgrade the capacity, and the licences is getting pretty fucking expensive at these volumes. Anyone know of a Proxy/routing/loadbalancing (with failover) that runs on Linux or FreeBSD ?

11-29-2006, 11:12 AM	#3
Spudstr Confirmed User Industry Role: Join Date: Jan 2003 Location: In a Tater Patch Posts: 2,321	ebus, look into SPLA licensing for windows licensing, as a service provider you now have to use SPLA for leased servers its cheaper anyway to do this. as far as load balancing for mysql mysql 5.0 and 5.1 5.0 introduced replication but 5.1 is introducing clustering. hit me up on icq and i can giveyou some exampls of some solutions for him that you can provide that are relatively inexpensive. __________________ Managed Hosting - Colocation - Network Services Yellow Fiber Networks icq: 19876563

11-29-2006, 03:31 PM	#5
CS-Jay Confirmed User Join Date: Oct 2003 Location: Command Central, West Palm Beach, Fl Posts: 1,794	I was looking into a freebsd webserver config awhile ago. this is what I found that was going to do it. http://siag.nu/pen/ and if I remember correctly, it would handle the php sessions correctly too, by sending the surfer to the same box every request. And you'd just connect to one mysql box in the back-end. __________________ I do stuff - aIm CS_Jay_D

11-29-2006, 10:56 AM	#2
vending_machine Confirmed User Join Date: Jun 2002 Location: Seattle Posts: 1,062	Linux high availability with keepalived.

11-29-2006, 05:16 PM	#7
frankfortuna Confirmed User Join Date: Aug 2002 Posts: 1,504	We are about to evaluate uni/cluster from Continuent http://www.continuent.com