apache / apache/gravitino

[Improvement] Provide Metrics for Gravitino MySQL Backend Storage Connect Pool

Open
#5,578 2 comments 1 reaction 0 assignees View on GitHub
improvement
Dominant language
Java
Stars
3.2k
Forks
935
Avg merge
1d 15h
Merged PRs (30d)
315

Description

### What would you like to be improved?

Currently, many parameters of the MySQL backend connection pool used by Gravitino, such as maxConnectCount and maxIdleConnect, are not configurable, and no relevant monitoring is configured for this connection pool. However, in reality, nearly every Gravitino REST request involves a call to the backend storage. Therefore, I believe it is essential to configure connection pool monitoring for a backend storage like MySQL in a production environment.

### How should we improve?

We have configured monitoring for the MySQL backend in production. You can assign this to me, and I will complete it.

Contributor guide

Open the contributing guide

Research direction

Start by locating the Java implementation of Gravitino's MySQL backend connection pool and the configuration for maxConnectCount and maxIdleConnect. Review how backend storage is initialized and how production monitoring is configured. Done means the pool parameters are configurable and relevant connection-pool metrics are exposed and verified.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
backend, databases, observability
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.