Welcome back, library explorer! Now that you’ve mastered the art of keys and relationships in your MySQL adventure, you’re ready for the next plot twist: discovering how data in one table connects to data in another. If you’ve ever wished your database could gossip between its tables—exchanging juicy details about students, books, and more—today’s the […]

Congratulations! If you’ve been following along, your digital library is now open for business—with tables for students, books, and all sorts of valuable catalog data. But what’s keeping your library organized, ensuring you don’t accidentally hand out two cards to the same bookworm, or have enrollments referencing students from a parallel universe? This is where […]

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