This topic describes the usage notes of ApsaraDB for RDS.

After you create an RDS instance, you do not need to conduct basic database operation and maintenance (O&M), such as high availability configuration and security patching. However, you must note the following information:

  • Instance upgrade

    While you upgrade your RDS instance, a brief disconnection of up to 30 seconds may occur. To avoid interruptions to your business, we recommend that you configure your application to automatically reconnect to your RDS instance.

  • Failover

    In the High-availability or Enterprise Edition, if your primary RDS instance breaks down unexpectedly, your database system fails over to a secondary RDS instance within 30 seconds. During this process, a brief disconnection of about 30 seconds may occur. To avoid interruptions to your business, we recommend that you configure your application to automatically reconnect to your database system.

  • Internet/internal network switchover

    While you switch your RDS instance between the Internet and an internal network, the server on which your application is running is disconnected from your RDS instance, and the IP address used for connection also changes. After the switchover is complete, immediately update the configuration data on your application to include the new endpoint that is used to connect to your RDS instance.

  • Data restoration

    We recommend that you back up the important data of your RDS instance on a regular basis to avoid data losses. If you want to restore the important data, we recommend that you follow these steps: Create a temporary or clone instance, restore the important data to the temporary or clone instance, verify the important data on the temporary or clone instance, and then migrate the important data back to your RDS instance.

  • Storage capacity

    After the storage capacity of your RDS instance is exhausted, your RDS instance will be locked and can only process read requests. We recommend that you check the storage usage on a regular basis.

  • Performance optimization

    • Check whether the number of CPU cores, memory capacity, input/output operations per second (IOPS), storage capacity, and maximum number of connections for your RDS instance are adequate. Optimize or upgrade your RDS instance if necessary.
    • Check whether your RDS instance is properly running. For example, check whether a large number of SQL statements are executed at low speeds, whether SQL statements need to be optimized, and whether some indexes are unnecessary or missing. Resolve all of the issues that you can identify.