Relational Database Service
Relational Database Service
- Function Overview
- Product Bulletin
- Service Overview
- Billing
- Getting Started
-
User Guide
- Suggestions on Using RDS for SQL Server
- Buying an RDS for SQL Server DB Instance
- Instance Connection
- Database Migration
- Performance Tuning
- Using IAM to Grant Access to RDS
- Instance Lifecycle
-
Instance Modifications
- Changing a DB Instance Name
- Changing a DB Instance Description
- Changing the Failover Priority
- Cloning a DB Instance
- Changing a DB Instance Class
- Scaling Up Storage Space
- Configuring Autoscaling
- Changing a Maintenance Window
- Changing a DB Instance Type from Single to Primary/Standby
- Manually Switching Between Primary and Standby DB Instances
- Updating the DB Engine and OS of a DB Instance
- Read Replicas
- Data Backups
- Data Restorations
-
Parameters
- Creating a Parameter Template
- Modifying RDS for SQL Server Instance Parameters
- Exporting a Parameter Template
- Comparing Parameter Templates
- Viewing Parameter Change History
- Replicating a Parameter Template
- Resetting a Parameter Template
- Applying a Parameter Template
- Viewing Application Records of a Parameter Template
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Accounts (Non-Administrator)
- Databases
- Security and Encryption
- Distributed Transactions
- SQL Server Integration Services (SSIS)
- Metrics and Alarms
- Interconnection with CTS
- Log Management
- DBA Assistant
- Publications and Subscriptions
- Task Center
- Billing Management
- Enabling or Disabling FileStream
- CLR Integration
- Default Language Setting for RDS for SQL Server
-
Usage of Stored Procedures
- Creating a Database Account
- Granting SSIS Permissions to a Domain Account
- Deploying an SSIS Project
- Changing Custom Database Names
- Viewing Error Logs
- Managing Trace Flags
- Capturing Change Data
- Removing a Custom Database from an Availability Group
- Replicating Databases
- Granting Database Permissions to Subaccounts
- Deleting Custom Databases
- Updating Database Statistics
- Cycling SQL Server Agent Error Logs
- Cycling SQL Server Error Logs
- Creating Alerts
- Setting Up Notifications for Alert
- Creating Operators for Alerts and Jobs
- Updating Alert Settings
- Updating Alert Notification Methods
- Updating Information About Operators for Alerts and Jobs
- Removing Alerts
- Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
- Removing Operators
- Shrinking Databases
- Changing the Permission to View All Databases
- Granting Permissions of Database-Level db_owner Role
- RDS for SQL Server Tags
- RDS for SQL Server Quotas
-
Best Practices
- Restoring Data from Backup Files to RDS for SQL Server DB Instances
- Migrating Data from a Self-Managed SQL Server Database on an ECS to an RDS for SQL Server DB Instance
- Modifying Parameters of RDS for SQL Server Instances
- Supporting DMVs
- Using the Import and Export Function to Migrate Data from a Local Database to an RDS for SQL Server DB Instance
- Creating a Subaccount of rdsuser
- Creating tempdb Files
- Microsoft SQL Server Publication and Subscription
- Installing a C# CLR Assembly in RDS for SQL Server
- Creating a Linked Server for an RDS for SQL Server DB Instance
- Deploying SQL Server Reporting Services (SSRS) on RDS for SQL Server
- Shrinking an RDS for SQL Server Database
- Using DAS to Create and Configure Agent Job and DBLink on the Master and Slave Databases for RDS for SQL Server Instances
- Creating a Job for Scheduled Instance Maintenance
- Using Extended Events
- Security Best Practices
- Performance White Paper
-
FAQs
-
Product Consulting
- What Should I Pay Attention to When Using RDS?
- Will My RDS DB Instances Be Affected by Other User Instances?
- Will Different RDS DB Instances Share CPU and Memory Resources?
- How Long Does It Take to Create an RDS for SQL Server Instance?
- What Can I Do About Slow Responses of Websites When They Use RDS?
- What Is the Time Delay for Primary/Standby Replication?
- Can Multiple ECSs Connect to the Same RDS DB Instance?
- Will Backups Be Encrypted After Disk Encryption Is Enabled for My RDS Instance?
- What Is the Availability of RDS DB Instances?
- Does RDS Support Cross-AZ High Availability?
- Can RDS Primary/Standby DB Instances Be Changed to Single-Node DB Instances?
- Can I Use an Encrypted Password to Log In to an RDS DB Instance?
- What Are the Differences Between Floating and Private IP Addresses of RDS DB Instances?
- What Can I Do If I Can't Find My RDS Resources?
- Resource Freezing, Release, Stopping, Deletion, and Unsubscription
-
Resource and Disk Management
- Which Types of Logs and Files Occupy RDS for SQL Server Storage Space?
- Does RDS for SQL Server Support Storage Scale-Down of DB Instances?
- Which Items Occupy the Storage Space of My RDS for SQL Server Instance?
- How Much Storage Space Is Required for DDL Operations?
- How Do I Prevent a Sharp Increase in Data Disk Usage If I Want to Push a Large Amount of Data to My RDS for SQL Server Instance in a Short Period of Time?
-
Database Connection
- What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
- What Should I Do If an ECS Cannot Connect to an RDS for SQL Server Instance Through a Private Network?
- What Should I Do If My RDS for SQL Server Instance Fails to Be Connected Due to Database Client Problems?
- What Should I Do If an RDS for SQL Server Database Problem Causes a Connection Failure?
- Do Applications Need to Support Reconnecting to an RDS DB Instance Automatically?
- Why Can't I Ping My EIP After It Is Bound to an RDS DB Instance?
- Can I Access an RDS for SQL Server Instance over an Intranet Across Regions?
- Why Did the New Password Not Take Effect After I Reset the Administrator Password of My RDS for SQL Server Instance?
- Can I Access Standby RDS DB Instances?
- Will I Be Logged Out If the Connection to an RDS for SQL Server Instance Times Out?
- What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
- Will My Access Be Restricted by Bandwidth When I Connect to My RDS for SQL Server Instance from an ECS over a Private Network?
- Database Migration
-
Database Permission
- What Are the Differences Between RDS ManageAccess and DAS Permissions?
- How Do I View Authorized Databases After a Local Client Is Connected to an RDS DB Instance?
- Can Multiple Users Log In to an RDS Instance Through DAS at the Same Time? Will the Accounts Be Locked If I Enter Wrong Passwords Several Times in a Row?
- How Are the Login Name Permissions of an RDS for SQL Server 2017 Enterprise Edition Primary/Standby Instance Synchronized to Its Read Replicas?
- After a Primary Instance Account Is Deleted and Recreated on RDS for SQL Server, Will the Permissions Be Automatically Synchronized?
- Database Storage
-
Database Usage
- How Do I Use DAS to Query SQL Statements?
- How Do I View Session IDs and Login and Logout Time of an RDS Database?
- What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File for My RDS Instance?
- Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
- Why Is an Error Reported When I Attempt to Delete a Database from My RDS for SQL Server Primary/Standby DB Instance?
-
Backup and Restoration
- How Do I View My Backup Storage Usage?
- How Is RDS for SQL Server Backup Data Billed?
- Why Has Automated Backup of My RDS Instance Failed?
- Why Is Data Lost or Deleted from My RDS Instance?
- How Long Does RDS for SQL Server Store Backup Data For?
- How Do I Clear RDS for SQL Server Backup Space?
- Can My RDS Instance Still Be Used in the Backup Window?
- How Can I Back Up an RDS for SQL Server Database to an ECS?
- Can I Dump RDS for SQL Server Backups to My OBS Bucket?
- How Are Unsynchronized Backups Generated for RDS for SQL Server Instances?
- What Should I Do If I Failed to Obtain a Backup Because the Name of the Bucket for Storing My RDS Backups Was Changed?
- Read Replicas and Read/Write Splitting
- Database Monitoring
- Capacity Expansion and Specification Change
- Database Parameter Modification
- Log Management
-
Network Security
- How Can Secure Data Transmission Be Ensured When I Access an RDS for SQL Server Instance Through an EIP?
- How Can I Prevent Untrusted Source IP Addresses from Accessing RDS for SQL Server?
- How Do I Import the SSL Certificate of an RDS Instance to a Windows or Linux Server?
- What Are the Possible Causes for Data Corruption of an RDS Instance?
- After My RDS for SQL Server Instance Is Deleted, Why Can't the Associated Security Group Be Deleted Immediately?
- Version Upgrade
- Developer-Related APIs and SDKs for RDS
-
Product Consulting
-
Troubleshooting
- Account Creation Failure for a SQL Server Database Migrated from Alibaba Cloud to Huawei Cloud
- Error Reported When a New Account Is Used to Log In to an RDS for SQL Server Instance
- Failed to Change the Instance Class of an RDS for SQL Server Instance or Perform a Primary/Standby Switchover
- How Do I Remove and Re-establish a Replication of My RDS for SQL Server Instance?
- General Reference
On this page
Help Center/
Relational Database Service_RDS for SQL Server/
User Guide/
Instance Modifications/
Changing the Failover Priority
Copied.
Changing the Failover Priority
Scenarios
RDS gives you control over the failover priority of your primary/standby DB instance. You can set it to Reliability or Availability.
- Reliability (default setting): Data consistency is preferentially ensured during a primary/standby failover. This is recommended for applications whose highest priority is data consistency.
- Availability: Database availability is preferentially ensured during a primary/standby failover. This is recommended for applications that require databases to provide uninterrupted online services.
Primary/Standby Replication Mode
- RDS for SQL Server uses synchronous replication between the primary and standby DB instances by default. SQL Server 2017 Enterprise Edition and 2019 Enterprise Edition use Always On availability groups (AGs). Other editions use database mirroring.
- RDS for SQL Server uses asynchronous replication between the primary DB instance and read replicas by default.
Procedure
- Click
in the upper left corner and select a region.
- Click
in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, click the primary instance name.
- On the displayed Overview page, find Failover Priority and click Configure under it. In the displayed dialog box, select a priority and click OK.
Figure 1 Changing the failover priority
- View the results on the Overview page.
Parent Topic: Instance Modifications
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot