This topic describes how to upgrade the network connection mode of your RDS instances from the high-security mode (database proxy mode) to the high-performance mode (standard mode). Note that during the network connection upgrade, you may experience a transient network disconnection for up to 30 seconds.

Potential risks of not performing the upgrade

The high-security mode may encounter temporary instability in certain scenarios. To guarantee service stability, we recommend that you perform the upgrade as soon as possible.

Benefits

After the upgrade, the network connection 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 must upgrade the network connection modes of all RDS for MySQL, RDS for PostgreSQL, RDS for PPAS, and HybridDB for PostgreSQL instances that are in high-security mode (database proxy mode).

To check whether an instance is in high-security 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 RDS instance is located.Select a region
  3. Find the target RDS instance and click the instance 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 you have enabled read/write splitting for an RDS for MySQL instance, the instance configuration does not support an upgrade at this time.
      • If a master instance is attached with read-only instances, you only need to upgrade the master instance, and the read-only instances are automatically upgraded

Impact of the upgrade

  • During the upgrade, the RDS instance may experience a transient disconnection for up to 30 seconds. Make sure that your application 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 you run multiple SQL statements after the upgrade, 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. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.Select a region
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Database Connection.
  5. On the Database Connection page, click Switch Access Mode.
  6. In the displayed dialog box, click Confirm.
  7. Check that services are running properly.
    Note Do not skip this step.

Upgrade method 2

Note This upgrade method is applicable only to some RDS instances.
  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.Select a region
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Database Proxy.
  5. On the Database Proxy page, click the slider next to Database Proxy (Safe Mode).
  6. In the displayed dialog box, click Confirm.
  7. Check that services are running properly.
    Note Do not skip this step.

FAQ

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

    See Instances that need to be upgraded.

  2. Why am I unable to upgrade my RDS instance?

    If read/write splitting is enabled an RDS for MySQL instance, the instance currently cannot be upgraded at this time.

  3. After a network connection upgrade, what actions do I need to take to make sure that my services run normally?

    We recommend that you check whether you must manually restart your services. If the automatic reconnection function is enabled, you do not need to manually restart your services.

  4. Can I switch back to the high-security mode (database proxy mode)?

    Yes, but this action is not recommended for most scenarios.

  5. If my master RDS instance is attached with 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.