schema migration

Aikesheng Open Source Community

Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

Database TroubleshootingJSONMySQL

0 likes · 7 min read

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

DevOps Cloud Academy

May 29, 2023 · Databases

Best Database Schema Migration Tools: CLI, GUI, and GitOps/Database-as-Code Solutions

Database schema changes are among the riskiest development tasks, and this article reviews top migration tools—from basic CLI clients like mysql and psql, through popular GUIs such as phpMyAdmin and DBeaver, to modern GitOps/Database-as-Code solutions like Liquibase, Flyway, Sqitch, Atlas, Prisma, and Bytebase—highlighting their features, pricing, and collaboration capabilities.

DatabaseDevOpsGUI

0 likes · 9 min read

Best Database Schema Migration Tools: CLI, GUI, and GitOps/Database-as-Code Solutions

DevOps Cloud Academy

Feb 15, 2023 · Databases

Using Bytebase for Database DevOps: A Step‑by‑Step Experience

This article walks through a hands‑on experience of deploying Bytebase via Docker‑Compose, configuring test and production environments, adding database instances, linking them to projects, performing a schema change with SQL, verifying the update, and completing the associated work‑order, offering practical insights for database DevOps practitioners.

BytebaseDatabase DevOpsDocker Compose

0 likes · 5 min read

Using Bytebase for Database DevOps: A Step‑by‑Step Experience

Architecture Digest

Feb 26, 2021 · Databases

Adding a Column to a Massive MySQL Table Safely

This article explains practical strategies for adding a new column to a MySQL table with tens of millions of rows, including creating a temporary table, copying data, renaming tables, and alternative replica‑based or third‑party methods to avoid long locks and potential crashes.

Data IntegrityMySQLadd column

0 likes · 4 min read

Adding a Column to a Massive MySQL Table Safely

Ctrip Technology

Sep 3, 2020 · Databases

Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0

This article details the design, evolution, and operational practices of Ctrip's MySQL database release system, covering its three major versions, the adoption of gh‑ost, safety mechanisms, real‑world case studies, and performance improvements that enable reliable, low‑impact schema changes at scale.

Database ReleaseMySQLautomation

0 likes · 14 min read

Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0

High Availability Architecture

Nov 14, 2019 · Databases

Why We Should Not Use Database Foreign Keys: Insights from a GitHub Engineer

A GitHub engineer argues that database foreign keys should be avoided because they shift integrity responsibilities to the DB, incur performance overhead, and cause complications during online schema migrations, illustrating the points with parent‑child tables, gh‑ost, and pt‑online‑schema‑change tools.

Foreign Keysdatabasesgh-ost

0 likes · 4 min read

Why We Should Not Use Database Foreign Keys: Insights from a GitHub Engineer

Aikesheng Open Source Community

Sep 18, 2019 · Databases

Understanding gh-ost Online DDL Migration Process and Cut‑over Mechanics

This article explains the internal workflow of the gh‑ost online DDL tool, covering its execution steps, binlog handling, data consistency analysis, cut‑over process, lock management, and failure scenarios, with detailed code examples and practical insights for safe schema changes in MySQL.

MySQLbinlogcut-over

0 likes · 15 min read

Understanding gh-ost Online DDL Migration Process and Cut‑over Mechanics

JD Retail Technology

Aug 16, 2019 · Databases

Online Schema Change in Distributed Databases: Insights from Google F1 and CB‑SQL

The article explains how distributed databases can perform online, asynchronous schema changes without blocking reads or writes by using lease‑based coordination, intermediate delete‑only and write‑only states, and a multi‑step algorithm inspired by Google F1 and implemented in CB‑SQL.

CB-SQLDistributed DatabasesGoogle F1

0 likes · 11 min read

Online Schema Change in Distributed Databases: Insights from Google F1 and CB‑SQL

Aikesheng Open Source Community

May 16, 2019 · Databases

Understanding MySQL 8.0 InnoDB DDL Operations and Their Cost Categories

This article explains how MySQL 8.0 InnoDB handles DDL statements, describes the five classification dimensions (Instant, In‑Place, Rebuild Table, Concurrent DML, Metadata‑only), provides examples of each cost level, and offers operational recommendations for safely applying schema changes.

DDLDatabase OperationsInnoDB

0 likes · 8 min read

Understanding MySQL 8.0 InnoDB DDL Operations and Their Cost Categories