Accessing an Amazon RDS MySQL Instance from an IronWorker Instance

Question

We use IronWorkers from http://www.iron.io/ to perform heavy image processing and PDF.

I want to link an instance of IronWorker with a MySQL RDS database on our Amazon AWS account so that our code running on IronWorker can directly make odds in that database.

I'm not too sure how to do this, as we have several technical issues to work with.

I understand that starting IronWorkers will not be in the security group of RDS instances and will be blocked from accessing our MySQL RDS instance. It is not possible to create a security group by creating a CIDR / IP record, because we do not know what the IP address for the running server will be.

Another approach would be to somehow get the .pem file in the running instance and configure the MySQL connection using the PEM file via SSH, but I'm not sure if this is the safest way to reach the connection.

Does anyone know of any means that a direct connection can be made from an IronWorker instance to a MySQL RDS instance?

Answer 1

There is a tricky way around this by finding the internal IP address of your RDS instance and then using it instead of the dns entry that AWS gives, for example:

$ ping myserverabcdefg.us-east-1.rds.amazonaws.com PING ec2-X-XX-XXX-X.compute-1.amazonaws.com (10.111.222.33) 56 (84) bytes of data.

dns dns .

, .