Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Generated Invisible Primary Key
MySQL 8.0.30 introduces the “Generated Invisible Primary Key” (GIPK) feature. This blog provides an introduction to this feature, discusses its limitations and restrictions, and describes how backup and restore operations work with this feature.Let’s get started! Background InnoDB storage engine incorporates an internal feature known as the Implicit Primary Key. This feature automatically generates a […]
MySQL Invisible Columns
Before MySQL 8.0.23, all user-defined columns in a table were always visible by default. However, starting from MySQL 8.0.23, a new feature called Invisible Columns was introduced, allowing users to hide specific columns within a table. With this feature, these invisible columns do not appear in the “SELECT *” query, providing a way to hide […]
MySQL 8 and Replication Observability
Many of us, old MySQL DBAs used Seconds_Behind_Source from SHOW REPLICA STATUS to find out the status and correct execution of (asynchronous) replication. Please pay attention of the new terminology. I’m sure we’ve all used the old terminology. However, MySQL replication has evolved a lot and the replication team has worked to include a lot […]
Oracle ClouldWorld Keynote: The Future of Scale-out Data Processing with HeatWave Lakehouse
Oracle recently announced HeatWave Lakehouse, enabling customers to query data in object storage with record performance vs. Snowflake, Amazon Redshift, Databricks, and Google Big Query. Querying the data in object storage is as fast as querying the database—an industry first. With HeatWave Lakehouse, you can now take advantage of HeatWave for non-MySQL workloads as well […]
Build MySQL 8 from the source rpm in OL8
After having explained how to build MySQL 8 (MySQL 8.0 and MySQL 8.1) on OL9 and OL7, this episode of the series will cover how to build MySQL 8 on Oracle Linux 8 (OL8) and compatible (EL8, CentOS 8, …). My build machine is a VM.Standard.E4.Flex instance on OCI having 8 OCPUs and 128GB of […]
Writing Tests For MySQL Document Store Apps with Node
In a previous post, I talked about how we can use Testcontainers to help make it easier to write tests for Node applications that interact with a MySQL database. In this post, we are going to discuss how we can write tests for Node applications that interact with MySQL Document Store – again using the MySQL Module for Testcontainers. The Issues Writing […]
Build MySQL 8 from the source rpm in OL7
This is the second post of a serie on how to build RPMs for MySQL 8 (8.0 and 8.1) on Oracle Linux (and compatible). The first post was dedicated on Oracle Linux 9 (OL9/EL9) and this one is about Oracle Linux 7. To be able to build successfully MySQL 8 on OL7, I needed to […]
Build MySQL 8 from the source rpm in OL9
After discussing with Simon, Oracle ACE Pro for MySQL, about some issues when trying to recompile MySQL 8.0.34 on CentOS 9 (see #111159), I also tried it and indeed some dependencies are not listed when compiling via the source RPM. This article is the first of a serie about how to buil MySQL 8 (8.0 […]
Welcome to Dolphie !
There are plenty GUI and Web application used to monitor a MySQL server. But if you are long time MySQL DBA, you might have used (and abused) Innotop ! I loved it ! And I even became maintainer of it. This particular task became more and more complicated with the different forks and their differences. […]
Are you ready for MySQL 10?
I know, we just released version 8.1, so isn’t it a bit early to think about version 10 now? But 5.7 has almost reached its end of life, and MySQL engineers are already working on 8.2 and 8.3. With this speed, we can expect to get to version 10 within a few years. And what […]