Update: So far I've been looking at the connection driver level following recommendations from Mauricio Scheffer on Stackoverflow.
Connector/J for MySQL has a configurable "ReplicationDriver", allowing you to specify what are reads/writes in code on the connection object (e.g. "conn.setReadOnly(false)" flags the database action as a Write and sends this to the configured Master). Connector/Net doesn't appear to have an equivalent. Closest being specifying multiple databases in the connection string (by delimiting separate host names with an "&") and while this is working for me in a Master-Master set up, I'm still looking to locate a Master/Slave solution. -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
