Re: PostgreSQL 8.1 vs. MySQL 5.0?

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?
Date: 2005-10-06 12:57:11
Message-ID: 60d5mils60.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

cool_screen_name90001(at)yahoo(dot)com (CSN) writes:
> I'm not sure what XA (distributed transactions) is -
> is that something that can be achieved with Slony?

No.

XA is an interface to allow having updates take place across multiple
databases.

That would mean that you do some updates on one DB, others on another,
and finally issue a "distributed COMMIT" which commits it all at once.

That's not similar to what Slony-I does...
--
(format nil "~S(at)~S" "cbbrowne" "cbbrowne.com")
http://cbbrowne.com/info/oses.html
"Have you noticed that, when we were young, we were told that
`everybody else is doing it' was a really stupid reason to do
something, but now it's the standard reason for picking a particular
software package?" -- Barry Gehm

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tatsuo Ishii 2005-10-06 14:06:57 Re: PostgreSQL 8.1 vs. MySQL 5.0?
Previous Message Tzvetan Tzankov 2005-10-06 08:37:35 Re: PostgreSQL 8.1 vs. MySQL 5.0?

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2005-10-06 13:02:48 Re: Dump all except some tables?
Previous Message WireSpot 2005-10-06 12:29:50 Re: Dump all except some tables?