Can a Cisco ACE load balance JDBC queries !!!

nlkarthik · ‎02-09-2011

For example, can it view the query string and send all such queries to the same server? This will allow the queries to hit the server that already has the cache for the query .If so, how wil the setup be....Please advice

FYI,

JDBC -- Java Database connectivity.

JDBC is a set of API's that offer a database-independent means of extracting and/or inserting data to or from a database.To perform these insertions and extractions,SQL code also resides in this tier facilitating create,read,update and delete actions.

Francesco Casotto · ‎02-09-2011

Hello Karthikeyan,

well, ACE does not implement a JDBC protocol interpreter, so there is no simple way to configure LB based on the sql query, to my knowledge JDBC is not based on HTTP, so the HTTP interpreter will not help here.

What you can try to do is implementing Generic Layer 4 Payload Parsing configuration for stickiness and/or LB decisions, you can have a look here:

http://www.cisco.com/en/US/docs/interfaces_modules/services_modules/ace/vA4_1_0/configuration/slb/guide/sticky.html#wp1064423

http://www.cisco.com/en/US/docs/interfaces_modules/services_modules/ace/vA4_1_0/configuration/slb/guide/classlb.html#wp1156050

is basically a way to look at whatever is in the data field of the TCP or UDP packet and try to match against regular expressions and use the match result for lb decisions, to try to implement it I suggest you start from having a look at packet captures of the JDBC traffic, checking if you can see the query strings you'd like to match on.

Please be aware that depending on the protocol format It might however not be possible to achieve the result you desire or might be quite difficult.

Hope it helps,

Francesco

nlkarthik · ‎02-10-2011

Hi Francesco,

Many thanks for your prompt response... Let me try this and update you.

Regards,

Karthik