MySQL HeatWave Database Service is available globally in 34 Oracle Cloud Infrastructure commercial regions. The most recent addition is Chicago in the United States.

MySQL Community Advent Calendar 2022 - In this blog post, we will discuss how to display long transactions in MySQL 8.0.

We recently covered Upgrading your Galera Cluster from MySQL 5.7 to MySQL 8.0. We’ve also had questions on how the upgrade path from our usual Galera Cluster “community” edition to the Galera Cluster Enterprise Edition (EE), which includes many new features, like XA transaction support, arm64 support or GCache encryption.

First off, let’s start by installing a Galera Cluster on CentOS 7. The reason we have picked this distribution? Let’s edit the /etc/yum.repos.d/galera.repo and add:

[galera4]
name = Galera
baseurl = https://releases.galeracluster.com/galera-4/centos/7/x86_64
gpgkey = https://releases.galeracluster.com/GPG-KEY-galeracluster.com
gpgcheck = 1

[mysql-wsrep8]
name = MySQL-wsrep
baseurl = https://releases.galeracluster.com/mysql-wsrep-8.0/centos/7/x86_64
gpgkey = …

AlmaLinux generally has Java installed. You can check whether java is installed with this command:

which -a java

It should return:

/usr/bin/java

Then, you can check the Java version with this command:

java -version

For AlmaLinux 9, it should return:

openjdk version "11.0.17" 2022-10-18 LTS
OpenJDK Runtime Environment (Red_Hat-11.0.17.0.8-2.el9_0) (build 11.0.17+8-LTS)
OpenJDK 64-Bit Server VM (Red_Hat-11.0.17.0.8-2.el9_0) (build 11.0.17+8-LTS, mixed mode, sharing)

Next, you check whether javac is installed. You can use the which command to determine whether it is installed. Generally, its not installed and you use this command to

sudo dnf search jdk | egrep -- '-17'

It should return:

Last metadata expiration check: 0:11:17 ago on Mon 19 Dec 2022 11:32:48 PM EST.
java-17-openjdk.x86_64 : OpenJDK 17 Runtime Environment
java-17-openjdk-demo.x86_64 …

MySQL Community Advent Calendar 2022 - In this blog post, we will show how to use Oracle Cloud Infrastructure (OCI) Serverless Functions and API Gateways to create logical dumps of a MySQL Database Service.

First, we will set up an OCI Serverless Function and an API Gateway, which will allow us to trigger the dump process via an HTTP request.

There’s so much great content across the internet. I do my best to share the best I can find each week in the OpenLampTech newsletter. Enjoy this week’s original and curated content. Thank you.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

This week in OpenLampTech issue #57, I’m sharing curated content on:

• A curated piece on JSON-Based SQL Injection
• WordPress backup file best practices
• Working with APIs in Laravel
• Using SQL Window functions for percentage calculations
• A new dev environment …

MySQL Community Advent Calendar 2022 - How to deploy Apache Airflow, a powerful tool for managing and scheduling pipelines, in OCI using MySQL HeatWave as backed store.

A holiday message from the MySQL Community Team!

MySQL Community Advent 2022 - in this blog post, we explore how MySQL 8.0 handles dates that are input incorrectly. This is an important topic to understand, as incorrect dates behaves differently between MySQL 5.x and MySQL 8.0.

Operators hide the complexity of the application and Kubernetes. Instead of dealing with Pods, StatefulSets, tons of YAML manifests, and various configuration files, the user talks to Kubernetes API to provision a ready-to-use application. An Operator automatically provisions all the required resources and exposes the application. Though, there is always a risk that the user would want to do something manual that can negatively affect the application and the Operator logic.

In this blog post, we will explain how to limit access scope for the user to avoid manual changes for database clusters deployed with Percona Operators. To do so, we will rely on Kubernetes Role-based Access Control (RBAC).

The goal

We are going to have two roles: …