public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Scott Marlowe <[email protected]>
Cc: Jason McManus <[email protected]>
Cc: pgsql general <[email protected]>
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Date: Fri, 30 Jun 2006 11:39:04 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Scott Marlowe <[email protected]> writes:
> On Fri, 2006-06-30 at 08:17, Jason McManus wrote:
>> * Replication support still rudimentary.

> Hmmmm.  I think that's an overly simplistic evaluation.  The slony
> replication engine is actually VERY advanced, but the administrative
> tools consist mostly of "your brain".  hehe.  That said, once you've
> learned how to drive it, it's quite amazing.  Keep in mind, slony can be
> applied to a living database while it's running, and can run between
> different major versions of postgresql.  That's a pretty advanced
> feature.  Plus, if the replication daemons die (kill -9ed or whatever)
> you can restart replication and slony will come right back where it was
> and catch up.

It might be worth pointing out that mysql's replication falls over
if you so much as look at it crosseyed.  I have not had to use it
for production purposes, but I can tell you that the mysql replication
regression tests fail ... irreproducibly of course ... almost one time
in two in Red Hat's build environment.  I've been able to trace a few of
these failures to quirks of the build environment, like trying to build
x86 and x86_64 at the same time in different chroots of the same machine
(must take care not to use same TCP port numbers for tests), but it
still seems flaky as hell.

			regards, tom lane

view thread (38+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox