Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
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
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
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
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
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
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive

Constraints

Updated on 2024-12-30 GMT+08:00

To improve instance stability and security, TaurusDB has certain constraints in place.

Specifications and Performance

Table 1 Specification and performance constraints

Resource Type

Constraint

Remarks

Storage space

  • Pay-per-use instance: a maximum of 128,000 GB
  • Yearly/monthly instance: 40 GB to 128,000 GB
  • Serverless instance: a maximum of 128,000 GB
  • Standard HTAP instance: 50 GB to 32,000 GB for backend nodes; 50 GB to 1,000 GB for frontend nodes

-

Temporary disk space

500 GB at most

For more information, see How Can I Use Temporary Disk of TaurusDB?

Connections

TaurusDB does not have constraints on the number of connections. It depends on the default values and value ranges of certain parameters in your DB engine.

For more information, see What Is the Maximum Number of Connections to a TaurusDB Instance?

Quotas

Table 2 Quota constraints

Quota

Constraint

Remarks

TaurusDB instances

50 instances at most

For details about how to increase the quota, see Increasing Quotas.

Read replicas

  • A single yearly/monthly instance: 0 to 15 read replicas
  • A single pay-per-use instance: 0 to 15 read replicas
  • A single serverless instance: 0 to 7 read replicas

For more information, see Introducing Read Replicas.

Tags

A maximum of 20 tags for each instance

For more information, see Tag Management.

Free backup space

About 100% of the purchased storage space

For more information, see How Is TaurusDB Backup Data Billed?

Automated backup retention period

  • Same-region backup: 1 to 732 days (7 days by default) You can contact customer service to extend the retention period to 3,660 days.
  • Cross-region backup: 1 to 1,825 days

For more information, see Configuring a Same-Region Backup Policy and Configuring a Cross-Region Backup Policy.

Log retention period

  • Error logs: 30 days
  • Slow query logs: 30 days
  • Slow query logs in plaintext: 30 days

For more information, see Log Management.

Naming

Table 3 Naming constraints

Item

Constraint

Remarks

Instance name

The name must start with a letter and consist of 4 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed.

For more information, see Changing a DB Instance Name.

Database name

  • The database name must consist of 1 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed. The total number of hyphens (-) cannot exceed 10.
  • To prevent errors, reserved keywords cannot be used.

For more information, see Creating a Database.

Username

  • The username must consist of 1 to 32 characters. Only letters, digits, and underscores (_) are allowed.
  • To prevent errors, reserved keywords cannot be used.

For more information, see Creating an Account.

Parameter template name

The template name must consist of 1 to 64 characters. Only letters (case-sensitive), digits, hyphens (-), underscores (_), and periods (.) are allowed.

For more information, see Creating a Parameter Template.

Backup name

The name must start with a letter and consist of 4 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed.

For more information, see Creating a Manual Backup.

Table name/function name/stored procedure name/view name

To prevent errors, reserved keywords cannot be used.

For more information, see Database Table Usage.

Security

Table 4 Security constraints

Item

Constraint

Remarks

Database root permissions

Only the root user is available on the instance creation page.

-

Account password

  • It must consist of 8 to 32 characters.
  • It must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_=+?,()&|.).
  • It cannot be the username or the username spelled backwards.
  • It must comply with the values of validate_password parameters.

    To check the password-related parameter values, click an instance name, choose Parameters in the navigation pane, and search for validate_password in the upper right corner of the page.

For more information, see Resetting the Administrator Password.

Port

  • The default value is 3306 and can be changed manually.
  • The database port ranges from 1025 to 65534, excluding 5342, 5343, 5344, 5345, 12017, 20000, 20201, 20202, 33062, 33060, and 33071, which are reserved by the system.

For more information, see Changing a Database Port.

VPC

After a TaurusDB instance is created, the VPC cannot be changed.

-

Security group

  • By default, you can create a maximum of 100 security groups in your cloud account.
  • By default, you can add a maximum of 50 rules to a security group.
  • One TaurusDB instance can be bound to multiple security groups, and one security group can be associated with multiple TaurusDB instances.
  • When creating an instance, you can select multiple security groups. (For better network performance, you are advised to select at most five security groups.)

-

System accounts

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

  • rdsAdmin: a management account with highest permissions, which is used to query and modify instance information, rectify faults, migrate data, and restore data.
  • rdsRepl: a replication account, which is used to synchronize data from primary nodes to standby nodes or read replicas.
  • rdsBackup: a backup account, which is used to back up data in the background.
  • rdsMetric: a metric monitoring account, which is used by watchdog to collect database status data.
  • rdsProxy: a database proxy account, which is used for authentication when the database is connected through a proxy address. This account is automatically created when you create a proxy instance.

-

Instance parameters

Most parameters can be modified through the console or APIs. To ensure security and stability of instances, some parameters cannot be modified.

For more information, see Modifying Parameters of a DB Instance.

Instance Operations

Table 5 Function constraints

Item

Constraint

Remarks

MySQL storage engine

TaurusDB supports only the InnoDB storage engine.

-

TaurusDB access

  • If TaurusDB instances do not have EIPs bound, the instances must be in the same VPC as the ECSs associated with these instances.
  • Security group rules must be added to allow ECSs to access TaurusDB instances.

    By default, a TaurusDB instance cannot be accessed by an ECS in a different security group. To enable access, you must add an inbound rule to the security group of a TaurusDB instance. When adding the rule, set the protocol and port, respectively, to TCP and to the default database port of the instance.

  • Port of a TaurusDB instance:

    The default port is 3306. You can change it if you want to access a TaurusDB instance through another port over a private or public network. For details, see Changing a Database Port.

-

Data migration

DRS or mysqldump can be used to migrate data to TaurusDB.

For more information, see Data Migration.

TaurusDB instance reboot

Instances can only be rebooted on the TaurusDB console.

For more information, see Rebooting a DB Instance.

TaurusDB backups

TaurusDB backups are stored in OBS buckets and are not visible to you.

-

Binlog function

Binlog cannot be enabled for TaurusDB read replicas.

For more information, see How Do I Enable and View Binlog of My TaurusDB Instance?

Partitioned tables

TaurusDB is compatible with MySQL Community Server 8.0.22. For a list-partitioned table, there are a maximum of 256 values in a partition, or an error is reported. (Workaround: Redistribute the contents of one table partition into multiple partitions.)

-

Small-scale instances

For TaurusDB instances with 2 vCPUs and 8 GB memory, there are a maximum of 300,000 tables in a single instance and a maximum of 5,000 tables in a single database.

-

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback