Le 09-12-03 à 18:29, Miguel Arroz a écrit :
Hi!
Q: Does PostgreSQL have replication?
A: Yes, currently we have a half-dozen different replication tools,
depending on the user's purpose and platform. This is limited to
master-slave replication in mature open source projects, including
built-in PITR and Slony-I. Multi-master replication is available in
the new project Bucardo as well as in various clustering tools.
Built-in simple replication is planned for version 8.5, due in 2010.
It didn't. Let's wait for 8.5! :)
Ick, Slony-I listed as mature... I used it and don't want to see that
thing for the rest of my life. wocommunity.org runs on pgsql, but
that's because Chunk forced me to :-)
Yours
Miguel Arroz
On 2009/12/03, at 23:26, Miguel Arroz wrote:
Hi!
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00913.php
I don't know if it made into 8.4 or not, but they eventually
understood they needed a better solution.
Yours
Miguel Arroz
On 2009/12/03, at 23:20, Mike Schrag wrote:
Also, full disclosure -- i DO use Postgresql and I think it's a
great database, but I always feel a little queasy when I do a
deployment with PG without clustering support. There's always the
feeling of "i sure hope this doesn't screw me." FrontBase has
clustering, but has an obnoxious bug with clustered sequences
which basically requires that you use guid pks, which none of our
stuff does, so it's pretty likely MySQL is in my future.
ms
On Dec 3, 2009, at 6:18 PM, Mike Schrag wrote:
Caveat here -- I don't use MySQL (yet) for anything real. InnoDB
is acid, though. I agree that you should never run a myisam
mysql for most normal systems and that it's strange that this is
the default, but the fact is that you CAN set it to innodb, and
it's a perfectly capable (if not VERY capable) database.
Soooooo -- I'm calling this out as FUD. Search google for
"postgresql corruption" and you'll get plenty of matches, too:
Results 1 - 10 of about 164,000 for postgresql corruption.
Results 1 - 10 of about 12,700 for mysql innodb corruption.
There are quite a few huge systems that are running on MySQL. And
the simple fact that you can cluster it actually makes it far
more resilient than postgresql. Go try to setup a fault tolerant
deployment of PG. Have fun and let me know when you're done.
ms
On Dec 3, 2009, at 6:10 PM, Miguel Arroz wrote:
Hi!
There is nothing "specifically" wrong about using MySQL as a
database for WO. What's wrong is using MySQL at all! ;)
Essentially, it sucks. The first concern of MySQL authors is
speed, and only then correctioness. This may be seen my the
existence of InnoDB itself. First, speeeeeed. A few years later,
yeah, this actually might be usable in something else than a
blog if we actually add ACID properties to it!
In my Univ, the IT team who deals with the central systems moved
everything they could from mysql to PostgreSQL. Among other
reasons, once in a while a MySQL table corrupted itself.
PostgreSQL is much more robust.
As always in software engineering, everything is a compromise.
There may be a few situations where MySQL is dramatically faster
than PostgreSQL, and the inverse is also true, it depends on the
usage and the DB architecture. This to say that you should use
what better suits your needs. But what I would not expect is
MySQL to... you know... work! ;)
Yours
Miguel Arroz
On 2009/12/03, at 22:58, Kieran Kelleher wrote:
Miguel, anyone, please enlighten me as to what specifically is
wrong with using MySQL InnoDB as a database for WO because I
have not seen any problem, but then I have not used PostgreSQL
or FrontBase either - so maybe I don't see a problem that I
should be concerned about.
-Kieran
On Dec 3, 2009, at 5:41 PM, Miguel Arroz wrote:
Hi!
On 2009/12/03, at 22:32, Kieran Kelleher wrote:
I create new OSCs for most background tasks. The one thing
is that I dispose() on it at the end of the task .... and
the dispose() is only useful if you use ERXJDBCAdaptor is
used since the regular WO 5.3 jdbc adaptor opens two
connections for every OSC and leaves the stupid things open
forever. ERXJDBCAdaptor only opens one db connection and
releases it when u call dispose() IIRC.
Dude! <http://terminalapp.net/webobjects-postgresql-and-db-growing-and-growing/
> ;)
Dude! www.mysql.com - innodb (or cluster NDB) .... doesn't
"grow and grow" (and it is not a "toy", no matter what
Chuck says ;-) )
No, it's a disaster! ;)
The "growing" is a side effect of leaving the transaction
opening that happens on PostgreSQL due to its architecture,
but the point is the same, do what I say there to avoid the
dumb connection. :)
Yours
Miguel Arroz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/arroz%40guiamac.com
This email sent to ar...@guiamac.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com
This email sent to msch...@mdimension.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com
This email sent to msch...@mdimension.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/arroz%40guiamac.com
This email sent to ar...@guiamac.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
This email sent to prob...@macti.ca
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com