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 any help on the web. No Tutorial, no discussion, no blog that would describe how to set up Hibernate with MySQL Replication.

You'll have to set up two session factories, and specify which one to use when loading objects. Writing any changes will be tricky (collections in particular don't like being moved between sessions), but I wouldn't advise writing anything to your master server that you've read from the slave.

Are you sure? Can anybody confirm this?

I mean, why do I configure the MySQL Replication Driver in hibernate.cfg.xml like this, with the master and the slave host?