Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Say Hello to OIDC in PostgreSQL 18!

| Percona

If you’ve ever wondered how to set up OpenID Connect (OIDC) authentication in PostgreSQL, the wait is almost over.

We’ve spent some time exploring what it would take to make OIDC easier and more reliable to use with PostgreSQL. And now, we’re happy to share the first results of that work.

Why OIDC, and why now?

We’ve spoken to some of our customers and noticed a trend of moving away from LDAP to OIDC. Our MongoDB product is already providing OIDC integration and the team working on PostgreSQL products saw an opportunity coming with PostgreSQL 18.

Learn More »

MySQL Basics: Join the Party—Bringing Tables Together with JOINs

Discover how to combine information from multiple tables using JOINs in MySQL! This beginner-friendly guide explains INNER JOINs (and friends) with fun library metaphors, approachable SQL examples, and practical tips to help you unlock the true power of your relational database.

Learn More »

Say Hello to OIDC in PostgreSQL 18!

| Percona

If you’ve ever wondered how to set up OpenID Connect (OIDC) authentication in PostgreSQL, the wait is almost over. We’ve spent some time exploring what it would take to make OIDC easier and more reliable to use with PostgreSQL. And now, we’re happy to share the first results of that work.

Why OIDC, and why now?

We’ve spoken to some of our customers and noticed a trend of moving away from LDAP to OIDC. Our MongoDB product is already providing OIDC integration and the team working on PostgreSQL products saw an opportunity coming with PostgreSQL 18. As some of you may have noticed…

Learn More »

MySQL HeatWave feature announcements at Oracle AI World

MySQL HeatWave feature announcements at Oracle AI World

Learn More »

Supercharge MySQL: Introducing WebAssembly Integration for Next-Gen Data Apps

This blog post introduces WebAssembly (Wasm) support in MySQL Heatwave! For the first time, you can bring high-performance, portable code, compiled from Rust, C++, and many more languages, directly to your MySQL data, unlocking a new universe of speed, flexibility, and innovation.

Learn More »

MySQL HeatWave and MySQL AI integration with Model Context Protocol

This blog is focused on Model Context Protocol (MCP). MCP is an open standard enabling seamless integration between applications powered by large language models (LLMs) and external data sources and/or tools. The MySQL HeatWave MCP Server provides a collection of specialized tools that help you leverage the full capabilities of both MySQL HeatWave and MySQL AI.

Learn More »

Introducing Delta Lake in MySQL HeatWave Lakehouse

MySQL HeatWave Lakehouse enables queries on file formats like Parquet, Avro, ND-JSON and CSV in an object store. This blog introduces support for the Delta Lake table format, thereby enabling ACID-compliant applications on data in the object store.

Learn More »

Semantic and Keyword—Hybrid Search in MySQL HeatWave

This blog explains Hybrid Search capabilities within MySQL HeatWave, describing how it combines the strengths of keyword-based (BM25) and semantic (embedding) search. It explains the benefits for advanced information retrieval and Retrieval Augmented Generation (RAG) pipelines, highlighting how hybrid search supports complex business scenarios that require both contextual understanding and exact match capabilities.

Learn More »

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.

Learn More »

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.

Learn More »