Five Stars

Amazon MYSQL components vs regular MYSQL components

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

2 REPLIES
Moderator

Re: Amazon MYSQL components vs regular MYSQL components

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Amazon MYSQL components vs regular MYSQL components

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