[Task] Add database account expiry monitoring metrics

[delei]

Description

In the database-type monitoring templates, add monitoring metrics for database account expiry and support alerting functionality.

What needs to be done

1. Add or modify monitoring metrics within the template.
2. Ensure monitoring data functions correctly.
3. Supports alert configuration.
4. Modify the template documentation and add new metric descriptions.
5. Please provide test cases if necessary.

Additional context

• This task list is related to the issue [Question] <title>数据库账号有效期监控 #2757
• Please refer to the sample provided in the PR [feature] add user password monitoring metrics in oracle monitor #3674

Task List

• app-mysql.yml (@BhanuNidumolu)
• app-mongodb.yml
• app-mariadb.yml
• app-oceanbase.yml
• app-dm.yml
• app-greenplum.yml
• app-kingbase.yml
• app-opengauss.yml
• app-postgresql.yml (@zxuexingzhijie )
• app-sqlserver.yml
• app-tidb.yml
• app-vastbase.yml

[delei]

If the community accepts this task list, it is expected that these tasks will be completed within the next milestone period.

Please feel free to add any missing tasks, and feel free to comment or submit a PR.

😃 Welcome new contributors and as their first contribution.

[tomsun28]

hi welcome! 👍

[XL-Zhao-23]

I'm interested in working on this task. Could you please assign it to me?

[delei]

I'm interested in working on this task. Could you please assign it to me?

Hi, @XL-Zhao-23

Welcome. If you are interested in contributing, please indicate which specific task you have in mind. Community members may assign it to you later.

[BhanuNidumolu]

Hi, I’d like to start by implementing database account expiry metrics for MySQL (app-mysql.yml) and extend it to other databases after review.

[zxuexingzhijie]

Hi, I’d like to start by implementing database account expiry metrics for pg (app-postgresql.yml) @tomsun28 ,plta

[delei]

Hi, I’d like to start by implementing database account expiry metrics for MySQL (app-mysql.yml) and extend it to other databases after review.

Welcome.

[delei]

Hi, I’d like to start by implementing database account expiry metrics for pg (app-postgresql.yml) @tomsun28 ,plta

Welcome.

[BhanuNidumolu]

Thanks! I will work on app-mysql.yml for database account expiry metrics.

I’ll follow the format from PR #3674 and update the template, metrics, and documentation accordingly.