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

Learn More »

Keep Calm - TDE for PostgreSQL 18 Is on Its Way!

| Percona

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.

Learn More »

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

Learn More »

Modular Magic: Reusing Code in MySQL with the New LIBRARY Feature

An overview of Library Feature in the MySQL HeatWave managed cloud service and elsewhere.

Learn More »

From MEM to Automation: Managing MySQL Enterprise with ClusterControl

| Severalnines

When Oracle announced the deprecation of MySQL Enterprise Monitor (MEM), many organizations running MySQL Enterprise Server suddenly faced a gap in their operations stack. MEM had long been part of the Enterprise subscription, providing monitoring and limited automation. Now, DBAs and DevOps teams must look elsewhere for visibility and control. The good news? Moving away […]

The post From MEM to Automation: Managing MySQL Enterprise with ClusterControl appeared first on Severalnines.

Learn More »

Querying the Unstructured: Natural Language to SQL for JSON Data

| MySQL expert Diary

Bridging natural language processing with semi-structured data brings both opportunity and complexity.

MySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues.

By creating well-structured views that reveal JSON’s internal organization, you can transform unstructured data into a relational format the model understands — improving both query accuracy and overall usability.

This approach…

Learn More »

MySQL Basics: Turning the Page—Using LIMIT and OFFSET for Pagination

Discover how to tame big tables using LIMIT and OFFSET in MySQL! This post makes pagination easy for newcomers, using friendly library metaphors, step-by-step SQL examples, and practical tips to help you view your data one page at a time.

Learn More »

Removing the index guesstimate with MySQL Autopilot Indexing

This blog post introduces the MySQL Autopilot Indexing feature.

Learn More »

Interact with MySQL in natural language

We are excited to announce the release of Natural Language to SQL (NL2SQL) capability for MySQL (with the AI option) and MySQL HeatWave cloud service. Natural language interface is essential for modern data platforms, allowing users to explore information more quickly.

Learn More »

Build a Smart Weather Agent with LangChain and MySQL HeatWave GenAI

This article showcases the power of combining the LangChain framework with an LLM hosted on MySQL HeatWave GenAI. Our goal is to create an agent that can answer the question, "What is the current weather in Fahrenheit?". To do this, the agent must first fetch the weather (which is in Celsius) and then convert it to Fahrenheit, a classic multi-step task. This agent will demonstrate how a Large Language Model (LLM) can use tools and a logical sequence of steps to solve a problem.

Learn More »