The instance management interface for MySQL

Last Updated: Oct 16, 2017

This article introduces the query information and executable operations supported by the RDS console for MySQL instance.

Log on to the instance management interface

  1. Log on to the RDS Console.

  2. Select the region where the target instance is located.

  3. Click the ID of the target instance or Manage in the corresponding Operation column to enter the instance management interface.

Overview of instance management interface

The following table lists the query information and executable operations supported by the RDS console for MySQL instance. As MySQL instances of different versions support different operations, information displayed on the console may vary accordingly. Refer to the actual interface when using this document.

Navigation pane Block name Description Links of common operations
Operating area at the top Allows you to migrate the database, and restart or back up an instance.
Basic Information Basic Information Allows you to view the basic information of an instance, for example, the instance ID, region and zone, instance type, intranet and Internet addresses, intranet and Internet ports, and perform migration across zones. Instance migration across zones
Instance Distribution Allows you to check the number of read-only instances and temporary instances under the master instance, and add read-only instances and temporary instances.
Operating Status Allows you to view the running status, payment option, and creation time of an instance, and release an instance, renew a subscription instance and so on.
Configuration Information Allows you to view the instance types, CPU, database type and version, database memory, and maximum number of connections, and upgrade the database version, set the maintenance period and so on.
Resource Information Allows you to view the storage space and backup usage of an instance.
Account Management Account List Allows you to do the following things:
  • View all accounts under an instance.
  • Create accounts, master account, or initial account.
  • Change the account password, delete an account, and modify the account permissions.
Service Account Privileges When an Alibaba Cloud engineer provides technical support, you need to authorize the engineer’s service account to enable the engineer to view or modify the instance configurations and view the table structure, index, and SQL statements. Authorize a service account
Database Management Allows you to view the databases information under an instance, and create and delete databases.
Database Connection Instance Connection Allows you to view the network type, access mode, intranet address, and port of an instance, change the network type, modify the connection address, and apply for and release an intranet/Internet address.
Monitoring and Alarms Monitoring Allows you to view the monitoring information, such as the CPU and memory usage, disk space usage, and IOPS, and set the monitoring frequency. Set monitoring frequency
Alarms Allows you to view the status of monitoring items and cloud account alert contact, and set the alert policies. Set monitoring rules
Security Controls Whitelist settings Allows you to view the whitelist information of an instance, modify the whitelist, and add a whitelist group. Set whitelist
SSL Allows you to view an SSL certificate, set SSL, and download a certificate. Set SSL encryption
TDE Allows you to view the status of Transparent Data Encryption (TDE), and activate the TDE. Set Transparent Data Encryption
Instance Availability Availability Information Allows you to view the instance zone type, instance availability, data replication mode, and ID of the master/slave node, switch the master/slave instances, and modify the data replication mode.
Zone Architecture Diagram Allows you to view the structural diagrams of the single zone and multi-zone instance.
Log Management Error Log Allows you to view SQL statements that are incorrectly executed in the database within a month. Log management
SQL Slow Log Details Allows you to view SQL statements whose execution period exceeds one second in the database within a month, and deduplicate similar statements.
SQL Slow Log Summary Collects SQL statements whose execution period exceeds one second in the database within a month, provides the analysis report for slow query logs, and allows you to download the statistics list.
Backup and Recovery Backup List Allows you to view the data backup list, recover data to the master instance, and delete and download the backup data.
Binlog List Allows you to view and download binlog files.
Temporary InstanceAllows you to create temporary instances which can be used to restore the lost data.
Backup Settings Allows you to view the backup policies, such as the data backup retention time, backup cycle, and backup time, and modify a backup policy. Back up RDS data
Parameter Settings Modifiable Parameters Allows you to view the parameter values of an instance, modify the parameter values, and import and export the parameters. Set parameters
Modification History Allows you to view parameter modification records.
Thank you! We've received your feedback.