Re: PG vs MySQL

Alex wrote:

> MySQL is still the default database offered by any web hosting company 
> and if Postgres wants to become the designated db engine for these 
> services or become the worlds no.1 open source db then i think lots of 
> things need to be done. Take for example the admin interface (MySQL 
> Administrator) for MySQL which is done very professionally or the ease 
> of setting up Replication. Postgres still is quite far behind there and 
> for normal users that know MySQL best the transition is probably a too 
> big step and risk.

How easy is it to setup a reliable replication with failover, switchover 
and especially switchback? I have never done that in MySQL, but you seem 
to know quite a bit about it. If I have one master and 3 slaves, and I 
need to shutdown the master for maintenance purposes, what do I have to 
do to switch over to one of the slaves, let the other two slaves 
replicate against that new master, and when I'm done and the original 
master could take over again, what's the procedure to get it back into 
the master role? Keep in mind that our databases are quite a few 
gigabytes in size and that longer interruption of accessibility is not 
acceptable (that's what we do that replication stuff for in the first 
place).

If you don't know the answers to that, I assume it isn't that easy as 
people try to make believe. And in case the answer is "that is not 
possible but ...", then you better think again what you want that 
replication setup for.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #