Tagged articles
database upgrade
26 articles · Page 1 of 1
This comprehensive guide details 20 critical technical checks for migrating from MySQL 5.7 to 8.0, covering authentication plugins, character sets, reserved words, strict SQL modes, replication setup, backup validation, and cutover procedures with executable SQL and bash examples.
AuthenticationDatabase MigrationMySQL
0 likes · 23 min read

This article explores MySQL 9.7's key innovations including native VECTOR type for semantic search, JavaScript stored procedures for in-database logic, parallel bulk import from object storage, and security upgrades like mandatory caching_sha2_password, with practical code examples and upgrade guidance.
Innovation releaseJavaScript stored proceduresMySQL 9.7
0 likes · 18 min read

This article details the TiDB upgrade journey from version 5.3.3 to 7.5.x, covering architecture, new v7 features, migration strategies, encountered problems with full‑table scans and inaccurate aggregation plans, the solutions applied, and the measurable performance and stability gains achieved after the upgrade.
NewSQLTiDBdatabase upgrade
0 likes · 15 min read

This article introduces Pika 3.5.x’s major enhancements—including a new sync mechanism, expanded Redis command support, RocksDB upgrades, BlobDB, containerization, observability tools, ACL and transaction support—while providing a step‑by‑step upgrade procedure, optional data synchronization, and two rollback strategies for safe migration.
PikaRedis CompatibilityRocksDB
0 likes · 17 min read

After upgrading an RDS MySQL instance from 5.6 to 8.0, the same ORDER BY query became dozens of times slower, and this article walks through step‑by‑step analysis, profiling, source‑code inspection, and the root cause behind the performance regression.
MySQLRDSbpftrace
0 likes · 11 min read

This article analyzes the MySQL 1709/1071 index‑column‑size‑too‑large error that appears after upgrading from 5.6 to 8.0.21, explains its relation to compact/redundant row formats, references the underlying bug, and provides practical steps and SQL queries to detect and fix affected tables before or after the upgrade.
Error 1709IndexMySQL
0 likes · 12 min read


21CTOJul 7, 2024 · Databases
Oracle’s July release introduces MySQL 9.0 Innovation alongside updates to 8.0 and the LTS 8.4 series, bringing new Vector data types, JavaScript stored procedures, upgraded libraries, event scheduling enhancements, and deprecations such as SHA‑1, while outlining future release cadence and upgrade considerations.
9.0Feature deprecationJavaScript stored procedures
0 likes · 5 min read

This article explains why MySQL columns defined as INT(10) appear as INT after upgrading from 5.7 to 8.0, demonstrates the change with reproducible examples, and discusses the storage limits, proper selection, and display‑width behavior of integer types including ZEROFILL.
Integer TypesMySQLSQL
0 likes · 9 min read

Facing MySQL 5.7’s February 2024 end‑of‑life, the team devised a zero‑impact blue‑green migration on AWS RDS to MySQL 8.0.35, using util.checkForServerUpgrade() compatibility checks, pt‑upgrade SQL validation, and a rapid 2‑minute switchover that completed within the planned low‑traffic window.
AWS RDSCompatibility CheckMySQL
0 likes · 12 min read

GitHub detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from version 5.7 to 8.0, describing the motivations, infrastructure scale, preparation steps, a staged rollout plan, rollback strategies, challenges faced, and key lessons learned for large‑scale database migrations.
GitHubHigh AvailabilityMySQL
0 likes · 16 min read


ITPUBNov 1, 2023 · Databases
After upgrading a Doris cluster from version 1.2.3 to 2.0.2, the author runs a series of SQL benchmarks—including PK lookups, top‑client queries, distinct counts on low‑ and high‑cardinality columns, minute‑level session analysis, and full‑table deduplication—to measure execution times, revealing mixed performance gains and regressions across the seven test scenarios.
DorisSQLdatabase upgrade
0 likes · 9 min read


ITPUBSep 3, 2023 · Databases
With MySQL 5.7 reaching end‑of‑life, this guide explains why you should upgrade to MySQL 8.0, outlines the new SQL capabilities and tools, and compares migration options including DBaaS and switching to PostgreSQL, helping you choose the best path for your workloads.
DBaaSMySQLPostgreSQL
0 likes · 8 min read

MySQL introduces Innovation and Long‑Term Support (LTS) release tracks, offering faster feature delivery for Innovation builds and stable, minimal‑change updates for LTS, while outlining new version cadence, HeatWave service options, deprecation policies, and detailed upgrade‑downgrade paths for developers and DBAs.
HeatWaveLTSMySQL
0 likes · 15 min read

This article provides a comprehensive step‑by‑step guide for senior DBAs to upgrade an online TiDB 2.1.x cluster to version 4.0.13 via data migration, detailing environment assessment, configuration changes, component deployment, full and incremental data transfer, consistency verification, permission synchronization, and traffic switchover.
AnsibleTiDBcluster management
0 likes · 26 min read

The first episode of the “MySQL Chōng Chōng Chōng” livestream discusses why now is an excellent time to upgrade to MySQL 8.0, covering fast add‑column, Atomic DDL, Hash Join, Group Replication, authentication changes, and includes thanks to sponsors and a preview of the next show.
Atomic DDLFast Add ColumnGroup Replication
0 likes · 9 min read

Didi's HBase team upgraded eleven clusters from version 0.98 to 1.4.8, tackling maintenance burdens and custom‑patch divergence, validating RPC and HFile compatibility, performing extensive functional and performance tests, opting for a rolling upgrade, fixing a region‑split data‑loss bug, merging critical upstream patches, and establishing a reusable migration methodology.
DidiHBaseRolling Upgrade
0 likes · 10 min read


ITPUBDec 20, 2019 · Databases
This tutorial walks through three practical experiments for upgrading Oracle databases to 19c: inserting a non‑CDB into a CDB, using Full Transportable Export/Import to move tablespaces, and plugging a 12c PDB into a 19c CDB, each illustrated with detailed steps, scripts and screenshots.
19cCDBOracle
0 likes · 10 min read


ITPUBDec 19, 2019 · Databases
This guide walks through upgrading an Oracle database to 19c, comparing pre‑ and post‑upgrade performance with HammerDB and AWR snapshots, using SQL Performance Analyzer and SQL Plan Management to evaluate SQL tuning sets, applying SQL Tuning Advisor recommendations, and finally automating the upgrade with the AutoUpgrade tool and post‑upgrade compatibility adjustments.
AutoUpgradeHammerDBOracle
0 likes · 11 min read


ITPUBDec 18, 2019 · Databases
This tutorial walks you through preparing a virtual‑machine environment, generating workload and AWR snapshots with HammerDB, capturing and exporting SQL tuning sets, performing a manual upgrade from Oracle 11.2 to 19c, and comparing performance before and after the upgrade, all with detailed commands and screenshots.
19cAWRHammerDB
0 likes · 12 min read

This article explains why enterprises should upgrade to Oracle 12cR2, outlines its key new features such as Multitenant, In‑Memory and Sharding, compares patch counts with earlier releases, details common bugs and work‑arounds, and provides recommended parameters and upgrade references for a smooth migration.
12cR2Oraclebug fixes
0 likes · 16 min read

This article explains the importance of upgrading PostgreSQL to benefit from new features and security fixes, compares traditional upgrade methods, introduces the PGQ replication system, and provides a detailed step‑by‑step guide for performing a major version upgrade with minimal downtime.
ConfigurationPGQPostgreSQL
0 likes · 11 min read

The article explains Oracle 12c Release 2's launch, decodes its version numbering, highlights new capabilities such as Global Service Manager, In‑Memory, Multitenant and Sharding, compares parameter growth across releases, and offers practical upgrade timelines and key parameter recommendations.
12cR2In-MemoryOracle
0 likes · 9 min read

This guide walks through upgrading an Oracle MAA environment from 11.2.0.4 to 12.1.0.2 with no front‑end service interruption, covering environment overview, two Data Guard switchover cycles, transient logical standby conversion, rolling patch execution with physru.sh, and post‑upgrade cleanup steps.
DBUAData GuardGrid Infrastructure
0 likes · 21 min read

This article consolidates Oracle ACS architect Zhou Guohong's comprehensive guide on selecting upgrade paths, outlining phase‑by‑phase tasks, highlighting key success factors, and answering common questions about migration tools such as Transportable Tablespaces, Data Pump, and GoldenGate.
Data PumpGoldenGateOracle
0 likes · 10 min read


21CTONov 28, 2015 · Databases
This article examines several MySQL issues—including key partition hash algorithm changes causing data loss after upgrades, a client crash triggered by misdirected dump output, GTID_PURGED interactions that break AUTO_POSITION replication, and replicate‑do‑db filtering effects on GTID continuity—and provides concrete compatibility fixes and troubleshooting steps.
GTIDReplicationdatabase upgrade
0 likes · 18 min read

A community discussion weighs the benefits and drawbacks of upgrading Oracle 10gR2 to 11g, sharing real‑world experiences, technical pitfalls like ORA‑24247, alternative viewpoints, and guidance for DBAs deciding whether the upgrade is worth the effort.
10g11gBest Practices
0 likes · 8 min read
