Hiya

I work for a pretty large hosting company, and we have some clients that you could call "in demand clients" (Well .... here where I live anyway :) ).

We already making use of heartbeat for high availability etc. But the one area that we have not tackled is load balancing.

I just read the following, which makes use of mysql proxy.

http://agiletesting.blogspot.com/2009/04/mysql-load-balancing-and-read-write.html

I would like to ask, does anyone make use of mysqlproxy in production, and if so, are you using it under "heavy load".
How do you find how it performance under load.

If anyone can share their failures, successors or even just thoughts and opinions on mysql-proxy (even SQL load balancing in general), I would be most grateful.

Kind Regards
Brent Clark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Hi Brent

You can visit the below link.

http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/

<http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/>
Thanks,
Krishna

On Thu, Mar 11, 2010 at 7:56 PM, Brent Clark <brentgclarklist@[Protected]>wrote:

> Hiya
>
> I work for a pretty large hosting company, and we have some clients that
> you could call "in demand clients" (Well .... here where I live anyway :) ).
>
> We already making use of heartbeat for high availability etc. But the one
> area that we have not tackled is load balancing.
>
> I just read the following, which makes use of mysql proxy.
>
>
> http://agiletesting.blogspot.com/2009/04/mysql-load-balancing-and-read-write.html
>
> I would like to ask, does anyone make use of mysqlproxy in production, and
> if so, are you using it under "heavy load".
> How do you find how it performance under load.
>
> If anyone can share their failures, successors or even just thoughts and
> opinions on mysql-proxy (even SQL load balancing in general), I would be
> most grateful.
>
> Kind Regards
> Brent Clark
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=prajapatikc@[Protected]

Bah, just spilled coffee on my keyboard.

I never was a big fan of mysqlproxy, but this is almost inconceivable. The
next genius to suggest it for our environment had better have asbestos
underwear.

Thanks for the link, Krishna.


On Thu, Mar 11, 2010 at 3:52 PM, Krishna Chandra Prajapati <
prajapatikc@[Protected]> wrote:

> Hi Brent
>
> You can visit the below link.
>
>
> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
>
> <
> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
> >
> Thanks,
> Krishna
>
> On Thu, Mar 11, 2010 at 7:56 PM, Brent Clark <brentgclarklist@[Protected]
> >wrote:
>
> > Hiya
> >
> > I work for a pretty large hosting company, and we have some clients that
> > you could call "in demand clients" (Well .... here where I live anyway :)
> ).
> >
> > We already making use of heartbeat for high availability etc. But the one
> > area that we have not tackled is load balancing.
> >
> > I just read the following, which makes use of mysql proxy.
> >
> >
> >
> http://agiletesting.blogspot.com/2009/04/mysql-load-balancing-and-read-write.html
> >
> > I would like to ask, does anyone make use of mysqlproxy in production,
> and
> > if so, are you using it under "heavy load".
> > How do you find how it performance under load.
> >
> > If anyone can share their failures, successors or even just thoughts and
> > opinions on mysql-proxy (even SQL load balancing in general), I would be
> > most grateful.
> >
> > Kind Regards
> > Brent Clark
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=prajapatikc@[Protected]
> >
> >
>



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

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.

Thank you for your reply.

Kind Regards
Brent Clark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

On Mar 11, 2010, at 9:49 AM, Brent Clark 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.
>
> Thank you for your reply.
>
> Kind Regards
> Brent Clark

Brent,

Some clients (namely the JDBC driver, and the R-O-R adapter) have load balancing built in.

-Mark
--
Mark Matthews
Principal Software Developer - Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]

Has MySQL Proxy been improved since that article was released?

I ask because although I have no personal experience with it I do know of a
big UK based online payment processing company who use MySQL Proxy with
MySQL 5.1 in production very successfully.


On Thu, Mar 11, 2010 at 3:34 PM, Johan De Meersman <vegivamp@[Protected]>wrote:

> Bah, just spilled coffee on my keyboard.
>
> I never was a big fan of mysqlproxy, but this is almost inconceivable. The
> next genius to suggest it for our environment had better have asbestos
> underwear.
>
> Thanks for the link, Krishna.
>
>
> On Thu, Mar 11, 2010 at 3:52 PM, Krishna Chandra Prajapati <
> prajapatikc@[Protected]> wrote:
>
> > Hi Brent
> >
> > You can visit the below link.
> >
> >
> >
> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
> >
> > <
> >
> http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/
> > >
> > Thanks,
> > Krishna
> >
> > On Thu, Mar 11, 2010 at 7:56 PM, Brent Clark <brentgclarklist@[Protected]
> > >wrote:
> >
> > > Hiya
> > >
> > > I work for a pretty large hosting company, and we have some clients
> that
> > > you could call "in demand clients" (Well .... here where I live anyway
> :)
> > ).
> > >
> > > We already making use of heartbeat for high availability etc. But the
> one
> > > area that we have not tackled is load balancing.
> > >
> > > I just read the following, which makes use of mysql proxy.
> > >
> > >
> > >
> >
> http://agiletesting.blogspot.com/2009/04/mysql-load-balancing-and-read-write.html
> > >
> > > I would like to ask, does anyone make use of mysqlproxy in production,
> > and
> > > if so, are you using it under "heavy load".
> > > How do you find how it performance under load.
> > >
> > > If anyone can share their failures, successors or even just thoughts
> and
> > > opinions on mysql-proxy (even SQL load balancing in general), I would
> be
> > > most grateful.
> > >
> > > Kind Regards
> > > Brent Clark
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/mysql?unsub=prajapatikc@[Protected]
> > >
> > >
> >
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel

Take a look at haProxy. It can be combined with some scripts to
loadbalance mysql.
http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/
We use it at Open Query for a similar case.

Cheers,

Walter Heck

Engineer @ Open Query
http://openquery.com | http://openquery.com/blog |

On Fri, Mar 12, 2010 at 02:09, John Daisley <daisleyjohn@[Protected]> wrote:
> Has MySQL Proxy been improved since that article was released?
>
> I ask because although I have no personal experience with it I do know of a
> big UK based online payment processing company who use MySQL Proxy with
> MySQL 5.1 in production very successfully.
>
>
> On Thu, Mar 11, 2010 at 3:34 PM, Johan De Meersman <vegivamp@[Protected]>wrote:
>
>> Bah, just spilled coffee on my keyboard.
>>
>> I never was a big fan of mysqlproxy, but this is almost inconceivable. The
>> next genius to suggest it for our environment had better have asbestos
>> underwear.
>>
>> Thanks for the link, Krishna.
>>
>>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=archiver@[Protected]