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: …

Hello MySQL enthusiasts!

We are excited to announce the schedule for the MySQL & Friends devroom at FOSDEM 2023. This year’s devroom will feature a diverse lineup of talks and presentations focused on MySQL.

The program is still in draft form as we await confirmation of accepted speakers.

We encourage you to mark your calendars and join us for what promises to be an engaging and informative event.

In addition, don’t miss the chance to extend your stay in Belgium and participate to the preFOSDEM MySQL Days that will take place on 2nd and 3rd February 2023. Registration here.

Sunday, Feb 5th

'MySQL Shorts' is a series of short instructional videos that highlight MySQL features and functionality.

In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a…

The post Restore single MySQL table (ibd) from Xtrabackup (video demo) first appeared on Change Is Inevitable.

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant…

The post MySQL Interview – ChatGPT is not your DBA first appeared on Change Is Inevitable.

MySQL Community Advent Calendar 2022 - How to generate a slow query log using MySQL Shell on Oracle Cloud Infrastructure (OCI) MySQL HeatWave. The slow query log is a valuable tool for identifying and troubleshooting performance issues with MySQL database queries.

Using MySQL Shell, we can import JSON data into JSON column in a database table. Take a look at the steps involved.

In my previous post about InnoDB Stalls on Empty Free List, I used a test environment that might look a little artificial : a table larger than the InnoDB Buffer Pool but fitting in the Linux Page Cache.  This configuration allows serving very quickly what MySQL thinks are IOs because these are hit in the filesystem cache.  In this post, I explain why this environment is not

Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in a controlled manner that does not disrupt application users or cause application downtime.

One of the tools in Percona Toolkit is pt-online-schema-change, a utility that alters the structure of a table without interfering with the reads or writes. The tool creates an empty copy of the table to alter and modify as desired before copying the rows from the original table into the new one.

When the copying is finished, it removes the original table and replaces it with the new one. Any changes made to data in the original tables during the copy process will be reflected in the new table as the tool creates triggers on …