MySQL applications often hit scaling ceilings—hot shards, schema-change windows, and operational sprawl from too many replicas. In this hands-on lab, you’ll learn how to modernize MySQL workloads on TiDB to unlock horizontal scale, online schema evolution, and operational simplicity without major code rewrites.
This session shows how TiDB’s MySQL-compatible, distributed SQL architecture separates compute and storage, scales linearly, and keeps applications online during migrations and upgrades. You’ll also see how to migrate from MySQL to TiDB using TiDB Data Migration tooling, including setting up a migration task and validating the migration results.
What you’ll learn:
– How to lift-and-shift MySQL schemas and data with minimal code changes using TiDB’s MySQL compatibility and migration tooling.
– Executing online DDL on hot tables without downtime and reducing lock contention under peak load.
– Horizontally scaling reads and writes by distributing data automatically, with elastic capacity and no application-side sharding.
– Strategies for zero- or near-zero-downtime cutover, verification, and safe rollback.
– Consolidating OLTP + operational analytics via TiDB’s columnar engine and secondary indexes to simplify your stack.
