Add documentation for using grafana, prometheus with RisingWave for monitoring of its metrics

[kwannoel]

Info

Close https://github.com/risingwavelabs/risingwave-docs/issues/1635

• Description

  • Document how to monitor the metrics of single node deployment with grafana and prometheus.

• Notes

  • [ Include any supplementary context or references here. ]

• Related code PR

  • [ Provide a link to the relevant code PR here, if applicable. ]

• Related doc issue

  Resolves [ Provide a link to the relevant doc issue here, if applicable. ]

For reviewers

• Preview

  • [ Paste the preview link to the updated page(s) here. Edit this item after the preview site is ready. To find the updated pages, scroll down to locate and open the Amplify preview link and select the dev version of the documentation. ]

• Key points

  • [ Parts that may need revision or extra consideration. ]

Before merging

• [ ] I have checked the doc site preview, and the updated parts look good.

• [ ] I have acquired the approval from the owner (and optionally the reviewers) of the code PR and at least one tech writer (CharlieSYH, emile-00, & hengm3467).

[kwannoel]

Add some links and LGTM now

Thank you!

[kwannoel]

Waiting for https://github.com/risingwavelabs/risingwave/pull/16594 to be reviewed and merged, otherwise the instructions here point to missing files.

[aws-amplify-us-east-1[bot]]

This pull request is automatically being deployed by Amplify Hosting (learn more).

Access this pull request here: https://pr-2125.d2fbku9n2b6wde.amplifyapp.com