Tzahi Fadida wrote:
On Tuesday 20 February 2007 14:37, Maxim Veksler wrote:
What about redundancy. I need an active-active cluster for databases
to get the 5*'9's up time euphoria. Is there an open source database
that can do that? Planing to? Tried to?
PostgreSQL can do that and i am betting MySQL can too. Though not alone. You
need an additional product that works with them.
Check out Slony-l and friends. Usually we are talking about Master-Slave
replication service but i think both can be active. I.e. one point of change,
multiple points of read. For peer to peer products, you'd perhaps have to
check out other products but i am not keeping current with new versions.
this is not 'active-active'. this is a a single writer with multiple
readers. 'active-active' means what amos wrote later on - clients may
access either of the two (or more) active nodes for any operation, and
they both can peform reads and writes at the same time, to the same
database. no replication - just (instantneous) synchronization.
--guy
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
