MySQL is one of the most popular open-source databases in the world. As a key component of the open-source software bundle LAMP (Linux, Apache, MySQL, and Perl/PHP/Python), MySQL has been widely applied to different scenarios.
Connect to an ApsaraDB RDS for MySQL instance
After you create an RDS instance, configure a whitelist, and create an account, you can use Data Management (DMS) or a database client to connect to the RDS instance. You can also configure the endpoints, ports, and account information in your application.
Use DMS to connect to an RDS instance
DMS is a graphical user interface (GUI) provided by Alibaba Cloud for you to manage databases. It can be used to manage relational and non-relational databases. It offers various functions, such as data and schema management, user authorization, security audit, data trends, data tracking, BI charts, and performance and optimization.
ApsaraDB RDS for MySQL is fully compatible with open source MySQL. You can connect to an ApsaraDB RDS for MySQL instance from a database client by using a similar method that you use to connect to an open source MySQL database. In the following example, the HeidiSQL client is used.
- Start the HeidiSQL client.
- In the lower-left corner of the Session manager dialog box, click New.
- Enter information about the RDS instance that you want to connect.
AliSQL
DB RDS for MySQL
Alibaba Cloud has polished AliSQL for more than five years and released over 300 patches to make AliSQL more competent in processing highly concurrent requests. In addition, Alibaba Cloud has introduced features such as thread pool, parallel replication, and implicit primary key to increase IOPS and make your database instances more stable.
Security certificates
ApsaraDB RDS for MySQL has received more than 10 security certificates from both China and the international community.
It uses transparent data encryption (TDE) to encrypt source code data and protect data from being stolen. ApsaraDB for RDS running MySQL 5.7 or 8.0 supports SSL encryption, ECS security group, disk encryption, Bring Your Own Key (BYOK), and rotation of keys.
CloudDBA
CloudDBA is integrated into the ApsaraDB for RDS console. It monitors the performance metrics and slow SQL statements of your database instances and provides suggestions to locate performance issues.