Creating generated hash columns in MySQL for faster strict equality lookups.

Learn how Multi-Valued Indexing in MySQL 8.0 can enhance query performance by efficiently indexing and querying JSON arrays. Discover the benefits, implementation steps, and considerations for optimizing your MySQL database.

1. Multi-Valued Indexing in MySQL 8.0
2. Understanding Multi-Valued Indexes and their benefits
3. Creating Multi-Valued Indexes in MySQL …

Thanks so much for reading OpenLampTech. Here is this week’s newsletter, full of great content all about PHP, MySQL, and the LAMP stack. Several WordPress and WooCommerce reads too.

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 #82, we have articles covering:

• WordPress …

MySQL Heatwave, a fully managed database service, not only provides customers with one database service for OLTP, OLAP, and ML, but it also supports centralized access management for these databases via integration with OCI IAM. Using Oracle Cloud Infrastructure Identity and Access Management (OCI IAM) customers can protect themselves against security threats, streamline access management, and achieve governance and compliance with industry standards.

MySQL at TaranovoConf, Bulgaria

MySQL Shell is a powerful utility for managing MySQL Instances. One feature is the ability to perform multithreaded data dumps and loads. In this post we will discuss hows to dump data to, and read data from, a Storage Bucket in Oracle Cloud Infrastructure.

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region

The "Max Transaction Limit" feature added MySQL Thread Pool in MySQL 8.0 Enterprise Edition helps to prevent performance drops as load increases.

We are sure you’ve probably already heard that MySQL 5.7 is going to reach End of Life (EOL) by October 2023. We are here to tell you that the migration from MySQL 5.7 need not be scary — MySQL 8.0 has been Generally Available for five years, and the Galera Cluster product for it, has been hardened for over three years, so it is truly time to get ready to migrate.

In our first session of the series, we are going to cover:
* the new features of Galera Cluster with MySQL 8 that you might benefit from, including what is available in Galera Cluster Enterprise Edition (EE)
* how to plan a migration from MySQL 5.7 or older to 8.0
* things to test for, before migrating
* common pitfalls of said migration
* how to ensure your Galera Cluster keeps humming along with no downtime

We also offer migration support to help you before and during your migration, after-which our regular support plan will cover …

I am trying something new with the OpenLampTech developer newsletter here on the blog. I will start re-sharing last week’s newsletter on the following Wednesday instead of Monday. If you want it earlier than that, you should subscribe. This won’t be permanent but does help me with some content creation as I am too thin with original content at the moment for the weekly blog. 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.

…