BestHub
Sign in
Tag

database migration

1 views collected around this technical thread.

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.

Distributed DatabasesOceanBasePerformance Optimization
0 likes · 12 min read
How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey
Java Captain
Java Captain
May 24, 2025 · Databases

Migrating a Project from MongoDB to MySQL: Design Considerations and Demo

This article discusses the motivations, comparative analysis, and practical steps for refactoring a Java backend project by replacing MongoDB with MySQL, covering pain points, selection criteria, schema redesign, entity mapping, and sample query code.

Backend DevelopmentJavaMongoDB
0 likes · 14 min read
Migrating a Project from MongoDB to MySQL: Design Considerations and Demo
Aikesheng Open Source Community
Aikesheng Open Source Community
May 21, 2025 · Databases

Understanding OMS Inmode Validation Anomalies in MySQL‑to‑OceanBase Migration

This article analyzes a puzzling case where data consistency checks between a MySQL source and an OceanBase target report matching results despite visible record differences, explains the OMS ordinary and Inmode validation modes, and outlines scenarios that trigger Inmode verification.

InmodeMySQLOMS
0 likes · 7 min read
Understanding OMS Inmode Validation Anomalies in MySQL‑to‑OceanBase Migration
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.

DataXOceanBasePerformance Tuning
0 likes · 14 min read
Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jan 25, 2025 · Databases

Master Flyway with Spring Boot 3: A Step‑by‑Step Migration Guide

This article announces a Spring Boot 3 practical case collection and provides a comprehensive Flyway tutorial—including installation, configuration, migration scripts, multi‑datasource usage, and visual verification—so developers can confidently manage database schema changes in Java backend projects.

FlywayJavaSpring Boot
0 likes · 10 min read
Master Flyway with Spring Boot 3: A Step‑by‑Step Migration Guide
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.

MongoDBOperationsPerformance
0 likes · 12 min read
How Zhihu Solved MongoDB Scaling Pain Points with a Cloud 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 CloudMongoDBOperational Efficiency
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.

Distributed SystemsMySQLdata consistency
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.

Distributed DatabaseMySQLOceanBase
0 likes · 16 min read
OceanBase Implementation and Migration Practices at vivo
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 5, 2024 · Databases

Using WM_CONCAT in OceanBase 3.x: Restoring Order with NO_REWRITE Hint

This article explains how to replace Oracle's XMLAGG with OceanBase's WM_CONCAT, analyzes why the result order is lost in OceanBase 3.x, demonstrates reproduction steps, shows that adding a NO_REWRITE hint restores ordering, and provides the final SQL solution and notes for OceanBase 4.x.

HintOceanBaseSQL
0 likes · 9 min read
Using WM_CONCAT in OceanBase 3.x: Restoring Order with NO_REWRITE Hint
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 10, 2024 · Databases

Understanding MySQL SQL_MODE: Values, Settings, and Migration Practices

This article explains MySQL's SQL_MODE system variable, its default values for different versions, common configuration options, how it influences data validation and migration, and provides practical code examples for adjusting and testing SQL_MODE settings.

MySQLSQL Settingsdata validation
0 likes · 13 min read
Understanding MySQL SQL_MODE: Values, Settings, and Migration Practices
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 BackupPlacement RulesTiCDC
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.

Double WriteJavaMyBatis
0 likes · 17 min read
Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin
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.

BugzillaMulti-Database Supportcode refactoring
0 likes · 6 min read
Designing Bugzilla for Multi‑Database Support: A Case Study
Top Architect
Top Architect
Jun 18, 2024 · Databases

Migrating a SpringBoot MySQL Project to PostgreSQL: Process, Pitfalls, and Helper Scripts

This article details how to switch a SpringBoot + MybatisPlus + MySQL project to PostgreSQL by adding the driver, updating JDBC settings, handling numerous SQL and type‑conversion pitfalls, and provides ready‑to‑run PostgreSQL scripts for bulk column modifications and default‑value settings.

JavaMySQLPostgreSQL
0 likes · 14 min read
Migrating a SpringBoot MySQL Project to PostgreSQL: Process, Pitfalls, and Helper Scripts
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 13, 2024 · Databases

Diagnosing “Server Internal Error” in OceanBase OMS OCP Association: A Case Study

This article walks through a real‑world OceanBase OMS migration case where adding an OCP association triggers a “Server Internal Error”, detailing log analysis, metadb schema inspection, OAT deployment checks, the impact of the MySQL “-f” flag, a temporary fix, and the root‑cause conclusion.

MetadbOCPOMS
0 likes · 8 min read
Diagnosing “Server Internal Error” in OceanBase OMS OCP Association: A Case Study