[jboss-user] [JCA/JBoss] - mysql datasource with read-only and write nodes

[brettcave]

Hi,

I am almost sure i came across some documentation a while ago on how to configure a mysql datasource to specify readonly and write nodes. I found this thread in the forums:
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=52346
but no real resolution on it.

Is this possible? e.g
1 datasource, with 2 mysql servers defined, and 1 configured as readonly server, while all writes are directed to the other.

also, with regards to the post listed above, what is CMP referring to (excuse my ignorance)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4204252#4204252

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4204252