Various Tutorials
  • About
  • Tutorials
    • 1. Instance for deployment
      • Create instance
      • Install and configure OCI CLI
      • OCI CLI small test
      • Install and configure Terraform
      • Terraform - small test
    • 2. OCI Networking &Terraform
      • 2.1 VCN (basics)
        • 2.1.1 Create a virtual network using Start VCN Wizard
        • 2.1.2 VCN & public subnet (step-by-step in Terraform)
        • 2.1.3 VCN & public subnet (new compartment)
        • 2.1.4 VCN, Terraform and Ansible (Nginx example)
        • 2.1.5 VCN & private subnet (step-by-step in Terraform)
      • 2.2
      • 2.3
    • 3. Untitled
    • 4. Untitled
    • 5. ATP and APEX
      • Setup Autonomous Database
        • Deploying ATP using OCI Interface
        • Deploy with OCI CLI
      • Setup APEX on ATP
      • Connect remotely to ATP
      • ATP, APEX and Jupyter
      • Demo
    • 6. MySQL
      • 6.1. The basics - OCI UI (MySQL DB System)
      • 6.2 The basics - OCI CLI (MySQL DB System)
      • 6.3 Access MySQL DB System
      • 6.4 HeatWave and MySQL DB Service
      • 6.5 Python SDK
      • 6.6 MySQL Replication (Compute Instances)
      • 6.7 Monitoring MySQL instances
        • Deploy MySQL instances
        • Monitoring tools
          • 1. Networking setup
          • 2. Prometheus setup
          • 3. MySQL Prometheus Exporter Setup
          • 4. Grafana setup
          • 5. Grafana metric graphs
    • 7. MySQL OCI &Terraform
      • 7.1 Deploy MySQL DB System with Terraform (basic tutorial)
      • 7.2 Deploy MySQL DB System with Terraform and access the system
      • 7.3 Endpoints
      • 7.4 Channels (troubleshooting)
        • Fixed MySQL source - MDS replication
      • 7.5 Channels (code)
Powered by GitBook
On this page
  1. Tutorials
  2. 6. MySQL
  3. 6.7 Monitoring MySQL instances
  4. Monitoring tools

1. Networking setup

PreviousMonitoring toolsNext2. Prometheus setup

Last updated 4 years ago

1. Networking setup

Before installing and configuring Prometheus and Grafana, perform following steps:

1.1 In the Cloud

Change ingress rules for ports 3000 (Prometheus port), respectively 9090 (Grafana port)

These two services are installed on an instance in the Cloud ("deploymentmachine")

1.1.1 Go to "Subnet"

1.1.2Select the corresponding Security List

1.1.3 Add follwing Ingress Rules for accessing the services from a browser:

  • Ingress Rule for Prometheus

  • Ingress Rule for Grafana

1.2. On the instance

Make sure same ports are opened for listening:

  • for Prometheus

root@deploymentmachine:/home# firewall-cmd --add-port=9090/tcp --permanent
success
root@deploymentmachine:/home# firewall-cmd --reload
success
root@deploymentmachine:/home#

  • for Grafana

root@deploymentmachine:/home# firewall-cmd --add-port=3000/tcp --permanent
success
root@deploymentmachine:/home# firewall-cmd --reload
success
root@deploymentmachine:/home#