Functions

Billing

Yearly/monthly and pay-per-use billing modes are available.

• Yearly/Monthly: A prepaid billing mode in which you pay for resources before using it. Bills are settled based on the subscription period. The longer you use the service, the more discounts you get. This mode is a good option for long-term, stable workloads.
• Pay-per-use: A postpaid billing mode. You pay as you go and just pay for what you use. The DB instance usage is calculated by the second but billed every hour. This mode allows you to adjust resource usage easily. You neither need to prepare for resources in advance, nor end up with excessive or insufficient preset resources.
• You can switch between the yearly/monthly and pay-per-use modes.

For more information, see Billing Overview.

Connecting to a DB Instance

You can connect to an RDS for MariaDB instance through Data Admin Service (DAS), a private network, or a public network.

• Through DAS: DAS is a professional database administration service. It enables you to connect to and manage DB instances with ease using a web-based console. The permission required for remotely connecting to DB instances has been enabled for you by default. Using DAS to connect to your DB instance is recommended, which is more secure and convenient.
• Through a private network: The system assigns a floating IP address to your instance by default. If your application is deployed on an ECS that is in the same region and VPC as your DB instance, you are advised to use a floating IP address to connect to the DB instance from the ECS.
• Through a public network: If you cannot access a DB instance through a floating IP address, bind an EIP to the DB instance and connect it through the EIP.

For more information, see RDS for MariaDB Instance Connection.

Resetting the Administrator Password

If you forget the password of your administrator account when using RDS, you can reset the password. If an error occurs on the root account, for example, if your root account credentials are lost or deleted, you can restore the root account permissions through resetting the password. For more information, see Resetting the Administrator Password to Restore Root Access.

Enabling Public Network Access

You can bind an EIP to an RDS for MariaDB instance for public access and can unbind the EIP from an instance as required.

• You can bind an EIP only to a primary DB instance or a read replica.
• If a DB instance has already been bound with an EIP, you must unbind the EIP from the instance first before binding a new EIP to it.

For more information, see Binding and Unbinding an EIP.

Read Replicas

In read-intensive scenarios, a single DB instance may be unable to handle the read pressure and workloads may be affected. To offload read pressure on the primary DB instance, you can create one or more read replicas in the same region as the primary instance. These read replicas can process a large number of read requests and increase application throughput. For more information, see Introduction to Read Replicas.

Scaling Up Storage Space

You can scale up storage space if it is no longer sufficient for your workloads. If the DB instance status is Storage full and data cannot be written to databases, you need to scale up storage space. Workloads are not interrupted during storage scale-up. For more information, see Scaling Up Storage Space.

Changing Instance Class

You can change the instance class (vCPUs and memory) of an instance if needed. For more information, see Changing a DB Instance Class.

Data Backup

RDS for MariaDB offers various backup types. To learn about their concepts and differences, see Backup Solutions.

A backup file is generated each time a backup is complete. If the instance fails or data is damaged, you can use the backup file to restore the instance, ensuring data availability.

Data Restoration

For more information, see Restoration Solutions.

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 associate a default or custom parameter template with it. After the DB instance is created, you can also change its parameter template.

• Default parameter template

  Each default parameter template contains database engine defaults and database system defaults.

• 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.

For more information, see Managing Parameter Templates.

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. For more information, see Problem Diagnosis and SQL Analysis.

Logs

• Error logs are generated when the database is running. These logs can help you analyze problems with the database.
• Slow query logs record statements that exceed the long_query_time value (1 second by default). You can view log details and statistics to identify statements that are executing slowly and optimize the statements.
• Failover/switchover logs help you evaluate the impact on workloads.
• Once SQL Audit is enabled, all SQL operations will be logged. You can download audit logs and query details.

For more information, see Log Management.

API

RDS supports v3 APIs. You can call RDS APIs to perform a range of operations, such as DB instance creation and deletion, backup and restoration, and parameter query and modifications. For more information, see API Reference.

SDK

Using SDKs provided by RDS, you can easily call RDS APIs to set up Internet applications on Huawei Cloud. Java, Python, and Go languages are supported. For more information, see SDK Developer Guide.