Mysql and Replication driver

[Ali]

Hi,

Has anyone used the mysql slave and master with play, I am using the
following configuration but i can't get the application run. I'm sure
im doing something stupid but if you can help i really appreciate it.



db.url=jdbc:mysql:replication://[master ip]:3306,[slave ip]:3306/
<dbname>autoReconnectForPools=true&roundRobinLoadBalance=true&loadBalanceBlacklistTimeout=5000&loadBalanceStrategy=random

db.driver=com.mysql.jdbc.ReplicationDriver
db.user=<dbusername>
db.pass=<dbpassword>

[Madhur Juneja]

Ali

I am not pretty much sure about doing it using replication driver, but
i just did a replication server yesterday of mysql on ec2 following
this link:

http://www.howtoforge.com/mysql_master_master_replication

Regards
MJ

> --
> You received this message because you are subscribed to the Google Groups "play-framework" group.
> To post to this group, send email to play-fr...@googlegroups.com.
> To unsubscribe from this group, send email to play-framewor...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/play-framework?hl=en.
>
>

[notalifeform]

Hi,

I'm actually investigating the same thing, but what I found so far (e.g. http://www.dragishak.com/?p=307)

tells me that using the replication driver is not enough - somehow you must tell the connection that is readOnly - the article describes how to do it in spring.

Is there anybody who succeeded to get this up and running with play?

regards,

Robert