When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 replica.

This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server with Percona XtraBackup.

In my lab, we have two test nodes:

PRIMARY:  mysql57 (192.168.56.111)    with   Percona Server 5.7 and  xtrabackup 2.4 installed
REPLICA:  mysql8    (192.168.56.113)   with  Percona Server 8  and   xtrabackup 8.0 installed

0. Pre-flight check with MySQL upgrade checker utility

Let’s run the MySQL upgrade checker utility to verify whether MySQL 5.7 server instances are ready for an upgrade.

MySQL  localhost  JS > util.checkForServerUpgrade('root@localhost:3306', {"password":"####", …

Today, the book I would like to recommend is Efficient MySQL Performance – Best Practices and Techniques, Daniel Nichter, O’Reilly, 2021. Best Practices and Techniques is a comprehensive guide to optimizing the performance of MySQL databases. Whether you’re a developer, database administrator, or system administrator, this book can provide valuable insights and techniques to help […]

MySQL Book Review: Efficient MySQL Performance from Daniel Nichter, O'Reilly, 2021.

For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. Is this related to the increase of microservices? In a microservices architecture, services are typically designed to be small, loosely coupled, and independently deployable. Each service may have its own database, which […]

For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. This article illustrates how to use FEDERATED tables in MySQL.

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.40 (release notes, download) and MySQL-wsrep 8.0.31 (release notes, download) with Galera replication library 4.14 (release notes, download) implementing wsrep API version 26. …

This blog gives details of the new feature introduced in MySQL 8.0.29 using which column(s) can be added/dropped to/from a table with ALGORITHM=INSTANT.

MySQL Summit 2023 is right around the corner. If you consider yourself a *true* fan of the Dolphin, but haven’t made plans to attend this free event either in-person (Redwood Shores, CA) or online, you’ll be missing out on a critical chance to hone your MySQL skills by learning best practices directly from MySQL engineers. […]

Free MySQL Summit Day - March 23rd, in-person and virtual. See main reasons to attend and agenda.

In this tutorial, we’ll be going over every step of how to install MySQL on AlmaLinux. Database servers are the ...

Read More

The post How to Install MySQL on AlmaLinux appeared first on RoseHosting.