Russ wrote: > What I want is what the latest MySQL sort of provides. I want to have > separate machines with local storage each running a DB daemon, and to be > able to at least have automatic failover
So I presume that you mean MySQL replication (since MySQL Cluster is main-memory and doen't have the local storage). In PostgreSQL you do that with Slony-1. It is an open source add ons you can just plug in and you don't even need to restart to do that. For the automatic failover you need to add a hartbeat and probably STONITH, but you should be used to that because you need that with MySQL as well to prevent a split brain. Apparently you can also do that with Bucardo (never tried that) and commercially with Mammoth Replicator. > and even better to have them both > be master's (basically being able to do load balancing). Multimaster replication would be done with either PGcluster, Cybercluster, PLProxy, Bucardo or pgpool-II. All open source and they all work with different algorithms so you can pretty much mix and match to your needs. Greenplum, EnterpriseDB and Continuent also provide commercial solutions and I am not sure in which list to put Gorda and Postgres-R. And I might have skipped a few :) The main reason there is no clustering and / or replication support in the PostgreSQL core is they really mean something different to everybody. There is no one size fits all solution so which one should be put in? There may be some movement on that since core has recently reached consensus and they plan to include a lossless shared-nothing HA solution in core that may be extended to do master-slave replication, but that will probably have to wait to 8.5. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
