Re: Notes on converting from MySQL 5.0.x to PostgreSQL

Scott Marlowe <smarlowe(at)g2switchworks(dot)com> 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