Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”

The program “MySQL Chōng Chōng Chōng” (Season 1, Episode 1) was launched on Bilibili on August 27, sponsored by the Aikesheng open‑source community and the IMG community. Host Jiang Chengyao introduces the topic: whether it is a good time to upgrade to MySQL 8.0.

Three top‑voted features from a recent Inside MySQL poll are examined:

1. Fast Add‑Column – an online, near‑instant column addition that eliminates the need for pt‑osc and reduces operational impact, especially for large tables.

2. Atomic DDL – conversion of metadata tables from MyISAM to InnoDB, making DDL operations fully atomic and reducing crash‑recovery issues, paving the way for transactional DDL.

3. Hash Join – introduced in MySQL 8.0.18, allowing the optimizer to use hash joins when no suitable index exists, with disk‑based fallback for large datasets, though multi‑threaded support is still limited.

Additional topics include Group Replication (MGR) improvements in 8.0 versus 5.7, and the change in authentication from native_password to sha256, with guidance on maintaining compatibility during upgrades.

The host strongly recommends upgrading to MySQL 8.0 now, citing two‑year maturity, continuous feature releases in minor versions, and widespread adoption in financial institutions.

Thanks are given to the Aikesheng community for their support, and a preview of the next episode is provided: “MySQL DBA Career Development – Will You Be Laid Off at 35?” with a mystery guest.

Live streaming details: Bilibili link https://live.bilibili.com/22230895, every Thursday 20:30‑21:30, host Jiang Chengyao, guests vary.