Tagged articles
9 articles
Page 1 of 1
Inke Technology
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.

PolardbScalabilitydatabase migration
0 likes · 12 min read
How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB
Full-Stack Internet Architecture
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
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 ToolsSchema Changegh-ost
0 likes · 25 min read
Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage
UCloud Tech
UCloud Tech
May 23, 2019 · Cloud Computing

How SPDK Boosts Cloud Disk I/O Performance: Hot Upgrade & Online Migration

This article explains how using the Storage Performance Development Kit (SPDK) optimizes virtualized I/O paths for cloud disks, covering its architecture, virtio vring basics, hot‑upgrade solutions, online migration techniques, and io_uring enhancements that together achieve up to 1.2 million IOPS with dramatically reduced latency.

Performance OptimizationSPDKcloud storage
0 likes · 14 min read
How SPDK Boosts Cloud Disk I/O Performance: Hot Upgrade & Online Migration
Hujiang Technology
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.

Data ConsistencyETLSQL Server
0 likes · 13 min read
Migrating from SQL Server to MySQL: Strategies, Tools, and Lessons Learned
UCloud Tech
UCloud Tech
Jan 25, 2018 · Cloud Computing

How Does KVM Online VM Migration Work? A Step‑by‑Step Guide

This article explains the principles and detailed three‑stage process—preparation, migration, and switch—of KVM‑based online virtual machine migration on UCloud’s platform, illustrating each step with diagrams and highlighting challenges, benefits, and current limitations of non‑shared storage migration.

KVMUCloudVirtualization
0 likes · 10 min read
How Does KVM Online VM Migration Work? A Step‑by‑Step Guide
21CTO
21CTO
Sep 15, 2015 · Databases

Zero‑Downtime Online Data Migration: Step‑by‑Step Guide

This article explains how to migrate live service data between systems without downtime, covering migration types, a four‑stage process, practical examples with MySQL and HBase, and key techniques for ensuring consistency and smooth cut‑over.

Data ConsistencyHBaseZero Downtime
0 likes · 11 min read
Zero‑Downtime Online Data Migration: Step‑by‑Step Guide