Monitor MySQL Heatwave Instance from MySQL Enterprise Monitor

 

- Introduction:

• MySQL Heatwave Cloud Database System endpoint has a private IP address. You cannot connect directly to it from a remote IP address. 
• There is no SSH access to DB system endpoint. It is not possible to install MySQL Enterprise Monitor agent on the DB system, so the MySQL Heatwave database will be monitored using MySQL enterprise monitor's built-in agent.

In this blog, we will demonstrate the steps to add MySQL Heatwave database (the same steps will be used for non-Heatwave MySQL instances) to MySQL enterprise monitor from monitor console.

- Prerequisites:

• An Oracle cloud free trial or paid account.
• A VCN with public subnet, private subnet, security lists, and route tables.
• MySQL Enterprise Monitor installed on OCI compute instance. You may follow steps in blog "Install MySQL Enterprise Monitor".
• One OCI compute instance VM located in VCN’s public subnet with API RSA private key.
• One MySQL Heatwave database system located in VCN's private subnet.
• Private subnet security list has below Ingress and Egress rules to allow access from public subnet to private subnet where MySQL Heatwave database system is located.

Rule Type	Source	IP Protocol	Source Port Range	Destination Port Range
Ingress	<Private Subnet CIDR>	TCP	All	3306 (MySQL default port)
Egress	<Private Subnet CIDR>	TCP	All	All



• Public subnet security list has below Ingress and Egress rules to allow access from Internet to public subnet where VM is located (where MySQL Enterprise Monitor is installed). 

Rule Type	Source	IP Protocol	Source Port Range	Destination Port Range
Ingress	0.0.0.0/0	TCP	All	18443, 18080
Egress	0.0.0.0/0	TCP	All	All

Steps to Add MySQL Database Instance

1. Login to MySQL enterprise monitor console with admin account.

    - Console "https://<MySQL-Monitor-VM-IP>:18443".

2. Navigate to "Configuration => MySQL Instances".

3. From MySQL Instances page, click "Add MySQL Instance".

4. On Add Instance dialog box select/enter below values then click "Add Instance".

     - Select "Monitor From": MEM Built-in Agent

     - Select "Connect Using": TCP/IP

     - Enter "Instance Address": MySQL Heatwave DB system's endpoint IP

     - Enter "Port": MySQL database instance default port 3306

     - Enter "Admin User": MySQL Heatwave DB's admin user

     - Enter "Admin Password": MySQL Heatwave DB's admin user's password

     - Select "Auto-Create Less Privileged Users": No  

  - Console will show "New instance (discovering)".

     Note: MySQL Heatwave instances will always show OS version "Remotely Monitored" because built-in agent is used to monitor DB system.

  - Console will show instance configuration once adding instance completes.

MySQL database instance is monitored now !!!.