Linux/FreeBSD based loadbalancing frontend to MySQL

[Machete_]

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]

Linux high availability with keepalived.

[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.

[Machete_]

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]

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_]

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]

We are about to evaluate uni/cluster from Continuent

http://www.continuent.com

[Machete_]

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]

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_]

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