Hi,

I hope this is a stupid question but I'm trying to work out how to 
configure a database connection in pylons to use a database failover.

I currently have 2 database servers set up in a master-master 
replication set up and wish for the pylons app to fail over to the 
second database server when the first goes down.

I'm running Pylons 0.9.5 with SqlAlchemy 0.3 and mysqldb but a solution 
for 0.9.6 or SA 0.4 would be sufficient for pointing me in the right 
direction.

In Java I would achieve this with a connection string that looks like 
the following,

jdbc:mysql://db1.example.com,db2.example.com/dbname?failOverReadOnly=false&useUnicode=true&characterEncoding=UTF-8

Thanks in advance,

Jon

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to