Prepare Database Access
Your Brightbox comes with access to a shared MySQL database cluster. The migration recipes check the format of database.yml
for the environment you are deploying to and will warn you if there is information missing, or in the wrong format
Edit the database.yml file
Edit your database.yml
and alter the production
section to the following:
production: adapter: mysql host: <your shared MySQL server> username: <your shared MySQL username> password: <your shared MySQL password> database: <your shared MySQL username>_<your application name>_<configuration section>
You'll find the shared MySQL service server name, username and password in your Brightbox control panel
The 'application name' is a short name for your application that differentiates this application database from all the others stored under your MySQL username. It should consist of just alphanumeric characters, no spaces or special characters.
So, for example, if your Brightbox account name is superfly
, your shared MySQL server is db99.mysql.vm.brightbox.net
and you have an application called myforum
then your production
section might look like this:
production: adapter: mysql host: db99.mysql.vm.brightbox.net username: superfly password: secret database: superfly_myforum_production