Thread: replication: PG vs My
Dear all: we're trying to choose a db for our site. We're a little bit worried about the load of the server so we were thinkingin some kind of db cluster. Mysql has a built-in way to do this but I found that pg relies on external utilities. How good are they? Are they ready forproduction-servers? Thanks in advance. Please sorry if this is not the correct list to post this message.
On Tuesday 15 July 2003 07:38 pm, Martin Sarsale wrote: > Dear all: we're trying to choose a db for our site. We're a little bit > worried about the load of the server so we were thinking in some kind of db > cluster. > > Mysql has a built-in way to do this but I found that pg relies on external > utilities. How good are they? Are they ready for production-servers? > Well, there are a lot of external replication solutions available, so saying how good they are depends on which one yourdiscussing. I have heard anectdotal evidence about all (most anyway) of them being used in production situations, butI don't think any of them have had extensive testing. There is a commercial replication solution that has had extensiveenterprise use available at http://www.erserver.com/. The company plans to open source it "real soon now" but asof yet you need a commercial license for it (which comes with support, so might be a good deal for you). I also have to mention that postgresql tends to scale a lot better than mysql so youre far less likely to need replicationfor scaleability, especially in multi-user, multi-write type environments. This is one of the reasons that it'staken so long for postgresql to get a "built in" replication solution, the need isn't strong enough to get the itch scratched. Robert Treat
> On Tuesday 15 July 2003 07:38 pm, Martin Sarsale wrote: > > Dear all: we're trying to choose a db for our site. We're a little bit > > worried about the load of the server so we were thinking in some kind of db > > cluster. > > > > Mysql has a built-in way to do this but I found that pg relies on external > > utilities. How good are they? Are they ready for production-servers? > > > > Well, there are a lot of external replication solutions available, so saying how good they are depends on which one yourdiscussing. I have heard anectdotal evidence about all (most anyway) of them being used in production situations, butI don't think any of them have had extensive testing. There is a commercial replication solution that has had extensiveenterprise use available at http://www.erserver.com/. The company plans to open source it "real soon now" but asof yet you need a commercial license for it (which comes with support, so might be a good deal for you). we only want free (as in speech) software :) which solution would you recommend? > I also have to mention that postgresql tends to scale a lot better than mysql so youre far less likely to need replicationfor scaleability, especially in multi-user, multi-write type environments. This is one of the reasons that it'staken so long for postgresql to get a "built in" replication solution, the need isn't strong enough to get the itch scratched. we don't exactly know how much users/querys we'll have, but we're afraid of having problems with only one DB server. Probablywill never add another DB server, but we would like to have the chance to do it, if we want to.
On Tue, Jul 15, 2003 at 08:38:34PM -0300, Martin Sarsale wrote:
> Dear all: we're trying to choose a db for our site. We're a little
> bit worried about the load of the server so we were thinking in
> some kind of db cluster.
>
> Mysql has a built-in way to do this but I found that pg relies on
> external utilities. How good are they? Are they ready for
> production-servers?
As far as I know, there are no real cluster systems for either
PostgreSQL or MySQL. That is, you can't just add another database
and write into it transparently as well. There are some under
development for PostgreSQL; I don't know about MySQL.
If you want simple replication, there are already some versions
available. The software currently in production, supporting the
.info and .org registries, is going to become free software (I'm
working on it now); so if you require free software, you might want
to wait for that.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
On Tue, Jul 15, 2003 at 10:36:32PM -0400, Robert Treat wrote: > have had extensive testing. There is a commercial replication > solution that has had extensive enterprise use available at > http://www.erserver.com/. The company plans to open source it "real > soon now" but as of yet you need a commercial license for it (which > comes with support, so might be a good deal for you). "Real soon" should mean weeks, not months. I can tell you that the code which is getting released is not what you get today if you buy the PostgreSQL, Inc. license, however. Moreover, there are additional changes currently under test (by us) which represent yet another big step forward. In particular, the new (not candidate for community release) code improves the support for multiple slaves and runs faster. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110