Amazon RDS security groups have migrated to VPC enviroments.... has the way to grant MYSQL access to RDS instance changed?
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?
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
Support Staff 1 Posted by Pat Allan on 24 Jan, 2015 03:47 AM
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