Hi, I have been thinking about logic for a second DSN for failover with some time interval to try the second source. If I am using asynchronous replication, time is required to allow slave to become master.
For application logic, I don't want to tolerate a failure. Rather, I want to log exception and setup up a sleep and try cycle until the next DSN is available. I am wondering if this logic ought to be in sqlalchemy's create_engine to allow a second DSN and a parameter for time between tries to second DSN. Overall, connections to original DSN would die and exception would trigger trying the second source. Perhaps there are alternatives also. Many thanks. Regards, David --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
