Knowledge Base/Engine Yard Cloud Documentation/Manage your Database

Find Information About Your Database

Engine Yard
posted this on February 16, 2012 10:02 AM

Updated: August 2nd, 2012

When an Engine Yard Cloud environment is created, a database is set up for the application and a database.yml file is generated. The database.yml file contains key information about your database.

The database.yml is written to the /data/app_name/shared/config/ directory in the application and database instance (single server environment) or the application master instance (clustered environment).

Note: Environments without databases do not have a database.yml file generated by Engine Yard Cloud. Enabling the "No database" option means that you are either not using ActiveRecord or you have supplied your own database.yml file in your repository.

Here are some example database.yml files.

  • For a MySQL master database

    Production:
    adapter: mysql2
    database: myapp
    username: deploy
    password: MyP4ssW0rd
    host: ec2-172-16-124-47.compute-1.amazonaws.com
    reconnect: true
  • For a PostgreSQL database cluster with a master database and a slave database

    production: 
    adapter: postgresql
    database: myapp
    username: deploy
    password: MyP4ssW0rd
    host: ec2-172-18-139-19.us-west-1.compute.amazonaws.com
    reconnect: true

    slave:
    adapter: postgresql
    database: myapp
    username: deploy
    password: MyP4ssW0rd
    host: ip-192-168-47-113.us-west-1.compute.internal
    reconnect: true
  • database name. The database is always named the same as your application. In examples, myapp is the application name.

  • username. This is the name of the database user. This username is always deploy.

  • password. This is the password for the deploy database user and also the root database user. It is an automatically-generated, case-sensitive, alphanumeric string. In examples, MyP4ssW0rd is the database password.

  • host. This identifies the server instance that is hosting the database.

To view your database.yml file

  1. Via SSH, connect to the application and database instance (for single server environment) or the application master instance (for a clustered environment).

  2. Type:

    cat /data/myapp/shared/config/database.yml

    where “myapp” is the name of your application.

  3. Make note of the database password.
    You need this password to manage your database.

About typing the MySQL password in command lines

For security, Engine Yard recommends the -p syntax in command lines instead of -pMyP4ssW0rd. If you type the password in the command line, it is saved to the shell history.

However, if security is not a concern, you can use the -pMyP4ssW0rd or --password=MyP4ssW0rd syntax to skip the password prompt.

More information 

For more information about...See...
SSHing into an instance                                                       Connect to your instance via SSH.                     
No database option                                                       Create an Environment.                     

If you have feedback or questions about this page, add a comment below. If you need help, submit a ticket with Engine Yard Support.