By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,706 Members | 1,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,706 IT Pros & Developers. It's quick & easy.

Replication options

P: n/a
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: 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.
Nov 22 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a

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

Nov 22 '05 #2

P: n/a
>> 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: 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@commandprompt.com - 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)

Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.