This document introduces query information and executable operations supported by the RDS console for MySQL instances.
Log on to the instance management interface
- Log on to the RDS console.
- Select the region where the target instance is located.
- Click the ID of the target instance or Manage in the Operation column to enter the instance management interface.
Overview of the instance management interface
The following table lists query information and executable operations supported by the RDS console for MySQL instances. As MySQL instances of different versions support different operations, information displayed on the console may vary accordingly. Pay attention to the actual interface when using this document.
|Navigation pane||Block name||Description||Links of common operations|
|Operation buttons at the top of the page||You can migrate databases, and restart or back up an instance.|
|Basic Information||Basic Information||You can view basic information about an instance. For example, the instance ID, region, zone, instance type, intranet and Internet IP addresses, and intranet and Internet ports, and perform migration across zones.||Instance migration across zones|
|Instance Distribution||You can query the number of read-only and temporary instances under the master instance. Additionally, you can add read-only instances, add temporary instances, and perform other operations.||Create a read-only instance|
|Operating Status||You can view the running status, billing method, and creation time of an instance, release an instance, renew a Subscription instance, and perform other operations.|
|Configuration Information||You can view the instance type, CPU, database type and version, database memory, and the maximum number of connections. Additionally, you can upgrade the database version, set the maintenance period, and perform other operations.|
|Resource Information||You can view the storage space and backup usage of an instance.|
|Account Management||Account List||You can view all accounts under an instance, create common accounts, master account, or initial accounts, change account passwords, delete accounts, and modify account permissions.|
|Service Account Privileges||When an Alibaba Cloud engineer provides technical support, you must authorize the engineer’s service account to view or modify the instance configurations and view the table structure, index, and SQL statements.||Authorize a service account|
|Database Management||You can view the databases information under an instance, and create or delete databases.|
|Database Connection||Instance Connection||You can view the network type, access mode, intranet IP address, and port of an instance, change the network type, modify the connection address, and apply for or release an intranet/Internet IP address.|
|Monitoring and Alarms||Monitoring||You can view monitoring information, such as the CPU and memory usage, disk space usage, and IOPS, and set the monitoring frequency.||Set monitoring frequency|
|Alarms||You can set the alarm rules and view the status of monitoring items and the alarm contact.||Set monitoring rules|
|Security Controls||Whitelist settings||You can view the whitelist of an instance, modify the whitelist, and add a whitelist group.||Set whitelist|
|SSL||You can view an SSL certificate, set SSL, and download a certificate.||Set SSL encryption|
|TDE||You can view the status of Transparent Data Encryption (TDE) and activate it.||Set Transparent Data Encryption|
|Instance Availability||Availability Information||You can view the instance zone type, instance availability, data replication mode, and ID of the master/slave node, switch over services between master slave instances, and modify the data replication mode.|
|Zone Architecture Diagram||You can view the structural diagrams of a single-zone instance or a multi-zone instance.|
|Log Management||Error Log||You can view SQL statements that are incorrectly executed in the database within a month.||Log management|
|Slow SQL Log Details||You can view SQL statements whose execution period exceeds one second in the database within a month, and deduplicate similar statements.|
|Slow SQL Log Summary||RDS collects SQL statements whose execution period exceeds one second in the database within a month and provides the analysis report for slow query logs, allowing you to download the statistics list.|
|Backup and Recovery||Backup List||You can view the data backup list, recover data to the master instance, and delete and download the backup data.|
|Binlog List||You can view and download binlog files.|
|Temporary Instance||You can create temporary instances which can be used to restore the lost data.|
|Backup Settings||You can modify a backup policy and view the backup policy information, such as the data backup retention time, backup cycle, and backup time.||Back up RDS data|
|Parameter Settings||Modifiable Parameters||You can view the parameter values of an instance, modify the parameter values, and import and export the parameters.||Set parameters through RDS console|
|Modification History||You can view parameter modification records.|