Skip to content
Tagged articles

Database Migration

299 articles · Page 1 of 3
Architecture Pony
Architecture Pony
Nov 8, 2026 · Backend Development

Spring Cloud Gray Release: Beyond Gateway Routing to Full-Chain Context Propagation

This article analyzes three real-world gray release failures in Spring Cloud, revealing that successful gray release requires full-chain context propagation, traffic-proportion accuracy, and bidirectional data compatibility—not just gateway routing. It covers implementation details, LoadBalancer filter chains, fallback strategies, database migration patterns, and troubleshooting techniques.

Context PropagationDatabase MigrationGray Release
0 likes · 53 min read
Spring Cloud Gray Release: Beyond Gateway Routing to Full-Chain Context Propagation
Xiaolin Talks Programming
Xiaolin Talks Programming
Nov 7, 2026 · Databases

Zero-Downtime Database Migration: Stock, Incremental, Validation & Cutover in Spring Boot

A comprehensive engineering guide to zero-downtime database migration covering cursor-based stock migration, incremental sync via binlog or dual-write, CRC-based chunked validation, field-level diffing, gray read cutover with dual-read verification, write-switch patterns, and rollback procedures — all implemented in Spring Boot with production-grade patterns and pitfalls.

CRC validationDatabase MigrationSpring Boot
0 likes · 27 min read
Zero-Downtime Database Migration: Stock, Incremental, Validation & Cutover in Spring Boot

OntoL-Manage 8.1: Switch Graph Databases by Config, Not Code

OntoL-Manage 8.1 introduces a graph database dialect layer that enables switching between Memgraph and Neo4j via a single configuration variable, abstracting away differences in constraint DDL, date functions, and timestamp units, with a defined migration process and validation criteria, while noting limitations like downtime and private extension incompatibility.

Database MigrationMemgraphNeo4j
0 likes · 4 min read
OntoL-Manage 8.1: Switch Graph Databases by Config, Not Code
AI Large-Model Wave and Transformation Guide
AI Large-Model Wave and Transformation Guide
Oct 27, 2026 · Backend Development

OntoL7.0 Architecture: MySQL8 Migration with SQLite Dialect Translation

The article details OntoL7.0's technical architecture after migrating business data to MySQL8, maintaining a single codebase with two isolated data stores (MySQL for business, SQLite for system) plus graph and vector storage, using a dialect translation layer to convert SQLite syntax to MySQL at the driver level.

Backend ArchitectureChromaDBDatabase Migration
0 likes · 5 min read
OntoL7.0 Architecture: MySQL8 Migration with SQLite Dialect Translation
Feidie Network
Feidie Network
Oct 19, 2026 · Backend Development

EF Core Deep Dive: Change Tracking, Query Optimization, Concurrency & Migration Strategies

This comprehensive guide explores EF Core's ChangeTracker internals, performance optimization techniques including AsNoTracking and compiled queries, optimistic concurrency with Timestamp tokens, production migration strategies using SQL scripts and bundles, and previews EF Core 10 LTS features like vector search and JSON support.

ChangeTrackerDatabase MigrationEF Core 10
0 likes · 19 min read
EF Core Deep Dive: Change Tracking, Query Optimization, Concurrency & Migration Strategies
Code Archaeology
Code Archaeology
Oct 14, 2026 · Backend Development

Evolutionary Architecture Structure: Connascence, Architectural Quanta, and Contract-Driven Design

This article explores how software topology determines evolvability through connascence-based coupling analysis, architectural quanta as independently deployable units, contract spectra from strict RPC to loose key-value, microservices as evolutionary templates, data mesh for analytical data, and evolutionary database practices including Expand/Contract migrations and data governance.

Bounded ContextDatabase Migrationarchitectural quantum
0 likes · 56 min read
Evolutionary Architecture Structure: Connascence, Architectural Quanta, and Contract-Driven Design
Raymond Ops
Raymond Ops
Oct 13, 2026 · Databases

MySQL 8.0 Upgrade Guide: 20 Critical Migration Pitfalls from 5.7

This comprehensive guide details 20 critical technical checks for migrating from MySQL 5.7 to 8.0, covering authentication plugins, character sets, reserved words, strict SQL modes, replication setup, backup validation, and cutover procedures with executable SQL and bash examples.

AuthenticationDatabase MigrationDatabase Upgrade
0 likes · 23 min read
MySQL 8.0 Upgrade Guide: 20 Critical Migration Pitfalls from 5.7
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Oct 1, 2026 · Databases

Xinchuang Database Migration: MySQL→Kingbase & Oracle→Dameng 5-Phase Guide

This article details a five-phase migration process for China's Xinchuang database replacements, covering Oracle-to-Dameng and MySQL-to-Kingbase routes, compatibility mode selection, schema conversion, data migration, application refactoring, regression verification, and critical dialect pitfalls like auto-increment, upsert, date functions, and empty-string handling.

DamengDatabase MigrationKingbase
0 likes · 10 min read
Xinchuang Database Migration: MySQL→Kingbase & Oracle→Dameng 5-Phase Guide
Programmer DD
Programmer DD
Sep 6, 2026 · Backend Development

OctaFuse Gateway 2.9.0 Adds Dual-Layer Rate Limiting, Custom Upstream Headers, and Dashboard Overhaul

OctaFuse Gateway 2.9.0 introduces per-user and per-key RPM rate limiting with sliding 60-second windows, per-route custom HTTP headers for upstream providers, a redesigned admin dashboard with consolidated metrics, and Key-level analytics with ingress host tracking, plus migration 0028 for database schema updates.

API GatewayAdmin DashboardCloudflare
0 likes · 17 min read
OctaFuse Gateway 2.9.0 Adds Dual-Layer Rate Limiting, Custom Upstream Headers, and Dashboard Overhaul
java1234
java1234
Sep 3, 2026 · Backend Development

MyBatis-Plus 3.5.15: Spring Boot 4.0 & Jackson 3.0 Support Explained

This article details MyBatis-Plus 3.5.15's new support for Spring Boot 4.0 and Jackson 3.0, providing step-by-step migration guidance including starter dependency changes, JSON field handling with Jackson3TypeHandler, and common upgrade pitfalls like starter mismatches and factoryBeanObjectType errors.

Database MigrationJackson 3.0Java
0 likes · 13 min read
MyBatis-Plus 3.5.15: Spring Boot 4.0 & Jackson 3.0 Support Explained
360 Smart Cloud
360 Smart Cloud
Aug 25, 2026 · Databases

MySQL-DTS: One-Stop MySQL/TiDB Sync with Online DDL Compatibility

MySQL-DTS unifies structure sync, full migration, and incremental replication in a single task for MySQL sources and MySQL/TiDB targets, featuring consistent snapshots, chunked parallelism, GTID/file+pos checkpoints, and built-in pt-osc/gh-ost compatibility for seamless online schema changes.

Database MigrationGTIDTiDB
0 likes · 14 min read
MySQL-DTS: One-Stop MySQL/TiDB Sync with Online DDL Compatibility
BirdNest Tech Talk
BirdNest Tech Talk
Aug 25, 2026 · Backend Development

Go database/sql Tutorial: 39 Practical Lessons from Core to ORMs & Tools

This practical Go database/sql tutorial covers 39 lessons spanning core concepts like connection pools, transactions, and isolation levels, compares ORMs (GORM, Bun, XORM) and lightweight tools (sqlx, sqlc, Squirrel), and addresses logging, migration, testing, and production practices using modernc.org/sqlite for runnable examples.

Database MigrationGoORM
0 likes · 5 min read
Go database/sql Tutorial: 39 Practical Lessons from Core to ORMs & Tools
SpringMeng
SpringMeng
Aug 18, 2026 · Operations

CFO’s No‑Code AI App Triggers a Month’s Server Bill in One Day

A CFO built a SaaS product in two days using Claude Code, but a missing database field caused the task queue’s automatic retries to re‑execute 21 LLM calls, turning a single day’s AI usage into a cost that exceeded the entire month’s server expenses.

AIDatabase MigrationIdempotency
0 likes · 11 min read
CFO’s No‑Code AI App Triggers a Month’s Server Bill in One Day
Long Ge's Treasure Box
Long Ge's Treasure Box
Jul 16, 2026 · Databases

NewSQL in Practice: Overview, HTAP Architecture, and Real-World Migration Cases

This article introduces NewSQL databases, compares popular products such as TiDB, CockroachDB, SingleStore, and YugaByteDB, explains HTAP architecture and storage‑compute separation, demonstrates TiDB configuration and serverless scaling, and provides concrete migration and real‑time analytics examples with code snippets.

Database MigrationHTAPNewSQL
0 likes · 8 min read
NewSQL in Practice: Overview, HTAP Architecture, and Real-World Migration Cases
DeWu Technology
DeWu Technology
Jul 8, 2026 · Databases

DeWu’s OceanBase Deployment: Multi‑Model Database Selection, Performance Gains, and Migration Lessons

DeWu, a leading fashion e‑commerce platform, evaluated and adopted OceanBase as a multi‑model database to replace a heterogeneous stack of MySQL, TiDB, MongoDB, HBase, ClickHouse, and others, achieving up to 200× query speedups, 40%+ storage savings, high‑availability with RPO = 0, and a streamlined operations model while documenting migration challenges and future roadmap.

Database MigrationDeWuMulti-Model Database
0 likes · 19 min read
DeWu’s OceanBase Deployment: Multi‑Model Database Selection, Performance Gains, and Migration Lessons
IT Services Circle
IT Services Circle
Jul 4, 2026 · Operations

When a Non‑Engineer Deploys with Claude Code, a Hidden Bug Makes One Day of AI Cost a Month of Server Fees

A CFO used Claude Code to launch a SaaS product in two days, but a missing database field combined with an automatic retry mechanism caused a single day's AI API calls to generate costs equivalent to a whole month's server expenses, prompting a detailed post‑mortem on the root causes and preventive measures.

Claude CodeCloud OperationsDatabase Migration
0 likes · 10 min read
When a Non‑Engineer Deploys with Claude Code, a Hidden Bug Makes One Day of AI Cost a Month of Server Fees
Xiaolin Talks Programming
Xiaolin Talks Programming
Jun 30, 2026 · Databases

Zero-Downtime Database Evolution: Flyway + Spring Boot Expand/Migrate/Contract Pattern

This article details a production-verified zero-downtime database migration strategy using Spring Boot and Flyway, covering why DDL causes outages, Flyway configuration best practices, the expand-migrate-contract pattern for smooth schema changes, script writing and rollback techniques, Kubernetes deployment coordination, monitoring with circuit breakers, and a post-mortem checklist.

DDLDatabase MigrationFlyway
0 likes · 18 min read
Zero-Downtime Database Evolution: Flyway + Spring Boot Expand/Migrate/Contract Pattern
Java Tech Enthusiast
Java Tech Enthusiast
Jun 4, 2026 · Databases

Why PostgreSQL Beats MySQL in the AI Era

The article explains why developers should move beyond MySQL to PostgreSQL, illustrating the productivity gains of native window functions, MVCC concurrency, rich indexing, JSONB support, and extensive extensions through detailed examples, installation guides, performance comparisons, and real‑world use cases.

Database MigrationIndexingJSONB
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
Architect's Guide
Architect's Guide
May 9, 2026 · Databases

Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization

This article introduces Alibaba’s open‑source DataX tool, explains its framework‑plugin architecture for heterogeneous database sync, walks through Linux installation, job configuration, full‑ and incremental MySQL synchronization, and shares performance results and practical tips.

DataXDatabase MigrationETL
0 likes · 15 min read
Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization
Java Architect Essentials
Java Architect Essentials
Mar 23, 2026 · Databases

When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes

A backend engineer discovers that a massive MySQL table’s auto‑increment INT primary key reached its maximum value, causing insert failures, and walks through detailed analysis, three remediation options—including switching to BIGINT, redesigning IDs, and sharding—plus practical scripts, performance measurements, and lessons learned about concurrency and schema design.

BIGINTConcurrencyDatabase Migration
0 likes · 10 min read
When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes
DevOps Coach
DevOps Coach
Mar 8, 2026 · Databases

Boosting Performance 25× and Cutting Costs 80%: Our Switch from Redis to DragonflyDB

Facing high memory overhead, operational complexity, and scaling limits of a large Redis cluster, we migrated to DragonflyDB using a three‑stage shadow, dual‑write, and cut‑over process, achieving up to 25‑fold throughput increase, 80% cost reduction, and simpler maintenance while preserving compatibility with existing Redis clients.

Database MigrationDragonflyDBRedis
0 likes · 7 min read
Boosting Performance 25× and Cutting Costs 80%: Our Switch from Redis to DragonflyDB
LuTiao Programming
LuTiao Programming
Mar 4, 2026 · Backend Development

Flyway vs Liquibase in Spring Boot: Which Database Migration Tool Wins?

The article compares Flyway and Liquibase for database version control in Spring Boot applications, explaining their core philosophies, integration steps, configuration examples, advantages, and trade‑offs, and provides guidance on selecting the appropriate tool based on project size, team skills, multi‑database needs, and rollback requirements.

Database MigrationFlywayLiquibase
0 likes · 7 min read
Flyway vs Liquibase in Spring Boot: Which Database Migration Tool Wins?
Tech Musings
Tech Musings
Feb 12, 2026 · Databases

From MySQL to Apache Doris: Key Design Shifts for OLAP Migration

This article explains how backend engineers should rethink table design, indexing, partitioning, and key strategies when migrating attendance data from MySQL's OLTP model to Apache Doris 2.1.7's OLAP architecture, providing concrete DDL examples and practical tips.

Apache DorisDatabase MigrationIndexing
0 likes · 12 min read
From MySQL to Apache Doris: Key Design Shifts for OLAP Migration
Dunmao Tech Hub
Dunmao Tech Hub
Jan 27, 2026 · Databases

Deploy Kingbase ES with Docker and Integrate It into Spring Boot

This guide walks through installing the Kingbase ES database via Docker, configuring persistence, adding the official driver to a Spring Boot project, adjusting the application.yml for PostgreSQL compatibility, and troubleshooting common container startup issues and SQL import procedures.

Database MigrationKingbasePostgreSQL Compatibility
0 likes · 6 min read
Deploy Kingbase ES with Docker and Integrate It into Spring Boot
Ray's Galactic Tech
Ray's Galactic Tech
Jan 12, 2026 · Databases

How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime

This guide explains why using a plain ALTER TABLE on massive MySQL tables can lock the table and halt services, and presents tool‑based online DDL, native INPLACE options, phased migration strategies, cloud‑DB features, best‑practice checks, monitoring, and rollback techniques to add new columns safely.

Database Migrationgh-ostmysql
0 likes · 8 min read
How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 24, 2025 · Databases

Why Relying Solely on Large Language Models for Database Migration Is Risky – Insights from SQLShift

The article explains the hidden challenges of database migration, demonstrates that large language models alone cannot reliably handle dialect differences, and describes how the SQLShift tool combines domain‑specific fine‑tuning, multi‑stage verification, and human‑AI collaboration to make migration safer and more predictable.

AIDBADatabase Migration
0 likes · 9 min read
Why Relying Solely on Large Language Models for Database Migration Is Risky – Insights from SQLShift
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 10, 2025 · Databases

Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It

A production migration from Oracle to OceanBase caused a column‑length change to trigger offline DDL, leading to connection errors, INSERT latency spikes, and complete table blockage; the article reproduces the fault, analyzes the OMS conversion and OceanBase DDL rules, and provides a two‑step remediation and a method to verify online DDL execution.

DDLDatabase MigrationOceanBase
0 likes · 11 min read
Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It
php Courses
php Courses
Dec 8, 2025 · Backend Development

Build a Full Laravel CRUD App from Scratch: Step‑by‑Step Guide

This tutorial walks you through setting up a Laravel development environment, creating a database, generating models, migrations, controllers, Blade views, defining routes, and testing a complete CRUD task manager, with optional extensions and troubleshooting tips.

Blade TemplatesCRUDDatabase Migration
0 likes · 8 min read
Build a Full Laravel CRUD App from Scratch: Step‑by‑Step Guide
Top Architect
Top Architect
Dec 3, 2025 · Backend Development

How to Add a Column to a Billion‑Row Order Table Without Breaking Production

When a new business field is required on a core order table with tens of millions of rows, the article walks through the risks of direct ALTER TABLE, evaluates master‑slave switching, online DDL tools, extension tables, JSON‑based schema‑less designs, and a clever reuse of an existing redundant column, providing practical steps and performance insights.

ALTER TABLEDatabase MigrationJSON column
0 likes · 9 min read
How to Add a Column to a Billion‑Row Order Table Without Breaking Production
Top Architect
Top Architect
Nov 25, 2025 · Databases

MySQL 8.0 End‑of‑Life in 2026: Migration Paths and Alternatives

With MySQL 8.0 support ending on April 30, 2026, users must migrate within six months to avoid security risks, and can choose upgrading to the latest MySQL, switching to Percona Server, or moving to alternatives like MariaDB or PostgreSQL, each with its own pros and cons.

Database MigrationEOLMariaDB
0 likes · 7 min read
MySQL 8.0 End‑of‑Life in 2026: Migration Paths and Alternatives
dbaplus Community
dbaplus Community
Nov 22, 2025 · Databases

MySQL 8.4 Upgrade: Removed & Deprecated Features You Must Know

With MySQL 8.0 reaching end‑of‑life in April 2026, DBAs must migrate to the LTS 8.4 release, updating tools and replacing removed system variables, deprecated options, and old commands to avoid breakage in applications, monitoring, and replication setups.

8.4Database MigrationDeprecated features
0 likes · 7 min read
MySQL 8.4 Upgrade: Removed & Deprecated Features You Must Know
Efficient Ops
Efficient Ops
Nov 11, 2025 · Databases

MySQL 8.0 End-of-Life 2026: Migration Paths and Best Practices

MySQL 8.0 will lose Oracle support on April 30, 2026, ending security patches, bug fixes, and official assistance, so organizations must choose between upgrading to a newer MySQL version, switching to Percona Server, or migrating to alternative databases like MariaDB or PostgreSQL.

DBaaSDatabase MigrationEnd-of-Life
0 likes · 5 min read
MySQL 8.0 End-of-Life 2026: Migration Paths and Best Practices
Ray's Galactic Tech
Ray's Galactic Tech
Oct 21, 2025 · Databases

Essential MySQL 5.7 → 8.0 Upgrade Guide: Common Pitfalls & Solutions

Upgrading MySQL from 5.7 to 8.0 involves careful preparation, thorough testing, and handling numerous compatibility issues such as deprecated features, authentication changes, SQL mode differences, and performance regressions, all of which are detailed with step‑by‑step solutions in this guide.

5.78.0Best Practices
0 likes · 9 min read
Essential MySQL 5.7 → 8.0 Upgrade Guide: Common Pitfalls & Solutions
Architect
Architect
Oct 12, 2025 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

Adding a new field to a core order table with tens of millions of rows can lock the table and disrupt services, so this article explores various strategies—including master‑slave switching, online DDL tools, extension tables, JSON fields, and repurposing redundant columns—to achieve schema changes safely and efficiently.

Database MigrationJSON fieldextension table
0 likes · 8 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
DevOps Coach
DevOps Coach
Oct 11, 2025 · Databases

Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification

Uber migrated its core database from PostgreSQL to MySQL because PostgreSQL suffered from index bloat, write amplification, high replication overhead, and limited MVCC support, prompting a detailed analysis of each issue, the improvements in newer PostgreSQL releases, and how MySQL’s architecture addresses these challenges.

Database MigrationIndex BloatPostgreSQL
0 likes · 12 min read
Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification
Java Tech Enthusiast
Java Tech Enthusiast
Oct 7, 2025 · Databases

When MySQL Auto‑Increment Hits INT Limit: Diagnosis & Fixes

The article recounts a real‑world incident where a massive MySQL table exceeded the INT auto‑increment limit, causing insert failures, and walks through analysis, three remediation strategies—including converting to BIGINT, using distributed IDs, and sharding—plus practical SQL scripts and performance insights for handling billions of rows.

BIGINTDatabase MigrationINT overflow
0 likes · 9 min read
When MySQL Auto‑Increment Hits INT Limit: Diagnosis & Fixes
Wukong Talks Architecture
Wukong Talks Architecture
Sep 24, 2025 · Databases

How Meiyou Scaled Overseas Messaging with TiDB Architecture

Meiyou, a leading women‑health platform, migrated its overseas messaging system and other core services from MySQL to TiDB, detailing the selection process, performance testing, deployment configurations, and the resulting gains in scalability, latency, high availability, and reduced operational costs.

Database MigrationHigh AvailabilityTiDB
0 likes · 12 min read
How Meiyou Scaled Overseas Messaging with TiDB Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2025 · Databases

How to Migrate SQL Server to OceanBase Using Action OMS: A Step‑by‑Step Guide

Action OMS, a customized version of OceanBase’s OMS tool, enables seamless migration and real‑time data subscription from Microsoft SQL Server (2008‑2019 Enterprise) to OceanBase, detailing preparation, configuration, CDC setup, and best‑practice considerations for reliable, low‑latency data transfer.

Action OMSCDCDatabase Migration
0 likes · 15 min read
How to Migrate SQL Server to OceanBase Using Action OMS: A Step‑by‑Step Guide
Architecture Digest
Architecture Digest
Sep 9, 2025 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

When a core order table with tens of millions of rows needs a new column, naïve ALTER TABLE can lock the table and cause outages, so this article explores master‑slave switching, online schema‑change tools, JSON or redundant fields, and practical tips for low‑risk, production‑grade schema evolution.

DDLDatabase MigrationOnline Schema Change
0 likes · 7 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
macrozheng
macrozheng
Aug 5, 2025 · Databases

Migrate SpringBoot MyBatis from MySQL to PostgreSQL: A Complete Guide

This guide walks you through converting a SpringBoot + MyBatisPlus project from MySQL to PostgreSQL, covering driver setup, JDBC configuration changes, common SQL syntax pitfalls, and provides helper scripts for bulk column adjustments and default value settings.

Database MigrationJDBCPostgreSQL
0 likes · 12 min read
Migrate SpringBoot MyBatis from MySQL to PostgreSQL: A Complete Guide
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jul 30, 2025 · Databases

Seamless Multi-DataCenter Database Migration: Strategies and Domain Scheduling

Learn how to execute a zero‑downtime, risk‑controlled database migration across data centers using pre‑expansion, cross‑room master switch, intelligent domain scheduling, and step‑by‑step operational guides—including VIP handling, global vs. zone‑specific domains, and post‑migration validation—to ensure continuous service and optimal resource elasticity.

Database MigrationDomain SchedulingHigh Availability
0 likes · 13 min read
Seamless Multi-DataCenter Database Migration: Strategies and Domain Scheduling
JD Tech Talk
JD Tech Talk
Jul 25, 2025 · Databases

How to Seamlessly Migrate a Legacy MongoDB System to JimKV, MySQL, and ES

This article presents a comprehensive migration plan for a legacy MongoDB‑based system, detailing scope analysis, dual‑write implementation, data source selection, bulk and incremental migration strategies, and a three‑pronged online approach (monitoring, gray release, rollback) to ensure a smooth cut‑over without service disruption.

BackendDatabase MigrationGray Release
0 likes · 8 min read
How to Seamlessly Migrate a Legacy MongoDB System to JimKV, MySQL, and ES
Top Architect
Top Architect
Jul 20, 2025 · Databases

When MySQL Auto‑Increment IDs Hit Their Limit – Diagnosis and Fixes

A senior architect investigates a missing device error caused by MySQL auto‑increment IDs reaching the 32‑bit integer limit, analyzes the overflow issue, evaluates three remediation strategies—including converting the column to BIGINT, adopting distributed IDs, or sharding the database—and shares practical code snippets and performance insights for large‑scale data migrations.

BIGINTDatabase Migrationauto-increment
0 likes · 11 min read
When MySQL Auto‑Increment IDs Hit Their Limit – Diagnosis and Fixes
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jul 1, 2025 · Backend Development

How Taobao Scaled from LAMP to Cloud: A Deep Dive into Its Architecture Evolution

This article chronicles Taobao's technical evolution—from a LAMP stack through Oracle migration, Java adoption, de‑IOE optimization, self‑built storage and caching systems, service‑oriented design, middleware integration, and finally a cloud‑native architecture—highlighting the challenges and solutions for scalability, performance, and cost reduction.

Database Migrationcloud computingmiddleware
0 likes · 11 min read
How Taobao Scaled from LAMP to Cloud: A Deep Dive into Its Architecture Evolution
Xiaolei Talks DB
Xiaolei Talks DB
Jun 5, 2025 · Databases

How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey

Zhihu’s evolving data architecture transitioned from a single MySQL setup to a heterogeneous ecosystem of SQL, NoSQL, and graph databases, ultimately adopting OceanBase for its multi‑tenant, high‑compression capabilities, supported by tools like OMS, OCP, and ob‑operator to achieve cost savings, performance gains, and robust operations.

Database MigrationMulti‑TenantOceanBase
0 likes · 12 min read
How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey
Film Hurricane Tech Team
Film Hurricane Tech Team
May 2, 2025 · Databases

Scaling DaVinci Resolve’s Database to Millions of Projects: Evolution and Lessons

The article details how DaVinci Resolve’s project library, built on PostgreSQL, evolved from a monolithic server to a Docker‑based setup and finally to a Pigsty‑powered high‑availability cluster, covering challenges, point‑in‑time recovery, permission management, a real‑world outage, and the resulting reliability gains.

DaVinci ResolveDatabase MigrationHigh Availability
0 likes · 6 min read
Scaling DaVinci Resolve’s Database to Millions of Projects: Evolution and Lessons
dbaplus Community
dbaplus Community
Apr 27, 2025 · Databases

Why We Dropped SQL for NoSQL: 5× Traffic Boost and Zero Downtime

Facing massive query latency, deadlocks and costly vertical scaling, our team abandoned a textbook‑perfect PostgreSQL setup, tried extensive SQL optimizations, added Redis caching and read replicas, and finally migrated critical order services to MongoDB, achieving five‑fold capacity, zero downtime and significant cost savings.

Database MigrationMongoDBNoSQL
0 likes · 16 min read
Why We Dropped SQL for NoSQL: 5× Traffic Boost and Zero Downtime
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2025 · Databases

Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide

This article presents a step‑by‑step migration plan for moving a PolarDB PostgreSQL 11.9 tenant to an OceanBase 4.2.1.10 Oracle‑compatible tenant, covering background, scope, task distribution, user and permission conversion, table‑structure transformation, DataX data transfer, performance tuning, error handling, monitoring, and final recommendations.

DataXDatabase MigrationOceanBase
0 likes · 14 min read
Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 2, 2025 · Databases

Replacing Elasticsearch with Apache Doris for Real‑Time Big Data Analytics: Architecture, Performance, and Enterprise Cases

This article analyzes why Elasticsearch struggles with large‑scale, complex real‑time analytics and demonstrates how Apache Doris’s MPP, columnar storage, and native SQL support provide a cost‑effective, high‑performance alternative, illustrated with detailed enterprise case studies.

Apache DorisDatabase MigrationElasticsearch
0 likes · 11 min read
Replacing Elasticsearch with Apache Doris for Real‑Time Big Data Analytics: Architecture, Performance, and Enterprise Cases
JD Retail Technology
JD Retail Technology
Jan 24, 2025 · Databases

How to Seamlessly Migrate a Legacy MongoDB System to New Storage

This article presents a complete, step‑by‑step migration plan for a legacy MongoDB‑based system, covering scope analysis, data‑store selection, DAO refactoring, dual‑write synchronization, bulk and incremental data migration, and the three‑pronged deployment strategy of monitoring, gray‑release and rollback to ensure a smooth cut‑over without service disruption.

Database MigrationMongoDBarchitecture
0 likes · 7 min read
How to Seamlessly Migrate a Legacy MongoDB System to New Storage
Xiaolei Talks DB
Xiaolei Talks DB
Jan 10, 2025 · Databases

How Zhihu Solved MongoDB Scaling Pain Points with a Cloud Migration

This article details Zhihu's security anti‑fraud system challenges with its self‑managed MongoDB cluster, the strategic move to Alibaba Cloud MongoDB services, the step‑by‑step migration plan, and the operational and performance benefits achieved after the successful cloud transition.

Database MigrationMongoDBperformance
0 likes · 12 min read
How Zhihu Solved MongoDB Scaling Pain Points with a Cloud Migration
ITPUB
ITPUB
Jan 7, 2025 · Databases

Cut Costs 25% and Boost Performance 70%: Retail Giant’s OceanBase Migration

The article details how WanJia Shuke, the tech arm of China Resources Vanguard, tackled retail system fragmentation, user‑experience degradation, complex linkages and scalability limits by migrating dozens of projects to the distributed OceanBase database, achieving up to 70% performance improvement, 25% cost reduction and streamlined operations.

Database MigrationFlinkOceanBase
0 likes · 15 min read
Cut Costs 25% and Boost Performance 70%: Retail Giant’s OceanBase Migration
Zhihu Tech Column
Zhihu Tech Column
Dec 25, 2024 · Databases

Technical Challenges and Solutions for Migrating Zhihu's Self‑Managed MongoDB Cluster to Alibaba Cloud

The article analyzes the storage, sharding, backup, and operational pain points of Zhihu's self‑operated MongoDB cluster, proposes cloud‑based architectural and procedural solutions, and details a step‑by‑step migration plan that ensures zero‑downtime, improved stability, and cost efficiency.

Alibaba CloudDatabase MigrationMongoDB
0 likes · 11 min read
Technical Challenges and Solutions for Migrating Zhihu's Self‑Managed MongoDB Cluster to Alibaba Cloud
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Dec 19, 2024 · Databases

Data Consistency Verification Practices and Implementation at Xiaohongshu

Xiaohongshu built a lock‑free, non‑disruptive data‑consistency verification tool that automatically selects optimal methods, handles heterogeneous sources and dynamic changes, performs full and incremental checks via chunked checksums or row‑by‑row comparison, quickly isolates mismatches, and supports automatic remediation, ensuring reliable migrations and sharding.

Data ConsistencyDatabase MigrationDistributed Systems
0 likes · 16 min read
Data Consistency Verification Practices and Implementation at Xiaohongshu
vivo Internet Technology
vivo Internet Technology
Dec 4, 2024 · Databases

OceanBase Implementation and Migration Practices at vivo

vivo migrated five 20‑TB MySQL clusters to OceanBase using OCP, oblogproxy, and OMS, eliminating sharding costs, achieving over 70% storage savings, improving consistency and performance, and leveraging native distributed architecture, tenant isolation, and strong compression to support scalable, reliable operations.

Data CompressionDatabase MigrationOceanBase
0 likes · 16 min read
OceanBase Implementation and Migration Practices at vivo
MaGe Linux Operations
MaGe Linux Operations
Sep 11, 2024 · Databases

Master MySQL Upgrade: Key Tips, Commands, and Common Pitfalls

This guide details essential MySQL upgrade considerations, backup warnings, version‑specific changes, and step‑by‑step procedures for both in‑place and logical migrations, helping administrators safely move from MySQL 5.6 to 5.7 while avoiding common pitfalls.

Database MigrationLogicalSQL
0 likes · 7 min read
Master MySQL Upgrade: Key Tips, Commands, and Common Pitfalls
Xiaolei Talks DB
Xiaolei Talks DB
Sep 4, 2024 · Databases

Master Online TiDB Migration: Step‑by‑Step Guide for Cross‑Data‑Center Moves

This guide details three online TiDB migration scenarios—including placement‑rule replica placement, TiCDC with BR backup, and hybrid strategies—covering preparation, network and resource requirements, configuration commands, region balancing, PD leader transfer, and post‑migration cleanup for seamless cross‑data‑center database relocation.

BR BackupDatabase MigrationKubernetes
0 likes · 19 min read
Master Online TiDB Migration: Step‑by‑Step Guide for Cross‑Data‑Center Moves
High Availability Architecture
High Availability Architecture
Aug 27, 2024 · Backend Development

Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin

This article details the background, requirements, and evaluation of migration options for the appointment service, explains why a double‑write approach with a custom MyBatis plugin was chosen, and walks through the full‑sync, incremental sync, code refactoring, plugin implementation, switch‑over procedures, and post‑migration validation to achieve reliable data isolation and system stability.

Database MigrationJavaMyBatis
0 likes · 17 min read
Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin
ITPUB
ITPUB
Aug 16, 2024 · Databases

How Canva Scaled Its Media Service: From MySQL Limits to DynamoDB Migration

Canva’s media service, handling billions of assets, evolved from a MySQL‑based microservice architecture to a DynamoDB‑backed solution by incrementally migrating metadata, sharding tables, employing real‑time dual writes via SQS, and implementing zero‑downtime cut‑over, dramatically improving latency and scalability.

CanvaDatabase MigrationDynamoDB
0 likes · 14 min read
How Canva Scaled Its Media Service: From MySQL Limits to DynamoDB Migration
vivo Internet Technology
vivo Internet Technology
Aug 7, 2024 · Databases

MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools

While MySQL 5.7 native DDL methods (copy, inplace rebuild, index build, metadata‑only) vary in speed, space use, lock impact, and binlog output, GH‑OST consistently offers the fastest execution, lowest lock blocking, real‑time replication, albeit at roughly double storage cost, making it ideal for risk‑averse online schema changes.

DDLDatabase MigrationInnoDB
0 likes · 11 min read
MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools
Java Architect Essentials
Java Architect Essentials
Aug 2, 2024 · Databases

Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts

This article details the step‑by‑step process of switching a SpringBoot‑MyBatisPlus application from MySQL to PostgreSQL, covering driver integration, JDBC configuration changes, numerous SQL and type‑conversion pitfalls, and provides ready‑to‑run PostgreSQL scripts for bulk column adjustments and default values.

Database MigrationJavaPostgreSQL
0 likes · 11 min read
Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts
Zhuanzhuan Tech
Zhuanzhuan Tech
Jul 17, 2024 · Databases

Data Migration Strategies: Dual‑Write and Gray‑Scale Switch Approaches

This article presents two practical database migration schemes—dual‑write and a gray‑scale switch—detailing their workflows, code refactoring, data synchronization using Syncer, consistency verification with sync‑diff‑inspector, and operational trade‑offs for minimizing downtime and ensuring data integrity.

Database MigrationGray SwitchSyncer
0 likes · 13 min read
Data Migration Strategies: Dual‑Write and Gray‑Scale Switch Approaches
Continuous Delivery 2.0
Continuous Delivery 2.0
Jul 4, 2024 · Databases

Designing Bugzilla for Multi‑Database Support: A Case Study

The article recounts how the Bugzilla project, originally tied to a single proprietary database (OldDB), was refactored to support multiple databases—including NewDB—through a comprehensive redesign that involved breaking the work into smaller, well‑tested tasks, improving maintainability and expanding support to four database systems.

Database MigrationMulti-Database Supportbugzilla
0 likes · 6 min read
Designing Bugzilla for Multi‑Database Support: A Case Study
dbaplus Community
dbaplus Community
Jun 10, 2024 · Backend Development

How to Seamlessly Switch a SpringBoot MyBatisPlus Project from MySQL to PostgreSQL

This guide walks you through migrating a SpringBoot + MyBatis‑Plus application from MySQL to PostgreSQL, covering driver addition, JDBC configuration changes, common SQL syntax pitfalls, transaction handling quirks, and provides batch scripts for schema adjustments and type conversions to ensure a smooth transition.

Database MigrationMybatisPlusPostgreSQL
0 likes · 12 min read
How to Seamlessly Switch a SpringBoot MyBatisPlus Project from MySQL to PostgreSQL
ITPUB
ITPUB
May 25, 2024 · Backend Development

How Infisical Migrated from MongoDB to PostgreSQL and What You Can Learn

Infisical’s engineering team recounts their three‑month journey of moving from MongoDB to PostgreSQL, detailing the motivations, technical challenges, ORM choices, migration planning, execution steps, and the performance and reliability gains achieved after the switch.

Database MigrationInfisicalKnex.js
0 likes · 13 min read
How Infisical Migrated from MongoDB to PostgreSQL and What You Can Learn
Tencent Cloud Developer
Tencent Cloud Developer
May 16, 2024 · Mobile Development

Technical Architecture Upgrade of Mobile QQ: Decoupling, Refactoring, and NT Architecture Evolution

The article chronicles Mobile QQ’s transformation from a 20‑year‑old monolithic codebase riddled with technical debt into a modular, cross‑platform system by decoupling business modules, refactoring millions of lines of code, introducing a unified C++ NT architecture, and implementing extensive migration, testing, and performance optimizations that cut compilation time by half and dramatically improve development efficiency.

Database MigrationMobile Developmentarchitecture refactoring
0 likes · 13 min read
Technical Architecture Upgrade of Mobile QQ: Decoupling, Refactoring, and NT Architecture Evolution
Java High-Performance Architecture
Java High-Performance Architecture
May 15, 2024 · Databases

Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Production – A Cautionary Tale

A developer used MySQL’s INSERT INTO SELECT to migrate millions of rows, causing full‑table scans, OOM errors and lost payment records, leading to a costly incident; the post analyzes the root causes, explains transaction locking behavior, and offers practical indexing and testing safeguards.

Database MigrationINSERT INTO SELECTfull table scan
0 likes · 7 min read
Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Production – A Cautionary Tale
dbaplus Community
dbaplus Community
May 12, 2024 · Databases

Why Infisical Switched from MongoDB to PostgreSQL—and How They Did It

Infisical, an open‑source secret‑management platform, migrated its data store from MongoDB to PostgreSQL to overcome transaction, schema, and cloud‑provider limitations, detailing the decision process, ORM choice, migration planning, execution steps, and the performance and usability benefits achieved.

Database MigrationInfisicalKnex.js
0 likes · 13 min read
Why Infisical Switched from MongoDB to PostgreSQL—and How They Did It
Java Tech Enthusiast
Java Tech Enthusiast
May 9, 2024 · Databases

Risks of Using INSERT INTO SELECT in MySQL: A Postmortem

Using MySQL’s INSERT INTO SELECT on a large, unindexed table caused full‑table locks that timed out concurrent transactions, leading to lost payment rows; the post‑mortem shows that adding appropriate indexes to the WHERE clause and understanding locking behavior prevents such intermittent failures.

Database MigrationINSERT INTO SELECTmysql
0 likes · 6 min read
Risks of Using INSERT INTO SELECT in MySQL: A Postmortem
Top Architect
Top Architect
Apr 23, 2024 · Databases

Using Flyway for Database Version Management and Migration in Spring Boot

This article introduces Flyway as a database migration tool, explains its migration types and common commands, demonstrates how to integrate Flyway with Spring Boot using Maven and YAML configurations, provides example SQL migration scripts and logs, and briefly mentions related community promotions.

Database MigrationFlywaySQL
0 likes · 14 min read
Using Flyway for Database Version Management and Migration in Spring Boot
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.

Database MigrationPolarDBdistributed database
0 likes · 12 min read
How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB
Architect
Architect
Apr 17, 2024 · Databases

How We Split a 500‑Million‑Row MySQL Table: Process, Pitfalls, and Lessons

Facing a 50‑million‑row financial transaction table that grew 6 million rows per month, the team analyzed the problem, set clear split goals, evaluated sharding middleware, designed a custom pagination algorithm, built a hybrid data‑migration plan, and executed a three‑stage rollout to safely replace the monolithic table with multiple 10‑million‑row shards.

BackendDatabase MigrationLarge Tables
0 likes · 13 min read
How We Split a 500‑Million‑Row MySQL Table: Process, Pitfalls, and Lessons
dbaplus Community
dbaplus Community
Mar 31, 2024 · Databases

How to Seamlessly Upgrade MySQL 5.7 to 8.0: Step‑by‑Step Guide and Common Pitfalls

This article walks through the complete process of upgrading MySQL 5.7.43 to 8.0.34 on CentOS 7, covering lifecycle background, new 8.0 features, pre‑upgrade checks, data backup, configuration changes, installation, upgrade execution, post‑upgrade verification, and troubleshooting of typical SSL and host‑blocking issues.

Database MigrationLinuxSQL
0 likes · 21 min read
How to Seamlessly Upgrade MySQL 5.7 to 8.0: Step‑by‑Step Guide and Common Pitfalls