Eventmachine talk - Jun 2008 - Speaking of evented database

You know, if you were of a mind to be evil, you might think about what
you could do by writing up the SERVERSIDE of the MySQL protocol, and
then proxying. For instance, maybe inside a Rails process isn''t the
right place to do connection pooling, caching, invalidation, and load
balancing.

--
---
Thomas H. Ptacek // matasano security
read us on the web: http://www.matasano.com/log

On Wed, Jun 11, 2008 at 11:55 PM, Thomas Ptacek <tqbf at matasano.com>
wrote:
> You know, if you were of a mind to be evil, you might think about what
> you could do by writing up the SERVERSIDE of the MySQL protocol, and
> then proxying. For instance, maybe inside a Rails process isn''t
the
> right place to do connection pooling, caching, invalidation, and load
> balancing.
I guess I don''t quite understand what such a system would entail.  So
you''d have an intermediary proc that would handle balancing, etc, and
keep open live connections to the database?
That has potential.  At least it would segregate the labor.

I did notice, however, that mysql had some hint of adding libevent to
its client [?] architecture.
http://krow.livejournal.com/572937.html
But that''s not too much help to us, being still in beta or what not.
For now I can be casually optimistic that an evented web service would
show some type of performance increase.  I guess the only parts
lacking to test this out are 1.9 compatibility for the adapter, and
getting Sequel to ''play nice'' with fibers, and the use the
adapter,
and then it''s a drop in replacement.
Take care.
-R