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

brettcave do-not-reply at jboss.com
Wed Jan 28 04:51:02 EST 2009


Ok, thanks

The datasources are used for persistence, so the workaround that I did was similar to the post i mentioned.

1 - mysql: grant select only on RO nodes, and insert / update / etc on RW nodes
2 - create 2 datasources, to ro and rw nodes
3 - create 2 persistence units, each one using a different datasource
4 - set persistencecontext / unit in the bean. implement all database writes in a different bean, using the rw persistence unit.




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

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



More information about the jboss-user mailing list