Amazon RDS security groups have migrated to VPC enviroments.... has the way to grant MYSQL access to RDS instance changed?

rk's Avatar

rk

23 Jan, 2015 06:46 AM

According to the documentation on heroku (the fs addon) and this forum itself - it seems that the only guidance is to

Amazon RDS

If you'd like to use Flying Sphinx with Amazon RDS (via Heroku's add-on for that service), then there's one more step you'll need to take care of: giving Flying Sphinx permission to access your MySQL database.

As part of the Amazon RDS setup, you will have given Heroku permission to access your database, and so just repeat that step once more - this time, using the owner id 092495821309 and group name Scalarium-Default-Server.

Is there more information needed here to complete this action with the new shift toward more VPC environments?

  1. Support Staff 1 Posted by Pat Allan on 24 Jan, 2015 03:47 AM

    Pat Allan's Avatar

    Hi rk

    I'm not sure what the VPC changes involve, but if you're using SSL for your MySQL connection, you'll want to add those settings to (Thinking) Sphinx as well, via config/thinking_sphinx.yml and the appropriate environment. The relevant settings are here: http://sphinxsearch.com/docs/current.html#conf-mysql-ssl

    I understand these settings have been enough to get everything working well. If you find that doesn't work for you, do get in touch.

    Kind regards,

    Pat

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac