Can css load balancing oracle sql queryes?

rvv · ‎07-19-2007

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?

catliao · ‎07-19-2007

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

rvv · ‎07-19-2007

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?

catliao · ‎07-19-2007

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.

rvv · ‎07-20-2007

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

What is sqlnet proxy?

catliao · ‎07-23-2007

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