Re: [GENERAL] Replication Using Triggers

2008-01-20 Thread Gregory Youngblood
On Sat, 2008-01-19 at 23:46 +, Gordan Bobic wrote: David Fetter wrote: In that case, use one of the existing solutions. They're all way easier than re-inventing the wheel. Existing solutions can't handle multiple masters. MySQL can do it at least in a ring arrangement. What

Re: [GENERAL] Replication Using Triggers

2008-01-20 Thread Merlin Moncure
On Jan 19, 2008 6:46 PM, Gordan Bobic [EMAIL PROTECTED] wrote: Existing solutions can't handle multiple masters. MySQL can do it at least in a ring arrangement. mysql multi-master replication looks a lot better on paper than it really is...one of the reasons mysql is able to seemingly provide

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread David Fetter
On Fri, Jan 18, 2008 at 09:27:08PM +, Gordan Bobic wrote: Andrew Sullivan wrote: On Fri, Jan 18, 2008 at 04:09:45PM +, [EMAIL PROTECTED] wrote: That's just it - I don't think any user-land libraries would actually be required. One of supposed big advantages of MySQL is it's

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread Gordan Bobic
David Fetter wrote: That's just it - I don't think any user-land libraries would actually be required. One of supposed big advantages of MySQL is it's straightforward replication support. It's quite painful to see PostgreSQL suffer purely for the sake of lack of marketting in this department.

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread Gordan Bobic
Gregory Youngblood wrote: On Sat, 2008-01-19 at 23:46 +, Gordan Bobic wrote: David Fetter wrote: In that case, use one of the existing solutions. They're all way easier than re-inventing the wheel. Existing solutions can't handle multiple masters. MySQL can do it at least in a ring

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread Scott Marlowe
On Jan 19, 2008 5:46 PM, Gordan Bobic [EMAIL PROTECTED] wrote: David Fetter wrote: That's just it - I don't think any user-land libraries would actually be required. One of supposed big advantages of MySQL is it's straightforward replication support. It's quite painful to see PostgreSQL

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread Scott Marlowe
On Jan 19, 2008 6:14 PM, Gordan Bobic [EMAIL PROTECTED] wrote: Gregory Youngblood wrote: On Sat, 2008-01-19 at 23:46 +, Gordan Bobic wrote: David Fetter wrote: In that case, use one of the existing solutions. They're all way easier than re-inventing the wheel. Existing

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread Gordan Bobic
Scott Marlowe wrote: On Jan 19, 2008 6:14 PM, Gordan Bobic [EMAIL PROTECTED] wrote: Gregory Youngblood wrote: On Sat, 2008-01-19 at 23:46 +, Gordan Bobic wrote: David Fetter wrote: In that case, use one of the existing solutions. They're all way easier than re-inventing the wheel.

Re: [GENERAL] Replication Using Triggers

2008-01-19 Thread Andreas 'ads' Scherbaum
On Sun, 20 Jan 2008 00:34:11 + Gordan Bobic wrote: Scott Marlowe wrote: On Jan 19, 2008 6:14 PM, Gordan Bobic [EMAIL PROTECTED] wrote: Oh, and there's this too: Cybertec sync-multi-master http://www.postgresql.org/about/news.752 http://www.postgresql.org/about/news.752 The

[GENERAL] Replication Using Triggers

2008-01-18 Thread gordan
Hi, Is there any reason why PostgreSQL replication solutions are all add-on 3rd party ones? Is there any reason why replication couldn't be implemented using triggers and a handful of stored procedures? This is what I have in mind: Have a plperl function that creates connections to all

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Peter Wilson
[EMAIL PROTECTED] wrote: On Fri, 18 Jan 2008, Erik Jones wrote: This is what I have in mind: Have a plperl function that creates connections to all servers in the cluster (replication partners), and issues the supplied write query to them, possibly with a tag of some sort to indicated it

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread gordan
This is what I have in mind: Have a plperl function that creates connections to all servers in the cluster (replication partners), and issues the supplied write query to them, possibly with a tag of some sort to indicated it is a replicated query (to prevent circular replication). Have a

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Gordan Bobic
Andreas 'ads' Scherbaum wrote: Have a plperl function that creates connections to all servers in the cluster (replication partners), and issues the supplied write query to them, possibly with a tag of some sort to indicated it is a replicated query (to prevent circular replication). Have a

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Andreas 'ads' Scherbaum
Hello, On Fri, 18 Jan 2008 17:37:07 + (GMT) [EMAIL PROTECTED] wrote: This is what I have in mind: Have a plperl function that creates connections to all servers in the cluster (replication partners), and issues the supplied write query to them, possibly with a tag of some sort

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Gordan Bobic
Andrew Sullivan wrote: On Fri, Jan 18, 2008 at 04:09:45PM +, [EMAIL PROTECTED] wrote: That's just it - I don't think any user-land libraries would actually be required. One of supposed big advantages of MySQL is it's straightforward replication support. It's quite painful to see PostgreSQL

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread gordan
On Fri, 18 Jan 2008, Erik Jones wrote: Is there any reason why PostgreSQL replication solutions are all add-on 3rd party ones? Because no one solution would be appropriate for everyone. The core team and contributors feel that their time is better spent on the database itself rather than

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Erik Jones
On Jan 18, 2008, at 9:21 AM, [EMAIL PROTECTED] wrote: Hi, Is there any reason why PostgreSQL replication solutions are all add-on 3rd party ones? Because no one solution would be appropriate for everyone. The core team and contributors feel that their time is better spent on the

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Erik Jones
On Jan 18, 2008, at 11:37 AM, [EMAIL PROTECTED] wrote: That's one thing. The other problem that most trigger based replication systems have problems with is propogating schema changes - because (I think) you can attach triggers to schema changes. I presume you mean that you cannot

Re: [GENERAL] Replication Using Triggers

2008-01-18 Thread Andrew Sullivan
On Fri, Jan 18, 2008 at 04:09:45PM +, [EMAIL PROTECTED] wrote: That's just it - I don't think any user-land libraries would actually be required. One of supposed big advantages of MySQL is it's straightforward replication support. It's quite painful to see PostgreSQL suffer purely for