?

Log in

No account? Create an account

Proxy, Proxy, on the Wall, who is the fairest of them all...

« previous entry | next entry »
May. 9th, 2008 | 11:17 am

Dear Lazyweb,

I am tracking three four five lots of different proxies for MySQL today:

http://forge.mysql.com/wiki/MySQL_Proxy
http://consoleninja.net/code/dpm/README.html
http://spockproxy.sourceforge.net/
http://sqlrelay.sourceforge.net/
http://myosotis.continuent.org/HomePage
Proximo

Would someone please do a write up on which is best, which is moving forward, and synopsis the differences? I don't expect a front runner just yet, but it would be nice to see a comparison about how their development is going.

Thanks!
-Brian

BTW I am sorry if I missed a proxy, if you have another one email me or leave a comment.
BBTW I don't consider HScale a proxy, but yes it is damn neat.
BBBTW I think the creation of proxies, points to a trend ;)

Link | Leave a comment |

Comments {21}

Missed one!

from: todointx
date: May. 9th, 2008 07:48 pm (UTC)
Link

SQL Relay, http://sqlrelay.sourceforge.net/

Have used it several years before MySQL came into existence.

Reply | Thread

Re: Missed one!

from: todointx
date: May. 9th, 2008 07:48 pm (UTC)
Link

s/MySQL/MySQL proxy/

Reply | Parent | Thread

Brian "Krow" Aker

Re: Missed one!

from: krow
date: May. 9th, 2008 08:55 pm (UTC)
Link

Added yours :)

Reply | Parent | Thread

El JoPe Magnífico

(no subject)

from: jope
date: May. 9th, 2008 08:52 pm (UTC)
Link

Mmm, yes, I keep meaning to arrange a conversation with you about this.

Reply | Thread

Brian "Krow" Aker

(no subject)

from: krow
date: May. 9th, 2008 08:55 pm (UTC)
Link

Are you on the proxy kick as well?

Reply | Parent | Thread

El JoPe Magnífico

(no subject)

from: jope
date: May. 9th, 2008 08:59 pm (UTC)
Link

It pays the bills.

Reply | Parent | Thread

myosotis

from: muzazzi
date: May. 9th, 2008 10:01 pm (UTC)
Link

http://myosotis.continuent.org/HomePage

This one is kind of cute. It's not as flexible as mysql-proxy & friends, but it masquerades as a MySQL or PostgreSQL frontend and connects to (non-MySQL/Postgres) backend servers via JDBC.

Reply | Thread

Me too...

from: jzawodn
date: May. 9th, 2008 10:06 pm (UTC)
Link

I, for one, wish to partake in this harvest of information.

Reply | Thread

Brian "Krow" Aker

Re: Me too...

from: krow
date: May. 9th, 2008 10:36 pm (UTC)
Link

I thought you never did anything with MySQL anymore? :)

Reply | Parent | Thread

Re: Me too...

from: jzawodn
date: May. 9th, 2008 10:39 pm (UTC)
Link

But I still try to stay informed... a little.

Besides, you never know when the opportunity to do something different may arise!

Reply | Parent | Thread

Brian "Krow" Aker

Re: Me too...

from: krow
date: May. 9th, 2008 11:11 pm (UTC)
Link

Very true :)

Reply | Parent | Thread

(Deleted comment)

Brian "Krow" Aker

(no subject)

from: krow
date: May. 10th, 2008 04:13 pm (UTC)
Link

What all were you disappointed in at the talk?

Reply | Parent | Thread

(Deleted comment)

Brian "Krow" Aker

(no subject)

from: krow
date: May. 11th, 2008 02:27 am (UTC)
Link

Being a fan of C, I can certainly see the sexiness of writing it in a nice scalable language.

Reply | Parent | Thread

(no subject)

from: jamesd
date: May. 10th, 2008 10:56 pm (UTC)
Link

Proximo.

Reply | Thread

Brian "Krow" Aker

(no subject)

from: krow
date: May. 11th, 2008 02:26 am (UTC)
Link

Have you played with it? It being Perl makes it pretty sexy :)

Reply | Parent | Thread

xb95

(no subject)

from: xb95
date: Jun. 9th, 2008 10:21 pm (UTC)
Link

I don't think anybody has actually played with it besides me, and I wrote it, so I don't think I count. ;-)

It's quite functional and works well for what it does, but it's pure Perl at this point and isn't extremely fast. I think the MySQL Proxy approach of having a C core is a good one, but I ran into the same issues as the above poster - couldn't figure out how to do what I wanted. (Which is mostly documentation and lack of Lua knowledge, I imagine.)

Also, I'm a sucker for Perl. All those years working on Perlbal, the same sort of approach seems like it would work really well for MySQL as well!

Reply | Parent | Thread

dbslayer

from: dgottfrid
date: May. 12th, 2008 02:32 am (UTC)
Link

http://code.nytimes.com/projects/dbslayer

Reply | Thread

matt

(no subject)

from: sent2matt
date: Oct. 9th, 2008 01:47 am (UTC)
Link

Beautiful list, thanks a lot

(I wish I could use openid to leave comments)

Reply | Thread

Brian "Krow" Aker

(no subject)

from: krow
date: Oct. 9th, 2008 02:14 am (UTC)
Link

You can't enable openid on Livejournal without enabling all anonymous comments at the same time :(

Reply | Parent | Thread

matt

(no subject)

from: sent2matt
date: Oct. 9th, 2008 03:46 pm (UTC)
Link

Yep, I've fixed that for the installation of LJ.Rossia.org
but never proposed the change into upstream.

Since the change is quite easy (speaking of technical part)
I suppose they have some social/political issues with it

Reply | Parent | Thread

Brian "Krow" Aker

(no subject)

from: krow
date: Oct. 9th, 2008 03:48 pm (UTC)
Link

There are a lot of folks who would like to see that patch applied :)

Reply | Parent | Thread