As all developers know, one of the most critical parts of any project is tracking database changes (or migrations). These changes will likely need to be applied in a particular order, and they need to be applied to every environment in the development workflow. We should also be able to roll back these changes should […]

With the rise and widespread use of low-code tools, Australian-based Five has created an IDE that enables developers to rapidly build out and deploy web applications on a MySQL database.

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.

I’m publishing more and more developer and founder text-based interviews in the OpenLampTech publication. I recently …

Oracle CloudWord is just around the corner…if you haven’t registered yet, you can still join us September 18-21, in Las Vegas. In my previous blog, I highlighted “The Future of Scale-out Data Processing with HeatWave Lakehouse” keynote. If you have an interest in MySQL, in machine learning, or in processing data in object storage, I […]

Oracle Cloudworld 2023 includes many MySQL HeatWave sessions that you may not want to miss, such as use cases from Toyota, Aiwifi, Efisys, and Credit Guarantee Fund Trust for Micro and Small Enterprises (CGTMSE).

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 …