Financial-grade, community-driven, and open-source database based on TDSQL
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
TencentDB for MariaDB uses a fully homogeneous master/slave system to ensure high availability. Master/slave failover can be performed within seconds and the virtual IP (VIP) remains unchanged. The strong sync replication scheme ensures data consistency during master/slave failover, meeting financial-grade requirements.
Three Data Replication Methods
TencentDB for MariaDB supports strong sync (non-downgradable), strong sync (downgradable), and async replication. The Multi-Thread Asynchronous Replication (MAR) technology designed by Tencent significantly improves the performance of strong sync replication. The performance of strong sync replication essentially matches that of async replication, ensuring master/slave data consistency.
All shards and underlying physical devices are monitored 24/7. In the event of a failure, TProxy will promptly switch route resolution from the failing node to a normal one. During master/slave faliover, VIP remains unchanged, meaning hot backup can be completed on the application layer without any modifications and has no effect on your business.
Automatic Node Failure Recovery
When a physical node carrying shards fails, the scheduling system will automatically retry to recover the node. If the node cannot be recovered, it will be automatically replaced within 30 minutes. A new node will be rebuilt from backups and automatically added to the cluster, ensuring the master/slave architecture of shards for the long term.
The master and slave can be deployed in different AZs in the same city where real-time data replication can be performed via Tencent Cloud Direct Connect. The local end is the master and the remote end is the slave. When data is accessed externally, the local instance will be accessed first, and the remote instance will be accessed if the local instance fails or is unreachable. This feature provides TencentDB for MariaDB with cross-AZ disaster recovery capability and master/slave failover imperceptible to end users, avoiding the operational risk of single-DC deployment.
TencentDB for MariaDB provides 1-region-2-DC and 2-region-3-DC deployment architectures. When a failure occurs, the database can be restored to normal operation within minutes.
TencentDB for MariaDB supports strong sync and semi-sync data replication methods. It has performed multiple data replication optimizations on MariaDB kernels with the aid of Multi-thread Asynchronous Replication (MAR) technology developed by Tencent, significantly improving the performance of strong sync replication. The phantom reads caused by master/slave failover and data read/write during master downtime are optimized to improve the data consistency of MariaDB.
Compliance with National, International, and Industry-specific Standards
TencentDB for MariaDB has received many national and international certifications, including but not limited to ISO22301, ISO27001, ISO20000, ISO9001, Trusted Cloud, Cybersecurity Classified Protection Certification (Level 3 or above), and CSA STAR.
Some features of TencentDB for MariaDB are developed and designed based on GBT 20273-2006: Information Security Technology - Security Techniques Requirement for Database Management System, and JRT 0072-2012: Testing and Evaluation Guide for Classified Protection of Information System of Financial Industry. Thus, you can use TencentDB for MariaDB even if your business has extremely high requirements for database security.
TencentDB for MariaDB allows you to run database instances in Virtual Private Cloud (VPC). You can isolate your instances and connect them to your existing IDC via IPsec VPN or Direct Connect.
Database Firewall and Security Protection
TencentDB for MariaDB provides multi-layer security protection for each database by default. It helps users defend attacking traffic and ensures business continuity when database instances with external network access are under DDoS attack. It can also efficiently block database attacks such as SQL injections and brute force attacks, significantly reducing users’ business interruption and loss.
Granular Permission Control
Accessing the database as the root account is disabled by default to avoid security risks. Permission controls are provided at the object level, such as tables, functions, and stored procedures. Designated accounts can only access authorized resources, keeping risks under control.
Physical Exclusivity Support
You can deploy database instances using resources of a dedicated physical cluster (device) in Tencent Cloud's public cloud. You can use the physical devices exclusively instead of sharing them with other tenants. Dedicated clusters meet your needs for resource exclusivity, physical security, and regulatory compliance. After purchasing dedicated clusters, you can flexibly create database instances with custom specifications in the Tencent Cloud Console.
High Storage Reliability
TencentDB for MariaDB provides master/slave data storage to ensure online data security. Data is automatically backed up daily and can be rolled back to any points in time in the past several days based on backup files. The daily cold data will be backed up in multiple copies to facilitate data recovery in the event of a disaster. You can securely store your data in TencentDB for MariaDB without worrying about data loss.
Comprehensive Daily Monitoring
TencentDB for MariaDB can monitor database performance at a 60-second granularity with over 70 key metrics, including connection access, database load, cache querying, and storage engine. It has 15 core database performance metrics that support comprehensive and real-time monitoring with accuracy down to the second. You can keep track of instance health and quickly locate instance performance issues. You can also customize threshold alarms for resources to stay informed on database operational issues. When the alarm is triggered, OPS personnel will be notified promptly. The slow log analysis report and complete SQL running report can be downloaded to help you understand factors that affect database performance.
You can customize threshold alarms for resources to stay informed on database operational issues. When the alarm is triggered, OPS personnel will be notified promptly.
Performance Analysis Logs
Slow log analysis report and complete SQL running report can be downloaded to help you understand factors that affect database performance.
You can implement read/write separation with a read-only account, meeting high volumes of business requests without purchasing additional read-only instances. If the read performance cannot meet your needs, you can purchase or build read-only instances through the server.
Performance and Capacity Expansion
TencentDB for MariaDB instances can be seamlessly scaled up except for those with the highest specification. If the performance fails to meet your needs, you can scale up the performance and capacity specification of the instance with one click. Your business will not be affected during the process. You can also achieve fast and seamless scaling by scheduling it during off-peak hours to meet your business growth needs.
Easy Management of Massive Database
TencentDB for MariaDB can be managed using command line or on the web. It supports batch database management, permission configuration, and SQL import, simplifying the OPS of a vast number of database instances into simple webpage clicks and significantly reducing OPS workload.
Multiple Network Access Methods
TencentDB for MariaDB supports access from VPC and basic network. External access can also be configured. You can access the database via Tencent Cloud, IDCs, private clouds, or clouds provided by other vendors to meet your database access needs under different environments.
TencentDB for MariaDB offers parameter configuration templates, which can be used to save commonly used database configurations and apply them to newly created instances. This simplifies parameter fine-tuning and eliminates the tedious work of initializing the database.
TencentDB for MariaDB features a complete API system. You can call APIs to integrate TencentDB for MariaDB into your internal monitoring and OPS systems, creating a business OPS system that automatically responds to business needs. For more information, please see the API documentation.
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 with the aid of Data Transmission Service (DTS). This simplifies the migration process and achieves seamless database cloudification with no manual intervention required.
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.
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.
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 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.
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.