BestHub
Sign in
Tagged articles

Database Migration

284 articles · Page 2 of 3
dbaplus Community
dbaplus Community
Oct 12, 2023 · Databases

How to Achieve Zero‑Downtime MySQL Version Upgrades: Strategies, Risks, and Best Practices

This article presents a comprehensive guide to planning and executing MySQL version upgrades—including industry version statistics, performance benchmarks, migration challenges, stability guarantees, detailed upgrade strategies, compatibility testing, and post‑upgrade validation—to ensure zero‑downtime and minimal operational impact.

Database MigrationMySQLcompatibility testing
0 likes · 18 min read
How to Achieve Zero‑Downtime MySQL Version Upgrades: Strategies, Risks, and Best Practices
Soul Technical Team
Soul Technical Team
Oct 9, 2023 · Databases

Understanding SQLite Log Modes and Fixing Duplicate Message ID Issues in Chat Applications

This article explains SQLite's Rollback and WAL logging modes, compares their performance and concurrency characteristics, investigates a real‑world problem where duplicate IM message IDs appear after app upgrades, and presents a step‑by‑step solution using UNIQUE constraints and index checks to prevent repeated inserts.

Database MigrationIndexRollback
0 likes · 26 min read
Understanding SQLite Log Modes and Fixing Duplicate Message ID Issues in Chat Applications
ITPUB
ITPUB
Sep 29, 2023 · Big Data

How Vivo Scaled Hive Metastore Using TiDB: A Deep Dive into Big Data Metadata

This article recounts Vivo’s journey to horizontally scale its Hive Metastore service by evaluating MySQL sharding, the open‑source Waggle‑Dance gateway, and ultimately selecting TiDB, detailing the migration process, configuration tweaks, performance benchmarks, encountered issues such as primary‑key conflicts, index choices, memory spikes, and the solutions implemented to ensure stable, high‑performance metadata storage for massive data volumes.

Big DataDatabase MigrationHive Metastore
0 likes · 22 min read
How Vivo Scaled Hive Metastore Using TiDB: A Deep Dive into Big Data Metadata
ITPUB
ITPUB
Sep 12, 2023 · Databases

What Risks Does MySQL 5.7 End‑of‑Life Pose and How to Migrate to Domestic Open‑Source Forks?

MySQL 5.7 reaches its official End‑of‑Life in October 2023, exposing users to security, compliance, performance, and support risks, and the article outlines four migration paths—continuing with 5.7, upgrading to MySQL 8.0, switching to domestic open‑source forks like GreatSQL, or adopting commercial Chinese databases—while providing a detailed case study of GreatSQL’s suitability for Chinese enterprises.

ChinaDatabase MigrationEnd of Life
0 likes · 13 min read
What Risks Does MySQL 5.7 End‑of‑Life Pose and How to Migrate to Domestic Open‑Source Forks?
Su San Talks Tech
Su San Talks Tech
Jul 22, 2023 · Backend Development

How Bilibili Scaled Its Relationship Chain Service from MySQL to KV and Redis

This article details how Bilibili’s relationship‑chain service evolved from a MySQL‑based design to a KV‑store with asynchronous writes, introduced multi‑layer caching with memcached, Redis hash and KV, added bloom‑filter optimization, and implemented hotspot mitigation to support millions of QPS.

Database Migrationbackendcaching
0 likes · 16 min read
How Bilibili Scaled Its Relationship Chain Service from MySQL to KV and Redis
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 3, 2023 · Databases

Replacing OCP Nodes Using the ANTMAN Tool in OceanBase Cloud Platform

This article provides a step‑by‑step guide on how to replace OceanBase Cloud Platform (OCP) nodes using the ANTMAN tool, covering environment preparation, configuration adjustments, execution of management scripts, tenant migration, cleanup of old services, and troubleshooting tips for a seamless database cluster upgrade.

ANTMANCluster ManagementDatabase Migration
0 likes · 25 min read
Replacing OCP Nodes Using the ANTMAN Tool in OceanBase Cloud Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 7, 2023 · Databases

OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices

This article presents a comprehensive performance comparison of OceanBase with MySQL and TiDB, details step‑by‑step deployment of OceanBase (both single‑node and cluster), explains configuration and resource‑pool management, and shares practical migration techniques and troubleshooting tips for production workloads.

Database MigrationMySQLOceanBase
0 likes · 23 min read
OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices
Qunar Tech Salon
Qunar Tech Salon
May 30, 2023 · Databases

Smooth Migration to Sharding: Design, Implementation, and Componentization of Qunar's Database Sharding Solution

This article describes the challenges of migrating a long‑running monolithic database to a sharded architecture, presents a two‑stage smooth migration strategy using double‑write, diff verification, and mapping‑key techniques, and details the componentized design, core implementation, and configuration of a reusable sharding framework built on MyBatis and Spring.

Data synchronizationDatabase MigrationMyBatis
0 likes · 34 min read
Smooth Migration to Sharding: Design, Implementation, and Componentization of Qunar's Database Sharding Solution
MaGe Linux Operations
MaGe Linux Operations
May 16, 2023 · Databases

How We Split a 50‑Million‑Row MySQL Table: Strategies and Lessons Learned

This article recounts how a finance team tackled a 50‑million‑row MySQL table by analyzing system bottlenecks, defining splitting goals, selecting sharding‑jdbc, addressing multi‑datasource transactions and pagination, designing data migration strategies, and executing a staged rollout to ensure stability and performance.

Database MigrationLarge TablesMySQL
0 likes · 12 min read
How We Split a 50‑Million‑Row MySQL Table: Strategies and Lessons Learned
Code Ape Tech Column
Code Ape Tech Column
Apr 3, 2023 · Backend Development

Why and How to Split Applications and Databases: Practical Practices

This article explains the reasons for splitting monolithic applications, outlines preparation steps, and provides detailed practical guidance on database vertical and horizontal splitting, global ID generation, migration, cut‑over strategies, consistency, and post‑split stability measures.

Backend ArchitectureDatabase Migrationapplication splitting
0 likes · 20 min read
Why and How to Split Applications and Databases: Practical Practices
Java High-Performance Architecture
Java High-Performance Architecture
Mar 31, 2023 · Databases

Mastering Liquibase with Spring Boot: A Step‑by‑Step Database Change Management Guide

This tutorial walks through setting up Liquibase in a Spring Boot project, creating a Maven plugin to generate XML/YAML changelogs, configuring the application, and performing common database operations such as creating tables, adding columns, creating indexes, initializing data, while also addressing a common includeAll path issue.

Database MigrationLiquibaseMaven Plugin
0 likes · 19 min read
Mastering Liquibase with Spring Boot: A Step‑by‑Step Database Change Management Guide
dbaplus Community
dbaplus Community
Mar 5, 2023 · Backend Development

How to Achieve Fast and Stable MySQL Data Center Migration at Scale

This article details the background, migration options, and step‑by‑step automated procedures used by a large‑scale e‑commerce platform to safely move over 400 MySQL clusters, comparing expansion‑plus‑master‑slave switching with cascading replication and explaining the chosen fast, reliable solution.

AutomationCascading ReplicationDatabase Migration
0 likes · 9 min read
How to Achieve Fast and Stable MySQL Data Center Migration at Scale
ITPUB
ITPUB
Feb 27, 2023 · Databases

Mastering SQL Joins: Boost Performance When Migrating from Oracle to Open‑Source Databases

This article explains why SQL join execution plans often cause severe performance drops after moving from Oracle to domestic or open‑source databases, demonstrates each join type with PostgreSQL examples, shows how plan choices like HASH JOIN versus NESTED LOOP affect speed, and offers rewrite techniques such as NOT EXISTS or UNION to restore efficiency.

Database MigrationJOINOptimization
0 likes · 8 min read
Mastering SQL Joins: Boost Performance When Migrating from Oracle to Open‑Source Databases
ITPUB
ITPUB
Feb 24, 2023 · Databases

How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned

Ctrip evaluated and extended OceanBase Migration Assessment tools, built a one‑click migration workflow, implemented comprehensive monitoring and automatic fault‑diagnosis pipelines, and addressed compatibility challenges such as .NET charset issues and Druid parser errors, ultimately achieving a smooth MySQL‑to‑OceanBase transition.

Database MigrationMonitoringMySQL
0 likes · 18 min read
How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned
Zhuanzhuan Tech
Zhuanzhuan Tech
Feb 21, 2023 · Databases

Fast and Stable MySQL Data Center Migration: Choosing and Implementing the Optimal Strategy

This article details the background, migration plan selection, and step‑by‑step procedures—including pre‑building cascades, service pause, automated batch operations, cluster tiering, pre‑ and post‑checks, and gray‑scale validation—to achieve a fast, stable MySQL data‑center migration for a large‑scale production environment.

AutomationDatabase MigrationMySQL
0 likes · 11 min read
Fast and Stable MySQL Data Center Migration: Choosing and Implementing the Optimal Strategy
dbaplus Community
dbaplus Community
Feb 20, 2023 · Databases

Why Teradata Is Leaving China and Which Domestic Data Warehouses Can Fill the Gap

Teradata announced its withdrawal from China due to geopolitical uncertainty and rising competition from mature domestic data‑warehouse solutions, prompting a detailed analysis of its architecture, the main Chinese warehouse designs, global market positioning, and migration tools for replacing Teradata.

Big DataData WarehouseDatabase Migration
0 likes · 10 min read
Why Teradata Is Leaving China and Which Domestic Data Warehouses Can Fill the Gap
ITPUB
ITPUB
Feb 20, 2023 · Databases

Why Teradata Is Leaving China and What It Means for the Domestic Data Warehouse Market

Teradata's withdrawal from China, driven by geopolitical tensions and the rise of mature domestic data‑warehouse solutions, prompts a detailed look at its MPP architecture, the three main Chinese warehouse designs, Gartner market positioning, and migration tools for alternatives like GBase 8a and GaussDB DWS.

Big DataData WarehouseDatabase Migration
0 likes · 9 min read
Why Teradata Is Leaving China and What It Means for the Domestic Data Warehouse Market
NetEase Yanxuan Technology Product Team
NetEase Yanxuan Technology Product Team
Feb 6, 2023 · Databases

Database Independence Migration for Yanxuan Trading System: Architecture Evolution and Implementation

Yanxuan migrated its monolithic trading system from a shared DDB cluster to an independent database by using Netease Data Canal for real‑time sync, a write‑stop switch with Pandora middleware, account and permission isolation, and extensive testing across three phases to ensure data consistency and minimal business impact.

Data ConsistencyDatabase MigrationEnterprise Database
0 likes · 15 min read
Database Independence Migration for Yanxuan Trading System: Architecture Evolution and Implementation
dbaplus Community
dbaplus Community
Nov 18, 2022 · Databases

Why openGauss Misses Index‑Only Scan and How USTORE Fixes It

The article examines why openGauss 2.0/3.0 cannot use Index‑Only Scan for covering indexes, explores the role of the visibility map and VACUUM, compares behavior with PostgreSQL 11, and shows how the USTORE storage engine can finally enable true covering indexes.

Covering IndexDatabase MigrationIndex Only Scan
0 likes · 11 min read
Why openGauss Misses Index‑Only Scan and How USTORE Fixes It
ITPUB
ITPUB
Oct 21, 2022 · Databases

How We Replaced Elasticsearch with ClickHouse for High‑Performance Log Storage

Facing rapid growth, our team evaluated ClickHouse’s hot‑cold storage and tiered‑disk policies to replace Elasticsearch, designing partitioning, TTL, and multi‑level storage strategies—including hot, cold, and archive disks, custom storage policies, and OSS integration—to achieve higher write throughput, better compression, and over 50% cost reduction.

ClickHouseCold Hot SeparationDatabase Migration
0 likes · 22 min read
How We Replaced Elasticsearch with ClickHouse for High‑Performance Log Storage
dbaplus Community
dbaplus Community
Aug 7, 2022 · Databases

Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases

In this interview, senior database expert Kong Zaihua explains the main performance, functional, and usability shortcomings of domestic Chinese databases compared with Oracle, and outlines practical strategies, tools, and migration techniques to evaluate compatibility, handle DDL conversion, manage online/offline data transfer, and reduce reliance on stored procedures.

AIOpsDatabase MigrationDomestic databases
0 likes · 10 min read
Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases
Wukong Talks Architecture
Wukong Talks Architecture
Jul 11, 2022 · Databases

Migrating from MySQL Dual-Master to Master‑Slave: Lessons Learned and Simple Conversion Steps

After a month of operating a MySQL dual‑master high‑availability cluster, the author details the numerous pitfalls encountered and explains a step‑by‑step manual process for converting the setup to a simpler master‑slave architecture, including configuration changes and Keepalived adjustments.

Database MigrationDual MasterHigh Availability
0 likes · 9 min read
Migrating from MySQL Dual-Master to Master‑Slave: Lessons Learned and Simple Conversion Steps
Efficient Ops
Efficient Ops
Jul 6, 2022 · Databases

How DataBus Enables Real-Time, Scalable Database Synchronization for Oracle Migration

DataBus is a real‑time data synchronization framework designed to support Oracle de‑commissioning, micro‑service migration, and heterogeneous storage engines by providing high‑availability CDC, flexible data pipelines, and seamless full‑to‑incremental migration across multiple source and target databases.

CDCData synchronizationDatabase Migration
0 likes · 19 min read
How DataBus Enables Real-Time, Scalable Database Synchronization for Oracle Migration
dbaplus Community
dbaplus Community
Jun 8, 2022 · Databases

Choosing the Right Database Migration Strategy: Real-World Lessons and Pitfalls

This article shares practical experiences and lessons learned from over a hundred database migration projects, comparing storage replication, logical replication, and ASM disk‑group rebalancing, and explains how system context, vendor capabilities, and careful planning determine the most suitable approach.

ASMDatabase MigrationLogical Replication
0 likes · 10 min read
Choosing the Right Database Migration Strategy: Real-World Lessons and Pitfalls
21CTO
21CTO
Jun 6, 2022 · Databases

Estimating Oracle Data Pump Export Size Without Impacting Production

This article explains how to use Oracle Data Pump's ESTIMATE and ESTIMATE_ONLY parameters to assess the size of a 1 TB production database for migration, compares BLOCKS and STATISTICS estimation methods, and details best practices for gathering accurate optimizer statistics with ANALYZE and DBMS_STATS.

DBMS_STATSData PumpDatabase Migration
0 likes · 10 min read
Estimating Oracle Data Pump Export Size Without Impacting Production
Hacker Afternoon Tea
Hacker Afternoon Tea
May 12, 2022 · Backend Development

How to Enable Distributed Multi‑Tenant PostgreSQL (Citus) in a Python/Django App

This guide walks through migrating a single‑node Django multi‑tenant application to a distributed PostgreSQL backend using Citus, covering schema changes, primary‑key and unique‑constraint adjustments, integration of the django‑multitenant library, data distribution, range‑query updates, and middleware automation.

CitusDatabase MigrationDjango
0 likes · 14 min read
How to Enable Distributed Multi‑Tenant PostgreSQL (Citus) in a Python/Django App
Efficient Ops
Efficient Ops
Mar 8, 2022 · Databases

From MongoDB to ClickHouse: Lessons Learned and Performance Gains

This article recounts the author's journey from using MongoDB for front‑end monitoring logs to migrating to ClickHouse, detailing the challenges with large‑scale data, optimization attempts, the fundamental differences between row‑ and column‑oriented databases, and the resulting performance and storage improvements.

Database MigrationMongoDBNode.js
0 likes · 19 min read
From MongoDB to ClickHouse: Lessons Learned and Performance Gains
Baidu Geek Talk
Baidu Geek Talk
Mar 2, 2022 · Backend Development

Evolution of Baidu Aifanfan Lead List: From Rapid Delivery to High-Performance Architecture

The Baidu Aifanfan lead list page evolved through six versions—from rapid MySQL‑based delivery to a metadata‑driven, ES‑backed architecture with Redis synchronization—culminating in a high‑availability, high‑performance system that slashed server latency from 25 seconds to under one second and cut frontend load times and static asset sizes dramatically.

APM monitoringDatabase MigrationFrontend Optimization
0 likes · 21 min read
Evolution of Baidu Aifanfan Lead List: From Rapid Delivery to High-Performance Architecture
Laravel Tech Community
Laravel Tech Community
Feb 16, 2022 · Databases

Using Phinx for Database Migrations in ThinkPHP

This tutorial explains how to install, configure, and operate Phinx within a ThinkPHP project to manage database schema migrations, create and run seed data, update tables, roll back changes, and keep development environments synchronized.

CLIDatabase MigrationPHP
0 likes · 6 min read
Using Phinx for Database Migrations in ThinkPHP
Top Architect
Top Architect
Jan 1, 2022 · Backend Development

Practical Guide to Application Splitting and Database Migration

This article provides a comprehensive, step‑by‑step guide on why and how to split monolithic applications, prepare for migration, execute database vertical and horizontal sharding, handle schema changes, ensure consistency, and maintain stability during and after the split, enriched with real‑world pitfalls and solutions.

Backend ArchitectureDatabase Migrationapplication splitting
0 likes · 17 min read
Practical Guide to Application Splitting and Database Migration
Programmer DD
Programmer DD
Dec 16, 2021 · Databases

Why a Former MySQL Engineer Recommends PostgreSQL Over MySQL

A former Oracle MySQL lead engineer explains why, after five years of work, he finds PostgreSQL a superior open‑source RDBMS, criticizing MySQL’s design flaws, comparing MariaDB, and highlighting real‑world migration experiences and industry perspectives.

Database ComparisonDatabase MigrationMariaDB
0 likes · 9 min read
Why a Former MySQL Engineer Recommends PostgreSQL Over MySQL
Architecture Digest
Architecture Digest
Dec 1, 2021 · Operations

Why and How to Split Applications and Databases: Practical Guidance and Best Practices

This article explains the reasons for splitting monolithic applications, outlines multi‑dimensional preparation, defines service boundaries, details DB vertical and horizontal splitting, global ID generation, migration steps, cut‑over strategies, consistency guarantees, and stability measures to ensure a successful transformation.

Database MigrationOperational Best Practicesapplication splitting
0 likes · 17 min read
Why and How to Split Applications and Databases: Practical Guidance and Best Practices
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 28, 2021 · Databases

MySQL Upgrade Guide: Principles, 8.0 Changes, Pre‑Upgrade Checks, and Step‑by‑Step In‑Place & Logical Migration

This article outlines the principles, recommended practices, and detailed steps for upgrading MySQL from 5.7 to 8.0, covering version compatibility, major 8.0 feature changes, pre‑upgrade checks, in‑place and logical migration procedures, and essential configuration adjustments with example commands.

ConfigurationDatabase MigrationInnoDB
0 likes · 23 min read
MySQL Upgrade Guide: Principles, 8.0 Changes, Pre‑Upgrade Checks, and Step‑by‑Step In‑Place & Logical Migration
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 26, 2021 · Databases

Understanding MySQL explicit_defaults_for_timestamp and Its Impact on TIMESTAMP Columns

This article explains how the MySQL system variable explicit_defaults_for_timestamp controls the default and NULL handling of TIMESTAMP columns, demonstrates the differences between OFF and ON settings with practical tests, and discusses why the parameter is being deprecated for stricter time‑data management.

Database MigrationMySQLNULL
0 likes · 10 min read
Understanding MySQL explicit_defaults_for_timestamp and Its Impact on TIMESTAMP Columns
Java Backend Technology
Java Backend Technology
Sep 19, 2021 · Databases

How Facebook Overcame the Challenges of Migrating MySQL 5.6 to 8.0

Facebook’s engineering team detailed the multi‑year effort to upgrade a heavily customized MySQL 5.6 deployment to MySQL 8.0, describing the migration strategy, code‑patch classification, row‑based replication adoption, extensive automation testing, and the performance and compatibility issues they resolved along the way.

8.0Database MigrationFacebook
0 likes · 16 min read
How Facebook Overcame the Challenges of Migrating MySQL 5.6 to 8.0
dbaplus Community
dbaplus Community
Aug 8, 2021 · Databases

How Facebook Migrated MySQL 5.6 to 8.0: Challenges, Patch Management, and Automation

Facebook detailed its multi‑year journey from MySQL 5.6 to 8.0, explaining why it stayed on 5.6 for MyRocks development, the massive patch‑porting effort, replica‑set migration steps, adoption of row‑based replication, extensive automation testing, and the performance and compatibility issues uncovered along the way.

AutomationDatabase MigrationFacebook
0 likes · 17 min read
How Facebook Migrated MySQL 5.6 to 8.0: Challenges, Patch Management, and Automation
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2021 · Databases

Migrating from MariaDB 10.3 to MySQL 5.7.25: Common Issues and Solutions

This article details the practical challenges encountered when migrating a MariaDB 10.3 database to MySQL 5.7.25, explains why certain defaults and engine-specific options cause import errors, and provides step‑by‑step fixes such as adjusting default expressions, removing Aria‑specific parameters, and configuring sql_mode.

Database MigrationMariaDBMySQL
0 likes · 5 min read
Migrating from MariaDB 10.3 to MySQL 5.7.25: Common Issues and Solutions
Fulu Network R&D Team
Fulu Network R&D Team
Jul 27, 2021 · Databases

Understanding Flyway: Database Migration Tool Overview and Spring Integration

Flyway is an open‑source database migration tool that version‑controls SQL scripts, supports many databases, and integrates with Maven and Spring to automate schema changes across environments, offering commands such as migrate, clean, info, validate, baseline, undo and repair, with detailed configuration examples.

Database MigrationMavenSQL
0 likes · 9 min read
Understanding Flyway: Database Migration Tool Overview and Spring Integration
Programmer DD
Programmer DD
Jul 27, 2021 · Databases

How Facebook Overcame the Challenges of Migrating to MySQL 8.0

Facebook’s engineering team detailed a multi‑year, complex migration from MySQL 5.6 to 8.0, highlighting custom‑feature porting, replication compatibility, query changes, performance regressions, and documentation gaps, and explaining how they finally achieved a successful upgrade.

Custom FeaturesDatabase MigrationFacebook
0 likes · 5 min read
How Facebook Overcame the Challenges of Migrating to MySQL 8.0
MaGe Linux Operations
MaGe Linux Operations
Jul 15, 2021 · Backend Development

How to Build a Custom User Model in Django Step‑by‑Step

This guide walks you through installing Django, creating an app, defining a custom user model with a manager, configuring AUTH_USER_MODEL, and migrating the database, enabling email‑based authentication and flexible user fields.

Database MigrationDjangoauthentication
0 likes · 7 min read
How to Build a Custom User Model in Django Step‑by‑Step
JD Cloud Developers
JD Cloud Developers
Jun 15, 2021 · Databases

Mastering Bidirectional Redis Sync: Strategies, Challenges, and Redissyncer in Action

This article explores the RedisSyncer toolkit for achieving reliable bidirectional Redis synchronization, explains the necessity of cache sync, details the data offset solution and double‑read approach, and provides step‑by‑step deployment instructions with code examples and practical considerations.

Bidirectional SyncData synchronizationDatabase Migration
0 likes · 14 min read
Mastering Bidirectional Redis Sync: Strategies, Challenges, and Redissyncer in Action
360 Quality & Efficiency
360 Quality & Efficiency
Jun 4, 2021 · Fundamentals

Understanding the Snowflake Algorithm for Distributed Unique ID Generation

This article explains the background of migrating from MySQL to TiDB, introduces the Snowflake algorithm’s 64‑bit ID structure, discusses its advantages and disadvantages, provides a Python implementation, and highlights its impact on achieving globally unique, time‑ordered identifiers in distributed systems.

Database MigrationPythonTiDB
0 likes · 5 min read
Understanding the Snowflake Algorithm for Distributed Unique ID Generation
Big Data Technology & Architecture
Big Data Technology & Architecture
May 27, 2021 · Databases

Database Selection and TiDB Implementation in NetEase Interactive Entertainment Billing Group

This article details the billing group's challenges with single‑node MySQL, the evaluation of alternative databases such as TiDB and CockroachDB, performance testing, migration strategies, operational best practices, and the final decision to adopt TiDB for scalable, high‑availability data services.

Cloud NativeDatabase MigrationDistributed SQL
0 likes · 15 min read
Database Selection and TiDB Implementation in NetEase Interactive Entertainment Billing Group
dbaplus Community
dbaplus Community
May 25, 2021 · Databases

How Migrating 40 B Records from MySQL to MongoDB Cut Costs and Boost Performance

A large‑scale IoT service migrated 40 billion rows from MySQL to MongoDB, solving capacity, cost, and data‑skew issues while achieving higher performance, lower storage consumption, and a flexible, highly available architecture, with detailed resource evaluation, migration steps, optimization tactics, and cost‑benefit analysis.

Cost SavingsDatabase MigrationMongoDB
0 likes · 21 min read
How Migrating 40 B Records from MySQL to MongoDB Cut Costs and Boost Performance
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 19, 2021 · Operations

Mastering Gray Release: Design, Strategies, and Real-World Implementation

This article explains the concept of gray (canary) release, outlines a simple system architecture with essential components, details common traffic‑splitting strategies, and demonstrates both basic and complex implementation scenarios using Nginx, gateway services, and database migration techniques.

Canary DeploymentDatabase Migrationgray release
0 likes · 6 min read
Mastering Gray Release: Design, Strategies, and Real-World Implementation
Cloud Native Technology Community
Cloud Native Technology Community
Apr 14, 2021 · Cloud Native

2020‑2021 Survey on Cloud‑Native Technology Adoption in Traditional Industries

The 2020‑2021 Cloud‑Native Technology Landing Survey, conducted by CNBPA, Lingqu Cloud and the Cloud‑Native Community, collected 783 responses from finance, manufacturing, energy, pharma, telecom and government sectors, revealing that cloud‑native adoption—including containers, DevOps, micro‑services, Kubernetes, Service Mesh and cloud‑native databases—has roughly doubled in production environments and is now the primary driver of digital transformation in traditional enterprises.

Database MigrationDevOpsIndustry Survey
0 likes · 12 min read
2020‑2021 Survey on Cloud‑Native Technology Adoption in Traditional Industries
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 12, 2021 · Databases

Practical Guide to MySQL Database Migration, Backup, and Multi‑Source Replication

This article summarizes a real‑world MySQL database migration project, detailing pre‑migration preparation, backup and import commands, replication setup—including multi‑source replication for merging databases—and post‑migration verification steps, while sharing practical tips and pitfalls.

BackupDatabase MigrationMulti-Source Replication
0 likes · 8 min read
Practical Guide to MySQL Database Migration, Backup, and Multi‑Source Replication
Amap Tech
Amap Tech
Mar 5, 2021 · Databases

Scaling and Migrating a High‑Volume Order System with Sharding, Data Synchronization and Gray‑Rollout on Alibaba Cloud

To support Gaode Taxi’s soaring order volume, the team expanded from four to eight ECS instances, re‑sharded 256 tables into 4,096, built a custom binlog‑to‑Kafka sync middleware for full‑load and incremental migration, implemented rigorous validation and repair processes, and employed a gray‑rollout with ABC verification, completing the migration without code changes or incidents.

Alibaba CloudData synchronizationDatabase Migration
0 likes · 16 min read
Scaling and Migrating a High‑Volume Order System with Sharding, Data Synchronization and Gray‑Rollout on Alibaba Cloud
Programmer DD
Programmer DD
Jan 12, 2021 · Databases

Master Database Version Control in Spring Boot with Flyway

This tutorial walks you through using Flyway in a Spring Boot application to manage MySQL schema versions, from initial table creation and CRUD implementation to incremental migrations like adding new columns, complete with Maven dependencies, SQL scripts, Java code, and automated tests.

Database MigrationMySQLSpring Boot
0 likes · 13 min read
Master Database Version Control in Spring Boot with Flyway
Ctrip Technology
Ctrip Technology
Jan 7, 2021 · Databases

Practical Experience of Data Storage in Ctrip Flight Big Data Platform: From Redis/MySQL to CrateDB

This article shares the Ctrip flight big‑data platform’s journey of evaluating and migrating data storage from Hive, MySQL and Redis to CrateDB, covering performance requirements, query patterns, maintenance challenges, containerization, and production results that reduced interface latency and resource consumption.

CrateDBCtripData Storage
0 likes · 10 min read
Practical Experience of Data Storage in Ctrip Flight Big Data Platform: From Redis/MySQL to CrateDB
macrozheng
macrozheng
Jan 4, 2021 · Databases

Mastering Flyway: Automatic Database Migrations with Spring Boot, CLI, and Maven

This guide explains how Flyway automates database schema migrations using version‑controlled SQL scripts, covering its core concepts, naming conventions, command‑line usage, Maven integration, and seamless Spring Boot configuration to keep databases in sync with application releases.

CLIDatabase MigrationMaven
0 likes · 16 min read
Mastering Flyway: Automatic Database Migrations with Spring Boot, CLI, and Maven
Code Ape Tech Column
Code Ape Tech Column
Dec 22, 2020 · Databases

How Zhihu Scaled to Trillions of Rows with TiDB: Architecture and Lessons

This article details Zhihu's Moneta service handling over a trillion rows, the scalability challenges it faced, the evaluation of MySQL sharding and MHA, and how adopting the open‑source HTAP database TiDB enabled millisecond‑level query latency, high availability, and easy horizontal expansion.

Database MigrationHTAPNewSQL
0 likes · 15 min read
How Zhihu Scaled to Trillions of Rows with TiDB: Architecture and Lessons
Top Architect
Top Architect
Dec 13, 2020 · Backend Development

Practical Guide to Application and Database Splitting: Preparation, Implementation, and Stability

This article presents a comprehensive, step‑by‑step guide on why and how to split monolithic applications and databases, covering business complexity analysis, service boundary definition, migration planning, global ID generation, data sync, query refactoring, switch‑over strategies, consistency guarantees, and post‑split stability measures.

Backend ArchitectureDatabase MigrationMicroservices
0 likes · 16 min read
Practical Guide to Application and Database Splitting: Preparation, Implementation, and Stability
dbaplus Community
dbaplus Community
Dec 10, 2020 · Databases

How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade

In May 2020 GitLab partnered with OnGres to upgrade a 12‑node PostgreSQL 9.6 cluster to version 11, using a carefully planned pg_upgrade process, automated Ansible playbooks, Patroni HA, and a detailed rollback strategy to keep a 6 TB dataset consistent while serving 300 k transactions per second.

AnsibleDatabase MigrationGitLab
0 likes · 16 min read
How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade
ITPUB
ITPUB
Nov 25, 2020 · Backend Development

Why and How to Split Monolithic Applications: A Practical Guide to Service and DB Refactoring

This article explains the reasons for breaking monolithic applications, outlines the preparatory steps for understanding business complexity and defining service boundaries, and provides detailed, step‑by‑step practices for vertical and horizontal database splitting, global ID generation, migration, cut‑over strategies, consistency handling, and post‑split stability measures.

Database Migrationapplication splitting
0 likes · 18 min read
Why and How to Split Monolithic Applications: A Practical Guide to Service and DB Refactoring
Selected Java Interview Questions
Selected Java Interview Questions
Nov 23, 2020 · Backend Development

Practical Guide to Application and Database Splitting for Scalable Systems

This article outlines why and how to split monolithic applications and databases, covering preparation, boundary definition, migration steps, DB sharding strategies, consistency guarantees, and operational safeguards to ensure a smooth transition to a more modular, scalable architecture.

Database MigrationOperational Best Practicesapplication splitting
0 likes · 17 min read
Practical Guide to Application and Database Splitting for Scalable Systems
dbaplus Community
dbaplus Community
Nov 22, 2020 · Databases

How Suning Scaled with PostgreSQL & Citus: Lessons from 3000+ Instances

This article details Suning's journey of replacing commercial databases with PostgreSQL and Citus, covering background, feature and performance comparisons, reliability tests, deployment architecture, real‑world use cases, operational tips, and a comprehensive Q&A on migration and maintenance.

CitusDatabase MigrationOperational Experience
0 likes · 26 min read
How Suning Scaled with PostgreSQL & Citus: Lessons from 3000+ Instances
php Courses
php Courses
Nov 20, 2020 · Databases

Using topthink/think-migration for Database Migrations in ThinkPHP

This guide explains how to install and use the topthink/think-migration package with ThinkPHP to create, run, and roll back database migration scripts, covering version compatibility, command‑line operations, migration class creation, and practical examples for creating, updating, and deleting tables and columns.

CLIDatabase MigrationPHP
0 likes · 5 min read
Using topthink/think-migration for Database Migrations in ThinkPHP
Programmer DD
Programmer DD
Nov 19, 2020 · Backend Development

Why and How to Split a Monolithic Application: Practical Guide

This article explains why monolithic systems need to be split, outlines multi‑dimensional preparation steps, details database vertical and horizontal partitioning, global ID generation, cut‑over strategies, consistency handling, and operational safeguards to ensure a smooth migration.

Backend ArchitectureDatabase Migrationapplication splitting
0 likes · 17 min read
Why and How to Split a Monolithic Application: Practical Guide
Efficient Ops
Efficient Ops
Nov 9, 2020 · Databases

How Lufax Achieved a Zero‑Downtime, 100% Oracle‑to‑MySQL Migration

Lufax completed a two‑year, zero‑downtime, 100% Oracle‑to‑MySQL migration across its entire financial platform, detailing the dual‑write strategy, fine‑grained batch switching, tool‑driven automation, and the resulting cost and operational benefits for over 45 million users and supporting critical transaction services.

AutomationDatabase MigrationFinancial Systems
0 likes · 16 min read
How Lufax Achieved a Zero‑Downtime, 100% Oracle‑to‑MySQL Migration
DevOps Coach
DevOps Coach
Oct 9, 2020 · Operations

How to Master Database Change Management for Zero‑Downtime Deployments

This article explains Google DevOps’s four capability categories, dives into DORA‑backed best practices for database change management—including communication, migration scripts, tooling, zero‑downtime strategies, common pitfalls, and key metrics—to help teams deliver changes safely and quickly.

DORADatabase MigrationDevOps
0 likes · 13 min read
How to Master Database Change Management for Zero‑Downtime Deployments
Architecture Digest
Architecture Digest
Oct 5, 2020 · Databases

ClickHouse Overview, MySQL Migration, Performance Benchmark, and Practical Tips

This article introduces ClickHouse as an OLAP columnar database, explains the differences between row‑ and column‑oriented storage, details a real‑world migration from MySQL using a CREATE TABLE AS SELECT approach, presents performance comparisons, discusses synchronization methods, and shares common pitfalls and solutions.

ClickHouseColumnar DatabaseDatabase Migration
0 likes · 6 min read
ClickHouse Overview, MySQL Migration, Performance Benchmark, and Practical Tips
dbaplus Community
dbaplus Community
Sep 28, 2020 · Databases

How ClickHouse Outperformed Elasticsearch for Ctrip’s Log Analytics: Speed, Cost & Ops

Facing growing log volumes and high Elasticsearch costs, Ctrip migrated its 200 TB daily logs to ClickHouse, achieving up to 38× faster queries, 60 % lower server resources, and simplified operations through columnar storage, sharding, and custom dashboards, while detailing deployment, tuning, and common pitfalls.

ClickHouseDatabase MigrationElasticsearch
0 likes · 14 min read
How ClickHouse Outperformed Elasticsearch for Ctrip’s Log Analytics: Speed, Cost & Ops
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 16, 2020 · Databases

Online DDL Tool pt-osc: Principles, Usage, and Comparison

This article provides a comprehensive guide to the pt-online-schema-change (pt-osc) tool for MySQL online DDL, covering its underlying mechanism, limitations, installation steps, command‑line syntax, practical examples, and a comparative analysis with native Online DDL and gh‑ost to help users choose the appropriate solution.

Database MigrationMySQLOnline DDL
0 likes · 32 min read
Online DDL Tool pt-osc: Principles, Usage, and Comparison
Efficient Ops
Efficient Ops
Aug 29, 2020 · Databases

How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale

Facing high licensing costs and poor scalability, Lujinso embarked on an 18‑month, self‑driven project to replace 90% of its Oracle databases—spanning billions of rows across financial services—with MySQL, supplemented by Elasticsearch, Redis, TiDB and HBase, using an automated migration platform.

AutomationData synchronizationDatabase Migration
0 likes · 7 min read
How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale
Qunar Tech Salon
Qunar Tech Salon
Aug 27, 2020 · Databases

Qunar Technology Carnival Interview Series: Insights on Hotel Flow Optimization, Database Architecture, and System Stability

The article presents a series of interviews from Qunar's Technology Carnival, featuring experts Liang Zhangping, Wang Zhufeng, and Zheng Jimin who discuss hotel booking flow improvements, database architecture comparisons and migration to PXC, and comprehensive system stability governance practices.

Database MigrationInfrastructureQunar
0 likes · 13 min read
Qunar Technology Carnival Interview Series: Insights on Hotel Flow Optimization, Database Architecture, and System Stability
dbaplus Community
dbaplus Community
Jul 31, 2020 · Databases

Optimizing TimesTen Cache Group Rebuilds During Oracle 19c Migration

A telecom client migrated from IBM AIX/Oracle 11g to a domestic X86 appliance with Oracle 19c, encountering slow TimesTen Cache Group rebuilds, and the article details the root‑cause analysis and step‑by‑step optimization that cut rebuild time to one‑third.

Cache GroupDatabase MigrationOracle 19c
0 likes · 10 min read
Optimizing TimesTen Cache Group Rebuilds During Oracle 19c Migration
dbaplus Community
dbaplus Community
Jul 23, 2020 · Databases

How to Export a 2TB Oracle LOB Table Using Rowid Partitioning

This article details a real‑world migration from Oracle 11g on IBM AIX to Oracle 19c, focusing on exporting a 2 TB LOB‑heavy table by adjusting undo retention, then using ROWID‑based modulo queries with Data Pump to achieve balanced, error‑free parallel exports.

Data PumpDatabase MigrationExport
0 likes · 8 min read
How to Export a 2TB Oracle LOB Table Using Rowid Partitioning
dbaplus Community
dbaplus Community
Jul 4, 2020 · Databases

Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide

This article explains the background of Oracle 19c hot clone, lists the prerequisites, details the three‑phase cloning process, provides exhaustive local, remote, subset and refreshable PDB scenarios with exact SQL commands, highlights common errors and their solutions, and concludes with best‑practice recommendations.

Database MigrationHot CloneOracle
0 likes · 21 min read
Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide
Tencent Cloud Developer
Tencent Cloud Developer
Jun 16, 2020 · Cloud Computing

Tencent Cloud Basic Network to VPC Migration Guide

This guide explains why Tencent Cloud’s Basic Network must be replaced by VPC for security isolation and details migration methods—including interconnection, CVM conversion, IP changes, image rebuilding, database VPC conversion, DTS, and load‑balancer adjustments—illustrated by a case study moving 600+ CVMs across 80 projects.

Basic NetworkCVMCloud Computing
0 likes · 7 min read
Tencent Cloud Basic Network to VPC Migration Guide
ITPUB
ITPUB
May 10, 2020 · Databases

How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×

This case study details the migration of Weimeng's MySQL databases to Tencent Cloud CDB, describing the testing methodology, performance bottlenecks discovered (NUMA, network parameters, low‑concurrency issues, and version bugs), the step‑by‑step optimizations applied, and the resulting QPS improvements across various workloads.

Database MigrationMySQLNUMA
0 likes · 20 min read
How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×
macrozheng
macrozheng
May 9, 2020 · Databases

Why Insert‑Into‑Select Can Lock Your MySQL Tables and How to Fix It

An engineer’s mishap with a massive ‘INSERT INTO … SELECT’ migration exposed how full‑table scans lock MySQL tables, causing payment failures, and shows that adding an index on the filter column prevents the lock and ensures safe, efficient data transfer.

Database MigrationINSERT INTO SELECTIndex
0 likes · 7 min read
Why Insert‑Into‑Select Can Lock Your MySQL Tables and How to Fix It
Laravel Tech Community
Laravel Tech Community
May 4, 2020 · Databases

Laravel Schema Cheat Sheet: Quick Guide to Database Migrations

This Laravel Schema cheat sheet provides concise, English-translated code examples for creating, modifying, and managing database tables, columns, indexes, and foreign keys, covering table creation, column types, indexing options, and common schema operations with clear syntax.

Cheat SheetDatabase MigrationPHP
0 likes · 5 min read
Laravel Schema Cheat Sheet: Quick Guide to Database Migrations