Welcome back, library explorers! By now, you’ve learned how to select, filter, and view data from your tables—like peering through your reading room’s card catalog to spot the newest bestsellers, most loyal readers, or anyone who might have “forgotten” to return a book or two. But what happens when your database shelves are overflowing—say, the […]

Congratulations, data explorer! Your library is open for business, the shelves are organized, and the tables are finally filled with real, tangible data—authors, books, and eager readers galore. But what if you want to see what’s actually on those digital shelves? Enter the mighty SELECT statement: SQL’s super-powered magnifying glass that lets you find, browse, and admire your collection. […]

Welcome back, data explorers! So far, you’ve built your digital library with MySQL: empty shelves have become bustling tables, and eager students (or books, or even pizza lovers) have taken their seats with INSERT statements. But what happens when someone spells their name “Alcie” instead of “Alice,” or a graduate heads off to bigger adventures? Sooner or […]

Welcome back, adventurous data explorer! So far, you’ve designed your very own digital library, built sturdy shelves (tables), and labeled each cubby just so. But a library with empty shelves is just a stylish storage unit. Today, we dive into the real fun: bringing your tables to life with data! Before you can ask your […]

By Ayten Abdelrazek  –  September 10, 2025 “AI is moving fast. The real edge? Using your data, your tools, your way.” — Heather VanCura, Oracle, TechCrunch 2025  At TechCrunch 2025, Oracle took the stage with a clear message: AI doesn’t have to be complicated, and you shouldn’t need to duct-tape half a dozen services together […]

On July 22nd, 2025, we released MySQL 9.4, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can notice several contributions related to NDB and the Connectors Connectors MySQL Server – Replication InnoDB Optimizer C API (client […]

Have you already tried to upgrade the MySQL version of your MySQL HeatWave instance in OCI that is deployed with Terraform? When you tried, you realized, I hope you didn’t turn off backups, that the instance is destroyed and recreated new! This is our current MySQL HeatWave DB System deployed using Terrafrom: And this is […]

We all know MySQL InnoDB ClusterSet, a solution that links multiple InnoDB Clusters and Read Replicas asynchronously to easily generate complex MySQL architectures and manage them without burdensome commands. All this thanks to the MySQL Shell’s AdminAPI. This is an example of MySQL InnoDB ClusterSet using two data centers:   Let’s explore how we can […]

The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. The MySQL REST Service was first released on https://labs.mysql.com in 2023 using MySQL Router. During spring 2025, it was released on MySQL HeatWave and standard […]

During the last MySQL & HeatWave Summit, Wim Coekaerts announced that a new optimizer is available and is already enabled in MySQL HeatWave. Let’s have a quick look at it and how to use it. The first step is to verify that Hypergraph is available: MySQL > SET SESSION optimizer_switch='hypergraph_optimizer=on'; ERROR: 3999 (42000): The hypergraph […]