Pivotal Knowledge Base

Follow

How to Connect to the PCF Elastic Runtime Internal MySQL database

Environment

Pivotal Cloud Foundry® (PCF) 

Purpose

This article discusses how to connect to PCF Elastic Runtime internal MySQL database. PCF uses this database to store information for UAADB, Apps Manager DB, CCDB, App Usage Events DB, Autoscaling, and Notifications. 

Procedure

Follow the steps below within the Elastic Runtime Tile of Ops Manager:

For versions 1.11 and lower:

  1. Depending on your configuration, you can connect directly to one of the many nodes in the cluster and not the proxy node. Select the Status tab and retrieve the IP from the specific MySQL Servernode
  2. Select the Credentials tab and retrieve the Mysql Admin Credentials from MySQL Server
  3. SSH into Ops Manager or a VM that has direct access to the MySQL DB Node and has the MySQL client installed.
  4. Run the following command mysql -h <ip> -u root -p where the IP is retrieved from step 1 above. The password will be prompted after you select enter.

For versions 1.12 and higher:

  1. Connect to one of the MySQL VM's by BOSH CLI: bosh ssh mysql/0
  2. Type the following command to start mysql with credentials sourced from mylogin.cnf: mysql --defaults-file=/var/vcap/jobs/mysql/config/mylogin.cnf

Additional Information

Here are a few popular MySQL commands:

  • To list database type the following command at MySQL prompt:

         mysql> show databases; (this displays database)

  • To use the database and to enlist the available tables type, here are two commands:

         mysql> use MySQL;
         mysql> show tables;

Also, link to the bootstrap docs as they instruct you to run commands to check the status of the cluster.

https://docs.pivotal.io/pivotalcf/1-7/customizing/mysql_bootstrap_ert.html

Comments

Powered by Zendesk