Trouble connecting Heroku App with Amazon RDS Instance

Question

I'm using Amazon RDS for the first time ever and I've been following the heroku docs to get my app using the RDS instance. So far I've created an instance and I have setup the addon using the format:

$ heroku addons:add amazon_rds url=mysql://user:[email protected]/databasename

After running heroku rake db:migrate I got

!!! The bundled mysql.rb driver rake aborted! no such file to load -- mysql

So I installed the MySQL gem. Doing the same thing again I got the error:

Can't connect to MySQL server on 'myapp.cqslpaxxqrok.eu-west-1.rds.amazonaws.com' (110)

I see there's a note about the instance being in the US-east region for Heroku's security group to control access or something. Can I not use a European instance?

Answer 1

No, you cannot use a European instance. Heroku is only available on the US East zone right now, and you need to be able to add Heroku to your security zone for the RDS instance to work, which I suppose require you to be in the same zone. More imporantly, you want to be in the same zone as Heroku for latency and security reasons (otherwise your database traffic will be travelling over the Internet).