Replication options

[Simon Windsor]

Hi

I am used to using Oracle (15 years) and MySQL(5 years), but I am planning
to move an existing application from MySQL to Postgres. The reasons are very
simple,

* New requirements means we need views, or a significant re-write
* Better query/index performance essential.
* Postgres and MySQL share a very common implementation of SQL-92, and
what is missing can easily be implanted in functions

The only negative issue is replication. I have checked several Postgres
Replication options and unsure which way to go. Can anyone recommend a
replication option that meets the following:

* 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.
* Must provide master-master and master-slave replication
* Simple to configure and maintain

Many Thanx

Simon Windsor

Eml: si***********@cornfield.org.uk

Tel: [phone]

Mob: [phone]


--
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]

On Feb 19, 2004, at 1:24 PM, Simon Windsor wrote:

Hi

*

I am used to using Oracle (15 years) and MySQL(5 years), but I am
planning to move an existing application from MySQL to Postgres. The
reasons are very simple,

*
• New requirements means we need views, or a significant re-write
• Better query/index performance essential.
• Postgres and MySQL share a very common implementation of SQL-92,
and what is missing can easily be implanted in functions

*

The only negative issue is replication. I have checked several
Postgres Replication options and unsure which way to go. Can anyone
recommend a replication option that meets the following:

*
• 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?
• Must provide master-master and master-slave replication
I don't think any of the solutions will do master-master.
• Simple to configure and maintain

*

Many Thanx

*

Simon Windsor

Eml: si***********@cornfield.org.uk

Tel: [phone]

Mob: [phone]

*

--
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.
[phone]
www.ravensfield.com
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Joshua D. Drake]

>> • 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: si***********@cornfield.org.uk

Tel: [phone]

Mob: [phone]



--
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.
[phone]
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.
[phone] - [e-mail] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)