Re[3]: [Cumbria] Mandrake 9.1

[Ian Linwood]

Hello Luke,

Saturday, April 12, 2003, 10:11:20 PM, you wrote:


> I believe in MySQL!

Some people belive in Santa Claus.  ;-)

>> But it all depends what you want to do. MySQL is excellent if you just
>> want a relational database with one or two persistent connections.

> one or two persistent connections? MySQL can handle a lot more then 1 or 2.

Yes, it can. But performance disappears down the plughole. :-(

> PostgreSQL only takes around 5 more concurrent connections before it falls
> over too.

Nonsense.

>> It is hard (if not impossible) to make secure, and misses out
>> a LOT of functionality compared to PostgreSQL.

> Why is it hard or impossible to make MySQL secure? I'd be very interested
> to know what makes it so insecure.

The daemon runs as root.
Also see http://www.paladion.net/papers/socketbinding.pdf
There are others.....

> I'll half agree on the functionality, however MySQL is not far behind.
> MySQL does have replication though, I don't see it in PostgreSQL (apart
> from add-on's)

Replication has been available (but as you say, as an add on)
commercially for MUCH longer that Mysql has has this feature.

Versions 7.4+ of PostgreSQL are working to include this.

BTW, there are many different types of replication. From master/slave,
multiple slave, simple mirroring to read only slaves, and more... The
type of replication to include in PG is still to be finalised.

You gripe about it being an ad on  - whats InnoDB, if its not an *add
on* kludge.

> p.s. any 'flaming' I do its not meant to be personal or offend any one, if
> any one has taken them this way I apologies.

Hey, It's all good fun and should be taken in good nature. It's just
discussion (a good thing). Nobody should get personal, so nobody
should get offended.

All the best.
Ian.