Re: syncing with a MySQL DB

Brandon Metcalf escribió:
> m == mmoncure@gmail.com writes:
>
>  m> On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <bmetcalf@nortel.com> wrote:
>  m> > m == mmoncure@gmail.com writes:
>  m> >
>  m> >  m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf@nortel.com> wrote:
>  m> >  m> > I have a need to keep a PostgreSQL and MySQL table synchronized.  My
>  m> >  m> > thoughts are to use triggers on the pgsql side to manipulate the MySQL
>  m> >  m> > table when data in the pgsql table is changed.  I also plan on using
>  m> >  m> > PL/Perl to write the functions.
>  m> >  m> >
>  m> >  m> > Are there better ways to achieve this?
>  m> >
>  m> >  m> have you looked at dbi-link?
>  m> >
>  m> >
>  m> > No, but just did and it looks very cool.  Have you used it before?  If
>  m> > so, would you mind if I ask you some questions?  We could take it off
>  m> > the list if that's more appropriate.
>
>  m> i'm not a perl guy...hop on postgresql irc and ping 'davidfetter' :-)
>
>
> OK.  I'll dig in and can probably figure everything out.  I'll contact
> David if I can't.
>
> Thanks.
>

Maybe you can use too a multi-master replication solution that supports mysql
and postgresql like symmetricds,  http://symmetricds.sourceforge.net , it is
developed in java and can works like a library or a daemon, i am using now
between postgresql machines but it supports replicate heterogeneous database (a
common usage in the forums it is oracle in a central and many mysql like
clients), it is a trigger based replication so i think it can be good fit for
your needs.

Regards,
Miguel Angel.