AWS Copy S3 to RDS

Question

I am trying to copy from S3(.csv file) to RDS(MySQL) using Amazon Data pipeline and My error:

Error copying record
Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Cause: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Cause: connect timed out

NOTE: I tried RDS TO S3 with the same connection string and it worked! but S3 to RDS does not work not sure why.

score 0 · Answer 1 · answered Feb 02 '16 at 17:13

0

I had the same error, It was a permission problem with the EC2 instance spawn by Data Pipeline to run the Copy Activity. You need to make sure that this instance can write into your RDS instance.

answered Feb 02 '16 at 17:13

Guillaume Mercey

391
3
14

score -1 · Answer 2 · edited Mar 16 '15 at 08:07

-1

I had this error. As said above please check the
jdbc:mysql://yourrdsdb.cehchrreccbt.us-east-1.rds.amazonaws.com:3306/dbname

edited Mar 16 '15 at 08:07

Opal

81,889
28
189
210

answered Mar 16 '15 at 07:50

SaM

31
1

AWS Copy S3 to RDS

2 Answers2