On Wed, May 21, 2008 at 09:49:32AM -0700, Mike Orr wrote:
> So how do you handle writes? You direct them all to one master server
> and let it propagate the changes to the slaves? Have you found a good
> replicable database among the free ones that work with SQLAlchemy?
Postgres was mentioned; I'll add that MySQL's replication is also
quite good for splitting out reads against replicas if your
application isn't write bound.
MySQL Cluster is now GA, with provides for HA db servers and
performance scalability without splitting reads and writes between
different servers. Downside is that you need at least four
servers....
--
Ross Vandegrift
[EMAIL PROTECTED]
"The good Christian should beware of mathematicians, and all those who
make empty prophecies. The danger already exists that the mathematicians
have made a covenant with the devil to darken the spirit and to confine
man in the bonds of Hell."
--St. Augustine, De Genesi ad Litteram, Book II, xviii, 37
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
