TencentDB for MariaDB

Financial-grade, community-driven, and open-source database based on TDSQL

Overview

TencentDB for MariaDB allows you to easily deploy and use MariaDB in the cloud. MariaDB was created by MySQL founder, Monty, after MySQL was acquired by Oracle. Its copyright was granted to MariaDB Foundation (a non-profit organization) to ensure that MariaDB will always be open source, making it the ideal choice for enterprise-grade applications. The mainstream open-source community systems and software tools use MariaDB as their default database system. MariaDB is highly compatible with MySQL, meaning MySQL instances can be migrated to TencentDB for MariaDB without modification. TencentDB for MariaDB is a complete database solution with diverse features such as backup, rollback, monitoring, fast scaling, and data transfer, simplifying IT OPS and allowing you to focus more on business development.

Benefits

Compatibility with MySQL protocols and syntax

TencentDB for MariaDB is highly compatible with MySQL protocols and syntax, including MySQL language structures, character sets, time zones, data types, functions, stored procedures, transactions, and clients. Most business systems can be migrated directly from MySQL to TencentDB for MariaDB without modification.

High availability based on strong data consistency

TencentDB for MariaDB adopts a master/slave architecture by default to offer over 99.95% availability. It supports strong sync replication for data consistency, where a response is returned only after the data written by the business system is synced to the slave. The complete data consistency between the master and slave eliminates data loss or corruption. Currently, the performance of strong sync replication essentially matches that of async replication.

Financial-grade features

TencentDB for MariaDB is used within Tencent to support various finance, billing, and blockchain services. Designed to meet international, national, and industry-specific security standards, it features a variety of security capabilities such as permission control, access security, data encryption (in beta), physical isolation, and multi-level audit. With many use cases having passed the compliance checks by the China Banking and Insurance Regulatory Commission, TencentDB for MariaDB can help users meet security and regulatory requirements.

Intra-city active-active architecture

TencentDB for MariaDB currently supports intra-city active-active architecture in Tencent Cloud's financial availability zones (AZs). Master and slave nodes of a database are deployed across AZs where servers access the database using the same unique virtual IP. If a failure occurs at the data center level, the affected node will be automatically switched over without changing the access IP or port of the database. You can use this architecture to build an intra-city active-active disaster recovery solution for your business across two data centers.

Ultra-high performance and read/write separation

TencentDB for MariaDB features customized kernels that outperform MySQL. It provides industry-leading throughput, default support for thread pool, and optimization of the storage engine to enable better performance when load gets heavier. Its performance can be further enhanced by read/write separation. Different permissions and polices can be configured as needed to achieve read/write separation with read-only accounts.

Elastic scalability without downtime

Currently, a single instance can sustain up to 6 TB of storage. If the performance or capacity does not meet your business growth needs, scaling can be performed with just a few clicks in the console. The IP does not change after scaling and the service will be interrupted for just a few seconds. Hence, you do not need to worry about data migration and instance verification. You can also specify the instance route switching time to precisely control the pace of scaling.

Comprehensive monitoring and alarms

You can view various database metrics including access, load, cache, and storage engine in TencentDB for MariaDB Console. These data metrics enables you to quickly identify databases that are running abnormally. Custom alarm policies can be configured for key metrics in Cloud Monitor.

Data migration

MySQL databases that are self-created on CVM, those in IDCs that have public IPs, and those from other cloud vendors can be automatically migrated to TencentDB for MariaDB using Data Transmission Service (DTS). This simplifies the migration process and achieves seamless database cloudification with no manual intervention required.

Deployment in public and private clouds

In public cloud, you do not need to worry about the installation, deployment, version update and troubleshooting of MariaDB because TencentDB operations team will take care of everything. To deploy a TencentDB instance or distributed database compatible with MySQL/MariaDB in your own data center, please contact your Tencent Cloud sales rep or solutions architect to purchase the private cloud version of TDSQL.

Features

TencentDB for MariaDB is a database hosting service featuring high performance, availability, security, scalability, and ease of use.
Enhanced Performance

Read/Write Separation (read-only slave)

TencentDB for MariaDB supports read/write separation by default. Each slave in the master/slave architecture can be read-only. If multiple slaves are configured, read requests will be automatically assigned to low-load slaves by TProxy to support the read traffic of large-scale applications. The three read/write separation schemes are read-only account, /slave/, and read-only instance.

Thread Pool

TencentDB for MariaDB supports thread pool by default. Tencent has optimized the scheduling algorithms of the thread pool to address extreme situations, such as when query and update requests are unevenly distributed among thread groups if the system is under heavy load. It can also better utilize computing resources to reduce unnecessary thread switching, and shorten the wait time of requests in queue to accelerate their processing.

Premium Hardware Configuration

Based on PCI-E SSD, TencentDB for MariaDB features an IOPS three times higher than SATA, and powerful IO performance that guarantees database accessibility. Its storage devices adopt the NvMe protocol and are specifically designed for PCI-E SSD, ensuring better performance. A single shard supports up to 245,509 queries per second (QPS), 384 GB memory, and 6 TB storage.

Scenarios

Finance

In conjunction with Tencent Finance Cloud, TencentDB for MariaDB has passed the information security checks of banking and insurance regulatory authorities in multiple projects. It has replaced Oracle database in core systems to store and process financial transaction and account data. TencentDB for MariaDB also provides database services such as security audit, cross-region disaster recovery, and strong data consistency, ensuring the security and reliability of financial data. For major financial businesses and complex functions, MariaDB has optimized performance compared to MySQL.

Ecommerce

TencentDB for MariaDB offers high performance and fast Redis read/write ability to help you cope with high concurrent traffic, business fluctuations, and access request surges during major campaigns and promotions.

Internet and Mobile Apps

TencentDB for MariaDB can serve as the storage medium of server data in internet and mobile apps. For scenarios with more reads than writes, read-only instances can be created for frequently read databases to improve the read performance.

Gaming

Gaming businesses require elastic scaling and fast rollback. TencentDB for MariaDB features elastic scalability for computing resources, allowing you to improve productivity and deploy a partitioned gaming database within minutes. Its rollback and batch operation features allow you to restore games to any points in time.

Pricing

TencentDB for MariaDB is pay-as-you-go. When you create a TencentDB for MariaDB instance, one hour's hardware fee will be frozen in your Tencent Cloud account. The usage will be charged hourly with a billing time down to the second. With pay-as-you-go, you only pay for what you use in TencentDB for MariaDB. No advance payment is required.