Forum Discussion

ayl_7563's avatar
ayl_7563
Historic F5 Account
Jun 30, 2009

irules for database loadbalancing based on read /write

Hi,

 

 

has anyone successfully written an irule for oracle or mssql to do loadbalncing based on read and write for the app / db layer?

 

 

Regards,

 

 

ayl
  • My .02: this is very tricky to do correctly, so be sure and characterize that SQL traffic carefully. For example, an insert based on a sub query could be interesting to say the least!

     

    -Matt
  • I think the key point is the DB protocol. If we could know them, we can use irues to resolve it!