topic Re: Can css load balancing oracle sql queryes? in Application Networking

Can css load balancing oracle sql queryes?

rvv — Thu, 19 Jul 2007 09:50:09 GMT

We have 2 Oracle database servers.

We need to switch sql querys between them.

Can we use Cisco CSS?

Or maybe we need some other solution?

Re: Can css load balancing oracle sql queryes?

catliao — Thu, 19 Jul 2007 15:31:51 GMT

Hi!

Are you looking to a) load balance specific type of query to a particular server? Or are you simply looking to b) distribute traffic to the two servers regardless of query type? The latter is basically L4 switching and supported by CSS (though you do need to make sure that the db knows how to properly replicate records with each other). a) is basically generic protocol parsing and is not supported on the CSS today.

Catherine

Re: Can css load balancing oracle sql queryes?

rvv — Thu, 19 Jul 2007 19:12:37 GMT

Hi!

We need load balance traffic, but we need load balance all type of query type ( updates etc...)

What i wanna to know is how CSS will work with dynamic port allocation scheme in oracle?

Oracle use not only 1525/tcp.

And how to keep user on one server when user can establish multiple tcp connections during one trnsaction?

Re: Can css load balancing oracle sql queryes?

catliao — Fri, 20 Jul 2007 01:11:06 GMT

Have you looked at using a sqlnet proxy to enable the consolidation of dynamic ports? Another approach to this would be to load balance traffic destined to a vip only rather than vip:port. You can maintain sticky based on source ip.

Re: Can css load balancing oracle sql queryes?

rvv — Sat, 21 Jul 2007 05:12:09 GMT

Thnx! I think sticky based on source ip will help to solve dynamic ports.

What is sqlnet proxy?

Re: Can css load balancing oracle sql queryes?

catliao — Mon, 23 Jul 2007 14:34:24 GMT

sqlnet proxy is a feature that is part of some firewalls designed to address the dynamic ports in sqlnet.