Database upgrade

360 Zhihui Cloud Developer

Sep 11, 2024 · Databases

Upgrade Pika to 3.5.x: Key New Features, Migration Guide & Rollback Tips

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.

Database upgradePikaRedis compatibility

0 likes · 17 min read

Upgrade Pika to 3.5.x: Key New Features, Migration Guide & Rollback Tips

Aikesheng Open Source Community

Jul 16, 2024 · Databases

How to Resolve MySQL "Index column size too large" (Error 1709) After Upgrading to 8.0.21

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.

Database upgradeDynamicError 1709

0 likes · 12 min read

How to Resolve MySQL "Index column size too large" (Error 1709) After Upgrading to 8.0.21

Aikesheng Open Source Community

Jun 18, 2024 · Databases

MySQL INT Type Changes After Upgrading from 5.7 to 8.0 and How to Choose Integer Types

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.

Database upgradeInteger TypesMySQL

0 likes · 9 min read

MySQL INT Type Changes After Upgrading from 5.7 to 8.0 and How to Choose Integer Types

37 Interactive Technology Team

Jun 17, 2024 · Databases

MySQL 5.7‑to‑8.0 Upgrade Plan, Compatibility Checks, and Blue‑Green Deployment on AWS RDS

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 CheckDatabase upgrade

0 likes · 12 min read

MySQL 5.7‑to‑8.0 Upgrade Plan, Compatibility Checks, and Blue‑Green Deployment on AWS RDS

Aikesheng Open Source Community

Apr 7, 2022 · Databases

TiDB 2.1.x to 4.0.13 Upgrade and Data Migration Guide

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.

AnsibleCluster ManagementDatabase upgrade

0 likes · 26 min read

TiDB 2.1.x to 4.0.13 Upgrade and Data Migration Guide

Aikesheng Open Source Community

Sep 3, 2020 · Databases

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

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 DDLDatabase upgradeFast Add Column

0 likes · 9 min read

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

Didi Tech

Jun 9, 2020 · Databases

Didi HBase Team’s Upgrade from 0.98 to 1.4.8: Challenges, Solutions, and Lessons Learned

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.

CompatibilityDatabase upgradeDidi

0 likes · 10 min read

Didi HBase Team’s Upgrade from 0.98 to 1.4.8: Challenges, Solutions, and Lessons Learned

Qunar Tech Salon

Nov 16, 2017 · Databases

Why Upgrade PostgreSQL and How to Perform a Major Version Upgrade Using PGQ

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.

Database upgradePGQPostgreSQL

0 likes · 11 min read

Why Upgrade PostgreSQL and How to Perform a Major Version Upgrade Using PGQ