replication « MySQL « JPA Q&A





1. Mysql to Mysql - Hibernate replication using db40/drs?    stackoverflow.com

I would like to do Mysql to Mysql replication using drs. Is it possible to do the same without storing data in db4o? I just want to use drs ...

2. mysql replication and hibernate    coderanch.com

Hi all, Has anyone done the mysql replication and used hibernate in the application? I am working on a fairly large web site that requires us to use mysql replication. I was wondering how hibernate handles mysql replication. Do I have to change the code accordingly and specify some configuration information to hibernate to use mysql replication? I am also using ...

3. Mysql + Replication    forum.hibernate.org

I want Hibernate to make use of the Replication (Master/Slave). Below is our datasource: PortalDS jdbc:mysql://masterurl:3399,slaveurl:4498/mydb com.mysql.jdbc.ReplicationDriver system system true true 5 20 0 I am extending on the MySQLInnoDBDialect Below is my persistence.xml: org.hibernate.ejb.HibernatePersistence java:/PortalDS

4. MySQL Replication: Reading from slaves - how?    forum.hibernate.org

I set up a MySQL Replication Database System with one master and one slave. However, all requests (read/write) go to the master. How must I configure Hibernate to do the reads from the slave? I heard from a roundRobinLoadBalance property in hibernate.cfg.xml, but this doesnt help. Do I have to call a special method such as setReadOnly(true); ? I cannot find ...