MySQL Document Store is a NoSQL solution built on top of MySQL. This means we need a test database to use when we want to test code that interacts with MySQL Document Store. With Testcontainers, we can spin up a MySQL database so we can easily test any code that interacts with MySQL Document Store.

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 of useful information about all the replication flavors available with MySQL.

For example, we’ve added parallel replication, group replication, … all that information is missing from the the good old SHOW REPLICA STATUS result.

There much better ways to monitoring and observing the replication process(es) using Performance_Schema.

Currently in Performance_Schema, there are 15 tables relating to replication instrumentation:

+------------------------------------------------------+
| …

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 […]

Learn how to build MySQL 8 RPMs from source.

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 […]

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 […]

We have another week of great content to share in this week’s OpenLampTech developer newsletter. Thanks for reading and many thanks to the author’s who write and publish development content each week.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

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.

In OpenLampTech issue #92, I’m reading and enjoying …

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 […]

Learn how to build MySQL 8 RPMs from sources for Oracle Linux 9

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. […]