The following engines and versions are supported by RDS which will support more database engine types and versions
Following conditions shall be met for the VM accessing RDS:
The data in the performance analysis is saved in the instance memory. The performance analysis data will be lost after the instance is rebooted. You can use following two OpenAPIs to export the data if demanding the historical data analysis.
In default, the RDS White List is only available to the VPC where this instance resides to ensure data security. Thus, you need to add your new IP address in the White List to access the database instance.
The username and password of the backup source database may be used for the new database created based on the backup or time point, which temporarily does not support the manual input during creation.
Users can only select configurations not less than the actual size of the backup when creating a backup according to a backup.
Automatic backup is currently available for 7 days at least.
If a network ACL is set for the subnet selected when the JD Cloud RDS is created, please ensure that DNS (UDP) rules are added into the outbound rules and accepted. Since the network ACL is stateless, please ensure that the inbound rules also allow the ALL UDP configurations. If the problem remains unresolved, please contact the customer service in work order form.
At present, user are not allowed to modify JCS for MySQL instance parameters in JD Cloud. Therefore, users can feed back the demands through open ticket to the engineers of JD Cloud, and the engineers will help give assistance in the modification.
This is a data file fragment hole problem. When InnoDB performs data deletion, the deleted space will not be recovered, and it will cause a lot of file holes, leading to that the data space usage in the monitoring graph will not change. Optimization method:
OPTIMIZE TABLE <table> or
ALTER TABLE <table> ENGINE=Innodb to rebuild the table space.
You can modify the character set of a database via DMS; Click Console to log in the database, select the name of the database containing the character set intended to be modified from the left after logging in DMS and click the operation tab on the top bar behind to refresh the current page; then, the ranking rule option will be shown in the current page; and choose the character set intended to be modified and click Execute.
Actually, the main function of the parameter character_set_server is to create a library based on the value of character_set_server by default when creating such library from the command line without specifying a character set; but the default operation of creating a database by JD Cloud JCS for MySQL can be operated only by Console, and the character set can be assigned as utf8mb4. Some users may find that even if they do so, the data they see when connecting to the database instance through the client tool are unreadable code, they think this is caused by not setting character_set_server as utf8mb4, in fact it is not, it also involves setting of relevant fields such as character_set_client, character_set_connection, character_set_result, *** and such fields actually can be assigned manually by client***, for details, please see official document: Connection Character Sets and Collations
To view the space used by the local disk of a database instance, please refer to the total usage amount of hard disk space in the monitor. As for the space used by database as searched by SQL command, the relevant statistical result may be inaccurate, because the information in the information_schema.tables table of MySQL isn’t updated in real time.