1. Home
  2. Docs
  3. CCX
  4. User Guide
  5. Data Stores
  6. Overview

Overview

Database Nodes

This section has all the database nodes running on the selected environment with the following information:

  • IP Address: If you press on this field you will access the node dashboard.
  • Status: Current node status.
  • Node Type: It could be Galera (MariaDB/PXC), or Master/Slave (PostgreSQL)
  • Last Seen: Last check.
  • View Host Details:
    • Cloud
    • Region
    • Size
    • CPU
    • RAM

Compare Dashboards

Use this option to compare different node dashboards.

You can compare System, Database, and Load Balancer Dashboards with information like:

System Database Load Balancer
Load Average Connections Client Connections
CPU Usage Delete Statements Slow Queries
RAM Usage Select Statements Server Connections
Network Usage Update Statements Active Transactions
Disk Usage Insert Statements Query Cache

And you will have more different graphs to be compared. You can also enable the “Summary” button to add a summary in all the graphs which will make it easier to compare the numbers.

Configure the Refresh rate and ranges according to your requirements.

The Refresh rate could be “Off” if you want to turn off the auto-refresh, or a specific time like 15/30 seconds, 1/2/5 minutes.

The Time Range to show in the graphs could be “last 30 minutes”, “last hour”, “last day”, “last week”, or you can specify a custom range using Start date and End data values.

Load Balancer Nodes

  • IP Address: If you press on it you will access the node dashboard.
  • Status: Current node status.
  • Node Type: ProxySQL, or HAProxy
  • Last Seen: Last check.
  • RW Port: Read and Write port. (Only for HAProxy Load Balancer)
  • RO Port: Read Only port. (Only for HAProxy Load Balancer)
  • View Host Details:
    • Cloud
    • Region
    • Size
    • CPU
    • RAM

 

Was this article helpful to you? Yes No