Forum Discussion
charlie_14972
Nimbostratus
NimbostratusHow to loadblance Oracle DB by use irules to differentiate read and write request?
I want to use irules to differentiate oracle read and write request.
Who can tell me how to do it?
rule:
If request include "select" ,then use db_read_pool
else then use db_write_pool
I can not know what is the right syntax.pls help me,thanks.
Charlie
- The_BhattmanHi 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 
hoolioCirrostratus
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
charlie_14972Hi Bhattman,
That irule cause can not connect to the database
Hi Hoolio,
Thank you for your suggestions
Charlie- The_Bhattmanhi 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
