1 Dec
2003
1 Dec
'03
2:19 p.m.
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(a)pdp11.nl>
To: "General Discussion: On-Topic and Off-Topic Posts"
<cctalk(a)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