[Sqlrelay-discussion] Deploying SQLRelay
Brought to you by:
mused
|
From: Tom H. <tom...@si...> - 2008-10-21 15:06:07
|
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... |