This report details the background, testing methodology, encountered issues, optimization steps, migration process, and final performance outcomes of moving Weimeng's MySQL databases to Tencent Cloud CDB, providing a comprehensive case study for database engineers and cloud architects.
This tutorial walks through three practical experiments for upgrading Oracle databases to 19c: inserting a non‑CDB into a CDB, using Full Transportable Export/Import to move tablespaces, and plugging a 12c PDB into a 19c CDB, each illustrated with detailed steps, scripts and screenshots.
The article details Tencent’s TXSQL (Tencent MySQL) architecture and optimizations—including asynchronous table deletion, DDL NO_WAIT/WAIT, MDL visibility, lock splitting, parallel replication, query push‑down, read‑view enhancements, low‑overhead auditing and KMS‑integrated encryption—highlighting its role as the core engine powering CDB for diverse industries such as gaming, finance, e‑commerce and internal services like WeChat and QQ.
This guide walks through creating an Oracle 12cR2 container database with CREATE DATABASE, explains OMF vs non‑OMF options, details the catcdb.sql/perl changes, resolves common Perl module errors, compares 10g/11g syntax differences, and provides practical fixes such as blocksize adjustments.
Tencent Cloud’s migration team successfully moved over 130 on‑premise MySQL instances totaling 20 TB to CDB by rigorously testing the migration tool, configuring master‑slave replication, handling high‑concurrency binlog sync, and resolving timestamp, stored‑procedure, and DDL issues, ensuring seamless production deployment.
An experienced Tencent Cloud engineer shares a detailed case study of moving over 130 MySQL instances (20 TB) from on‑premise IDC to CDB for MySQL, covering test cases, migration tool mechanics, multi‑instance concurrency, binlog handling, encountered issues, and practical solutions that ensured a smooth, high‑availability transition.
This article recounts a real‑world CDB OSS disaster, outlines eight concrete steps—including inventorying OSS clusters, scripting backups, monitoring replication, and documenting failover procedures—to ensure reliable data protection, and reflects on the mindset needed for effective operations while also announcing the upcoming DTCC 2016 conference.
