Skip to content
Tagged articles

Database Migration

299 articles · Page 2 of 3
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2024 · Databases

Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance

This article explains the differences between global and local indexes in OceanBase, analyzes why queries using global unique indexes run significantly faster than those using local indexes during Oracle migration, and provides detailed SQL examples, execution plans, and performance testing results to guide database optimization.

Database MigrationGlobal IndexLocal Index
0 likes · 32 min read
Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance
dbaplus Community
dbaplus Community
Feb 20, 2024 · Databases

How to Migrate to AntDB with a Six‑Step Progressive Strategy and Optimize Key Parameters

This article outlines a six‑stage, progressive migration plan for replacing legacy databases with AntDB, covering deployment, extensive testing, SQL refactoring, data migration, go‑live procedures, and monitoring, while providing detailed tuning recommendations for dozens of critical database parameters.

AntDBDatabase MigrationPerformance Tuning
0 likes · 21 min read
How to Migrate to AntDB with a Six‑Step Progressive Strategy and Optimize Key Parameters
Zuoyebang Tech Team
Zuoyebang Tech Team
Feb 19, 2024 · Databases

How OceanBase’s HTAP Architecture Solved Our MySQL Scaling Pain Points

Facing rapid data growth, our team struggled with MySQL scaling, costly distributed refactoring, and inflexible storage; by adopting OceanBase’s native distributed HTAP platform we achieved elastic scaling, strong consistency, over 60% storage savings, and multi‑tenant performance gains for both OLTP and OLAP workloads.

Database MigrationHTAPOceanBase
0 likes · 9 min read
How OceanBase’s HTAP Architecture Solved Our MySQL Scaling Pain Points
ITPUB
ITPUB
Dec 30, 2023 · Databases

Why MySQL 5.6 → 5.7 Upgrades Fail and How to Prevent Rollbacks

The article recounts a legacy project that relied on MySQL 5.6, explains common pitfalls of that version such as replication lag, heavy performance_schema overhead, binlog issues, and memory limits, then details why an upgrade to 5.7 was rolled back due to syntax changes, case‑sensitivity differences, and unresolved configuration problems.

Case SensitivityDatabase MigrationSQL syntax
0 likes · 9 min read
Why MySQL 5.6 → 5.7 Upgrades Fail and How to Prevent Rollbacks
Selected Java Interview Questions
Selected Java Interview Questions
Dec 27, 2023 · Databases

Fast Database Migration Methods: Logical, File, and Physical Approaches with MySQL

This article explains three MySQL data‑migration techniques—logical migration using mysqldump, file‑based migration with SELECT … INTO OUTFILE and LOAD DATA INFILE, and physical migration by copying InnoDB files—detailing commands, performance considerations, and practical steps for each method.

Database MigrationFile MigrationLogical Migration
0 likes · 12 min read
Fast Database Migration Methods: Logical, File, and Physical Approaches with MySQL
Architecture Digest
Architecture Digest
Dec 25, 2023 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL: OOM, Full Table Scan, and Transaction Issues

This article recounts a real‑world MySQL data‑migration failure caused by an unguarded INSERT INTO SELECT that triggered OOM, full‑table scans, and row‑level locking, explains why testing missed the problem, and offers indexing and transaction‑level safeguards to prevent similar incidents.

Database MigrationINSERT INTO SELECTfull table scan
0 likes · 6 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL: OOM, Full Table Scan, and Transaction Issues
ITPUB
ITPUB
Dec 22, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime

GitHub upgraded over 1,200 MySQL hosts from 5.7 to 8.0 across more than 50 clusters, detailing the motivation, infrastructure, extensive preparation, a five‑step rolling upgrade process, rollback strategies, challenges like Vitess integration and replication lag, and key lessons for future database migrations.

Database MigrationGitHubmysql
0 likes · 14 min read
How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime
21CTO
21CTO
Dec 15, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime

GitHub’s engineering team detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from 5.7 to 8.0, preserving high availability, SLO compliance, and rollback capability while introducing new features and performance improvements.

Database MigrationGitHubHigh Availability
0 likes · 17 min read
How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime
Programmer DD
Programmer DD
Dec 14, 2023 · Databases

How GitHub Upgraded Its 1200‑Node MySQL Cluster to 8.0 Without Downtime

GitHub detailed its year‑long, multi‑team effort to seamlessly upgrade over 1,200 MySQL servers—supporting more than 300 TB of data and 5.5 million queries per second—from 5.7 to 8.0, outlining the infrastructure, tools, and step‑by‑step migration strategy used to maintain service reliability.

Database MigrationGitHubScaling
0 likes · 5 min read
How GitHub Upgraded Its 1200‑Node MySQL Cluster to 8.0 Without Downtime
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Dec 12, 2023 · Databases

Master Database Migration to Cloud: Challenges & Solutions with Baidu DTS

This article examines the rapid growth of China's database market, the technical hurdles of moving databases to public cloud—including engine selection, lengthy migration processes, efficiency, disaster recovery, and data consistency—and explains how Baidu Intelligent Cloud's DTS platform offers a smooth, reliable, high‑availability, and high‑performance one‑stop solution with real‑world use cases.

Baidu CloudDTSData Consistency
0 likes · 25 min read
Master Database Migration to Cloud: Challenges & Solutions with Baidu DTS
FunTester
FunTester
Dec 10, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime

GitHub detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from 5.7 to 8.0 using phased rollouts, automated testing, compatibility checks, and rollback mechanisms while maintaining strict SLOs and high‑availability requirements.

Database MigrationGitHubHigh Availability
0 likes · 16 min read
How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime
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 Migrationcompatibility testingmysql
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 MigrationIndexSQLite
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.

Database MigrationHive MetastorePerformance Optimization
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.

BackendDatabase MigrationDistributed Systems
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.

ANTMANDatabase MigrationOCP
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 MigrationOceanBaseSQL
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.

Database MigrationMyBatisdata synchronization
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.

BackendDatabase MigrationLarge Tables
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.

Cascading ReplicationDatabase MigrationHigh Availability
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 MigrationOptimizationOracle
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 MigrationOceanBasePerformance Diagnosis
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.

Database Migrationautomationcloud
0 likes · 11 min read
Fast and Stable MySQL Data Center Migration: Choosing and Implementing the Optimal Strategy
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.

Database MigrationGBaseGaussDB
0 likes · 9 min read
Why Teradata Is Leaving China and What It Means for the Domestic Data Warehouse Market

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 MigrationOracle compatibility
0 likes · 10 min read
Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 21, 2022 · Databases

Migrating from MyCat to DBLE: Parameter Settings, Sharding Functions, and SQL Compatibility

This article details a low‑impact migration from MyCat to DBLE, covering required parameter adjustments, sharding function replacement, data node handling, and business‑SQL compatibility issues, while providing concrete configuration examples and practical recommendations for a smooth transition.

DBLEDatabase MigrationDistributed Systems
0 likes · 7 min read
Migrating from MyCat to DBLE: Parameter Settings, Sharding Functions, and SQL Compatibility
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.

CDCDatabase MigrationHigh Availability
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.

ASMBest PracticesDatabase Migration
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
Qunar Tech Salon
Qunar Tech Salon
May 31, 2022 · Databases

Comparison of pt-online-schema-change, gh-ost, and MySQL Online DDL for Online Schema Changes

This article introduces and compares three MySQL online schema‑change solutions—pt‑online‑schema‑change, gh‑ost, and native MySQL ONLINE DDL—detailing their workflows, limitations, risks, monitoring features, and practical considerations for safely altering large tables in production environments.

DDLDatabase MigrationOnline Schema Change
0 likes · 27 min read
Comparison of pt-online-schema-change, gh-ost, and MySQL Online DDL for Online Schema Changes
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.

Database MigrationPHPPhinx
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 MigrationDistributed Systems
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 MigrationMariaDBPostgreSQL
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.

Database MigrationInnoDBSQL
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 MigrationNULLSQL
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.

Database MigrationFacebookMyRocks
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 MigrationMariaDBSQL
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 MigrationFlywayMaven
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.

AuthenticationBackendDatabase Migration
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 SyncDatabase MigrationRedissyncer
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 MigrationPythonSnowflake
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 MigrationTiDB
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.

Database MigrationMongoDBPerformance Optimization
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.

Database MigrationGray ReleaseTraffic Routing
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.

Database MigrationMulti-Source Replicationbackup
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 CloudDatabase Migrationcapacity planning
0 likes · 16 min read
Scaling and Migrating a High‑Volume Order System with Sharding, Data Synchronization and Gray‑Rollout on Alibaba Cloud
Python Crawling & Data Mining
Python Crawling & Data Mining
Feb 5, 2021 · Backend Development

Build a Full‑Featured Django Website: Login, Registration, and More

This step‑by‑step tutorial shows how to create a Django website with user authentication features—including login, registration, logout, password change, password‑less login and reset—by configuring the project, defining models, forms, views, URLs, performing migrations, and running the server.

AuthenticationDatabase MigrationDjango
0 likes · 5 min read
Build a Full‑Featured Django Website: Login, Registration, and More
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 MigrationFlywayJava
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.

Database MigrationFlywayMaven
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 MigrationDistributed Systems
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.

ComposerDatabase 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 MigrationDistributed Systems
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.

Database Migrationautomationfinancial 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