MySQL 8

on YouTube ↗34m

" summary

Step-by-step runbook for an in-place move to MySQL 8.4: run the MySQL Shell upgrade checker, migrate deprecated plugins to components, convert any MySQL native auth users and UTF8MB3 schemas, test an upgraded replica first, capture and sample real queries and replay them with pt-upgrade and PT-query-digest, validate replication with PT-table-checksum, take a verified backup and watch error logs and PMM metrics; Percona reports upgrading hundreds of servers across versions with zero rollbacks.

AI-written summary · about

" chapters (11)

1. 0:00MySQL 8.4 upgrade best practices
2. 1:07Upgrade to MySQL 8.4 now
3. 2:32Supported upgrade paths
4. 4:41Key changes affecting upgrades
5. 9:37Pre-upgrade checks and prep
6. 14:15Why upgrade testing is critical
7. 17:03Query compatibility testing with PT
8. 22:37Upgrade testing workflow
9. 27:36Production upgrade safely
10. 30:07Post-upgrade validation
11. 31:32Percona MySQL upgrade help

" related talks

• 48mReducing Risk Before Upgrading MySQLKenny Gryp, Tom De Cooman · Percona Live Open Source Database Conference 2017
• 50mMySQL 8.0 at 4. Where are we now?Simon J Mudd · Percona Live 2022
• 53mMigrating Meta to MySQL 8.0Herman Lee, Pradeep Nayak · Percona Live 2022
• 37m8.0 New FeaturesDave Stokes · Open Source 101 at Home 2020
• 21mSwitching from MySQL/Percona to MariaDBPramod Mahto · MariaDB OpenWorks 2023
• 42mOMG MySQL 8.0 is out! Are we there yet?Gabriela D'Avila Ferrara · Laracon EU 2018
• 34mMySQL 8.0 New FeaturesDave Stokes · Open Source Summit + Embedded Linux Conference + OSPOCon 2021
• 36mOMG MySQL 8.0 is out! Are we there yet?Gabriela D'Avila Ferrara · Dutch PHP Conference 2018