irule to send database read requests to one database and database write requests to another

Hi Pete,

I'm not sure this is as simple as looking for read keywords. Would you want a query like this being sent to a read pool or write pool?

UPDATE t1
SET s1 = "something"
WHERE column_name IN (
   SELECT s2 FROM t2
);

I think it might be safer to look for DDL keywords indicating a write/modification. However even doing that doesn't account for invalid matching like this:

SELECT c1 FROM t1 WHERE c2 LIKE 'some string with update or create in it';

Anyhow to address your question, I think you'd need to continue collecting and releasing the payload. But this isn't something I've tested with TCP. Is this SOAP over HTTP? If so, you could potentially add an HTTP profile and then use HTTP::collect on each HTTP_REQUEST.

Aaron