To ensure better stability and performance, we recommend that you upgrade the network connection mode of your RDS instances from the safe mode (database proxy mode) to the high-performance mode (standard mode).

Potential risks of not performing the upgrade

The safe mode may encounter temporary instability in certain scenarios. To ensure stability of your services, we recommend that you perform the upgrade as soon as possible.

Benefits

After the upgrade, the network link is shorter so that:
  • The network becomes more stable.
  • The average response time is reduced by 20% and performance is significantly improved.

Instances that need to be upgraded

You need to upgrade the network connection modes of all RDS for MySQL, RDS for PostgreSQL, RDS for PPAS, and HybridDB for PostgreSQL instances that are in safe mode (database proxy mode).

To check whether an instance is in safe mode (database proxy mode), follow these steps:
  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target instance is located.

  3. Find the target instance and click its ID.
  4. In the left-side navigation pane, click Database Connection. Then, check the Database Proxy (Safe Mode) field.
    • If the status is Disabled, the instance does not need to be upgraded.
    • If the status is Enabled, the instance needs to be upgraded.
      Note
      • If an MySQL instance has enabled read/write splitting, the instance does not need to be upgraded. Alibaba Cloud will provide another upgrade plan for such instances.
      • If an instance has read-only instances attached to it, you only need to upgrade the master instance and then the read-only instances will be automatically upgraded

Impact of the upgrade

  • During the upgrade, the RDS instance being upgraded will be disconnected for about 30 seconds. Make sure that your services can automatically reconnect to the RDS instance.
  • In database proxy mode, the multi-statement function is enabled at the protocol layer by default. Therefore, if the multi-statement function is disabled but multiple SQL statements are run after the switchover, the system reports errors while running the SQL statements. We recommend that you check and add connection parameters before the upgrade. For example, you can add the allowMultiQueries parameter in the JDBC API as follows:
    dbc:mysql:///test?allowMultiQueries=true

Upgrade method 1

  1. On the Database Connection page, click Switch Access Mode.
    Note This button is displayed only when the access mode of the instance is safe mode (database proxy mode).
  2. In the displayed dialog box, click Confirm.
  3. Check that services are running properly.
    Note This step is important.

Upgrade method 2

  1. On the Database Proxy page, click the slider next to Database Proxy (Safe Mode).
    Note This slider is available only when the access mode of the instance is safe mode (database proxy mode).
  2. In the displayed dialog box, click Confirm.
  3. Check that services are running properly.
    Note This step is important.

FAQ

  1. How do I know whether an instance needs to be upgraded?

    See Instances that need to be upgraded.

  2. I cannot upgrade my instance. Why?

    If a MySQL instance has enabled read/write splitting, the instance currently cannot be upgraded. Alibaba Cloud will provide another upgrade plan for such instances.

  3. What do I need to do for my services after an upgrade?
    • During an upgrade, the instance being upgraded may be disconnected. Make sure that your services have an automatic reconnection mechanism; otherwise, you may need to manually restart your services.
    • After an upgrade, the connection address, IP address, and other settings of the RDS instance remain unchanged, so you do not need to make any changes to your applications.
  4. Can I switch back to the safe mode (database proxy mode)?

    You do not need to switch back to the safe mode. The safe mode was designed to support the coexistence of different network types (Internet and intranet), but now the high-performance mode (standard mode) also serves that purpose.

  5. If a master instance has read-only instances, do I need to upgrade each read-only instance?

    No. You only need to upgrade the master instance. The attached read-only instances are then automatically upgraded.