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 keep a

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 single

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 is really

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,

[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 --

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/Perl to

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 table is

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 use triggers on

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 table