ApsaraDB for SelectDB:Use Managed Service for Grafana to visualize data

Prerequisites

• A SelectDB instance is added to Managed Service for Grafana over the Internet. For more information about how to apply for a public endpoint for a SelectDB instance, see Apply for or release a public endpoint.

• The username and password that are used to log on to the SelectDB instance are obtained.

  Note

  We recommend that you use a read-only account with low-level permissions. Otherwise, server security may be threatened.

• A workspace is created in Managed Service for Grafana. For more information, see Create and manage a Grafana workspace.

• The public IP address of the workspace on Managed Service for Grafana is added to the IP address whitelist of the SelectDB instance.

  1. Obtain the public IP address of the workspace on Managed Service for Grafana.

     1. Log on to the ARMS console. In the left-side navigation pane, choose Managed Service for Grafana > Workspace Management.

     2. On the Workspace Management page, click the ID or name of the workspace that you want to manage. On the page that appears, view the information in the Public IP Address section.

  2. Add the public IP address of the workspace to the IP address whitelist of the SelectDB instance. For more information, see Configure an IP address whitelist.

Billing rules

If you use Managed Service for Grafana Shared Edition, no fees are generated. For more information, see Billing rules.

Procedure

Step 1: Add a data source

1. Log on to the ARMS console. In the left-side navigation pane, choose Managed Service for Grafana > Workspace Management.

2. On the Workspace Management page, find the workspace that you want to manage and click the URL in the URL column to go to Grafana.

   Note

   You can log on to Grafana with the administrator account of Grafana and the password that you configured when you created the workspace. You can also click Sign in with Alibaba Cloud to log on to Grafana with the current Alibaba Cloud account.

3. Managed Service for Grafana 9.x

   In the left-side navigation pane of Managed Service for Grafana, click the icon. On the page that appears, click Add data source and then MySQL.

   Note

   Managed Service for Grafana does not support SelectDB data sources. You can connect Managed Service for Grafana to a MySQL data source because the SelectDB is compatible with MySQL 5.7 connection protocols and syntax.

   Managed Service for Grafana 10.x

   1. On the Grafana homepage, click the icon in the upper-left corner.

   2. In the left-side navigation pane, choose Management > Data sources.

   3. On the Data sources tab, click Add data source. Click MySQL.

      Note

      Managed Service for Grafana does not support SelectDB data sources. You can connect Managed Service for Grafana to a MySQL data source because the SelectDB is compatible with MySQL 5.7 connection protocols and syntax.

4. On the Settings page, configure the following parameters.

   The following table describes common parameters. For more information about other parameters, see Grafana documentation.

   Parameter	Description
   Name	The name of the data source.
   Host	The public endpoint of the SelectDB instance. You can obtain the public endpoint on the details page of the SelectDB instance. Format: <Public endpoint>:<[MySQL port>. Example: selectdb-cn-bcd****-public.selectdbfe.rds.aliyuncs.com:9030.
   Database	The name of the SelectDB instance.
   User	The username of that is used to log on to the SelectDB instance. Important We recommend that you use a read-only account with low-level permissions. Otherwise, server security may be threatened.
   Password	The password that is used to log on to the SelectDB instance.

5. Click Save & Test.

   If the Database Connection OK message appears, the data source is added to Managed Service for Grafana.

   If an error message appears after you click Save & Test, perform the following steps to resolve the error:

   1. Check whether the public endpoint, instance name, username, and password are correctly configured.

   2. Check whether the public IP address of the workspace on Managed Service for Grafana is added to the IP address whitelist of the SelectDB instance. For more information, see How do I add the public IP address of Managed Service for Grafana to the IP address whitelist of an SelectDB instance?

Step 2: Use the data source to create a dashboard

The following information provides an example on how to create a dashboard panel in the table format and a time series chart on the dashboard for SelectDB data.

SELECT * FROM `test_table` where operate_time<'2022-07-20 03:00:00';