Re: PostgreSQL vs. MySQL

On Monday 01 August 2005 13:52, Scott Marlowe wrote:
> On Mon, 2005-08-01 at 11:44, Vratislav_Morkus(at)lmc(dot)cz wrote:
> > Hi all,
> > I am sorry for a stupid easy question, but I'am PostgreSQL novice.
> > Our development team has encountered problem with trying to install and
> > maintain cluster (pgcluster) on our production database. So they have
> > decided to switch the entire solution to MySql database.
> > a) have you got any good/bad experience with administering and running
> > cluster on PostrgeSQL DB?
> > b) would u switch PostgreSQL to MySql (7.4 --> 4.1) and why?
>
> I would never switch from pgsql to mysql.
>
> Here's a short list of the reasons why:
>
> http://sql-info.de/mysql/gotchas.html
>
> If they're having problems and haven't asked for help in these lists,
> then I'm willing to be they're just looking for an excuse to change to
> what they're comfortable with, and not really serious about using
> postgresql.
>
> Also, why pgcluster? why not slony or mammoth replicator? Both of
> those are fine pieces of software that handle most replication needs.
> Combine slony with pgpool and a few scripts and you've got quite a nice
> cluster setup.
>

Can someone point me to the multi-master replication docs for my$ql 4.1? I
agree with Scott, sounds like they are looking for an excuse.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL