From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Justifying a PG over MySQL approach to a project |
Date: | 2009-12-17 16:23:48 |
Message-ID: | 482E80323A35A54498B8B70FF2B879800437F852BB@azsmsx504.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How difficult is it to switch the master's hat from one DB instance to another? Let's say the master in a master-slave scenario goes down but the slave is fine. Can I designate the slave as being the new master, use it for read/write, and then just call the broken master the new slave once it comes back to life (something like that)?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Greg Sabino Mullane
Sent: Thursday, December 17, 2009 9:28 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Justifying a PG over MySQL approach to a project
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> - MySQL is horizontally scalable via clustering and multi-master
> replication (though you must beware of numerous gotchas). PostgreSQL can
> be used with read-only slaves via Slony/Bucardo/etc replication, but is
> limited to a single authoriative master.
>
> (There's work ongoing to enable readonly hot standby slaves with
> failover, but no multi-master is on the horizion).
Well that's refreshing: usually Bucardo is mistaken for a system that
only does master-master and not master-slave, rather than vice-versa. :)
You can have two authoritative masters with Bucardo, in addition to
any number of slaves radiating from one or both of those (as well as
just simple master->slaves).
> - It's a cool tool when you want to query and integrate data from all
> sorts of disparate sources, thanks to its support for pluggable storage
> engines. If you want something for data analysis and integration rather
> than safe storage it's well worth looking at.
What sort of sources? I'm curious here to find areas we can improve upon.
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 200912170927
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAksqP9kACgkQvJuQZxSWSshbUQCg3CfvpeivDi6gg2bkr74I17Qe
RKAAnRu3GTUQ3Bg3R2Fq3eOsgK4N0xd1
=5r9R
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2009-12-17 16:51:19 | Re: Justifying a PG over MySQL approach to a project |
Previous Message | Gauthier, Dave | 2009-12-17 16:19:05 | Re: Justifying a PG over MySQL approach to a project |