Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
rvv
Community Member

Can css load balancing oracle sql queryes?

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?

5 REPLIES
Community Member

Re: Can css load balancing oracle sql queryes?

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
Community Member

Re: Can css load balancing oracle sql queryes?

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?

Community Member

Re: Can css load balancing oracle sql queryes?

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
Community Member

Re: Can css load balancing oracle sql queryes?

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

What is sqlnet proxy?

Community Member

Re: Can css load balancing oracle sql queryes?

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

288
Views
0
Helpful
5
Replies
CreatePlease to create content