Creating Databases for PAS
Page last updated:
This topic provides an example procedure for creating the necessary databases on your external database instance so that you can deploy Pivotal Application Service (PAS) with an external database.
WARNING: Protect whichever database you use in your deployment with a password.
To create your Pivotal Application Service (PAS) databases, do the following:
Note: Exact configurations depend on your database provider. The following procedure uses AWS RDS as an example.
ubuntuaccount key pair from your IaaS deployment to your local SSH profile so you can access the Pivotal Operations Manager VM. For example, in AWS, you add a key pair created in AWS:
$ ssh-add aws-keypair.pem
SSH in to your Ops Manager using the Ops Manager FQDN and the username
$ ssh ubuntu@OPS-MANAGER-FQDN
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:
$ mysql --host=RDSHOSTNAME --user=RDSUSERNAME --password=RDSPASSWORD
Run the following MySQL commands to create databases for the eleven PAS components that require a relational database:
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; CREATE database uaa; CREATE database credhub;
exitto quit the MySQL client, and
exitagain to close your connection to the Ops Manager VM.