Re: syncing with a MySQL DB - Mailing list pgsql-general

From Merlin Moncure
Subject Re: syncing with a MySQL DB
Date
Msg-id b42b73150810210658l3c7885cdg8c72ee582f3b4c78@mail.gmail.com
Whole thread Raw
In response to Re: syncing with a MySQL DB  ("Brandon Metcalf" <bmetcalf@nortel.com>)
Responses Re: syncing with a MySQL DB  ("Brandon Metcalf" <bmetcalf@nortel.com>)
List pgsql-general
On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <bmetcalf@nortel.com> wrote:
> m == mmoncure@gmail.com writes:
>
>  m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf@nortel.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

pgsql-general by date:

Previous
From: "Brandon Metcalf"
Date:
Subject: Re: syncing with a MySQL DB
Next
From: "Rob Richardson"
Date:
Subject: When are updates from inside transactions visible?