This topic describes how to disable the database proxy mode for an RDS for SQL Server instance. Disabling the database proxy mode means switching to the standard mode, which helps improve the performance of the RDS instance.

Precautions

  • In the database proxy mode, the multi-statement function is enabled by default at the protocol layer. Therefore, after you disable the database proxy mode, if you do not enable the multi-statement function but run multiple SQL statements, the system reports errors in the SQL statements. To prevent this problem, you must check and add connection parameters in advance. For example, you can add the allowMultiQueries parameter to JDBC as follows:
    dbc:mysql:///test?allowMultiQueries=true
  • You can only disable the database proxy mode (that is, switch from the database proxy mode to the standard mode). You cannot enable the database proxy mode (that is, switch from the standard mode to the database proxy mode).
  • Switching the access mode may cause a 30-second transient disconnection. Therefore, we recommend that you switch the access mode during off-peak hours or make sure that your application can automatically reconnect to the RDS instance.
  • If the RDS instance uses the SQL Server 2008 R2 version and runs in a VPC, the database proxy mode is used by default and cannot be switched to the standard mode.
  • If the RDS instance uses the SQL Server 2008 R2 version and runs in a classic network, the standard mode is used by default and cannot be switched to the database proxy mode. Additionally, the RDS instance cannot be migrated to a VPC.

Access modes

DB engine version Supported access modes
SQL Server 2012/2016/2017 Standard mode
SQL Server 2008 R2 Standard mode and database proxy mode

Prerequisites

The database proxy mode is enabled for your RDS instance.

Note
  • If the Database Proxy tab is displayed, the database proxy mode is enabled and you can proceed with the operations described in this topic.
  • If the Database Proxy tab is not displayed, the database proxy mode is not displayed and you can skip this topic.

数据库代理页签

Procedure

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.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Database Connection.
  5. Click Switch Access Mode and in the displayed dialog box, click Confirm.
    数据库连接
    Note This button is available only when you have enabled the database proxy mode.

Method 2

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    选择地域
  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 tab, click the slider next to the database proxy status and in the displayed dialog box, click Confirm.
    Note This tab page is available only when you have enabled the database proxy mode.