Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
MySQL Basics: Count Me In—Aggregating and Grouping Your Data
Welcome back, library explorer! By now, you’ve learned how to select data with SELECT, peek at your digital shelves, and even master the art of paging through a crowded student register using LIMIT and OFFSET. But what if you want answers to those big questions, like “How many student records have I collected?” or “What’s the earliest book checked […]
MySQL Basics: Join the Party—Bringing Tables Together with JOINs
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 […]
Supercharge MySQL: Introducing WebAssembly Integration for Next-Gen Data Apps
MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. Also included is MySQL HeatWave Lakehouse, which allows users to query data in object storage, MySQL databases, or a combination of both. Users can deploy MySQL HeatWave–powered apps on a choice of public […]
MySQL HeatWave and MySQL AI integration with Model Context Protocol
MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. Also included is MySQL HeatWave Lakehouse, which allows users to query data in object storage, MySQL databases, or a combination of both. Users can deploy MySQL HeatWave–powered apps on a choice of public […]
MySQL Basics: The Keys to the Kingdom—Primary and Foreign Keys Explained
Unlock the secrets to reliable databases with primary and foreign keys! This beginner-friendly post uses engaging library metaphors and approachable SQL examples to show how keys keep your MySQL tables organized and your data relationships strong. Learn how to build, enforce, and practice these essential building blocks in your own projects.
Streamlining GenAI and ML Application Development with the MySQL HeatWave Python SDK
This document provides a walk-through of the MySQL HeatWave Python SDK. It offers helpful tips on how to use the SDK to accelerate your application development culminating in three demonstrations of developing applications to solve real-world problems with, a Retrieval Augmented Generation (RAG) bot, an LLM-based agent with tool-calling, and a machine learning pipeline for fraud detection.
MySQL HeatWave Now FedRAMP Authorized and Live in OCI Government Realms
Big news for our public sector customers! Oracle's MySQL HeatWave has achieved Authorization to Operate (ATO) in both the OC2 (FedRAMP High / DISA IL4) and OC3 (DISA IL5) realms of the Oracle Cloud Infrastructure (OCI) Government Cloud.
This is a massive milestone that unlocks powerful new capabilities for government agencies, contractors, and other public sector organizations. Let's break down what this means and why it's so important.
Keep Calm - TDE for PostgreSQL 18 Is on Its Way!
If you’ve been following the buzz around PostgreSQL, you’ve probably already heard that database level open source data-at-rest encryption is now available thanks to the Transparent Data Encryption (TDE) extension available in the Percona Distribution for PostgreSQL. So naturally, the next question is:
Where’s Percona Distribution for PostgreSQL 18?
The short answer:It’s coming.
The slightly longer one:It’s taking a bit of time, for all the right reasons.
MySQL HeatWave 9.4.2 – Improvements In Reloading Data Into The HeatWave Cluster After Rebooting
Quick Overview of Data Reloading in MySQL HeatWave After Reboot In MySQL HeatWave, the in-memory cluster (RAPID engine) stores data in volatile memory, so a reboot of the DB System or HeatWave cluster (e.g., due to maintenance, upgrades, or failures) typically requires reloading data to restore full functionality. Prior to MySQL 9.2.0, reloading involved manually […]
MySQL HeatWave 9.4.2 - Improvements In Reloading Data Into The HeatWave Cluster After Rebooting
This blog post explains the in-memory data cluster reloading improvements of MySQL HeatWave version 9.4.2