This question may be more appropriate in the mysql forums (so I've asked it there too) but I wanted to see if anyone knew how to do it here.
I'm setting up replication with mysql and have it successfully using the ReplicationDriver & the @Transactional annotations.
I'm seeing it utilize both the master and the slave, but it's not only using the slave for reads (sometimes it reads from the master). This is only a problem because we'd like to use replication to enable a foreign site to query our web-app quicker (we'll set up a local slave & webserver so their queries are quick but writes are still going to the master, so they'll be slower)
Does anyone have any ideas or somewhere to point me to? Thanks!