Online Migration

Inke Technology

Apr 23, 2024 · Databases

How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB

This article details the migration of a popular social app's private‑message service from a saturated MySQL cluster to PolarDB, covering business challenges, evaluation of storage‑optimization, vertical and horizontal scaling, the chosen distributed database solution, step‑by‑step offline and online migration procedures, and the resulting performance and cost benefits.

Distributed DatabaseMySQLOnline Migration

0 likes · 12 min read

How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB

Full-Stack Internet Architecture

May 12, 2021 · Databases

Database Scaling Strategies: From Single Instance to Smooth Horizontal Expansion

The article explains how to evolve a simple single‑instance database into a highly available, horizontally sharded system, detailing offline scaling, online dual‑write migration, and a smooth four‑node expansion process with configuration changes, data migration, and cleanup steps.

Configuration ManagementDatabase ScalingHigh Availability

0 likes · 6 min read

Database Scaling Strategies: From Single Instance to Smooth Horizontal Expansion

Aikesheng Open Source Community

Jul 30, 2020 · Databases

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

This article provides a comprehensive guide to gh-ost, the GitHub‑released online MySQL schema migration tool, covering its design principles, three migration modes, download and RPM installation, common command‑line options, interactive socket commands, and a step‑by‑step example of altering a column type while monitoring progress and performing a safe cut‑over.

Database ToolsLinuxMySQL

0 likes · 25 min read

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

Hujiang Technology

Mar 13, 2018 · Databases

Migrating from SQL Server to MySQL: Strategies, Tools, and Lessons Learned

This article details the background, design considerations, migration workflows, tooling choices, data consistency verification, rollback mechanisms, and practical experiences of moving a large‑scale production environment from Microsoft SQL Server to MySQL, covering both offline and online migration scenarios.

ETLMySQLOnline Migration

0 likes · 13 min read

Migrating from SQL Server to MySQL: Strategies, Tools, and Lessons Learned