Upgrade the network connection mode of an ApsaraDB RDS instance

Who is affected

This upgrade applies to ApsaraDB RDS for MySQL instances and AnalyticDB for PostgreSQL instances that are in the database proxy mode with read/write splitting disabled.

To check whether your instance requires an upgrade:

1. Log on to the ApsaraDB RDS console. On the Instances page, select the region where the instance resides, then click the instance ID.

2. In the left-side navigation pane, click Database Connection.

3. In the Database Connection section, check the value of Database Proxy Status:

   • Disabled: no upgrade needed.

   • Enabled: upgrade required.

If read/write splitting is enabled on your instance, use a separate upgrade path. See Upgrade the database proxy of an ApsaraDB RDS for MySQL instance from a shared proxy to a dedicated proxy.

What happens if you don't upgrade

Without the upgrade, network jitter may occur when accessing the instance, causing intermittent business interruptions.

Before you upgrade

The upgrade triggers an instance switchover. Complete the following checks before proceeding:

Configure automatic reconnection

Make sure your application is configured to automatically reconnect to the RDS instance after a switchover. If not, you may need to manually restart the application after the upgrade. For details on switchover behavior, see Impacts of an instance switchover.

Check multi-statement settings

In the database proxy mode, multi-statement execution is enabled by default at the protocol layer. After switching to the standard mode, this is disabled. If your application executes multi-statement strings, add the allowMultiQueries parameter to your Java Database Connectivity (JDBC) connection string before upgrading:

jdbc:mysql:///test?allowMultiQueries=true

If your instance has read-only instances attached, you only need to upgrade the primary instance. The system automatically upgrades the read-only instances.

Upgrade method 1: switch access mode

1. In the ApsaraDB RDS console, go to the Database Connection page and click Switch Access Mode.

2. In the dialog box, click OK to disable the database proxy mode.

3. Verify that the instance is running as expected.

Do not skip the verification step.

Upgrade method 2: database proxy page

This method is available only for some RDS instances.

1. In the ApsaraDB RDS console, go to the Database Proxy page and click Enabled.

2. In the dialog box, click OK to disable the database proxy mode.

3. Verify that the instance is running as expected.

Do not skip the verification step.

Upgrade method 3

1. After you receive the SMS or email notification, log on to the ApsaraDB RDS console.

2. Click Pending Events.

3. Select the instance and click Customize Operation Time to change the time at which the upgrade is performed, which is the scheduled switchover time. The scheduled switchover time cannot be later than the latest operation time.

   Note

   • If the start time and scheduled switchover time are empty, you must manually specify the time. Make sure that you click Customize Operation Time to specify the time.

   • If you do not change the time, the upgrade is performed at the default scheduled switchover time (by default, within the maintenance window of the instance).

   • You can specify different scheduled switchover times for different instances.

4. Check whether the database proxy status (formerly high security mode) is Not Enabled.

5. Verify that your business runs as expected.

   Note

   Do not skip this verification step.

After the upgrade

After the upgrade completes, the endpoints and IP addresses of the instance remain unchanged. No changes to your application's connection configuration are required.

FAQ

Do I need to upgrade?

Check the Database Proxy Status field on the Database Connection page. If the status is Enabled, the upgrade is required. See Who is affected for the full check procedure.

Why can't I upgrade?

If read/write splitting is enabled on your instance, the standard upgrade path is not available. Use the dedicated proxy upgrade path instead. See Upgrade the database proxy of an ApsaraDB RDS for MySQL instance from a shared proxy to a dedicated proxy.

Can I switch back to the database proxy mode after upgrading?

Yes. You can switch back to the database proxy mode, though you do not need to do so. The standard mode supports the same communication types as the database proxy mode — both Internet and internal network connections work the same way.