Amazon MYSQL components vs regular MYSQL components

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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