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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
