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

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.

For this last technical post of the MySQL Community Advent Calendar 2022, I will explain how to grant privileges to users in MySQL 8.0. This is an important task for anyone who is responsible for managing a MySQL database, as it allows you to control which users have access to which parts of your database. […]

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.

Since MySQL 8.0.30, the Dynamic InnoDB Redo Log is a new feature that allows users to resize the redo log files on the fly without the need for a restart. This is a significant improvement over previous versions of MySQL, where the redo log files had to be manually resized and the database had to […]

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.