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 9.7 LTS Is Here: Upgrade and Modernize on a Stronger Community Edition
MySQL 9.7 LTS is here, establishing the new MySQL 9.7.x Long-Term Support release line. For organizations running MySQL today, this is the right time to evaluate upgrade plans and move toward a current, supported foundation. It is also a good moment for teams standardizing their database strategy to take a fresh look at MySQL. Whether […]
No More JSON Plumbing: MySQL 9.7 Community Levels Up Duality Views
Modern applications often pass JSON back and forth with the database server. With MySQL, we have had great JSON support, but working with relational data as JSON usually meant generating documents manually with built-in JSON functions. When an application sent JSON back to the server, we often had to break that document apart and write […]
Inserting in Two Tables in a Single Round-Trip with JSON Duality Views in MySQL 9.7
A few months ago, I was asking myself how to insert in two tables in a single round-trip to the database. I wanted to do that to optimize a process. My optimization involved splitting a table in two, which would need inserting in two tables atomically. The downside was changing an auto-commit INSERT to a transaction with two inserts, which was changing the shape of the workload
Summary of MySQL Public Discussion #4: Updates and Improvements to Contributions – Let’s Talk About What’s Next for MySQL
One of the best things about MySQL has always been its community. Whether you’re building applications, running production databases, contributing code, creating tools, writing documentation, answering questions, or simply sharing feedback, you’ve helped make MySQL what it is today. In this discussion we shared updates on where we are today and had a discussion on […]
From Question to Insight with MySQL Studio
When we introduced MySQL Studio, the goal was to bring the common parts of database development and analysis into one OCI workspace: SQL authoring, schema exploration, results visualization, and Ask Studio. The next step is making that workspace more useful during the everyday flow of MySQL work. For many MySQL developers, DBAs, and application teams, […]
The Percona Community Slack is open — come hang out
The Percona Community Slack is open — come hang out There’s a new place for the people behind the databases to actually talk to each other.
Where can you find MySQL during June–August 2026?
The MySQL Community team will be active across conferences, user group meetups, open source events, and regional community activities during the summer months. Whether you would like to hear about the latest MySQL 9.7 updates, meet the MySQL team, join a user group meetup, or connect with the broader open source and developer community, here […]
Building Smart Semantic Search using PostgreSQL and pgvector. Case Study - Part 2 - Postgres Layer
I’ll explain how I built the Postgres layer for semantic vector search on the Percona Community website: pgvector, chunks, two table modifications, the database schema, how the indexer populates Postgres, and what the SELECT statement looks like during a search.
Building Smart Semantic Search using PostgreSQL and pgvector. Case Study - Part 1 - Introduction
Type “zero downtime database migration” into the site’s search bar and you’ll get articles and talks about database migration with minimal downtime, even if those words aren’t in the titles or content. This is semantic search on PostgreSQL and pgvector, without paid embedding APIs or a separate vector database. In this series I’ll cover how it works and why I chose this stack.
MySQL HeatWave Document Store for Modern Applications
Modern applications generate and consume enormous amounts of semi-structured data. User profiles, product catalogs, IoT telemetry, application events, AI prompts, and content metadata rarely fit neatly into rigid relational schemas anymore. At the same time, enterprises still need the reliability, security, analytics, and operational maturity of a traditional database platform. This is where MySQL HeatWave […]