Re: [GENERAL] syncing with a MySQL DB

2008-10-27 Thread Linos
Brandon Metcalf escribió: m == [EMAIL PROTECTED] writes: m> On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: m> > m == [EMAIL PROTECTED] writes: m> > m> > m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: m> > m> > I have a need to

Re: [GENERAL] syncing with a MySQL DB

2008-10-26 Thread David Fetter
On Sun, Oct 26, 2008 at 12:41:39PM -0400, Jonah H. Harris wrote: > On Sat, Oct 25, 2008 at 1:19 PM, Ernesto Quiñones <[EMAIL PROTECTED]> wrote: > > I use dbi-link, work fine, but I have problems when I call mysql > > tables "linked" and these tables are big, maybe a millon records, > > the answers

Re: [GENERAL] syncing with a MySQL DB

2008-10-26 Thread Jonah H. Harris
On Sat, Oct 25, 2008 at 1:19 PM, Ernesto Quiñones <[EMAIL PROTECTED]> wrote: > I use dbi-link, work fine, but I have problems when I call mysql > tables "linked" and these tables are big, maybe a millon records, the > answers is really slow, I need to wait 5 or more minutes to have an > answer in a

Re: [GENERAL] syncing with a MySQL DB

2008-10-25 Thread Ernesto Quiñones
I use dbi-link, work fine, but I have problems when I call mysql tables "linked" and these tables are big, maybe a millon records, the answers is really slow, I need to wait 5 or more minutes to have an answer in a single query like this "select * from table limit 10", I am thinking maybe dbi-link

Re: [GENERAL] syncing with a MySQL DB

2008-10-22 Thread Jonah H. Harris
On Tue, Oct 21, 2008 at 10:00 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: > OK. I'll dig in and can probably figure everything out. I'll contact > David if I can't. You should try http://www.anysql.net/en/software/refresh_mysql.zip It's written in Perl and designed to replicate Oracle->MySQL

Re: [GENERAL] syncing with a MySQL DB

2008-10-21 Thread Brandon Metcalf
m == [EMAIL PROTECTED] writes: m> On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: m> > m == [EMAIL PROTECTED] writes: m> > m> > m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: m> > m> > I have a need to keep a PostgreSQL and MySQL

Re: [GENERAL] syncing with a MySQL DB

2008-10-21 Thread Merlin Moncure
On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: > m == [EMAIL PROTECTED] writes: > > m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <[EMAIL PROTECTED]> > wrote: > m> > I have a need to keep a PostgreSQL and MySQL table synchronized. My > m> > thoughts are to us

Re: [GENERAL] syncing with a MySQL DB

2008-10-21 Thread Brandon Metcalf
m == [EMAIL PROTECTED] writes: m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <[EMAIL PROTECTED]> 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

Re: [GENERAL] syncing with a MySQL DB

2008-10-21 Thread Merlin Moncure
On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: > I have a need to keep a PostgreSQL and MySQL table synchronized. My > thoughts are to use triggers on the pgsql side to manipulate the MySQL > table when data in the pgsql table is changed. I also plan on using > PL/Per

[GENERAL] syncing with a MySQL DB

2008-10-21 Thread Brandon Metcalf
I have a need to keep a PostgreSQL and MySQL table synchronized. My thoughts are to use triggers on the pgsql side to manipulate the MySQL table when data in the pgsql table is changed. I also plan on using PL/Perl to write the functions. Are there better ways to achieve this? -- Brandon --