Re: Replication options

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Andrew Rawnsley <ronz(at)ravensfield(dot)com>
Cc: Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Replication options
Date: 2004-02-19 20:06:29
Message-ID: 40351745.5030800@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> • Does not use triggers. Usually slow, and one action that
>> modifies several records, can trigger many actions on slaves/peers.
>> • Does use WAL, or other log, so that SQL DDL/DML is copied to
>> slave/peer, rather than the result of the DDL/DML.
>
>
> I think only Mammoth's ships WAL logs. Josh?

No we do not ship WAL logs. We ship our own transaction logs. One of the
reasons we do this is so you can bring up new slaves live. We do not
support replication of the SQL DDL but you do not need to stop the
replication or stop the database to add tables to the replicated list.

>> • Must provide master-master and master-slave replication
>
>
> I don't think any of the solutions will do master-master.

Only that new clusgres thing from LinuxLabs but I would have to see it
in production before I would get anywhere near it.

Sincerely,

Joshua D. Drake

>
>> • Simple to configure and maintain
>>
>>
>>
>> Many Thanx
>>
>>
>>
>> Simon Windsor
>>
>> Eml: simon(dot)windsor(at)cornfield(dot)org(dot)uk
>>
>> Tel: 01454 617689
>>
>> Mob: 07960 321599
>>
>>
>>
>> --
>> This message has been scanned for viruses and
>> dangerous content by MailScanner, and is
>> believed to be clean.
>> Mailscanner thanks transtec Computers for their support.
>
> --------------------
>
> Andrew Rawnsley
> President
> The Ravensfield Digital Resource Group, Ltd.
> (740) 587-0114
> www.ravensfield.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randall Skelton 2004-02-19 20:19:13 Re: Inner join question
Previous Message Martijn van Oosterhout 2004-02-19 20:04:05 Re: Inner join question