List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 12 2010 11:42am
Subject:Re: mysql proxy in production?
View as plain text  
On Thu, Mar 11, 2010 at 4:49 PM, Brent Clark <brentgclarklist@stripped>wrote:

> On 11/03/2010 16:52, Krishna Chandra Prajapati wrote:
>
>> Hi Brent
>>
>> You can visit the below link.
>>
>>
>>
> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
>>
>
> Well thats disappointing.
>
> sigh
> So what are we supposed to use for loadbalancing mysql.
>

Throw plenty of servers at it :-) If you put three servers behind the proxy,
you'll get the same performance as a single server, every additional server
is performance benefit :-D

Seriously, though, I don't have much faith in these kind of things (in the
context of read/write splitting, that is), because the proxy can never know
wether there'll be a write-request in the session without notification from
the client anyways. If you have to modify your application anyway, just do
it toroughly (you have to fish out the connects that will write in either
case, so that's half the work done) and make your application fully
slave-aware. That also allows you to tighten security by assigning a
select-only user for the read connections, diminishing the chances of a
succesfull sql injection.

If you're wondering about loadbalancing between read-only slaves, you don't
need a SQL aware proxy, just balance at level 4 using ldirectord or a
hardware loadbalancer with sticky sessions.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
mysql proxy in production?Brent Clark11 Mar
  • Re: mysql proxy in production?Krishna Chandra Prajapati11 Mar
    • Re: mysql proxy in production?Johan De Meersman11 Mar
      • Re: mysql proxy in production?John Daisley11 Mar
        • Re: mysql proxy in production?Walter Heck - OlinData.com12 Mar
          • Re: mysql proxy in production?Krishna Chandra Prajapati12 Mar
    • Re: mysql proxy in production?Brent Clark11 Mar
      • Re: mysql proxy in production?Mark Matthews11 Mar
      • Re: mysql proxy in production?Johan De Meersman12 Mar
        • Re: mysql proxy in production?Krishna Chandra Prajapati12 Mar
          • Re: mysql proxy in production?Johan De Meersman12 Mar