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

Back to Index

docs/gemv2/howto/database.txt · Last modified: 2009/12/21 17:26 by johnleach