MySQL HeatWave Lakehouse has been praised by leading industry analysts as “an unprecedented innovation in cloud data services.” Yet, you may be wondering “why should this matter to me and my organization?” This blog aims to answer that question.

On any software project, one important piece is managing database changes. Tools such as Knex can make this process less daunting. This post talks about using Knex CLI to manage MySQL database migrations and how to seed your database with data.

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

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…