Re: syncing with a MySQL DB

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: syncing with a MySQL DB
Date: 2008-10-21 13:58:24
Message-ID: b42b73150810210658l3c7885cdg8c72ee582f3b4c78@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)com> wrote:
> m == mmoncure(at)gmail(dot)com writes:
>
> m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)com> wrote:
> m> > I have a need to keep a PostgreSQL and MySQL table synchronized. My
> m> > thoughts are to use triggers on the pgsql side to manipulate the MySQL
> m> > table when data in the pgsql table is changed. I also plan on using
> m> > PL/Perl to write the functions.
> m> >
> m> > Are there better ways to achieve this?
>
> m> have you looked at dbi-link?
>
>
> No, but just did and it looks very cool. Have you used it before? If
> so, would you mind if I ask you some questions? We could take it off
> the list if that's more appropriate.

i'm not a perl guy...hop on postgresql irc and ping 'davidfetter' :-)

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Metcalf 2008-10-21 14:00:25 Re: syncing with a MySQL DB
Previous Message Rob Richardson 2008-10-21 13:57:51 When are updates from inside transactions visible?