BestHub
Sign in
Tagged articles

database migration

290 articles · Page 1 of 3
ITPUB
ITPUB
Sep 11, 2026 · R&D Management

From DBA to Tech Lead: Wang Le on Database Migration, Platform Engineering, and Open Source Growth

Vivo database lead Wang Le shares a decade of experience spanning Oracle-to-MySQL migration, domestic database replacement, gh-ost bug fixes, and building automation platforms, revealing how DBAs can evolve into technical leaders through continuous learning and long-term thinking.

DBA Career GrowthDomestic Database ReplacementOpen Source Contribution
0 likes · 18 min read
From DBA to Tech Lead: Wang Le on Database Migration, Platform Engineering, and Open Source Growth
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.

Jackson 3.0JavaMyBatis-Plus
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.

BinlogGTIDMySQL
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.

GoORMSQLite
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.

AICloud InfrastructureCost Management
0 likes · 11 min read
CFO’s No‑Code AI App Triggers a Month’s Server Bill in One Day
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.

DeWuMulti-Model DatabaseOceanBase
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 OperationsLLM Cost
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.

DDLFlywayKubernetes
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.

IndexingJSONBJava integration
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
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.

BIGINTConcurrencyMySQL
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.

Cost OptimizationDragonflyDBRedis
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.

FlywayLiquibaseSpring Boot
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 DorisIndexingMySQL
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.

DockerKingbasePostgreSQL 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.

MySQLOnline DDLdatabase migration
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.

AIDBADialect Conversion
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.

DDLOceanBaseOffline DDL
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 TemplatesCRUDLaravel
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 TABLEJSON columnMySQL
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.

EOLMariaDBMySQL
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.4Deprecated featuresMySQL
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.

DBaaSMariaDBMySQL
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.0MySQL
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.

JSON fieldMySQLOnline DDL
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.

Index BloatMySQLPostgreSQL
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.

BIGINTINT overflowMySQL
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.

TiDBdatabase migrationhigh availability
0 likes · 12 min read
How Meiyou Scaled Overseas Messaging with TiDB Architecture
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.

DDLMySQLdatabase migration
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.

JDBCMySQLPostgreSQL
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.

Domain SchedulingMySQLdatabase migration
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.

BackendGray ReleaseJImKV
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.

BIGINTMySQLauto-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.

Cloud Computingdatabase migrationmiddleware
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.

Multi‑TenantOceanBasePerformance Optimization
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 ResolvePITRPigsty
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.

MongoDBNoSQLPerformance Optimization
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.

DataXOceanBasePolarDB
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 DorisElasticsearchReal-time Analytics
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.

MongoDBarchitecturedatabase migration
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.

MongoDBPerformancedatabase migration
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.

FlinkOceanBasePerformance
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 CloudCloud ComputingMongoDB
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 ConsistencyData ValidationMySQL
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.

MySQLOceanBasedata compression
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.

LogicalMySQLSQL
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 BackupKubernetesPlacement Rules
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.

JavaMyBatisMySQL
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.

CanvaDynamoDBMedia Service
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.

DDLInnoDBMySQL
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.

JavaMySQLPostgreSQL
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.

Gray SwitchMySQLSyncer
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.

Multi-Database Supportbugzillacode refactoring
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.

MybatisPlusPostgreSQLSQL pitfalls
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.

InfisicalKnex.jsMongoDB
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.

Architecture RefactoringMobile Developmentcross-platform
0 likes · 13 min read
Technical Architecture Upgrade of Mobile QQ: Decoupling, Refactoring, and NT Architecture Evolution
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.

InfisicalKnex.jsMongoDB
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.

INSERT INTO SELECTMySQLdatabase migration
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.

FlywaySQLSpring Boot
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.

MySQLPolarDBdatabase migration
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.

BackendMySQLPerformance
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.

ConfigurationLinuxMySQL
0 likes · 21 min read
How to Seamlessly Upgrade MySQL 5.7 to 8.0: Step‑by‑Step Guide and Common Pitfalls
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.

Local IndexOceanBaseOracle
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.

AntDBPostgreSQL ParametersSQL Refactoring
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.

Distributed ArchitectureHTAPMySQL
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 SensitivityMySQLReplication
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.

File MigrationLogical MigrationPhysical 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.

INSERT INTO SELECTMySQLdatabase migration
0 likes · 6 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL: OOM, Full Table Scan, and Transaction Issues