topic Amazon MYSQL components vs regular MYSQL components in Talend Studio

Amazon MYSQL components vs regular MYSQL components

Anonymous — Sat, 16 Nov 2024 09:06:24 GMT

Hi,

I have migrated my MYSQL databases to Amazon RDS. I am trying to get the data from SQL server to Amazon RDS mysql through talend. However, the jobs run very slow. A 50000 rows insertion takes an hour of time. Whereas, when I use the Talend Amazon components, tAmazonMysqlOutput, the same job completes in less than a minute

May I know what is the reason for this? If I change all my regular mysql components to Amazon mysql components would there be any issues?

Any ideas on this would be of great help

Thanks
Rathi

Re: Amazon MYSQL components vs regular MYSQL components

Anonymous — Wed, 08 Nov 2017 09:10:08 GMT

Hello,

Usually, we use tAmazonMysqlXXX to connect DB which is on Amazon service.
From code side, tAmazonMysqlXXX and tMysqlXXX are same.

Best regards

Sabrina

Re: Amazon MYSQL components vs regular MYSQL components

Anonymous — Wed, 08 Nov 2017 14:32:45 GMT

Thank you Sabrina

But why is it the job timing increases when I connect to the Amazon RDS instance? Even when I change the components to amazon mysql components, the performance is too slow