Re: Simplifying replication

On 19/10/10 13:16, Josh Berkus wrote:
> Robert asked me to write this up, so here it is.
>
> It is critical that we make replication easier to set up, administrate
> and monitor than it currently is. In my conversations with people,
> this is more important to our users and the adoption of PostgreSQL
> than synchronous replication is.
>
> First, I'm finding myself constantly needing to tutor people on how to
> set up replication. The mere fact that it requires a minimum 1-hour
> class to explain how to use it, or a 10-page tutoral, tells us it's
> too complex. As further evidence, Bruce and I explained binary
> replication to several MySQL geeks at OpenSQLCamp last weekend, and
> they were horrified at the number and complexity of the steps
> required. As it currently is, binary replication is not going to win
> us a lot of new users from the web development or virtualization world.
>

+1

I've been having the same experience - how to set this up and do
failover and failback etc occupies quite a bit of time in courses I've
been teaching here in NZ and Australia. Having this whole replication
business much simpler is definitely the way to go.

A good example of how simple it can be is mongodb, where it is
essentially one command to setup a 2 replica system with a voting arbiter:

$ mongo
> rs.initiate(
{
_id : "replication_set0",
members : [
{ _id : 0, host : "192.163,2,100" },
{ _id : 1, host : "192.168.2.101" },
{ _id : 2, host : "192.168.2.103", arbiterOnly : true }
]
}
)