_ert_database_external.html.md.erb

<p class="note"><strong>Note</strong>: To configure an external database for UAA, see the <i>External Database Configuration</i> section of <a href="#uaa">Configure UAA</a>.</p>

<p class="note"><strong>Note</strong>: The exact procedure to create databases depends upon the database provider you select for your deployment. The following procedure uses AWS RDS as an example. You can configure a different database provider that provides MySQL support, such as Google Cloud SQL.</p>

<p class="note warning">
<strong>Warning</strong>: Protect whichever database you use in your deployment with a password.</p>

To create your Elastic Runtime databases, perform the following steps:

1. Add the `ubuntu` account key pair from your IaaS deployment to your local SSH profile so you can access the Ops Manager VM. For example, in AWS, you add a key pair created in AWS:

    <pre class='terminal'>$ ssh-add aws-keypair.pem</pre>

1. SSH in to your Ops Manager using the Ops Manager FQDN and the username `ubuntu`:

    <pre class='terminal'>$ ssh ubuntu@OPS-MANAGER-FQDN</pre>

1. Log in to your MySQL database instance using the appropriate hostname and user login values configured in your IaaS account. For example, to log in to your AWS RDS instance, run the following MySQL command:

     <pre class='terminal'>$ mysql --host=RDSHOSTNAME --user=RDSUSERNAME --password=RDSPASSWORD</pre>

1. Run the following MySQL commands to create databases for the eleven Elastic Runtime components that require a relational database:
  <pre class="terminal">CREATE database ccdb;
  CREATE database notifications;
  CREATE database autoscale;
  CREATE database app\_usage\_service;
  CREATE database routing;
  CREATE database diego;
  CREATE database account;
  CREATE database nfsvolume;
  CREATE database networkpolicyserver;
  CREATE database silk;
  CREATE database locket;
  </pre>

1. Type `exit` to quit the MySQL client, and `exit` again to close your connection to the Ops Manager VM.

1. In Elastic Runtime, select **Databases**. 

1. Select the **External Databases** option.

1. For **Hostname**, enter the hostname of the database server.

1. For **TCP Port**, enter the port of the database server.

1. Each component that requires a relational database has two corresponding fields: one for the database username and one for the database password. For each set of fields, specify a unique username that can access this specific database on the database server and a password for the provided username.

1. Click **Save**.