How to loadblance Oracle DB by use irules to differentiate read and write request?

Hi Charlie,

 

There is a post similar to your request made in the Oracle Forum

 

 

http://devcentral.f5.com/Community/GroupDetails/tabid/1082223/asg/63/aft/2929/showtab/groupforums/Default.aspx

 

 

I hope this helps

 

Bhattman

I don't think the logic is quite that easy though, as you could have a DDL command with a select statement:

 

 

SELECT *

 

INTO new_table

 

FROM old_table

 

 

If this is something you'd like to see built into LTM, you could open a case with F5 Support with details on your use case.

 

 

Aaron

Hi Bhattman,

 

That irule cause can not connect to the database

 

 

Hi Hoolio,

 

Thank you for your suggestions

 

 

Charlie

hi Charlie,

 

The iRule won't know how to connect to the database - simply because the irule is looking into the TCP packet. However, that would lead into a more sophisticated version of the Irule to account for the DDL command.

 

 

 

Bhattman