mySQL

From: Jay West <jwest_at_classiccmp.org>
Date: Mon Dec 1 22:19:48 2003

mysql has supported replication for quite some time. Replication was
originally kind of a kludge, now it's supported directly. You still have to
have a master and multiple slaves. Last I heard, they were very close (may
already have it) to having a "master election" in case the master goes down,
things keep on running.

mySQL isn't oracle. But it's getting there, and fairly quickly. However,
most databases that are tied to websites are not extremely complex, hence,
the selection of mySQL for fairly simple databases but with high performance
requirements - is fairly straightforward.

Jay
----- Original Message -----
From: "Fred N. van Kempen" <waltje_at_pdp11.nl>
To: "General Discussion: On-Topic and Off-Topic Posts"
<cctalk_at_classiccmp.org>
Sent: Monday, December 01, 2003 10:05 PM
Subject: OT: mySQL


> On Mon, 1 Dec 2003, Jay West wrote:
>
> > Very true that mySQL lacks certain features present in other SQL's.
However,
> > I was under the impression triggers were added a while back, as were
foreign
> > keys (for innodb, not myisam). I will double check!
>
> Does it support replication these days? Thats why I never really
> used it; I need database replication features, since my network
> is spread out over 3 parts of the world :)
>
> --f
>
>
Received on Mon Dec 01 2003 - 22:19:48 GMT