There is more and more great content online these days. It’s hard to keep up with it all. OpenLampTech is your source of the best curated and original PHP, MySQL, and LAMP stack content. Thanks for reading!

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 #93, we are looking at content on:

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

Starting from MySQL 8.0.23, a new feature called Invisible Columns was introduced. This blog describes Invisible Columns feature.

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. To know more about the deployments of these topologies, you can refer to the manuals – InnoDB Cluster and Innodb ClusterSet setup.

In the below snippet, we have two clusters (cluster1 and cluster2), which are connected via an async channel and combined, known as a ClusterSet topology. We are going to use the below topology in all of our cases.

MySQL  127.0.0.1:3308 ssl  JS > myclusterset.status({extended: 1})
{
    "clusters": {
        "Cluster1": {
            "clusterRole": "PRIMARY", …

In this article, you will learn how to monitor all your MySQL replication channels.

To reduce the backup size, save storage space, and speed up the backup and restore process, you can compress a backup with Percona XtraBackup. The XtraBackup --compress option makes XtraBackup compress all output data, including the transaction log file and metadata files, with one of the supported compression …

NodeJS is an open-source, cross-platform runtime environment that uses JavaScript for creating fast, data-intensive, and secure server-side applications.  These applications require some ways to store data in order to use them again. NodeJS supports all kinds of Databases, relational, and non-relational out of which MySQL can be the best choice. MySQL is a relational database management system that stores data in one or more tables of rows and columns. It can be used in NodeJS to store large amounts of data and retrieve data quickly due to its simple structure using SQL. SQL stands for structured query languages which we…

In our lab environment, we received some emails from our provider, DigitalOcean saying a few nodes would be going down, because of issues with the physical nodes. Since we run a 9-node Galera Cluster in the lab, across 3 regions (San Francisco, London and Singapore), this posed an interesting problem!

Upon connecting to one of the nodes, we see:

mysql> show status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 7     |
+--------------------+-------+
1 row in set (0.02 sec)

So we know that 2 of the nodes are down. Presuming you do not have any monitoring setup (might we recommend …

Learn how to build MySQL 8 RMS for Oracle Linux 8 from the sources

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