MySQL

Create Service

To experience the full power of GreptimeCloud, you need to create a service which contains a database with authentication. Open the GreptimeCloud console, signup and login. Then click the New Service button and config the following:

  • Service Name: The name you want to describe your service.
  • Description: More information about your service.
  • Region: Select the region where the database is located.
  • Plan: Select the pricing plan you want to use.

Now create the service and we are ready to write some metrics to it.

Write Data

To quickly get started with MySQL, we can use Bash to collect system metrics, such as CPU and memory usage, and send it to GreptimeCloud via MySQL CLI.

shell

  1. curl -L https://raw.githubusercontent.com/GreptimeCloudStarters/quick-start-mysql/main/quick-start.sh | bash -s -- -h <host> -d <dbname> -u <username> -p <password>

The source code is avaliable on GitHub.

Visualize Data

After successfully writing data to the service, you can view the data on the GreptimeCloud dashboard. The dashboard provides a variety of visualizations to help you understand, monitor and analyze the data.

Here, we create a panel that displays the 95% CPU usage as an example. To do this, click the Add Panel button, select a table that contains the CPU usage data, and then choose the 95% aggregation method. Finally, click the Save button to save the panel. You can now see the new panel and set up an alert rule for it.