Atomikos Forum

I want MySql Replication. (writes on master, reads on slave)

In order to get MySql replication driver to hit the slave, the connection must be ReadOnly.

In order to get the connection readonly since I use Spring, i must use a TransactionManager and set the Transaction to readonly.

So I randomly picked Atomikos. Because it's free.

Here's my code:

http://screencast.com/t/WbXZWZTErk

I just want readonly connections!

Apparently it wasn't enough, I had to create a wrapped thing, because Atomikos doesn't cascade readonly to the connection (my entire point...)

http://screencast.com/t/v0GJQkRaGvrU


Here's the concern:

http://screencast.com/t/v0GJQkRaGvrU

Apparently there's a large CPU bottleneck caused by using Atomikos, that is waiting for the disk.

Please help!

I am unable to modify my request, so here's the missing screenshot:

http://screencast.com/t/u05lWVZufKo

It appears that i missed the (defaults to true) setting:

com.atomikos.icatch.enable_logging

I set this to false, and am investigating the performance ramifications.

Disabling the logging should help indeed.

Best