During its operation, OCP collects various performance data of the managed targets, mainly OceanBase clusters. This data is stored in MonitorDB. It is recommended to create a dedicated tenant in OceanBase for MonitorDB.
For scenarios with a large management scale, it is recommended to deploy a dedicated OceanBase cluster for MonitorDB. The recommended minimum configuration for MonitorDB is 4 CPUs and 16 GiB of memory allocated per replica.
CPU and Memory
Based on the number of OBServer nodes managed by OCP, we recommend the CPU and memory resources for each replica in the MonitorDB tenant. The following configurations are calculated based on the standard of 10 tenants per cluster. Please calculate and select appropriate CPU and memory according to your actual situation.
Number of managed servers |
CPU (Cores) |
Memory (GiB) |
|---|---|---|
| ≤10 | 4 | 16 |
| ≤50 | 16 | 64 |
| ≤100 | 32 | 128 |
| ≤200 | 64 | 256 |
| ≤400 | 128 | 512 |
Disk Capacity Estimation
Estimation description: Monitoring data is mainly divided into two parts: metric data and SQL execution records.
Metric data consumes approximately 100 MiB to 300 MiB of storage per server per day.
SQL execution record consumption depends on business volume. Empirical values indicate that the data size is about 10 to 50 times that of metric data.
Based on empirical values, the average daily increment of monitoring data per server is 1 GiB to 40 GiB. Estimate 20 GiB. OCP uses partitioned tables to store monitoring data. The retention periods for monitoring data are as follows:
Metric data: 8 days for seconds-level data and 31 days for minutes-level data.
SQL execution records: Retained for 8 days.
Since most of the storage space is occupied by SQL execution records, disk resource usage is estimated based on SQL execution records.
Resource estimation formula: Total number of machines in all OceanBase clusters to be managed. The following uses server_count as an example:
Estimated daily data increment for the OCP monitoring database is server_count * 20 GiB.
MonitorDB storage requirement is daily data increment * 8 days.
Estimation example: Total number of machines in all OceanBase clusters to be managed. The following uses 20 as an example:
Estimated daily data increment for the OCP monitoring database is 20 * 20 GiB = 400 GiB.
Estimated MonitorDB storage capacity is 400 GiB/day * 8 days = 3200 GiB, approximately 3.2 TiB.
Note
The resource consumption provided above is only a rough estimate. Actual MonitorDB resource consumption may vary depending on business volume.