schema change | BestHub

JD Retail Technology

Feb 20, 2025 · Big Data

Cold‑Hot Data Tiering Solutions for JD Advertising Using Apache Doris

JD Advertising built a petabyte‑scale ad analytics service on Apache Doris, identified a hot‑cold access pattern, and implemented a native cold‑hot tiering solution (upgrading to Doris 2.0 and optimizing schema changes) that cut storage costs by ~87% and boosted concurrent query capacity over tenfold while simplifying operations.

Apache DorisBig Datacold-hot tiering

0 likes · 18 min read

Cold‑Hot Data Tiering Solutions for JD Advertising Using Apache Doris

JD Tech

Feb 11, 2025 · Big Data

Cold‑Hot Data Tiering and Performance Optimization in Apache Doris for JD Advertising

This article presents JD Advertising's engineering experience with Apache Doris, describing the evolution from a data‑lake cold‑data solution to a native cold‑hot tiering approach, detailing performance regressions after upgrading to Doris 2.0, and outlining a series of optimizations for query speed, CPU and memory usage, schema‑change efficiency, and automated data migration and restoration.

Apache DorisBig Datacold-hot tiering

0 likes · 17 min read

Cold‑Hot Data Tiering and Performance Optimization in Apache Doris for JD Advertising

Aikesheng Open Source Community

Apr 18, 2023 · Databases

Schema Change for a 400‑Million‑Row MySQL Table Using Cascade Replication

This article details a step‑by‑step strategy for expanding a VARCHAR column from 50 to 500 characters on a 4‑hundred‑million‑row MySQL 8.0 table, evaluating online DDL, gh‑ost, pt‑osc, and ultimately implementing a cascade replication workflow to meet a four‑hour downtime window.

MySQLcascade replicationgh-ost

0 likes · 10 min read

Schema Change for a 400‑Million‑Row MySQL Table Using Cascade Replication

Aikesheng Open Source Community

Jul 30, 2020 · Databases

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

This article provides a comprehensive guide to gh-ost, the GitHub‑released online MySQL schema migration tool, covering its design principles, three migration modes, download and RPM installation, common command‑line options, interactive socket commands, and a step‑by‑step example of altering a column type while monitoring progress and performing a safe cut‑over.

Database ToolsLinuxMySQL

0 likes · 25 min read

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

JD Retail Technology

Jul 5, 2019 · Databases

Understanding MySQL Online DDL, PT-OSC, and GH-OST for Large Table Schema Changes

This article explains how MySQL performs DDL operations on large tables without long‑lasting locks, covering the evolution from copy‑table and in‑place methods to Fast Index Creation, Online DDL introduced in 5.6, and third‑party tools PT‑OSC and GH‑OST, with detailed process steps and comparisons.

MySQLdatabasesgh-ost

0 likes · 11 min read

Understanding MySQL Online DDL, PT-OSC, and GH-OST for Large Table Schema Changes