RDS supports two access modes, standard mode and safe connection mode. This article mainly describes the differences between the two access modes and the switching method.
Standard mode: RDS uses SLB to eliminate the impact of database engine HA switching on the application layer which helps shorten the response time, but that may slightly increase the probability of transient disconnections and disable the built-in SQL injection protection.
This mode supports only one connection address. When the instance has both the Intranet address and the Internet address, it is required to first release the Intranet address or the Internet address, and then switch to standard mode.
Safe connection mode: This mode can prevent 90% of transient disconnections and provides SQL injection protection (attacks are prevented through semantic analysis), but the response time will be increased by 20% or more. This mode supports coexistence of the Intranet address and the Internet address.
The defaul access mode of MySQL 5.7 and SQL Server 2012 instance is standard mode. The switch between standard mode and safe connection mode is not supported.
The defaul access mode of PPAS and PostgreSQL instances is safe connection mode. The switch between standard mode and safe connection mode is not supported.
When switching the access mode, the RDS service may flash off for about 30 seconds. To avoid the impacts on your production, it is recommended that you upgrade the database at the low peak of the service, or make sure that your application has the automatic reconnection mechanism.
Log on to the
Select the region where the target instance is located.
Click the ID of the instance to visit the Basic Information page.
Select Database Connection in the left navigation bar to visit the Database Connection page.
Click Switch Access Mode.
Click Confirm on the displayed confirmation interface to switch the access mode.