Has anyone tried to split read and write commands across databases in a pool? We are using tomcat and we have several requirements:
1. Balance requests across two mysql databases (master/slave) for an application which is read-only. We could do that within the mysql JDBC adapter (jdbc:mysql:replication), within tomcat (not sure how but there is some pooling mechanism) or within Cayenne itself (with some code to route requests). 2. Same as the above but for an application which is read-write. So read-write requests must go to the master. Right now, I am more concerned about (1) and about the ability for the app to automatically stop using a database which has failed. The tomcat connector has validationQuery, but I'm not sure how this applies across multiple databases in this way. Has anyone tried to do anything like this? Cheers Ari -- --------------------------> Aristedes Maniatis ish http://www.ish.com.au Level 1, 30 Wilson Street Newtown 2042 Australia phone +61 2 9550 5001 fax +61 2 9550 4001 GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
