[Sqlrelay-discussion] Deploying SQLRelay

[Tom H. <tom...@si...>]

I just started looking into SQLRelay mostly from a standpoint of 
connection pooling when I found out that it is also able
to do load balancing, routing and filtering.

I have a configuration of about 23 servers all connecting to a cluster 
of MySQL database servers hosting several databases.
Database servers are set up in master-slave configurations where the 
slaves are put "behind" a load-balancer.

Some of the application servers host websites where the database load 
will be relatively low bust most of them host webservices
that need to be able to handle several thousands of requests per hour. 
All of these requests will result in one or more database transactions.
Right now all the applications running on these server decide themselves 
which database to access (albeit via some configuration mechanism),
whether they need to connect to a master or a slave, etc. but you can 
imagine that maintenance of this configuration mechanism is becoming
quite a challenge.

My question is: would it be possible to deploy SQLRelay on one separate 
server where all the servers mentioned above connect to for their
database access? I guess that's exactly the idea behind SQLRelay but 
wouldn't it become a huge bottleneck?

In addition: has anyone ever tried building a native driver for LDAP?

Thanks for your time.


Kind Regards,
Tom Hesp
tom...@si...