Function Overview
- ALL
- RDS for SQL Server
- Connecting to an RDS for SQL Server Instance
- Data Migration
- Resetting the Administrator Password
- Enabling Public Accessibility
- Read Replicas
- Scaling Up Storage Space
- Changing a DB Instance Class (vCPUs and Memory)
- Backup and Restoration
- Parameter Templates
- Publications and Subscriptions
- DBA Assistant
- Logs
- APIs
- SDKs
-
RDS for SQL Server
-
SQL Server is a commercial database with a mature enterprise-class architecture. One-stop deployment simplifies key O&M services and greatly reduces labor costs. With RDS for SQL Server, you can build a safe and stable database operation environment that meets Huawei international security standards. It is widely used in government, finance, medical care, education, and gaming.
RDS for SQL Server is reliable, scalable, inexpensive, and easy to manage. It supports high availability for your application with automatic database failover that completes within several seconds. It also provides multiple options for backing up your data.
All regions
-
-
Connecting to an RDS for SQL Server Instance
-
You can connect to an RDS for SQL Server instance through Data Admin Service (DAS), a private network, or a public network.
-
Connecting to a DB Instance Through DAS
-
DAS is a web-based console that simplifies database management and improves efficiency. You can connect and manage DB instances through DAS. By default, you have the remote login permission. It is recommended that you connect to DB instances through DAS, which is more secure and convenient.
-
-
Connecting to a DB Instance Through a Private Network
-
A private (floating) IP address is provided by default. If your applications are deployed on an ECS that is in the same region and VPC as your RDS DB instance, you are advised to use a private IP address to connect the ECS and RDS DB instance.
-
-
Connecting to a DB Instance Through a Public Network
-
If you cannot access a DB instance through a private IP address, bind an EIP to the DB instance first and connect the ECS to the DB instance through the EIP.
-
-
-
Data Migration
-
Data Replication Service (DRS) is recommended to migrate data because it is stable, efficient, easy to use, and simplifies the complexity of data transmission and reduces the transmission costs.
All regions
-
-
Resetting the Administrator Password
-
If you forget the password of the administrator account rdsuser, you can reset the password.
If an error occurs on the rdsuser account, for example, the rdsuser account is lost or deleted, you can restore the account rights through resetting the password.All regions
-
-
Enabling Public Accessibility
-
You can bind an EIP to a DB instance for public accessibility and can also unbind the EIP from the DB instance as needed.
- You can bind an EIP to a primary DB instance or a read replica only.
- If a DB instance has already an EIP bound, you must unbind the EIP from the DB instance first before binding a new one to it.
All regions
-
-
Read Replicas
-
In read-intensive scenarios, a single DB instance may be unable to handle the read pressure and service performance may be affected. To offload read pressure on the database, you can create read replicas in a region. These read replicas can process a large number of read requests and increase application throughput.
All regions
-
-
Scaling Up Storage Space
-
You can scale up storage space if it is no longer sufficient for your requirements. If the DB instance status is Storage full and data cannot be written to databases, you need to scale up storage space.
Services are not interrupted during storage scale-up.
All regions
-
-
Changing a DB Instance Class (vCPUs and Memory)
-
You can change the DB instance class of a DB instance as required. If the status of a DB instance changes from Changing instance class to Available, the change is successful.
All regions
-
-
Backup and Restoration
-
You can use an automated or manual backup to restore a DB instance to the status when the backup was created.
-
-
Parameter Templates
-
You can use database parameter templates to manage DB engine configurations. A database parameter template acts as a container for engine configuration values that can be applied to one or more DB instances.
When creating a DB instance, you can use a default parameter template or create a custom template. After the DB instance is created, you can change the applied parameter template.
- Default parameter template
DB engine defaults and database system defaults are included in default parameter templates.
- Custom parameter template
If you want to use your custom parameter settings, you can create a parameter template and apply it with your DB instance.
- Default parameter template
-
-
Publications and Subscriptions
-
RDS for SQL Server provides publications and subscriptions. This function uses the replication technology to split data reads and writes as well as synchronize data between cloud databases and between cloud databases and on-premises databases.
-
-
DBA Assistant
-
DBA Assistant provides you with a range of database O&M functions, making it easy to diagnose database problems, locate faults, analyze and optimize database performance.
All regions
-
-
Logs
-
- System logs contain logs generated while a DB instance is running. They can help you analyze database problems.
- SQL Audit records major change operations on services, databases, and tables in log files for future query and download.
- Slow query logs record statements that exceed the long_query_time value (1 second by default). You can view log details to identify statements that are executing slowly and optimize the statements.
-
-
APIs
-
RDS supports v3 APIs. You can invoke RDS APIs to perform a range of operations, such as DB instance creation and deletion, backup and restoration, and parameter query and modifications.
-
-
SDKs
-
With RDS SDKs, you can easily invoke RDS APIs to create applications on Huawei Cloud. Currently, SDKs support Java, Python, and Go languages.
All regions
-
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot