lateef jackson wrote: > Is it possible to send all insert and updates to multiple database backends? > There is still an issue with getting databases that have failed back in > sync. Just an idea for shortest path.
Use the database server's replication. Trying to send manage updates to several databases through your application will inevitably lead to failure when the updates get issued in different orders on the different servers. (Imagine if you're saving two new objects at the same time. The inserts may not happen in the same order on both databases so the objects have different ids on each database. Any related records inserted will be broken on one of the databases because the ids are inconsistent.) MySQL has supported replication at least since 3.23, I believe there are some third-party solutions for PostgreSQL, and commercial databases should have it built in. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears -~----------~----~----~----~------~----~------~--~---
