如何使用你自己的mysql数据库服务器与heroku? [英] How to use your own mysql database server with heroku?
问题描述
我想使用托管在我自己的服务器上的mysql数据库。
我已经将DATABASE_URL和SHARED_DATABASE_URL配置变量更改为指向我的服务器,但它仍然尝试连接到heroku的amazonaws服务器。我该如何解决这个问题?
根据 Heroku文档,更改 DATABASE_URL
是正确的选择。
如果您希望让您的rails应用程序连接到一个非Heroku提供的数据库,那么您可以利用这种相同的机制。只需将您的DATABASE_URL config var设置为指向任何云可访问的数据库,Heroku就会自动创建您的database.yml文件以指向您选择的服务器。 Amazon RDS附加组件会自动为您执行此操作,不过您也可以使用此方法连接到非RDS数据库。
下面是一个应该可以工作的例子:
heroku config:add DATABASE_URL = mysql:// user:password @ host / db
您可能需要通过更改并运行来重新部署git push heroku master
I want to use mysql database which is hosted on my own server. I've changed DATABASE_URL and SHARED_DATABASE_URL config vars to point to my server, but it's still trying to connect to heroku's amazonaws servers. How do I fix that?
According to the Heroku documentation, changing DATABASE_URL
is the correct way to go.
If you would like to have your rails application connect to a non-Heroku provided database, you can take advantage of this same mechanism. Simply set your DATABASE_URL config var to point to any cloud-accessible database, and Heroku will automatically create your database.yml file to point to your chosen server. The Amazon RDS Add-on does this for you automatically, though you can also use this same method to connect to non-RDS databases as well.
Here's an example that should work:
heroku config:add DATABASE_URL=mysql://user:password@host/db
You may need to redeploy by making a change and running git push heroku master
这篇关于如何使用你自己的mysql数据库服务器与heroku?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!