07-19-2007 02:50 AM
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?
07-19-2007 08:31 AM
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
07-19-2007 12:12 PM
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?
07-19-2007 06:11 PM
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.
07-20-2007 10:12 PM
Thnx! I think sticky based on source ip will help to solve dynamic ports.
What is sqlnet proxy?
07-23-2007 07:34 AM
sqlnet proxy is a feature that is part of some firewalls designed to address the dynamic ports in sqlnet.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide