Estos contenidos se han traducido de forma automática para su comodidad, pero Huawei Cloud no garantiza la exactitud de estos. Para consultar los contenidos originales, acceda a la versión en inglés.
Cómputo
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Redes
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Gestión y gobernanza
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
Cloud Operations Center
Resource Governance Center
Migración
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Análisis
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
IoT
IoT Device Access
Otros
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Seguridad y cumplimiento
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Servicios multimedia
Media Processing Center
Video On Demand
Live
SparkRTC
Almacenamiento
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Contenedores
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Bases de datos
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Aplicaciones empresariales
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Data Lake Factory
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Distribución de contenido y cómputo de borde
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Soluciones
SAP Cloud
High Performance Computing
Servicios para desarrolladores
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
Cloud Application Engine
aPaaS MacroVerse
KooPhone
KooDrive

RDS for MariaDB Constraints

Actualización más reciente 2024-06-05 GMT+08:00

The following shows the constraints designed to ensure the stability and security of RDS for MariaDB.

Constraints on Usage

  • Only the InnoDB storage engine is supported. Transparent Data Encryption (TDE) is not supported.
  • DDL statements cannot be executed during full backup.
  • DML operations cannot be performed on tables in system databases such as mysql, information_schema, and performance_schema.
  • Operations that require the SUPER or *_ADMIN permissions are not supported.

Specifications

Tabla 1 Specifications

Item

Constraints

Description

Storage space

Cloud SSD: 40 GB to 4,000 GB

-

Connections

A maximum of 100,000 for 512 GB of memory

The default maximum number of connections varies depending on the memory. For details, see What Is the Maximum Number of Connections to an RDS DB Instance?

IOPS

Cloud SSD: a maximum of 50,000

The input/output operations per second (IOPS) supported depends on the I/O performance of Elastic Volume Service (EVS) disks. For details, see the description about ultra-high I/O in Disk Types and Performance of Elastic Volume Service Service Overview.

Quotas

Tabla 2 Quotas

Item

Constraints

Description

Read replica

A maximum of five read replicas can be created for a DB instance.

For more information, see Introducing Read Replicas.

Tags

A maximum of 20 tags can be added for a DB instance.

For more information, see Managing Tags.

Free backup space

RDS for MariaDB provides free backup space of the same size as your purchased storage space.

After you pay for the storage space of your DB instance, you will get a backup space of the same size for free. For more information, see How Is RDS Backup Data Billed?

Retention period of automated backups

The default value is 7 days. The value ranges from 1 to 732 days.

For more information, see Configuring an Intra-Region Backup Policy.

Log retention period

  • Error log details: 30 days
  • Slow query log details: 30 days

For more information, see Log Management.

Naming

Tabla 3 Naming

Item

Constraints

Instance name

  • 4 to 64 characters long
  • Must start with a letter. Only letters (case sensitive), digits, hyphens (-), and underscores (_) are allowed.

Database name

  • 1 to 64 characters long
  • Only letters, digits, hyphens (-), and underscores (_) are allowed. The total number of hyphens (-) cannot exceed 10.

Account name

  • 1 to 32 characters long
  • Only letters, digits, hyphens (-), and underscores (_) are allowed.

Backup name

  • 4 to 64 characters long
  • Must start with a letter. Only letters (case sensitive), digits, hyphens (-), and underscores (_) are allowed.

Parameter template name

  • 1 to 64 characters long
  • Only letters (case sensitive), digits, hyphens (-), underscores (_), and periods (.) are allowed.

Security

Tabla 4 Security

Item

Constraints

root permissions

Only the administrator account root is provided on the instance creation page. For details about the supported permissions, see Tabla 6.

NOTA:

Running revoke, drop user, or rename user on root may cause service interruption. Exercise caution when running any of these statements.

root password

  • 8 to 32 characters long
  • Must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@$#%^*-_=+?,()&).

For more information, see Resetting the Administrator Password to Restore Root Access.

Database port

1024 to 65535 (excluding 12017 and 33071, which are occupied by the RDS system)

For more information, see Changing a Database Port.

VPC

The VPC where a DB instance is located cannot be changed after the instance is created.

Security group

  • By default, you can create a maximum of 100 security groups in your cloud account.
  • By default, you can add up to 50 security group rules to a security group. For more information, see Configuring a Security Group Rule.
  • One RDS DB instance can be associated with multiple security groups, and one security group can be associated with multiple RDS DB instances.

System account

To provide O&M services, the system automatically creates system accounts when you create RDS for MariaDB DB instances. These system accounts are unavailable to you.

  • mariadb.sys: used to create views.
  • rdsAdmin: a management account, used to query and modify instance information, rectify faults, migrate data, and restore data.
  • rdsRepl: a replication account, used to synchronize data from the primary instance to the standby instance or read replicas.
  • rdsBackup: a backup account, used for backend backup.
  • rdsMetric: a metric monitoring account used by watchdog to collect database status data.
  • rdsProxy: a database proxy account, used for authentication when the database is connected through the read/write splitting address. This account is automatically created when you enable read/write splitting.

Instance parameter

To ensure the optimal performance of RDS, you can modify parameters in the parameter template you created as needed.

Instance Operations

Tabla 5 Instance operations

Item

Description

Instance deployment

ECSs where DB instances are deployed are not directly visible to you. You can only access the DB instances through IP addresses and database ports.

Data synchronization

You can synchronize data from self-managed MariaDB databases or MariaDB databases built on other clouds to RDS for MariaDB, or from one RDS for MariaDB instance to another RDS for MariaDB instance.

The common data synchronization tool is Data Replication Service (DRS). For details, see From MariaDB to RDS for MariaDB.

DRS is easy to use and can complete a synchronization task in minutes. DRS facilitates data transfer between databases, helping you reduce DBA labor costs and hardware costs.

High CPU usage

If the CPU usage is high or close to 100%, data read/write and database access will become slow, and an error will be reported during data deletion.

Full storage

There is not enough storage available for a DB instance and the instance becomes read-only, so applications cannot write any data to the instance.

For details, see What Should I Do If an RDS DB Instance Is Abnormal Due to Full Storage Space?

Number of tables

RDS for MariaDB supports a maximum of 500,000 tables.

If there are more than 500,000 tables, database backup or a minor version upgrade may fail.

Rebooting a DB instance

DB instances cannot be rebooted through commands. They must be rebooted through the RDS console. For details, see Rebooting DB Instances or Read Replicas.

Viewing backups

You can download automated and manual backups for local storage. To download a backup, you can use OBS Browser+, the current browser, or the download URL.

For more information, see Downloading a Full Backup File.

Log management

  • RDS for MariaDB logging is enabled by default and cannot be disabled.
  • Binary logging is enabled for RDS for MariaDB by default and uses row-based logging.
  • Read replicas do not provide binlogs.

Recycle bin

RDS allows you to move deleted pay-per-use DB instances to the recycle bin. You can rebuild a DB instance that was deleted up to 7 days ago from the recycle bin.

root Permissions

Tabla 6 root permissions

Permission

Level

Description

Supported

Select

Table

Query permissions

Yes

Insert

Table

Insert permissions

Update

Table

Update permissions

Delete

Table

Delete permissions

Create

Database, table, or index

Permissions of creating databases, tables, or indexes

Drop

Database or table

Permissions of deleting databases or tables

Reload

Server management

Permissions of running the following commands: flush-hosts, flush-logs, flush-privileges, flush-status, flush-tables, flush-threads, refresh, and reload

Process

Server management

Permissions of viewing processes

Grant

Database, table, or stored program

Permissions of granting access control

References

Database or table

Foreign key operation permissions

Index

Table

Index permissions

Alter

Table

Permissions of altering tables, such as adding fields or indexes

Show_db

Server management

Permissions of viewing database connections

Create_tmp_table

Server management

Permissions of creating temporary tables

Lock_tables

Server management

Permissions of locking tables

Execute

Stored procedure

Permissions of executing storage procedures

Repl_slave

Server management

Replication permissions

Repl_client

Server management

Replication permissions

Create_view

View

Permissions of creating views

Show_view

View

Permissions of viewing views

Create_routine

Stored procedure

Permissions of creating storage procedures

Alter_routine

Stored procedure

Permissions of altering storage procedures

Create_user

Server management

Permissions of creating users

Event

Database

Event triggers

Trigger

Database

Triggers

Super

Server management

Permissions of killing threads

No

File

File on the server

Permissions of accessing files on database server nodes

No

Shutdown

Server management

Permissions of shutting down databases

Create_tablespace

Server management

Permissions of creating tablespaces

Utilizamos cookies para mejorar nuestro sitio y tu experiencia. Al continuar navegando en nuestro sitio, tú aceptas nuestra política de cookies. Descubre más

Comentarios

Comentarios

Comentarios

0/500

Seleccionar contenido

Enviar el contenido seleccionado con los comentarios