Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Thursday, 09. October 2025

Advanced observability and troubleshooting with Amazon RDS event monitoring pipelines (from AWS Database Blog)

AWS provides a wide range of monitoring solutions for your Amazon RDS and Amazon Aurora instances, such as Amazon CloudWatch, Amazon CloudWatch Database Insights, and AWS CloudTrail. Amazon RDS event monitoring pipelines make troubleshooting operational events like reboots, errors, and failovers more efficient. In this post, we present a solution to get a head start on troubleshooting by sending an [...]

September 2025 Recap: Azure Database for MySQL (from Azure for MySQL Blog)

pJoin us live on our YouTube channel on October 15, 2025 for an exclusive webinar where we’ll dive deeper into the latest Azure Database for MySQL updates and answer your questions! Watch it live here./p Support for In-Place Major Version Upgrade from 8.0 to 8.4 pWe previously announced that Azure Database for MySQL version 8.4 is now generally available. We’re now happy to share that in- [...]

MySQL Basics: WHERE’s the Data? Filtering Results with WHERE Clauses (from The Oracle MySQL Blog)

Ready to grow your querying skills? This post introduces curious newcomers to the WHERE clause in MySQL, showing how simple conditions, clever operators, and cheerful library metaphors can help you filter data like a pro. Find the exact records you need using approachable SQL examples—no dusty catalogs required! [...]

A Data Importing AI Agent (from DoltHub Blog)

For the past few months, I've been blogging about my experience with agents. My first blogs on the subject were about using agents with Dolt… [...]

Wednesday, 08. October 2025

Here’s the Message I Sent Welcoming Percona’s New CEO Peter Farkas (from Peter Zaitsev)

pFirst, I want to give a big thank-you to Bennie Grant, who has been our Interim CEO over the past few months. Stepping into the CEO role is never easy — and doing it on an interim basis can be even tougher. Bennie, we’re grateful for the way you’ve helped steer us through this transition […]/p pThe post Here’s the Message I Sent Welcoming Percona’s New CEO Peter Farkas appeared first o [...]

Introducing TiDB X: A New Foundation for Distributed SQL in the Era of AI (from PingCAP Blog)

pAsk any engineering team managing a modern application today, and you’ll hear the same frustrations: traffic spikes that can’t be predicted, autoscalers that react too slowly, and workloads that look nothing like they did yesterday. One hour you’re processing transactions, the next you’re serving analytical or vector queries — all in real time, all under […]/p pThe post Introducing TiDB X: A [...]

What’s New in MySQL HeatWave on AWS? (from The Oracle MySQL Blog)

We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance. [...]

From Vision to Action: Strengthening the MariaDB Foundation Board – Welcome, Frank Karlitschek! (from MariaDB Foundation Blog)

pStrengthening the Board with industry leaders is a key goal for the MariaDB Foundation in 2025 – and beyond./p pAt the MariaDB Foundation, we believe that leadership in open source isn’t just about code — … /p pContinue reading \"From Vision to Action: Strengthening the MariaDB Foundation Board – Welcome, Frank Karlitschek!\"/p pThe post From Vision to Action: Strengthening [...]

Why MySQL on Kubernetes Fails Without the Right Operator (from Continuent Blog)

Challenges of running MySQL on Kubernetes and how Operators ensure reliability through replication, failover, and observability.Tags: kubernetesoperatorMySQL [...]

Tuning BLOB for performance in NDB [Part 2] (from The Oracle MySQL Blog)

This blog post shows the performance evaluation of the BLOB_INLINE_SIZE column option for NDB tables in comparison without it, as well as the benefits of batching BLOB read and writes. [...]

What is JPA? Introduction to Java persistence (from InfoWorld)

pThe Jakarta Persistence API (JPA) is a specification that defines a standardized framework for data persistence. Persistence is the fundamental mechanism for saving and retrieving data over time. In Java, the data we persist is held in objects. The JPA specification lets you define how your objects will be persisted while leaving the work itself to an underlying framework. /p [...]

Tuesday, 07. October 2025

Celebrating a New Chapter: Percona Welcomes Peter Farkas as its New Chief Executive Officer (from One-Time MySQL Community/Ecosystem Posts)

Today, we are excited to announce that Peter Farkas will serve as Percona’s new Chief Executive Officer, where he will build on the company’s long-standing track record of success with an eye toward continuous innovation and growth. [...]

MySQL Basics: Seek and You Shall SELECT—Retrieving Data from Your Tables (from The Oracle MySQL Blog)

Curious about what's inside your MySQL tables? This post introduces beginners to the SELECT statement, using friendly library metaphors, approachable SQL examples, and helpful tips—including how to alias column names. Get ready to start exploring your data with confidence! [...]

Impressive stats from ideation phase of Bengaluru Python hackathon, now closed (from MariaDB Foundation Blog)

pThe ideation phase of the MariaDB-Python Hackathon wrapped up on Sunday — and the response was phenomenal!br A huge thanks to everyone who joined the journey: from the BangPypers’ … /p pContinue reading \"Impressive stats from ideation phase of Bengaluru Python hackathon, now closed\"/p pThe post Impressive stats from ideation phase of Bengaluru Python hackathon, now closed appea [...]

Let Your AI DBA Assistant Write Your MySQL Queries (from MySQL expert Diary)

pHaving explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]/p The post Let Your AI D [...]

Run Bats with a Single Click on Windows using GoLand (from DoltHub Blog)

Dolt is a plug-in MySQL-compliant database that behaves like Git, allowing you to version control your data. In the last couple of months, I… [...]

Monday, 06. October 2025

September Product Update (from Readyset Blog)

♦pSpooky season is here, and so are the latest updates from Readyset:  /pQueryPilot Demo: It's Not Broken, It's Just That Fast. pQueryPilot automatically finds and optimizes your most expensive queries with zero manual tuning or configuration. Its performance is so instant that results are/p [...]

Optimizing queries by using observability (from InfoWorld)

pIn a modern enterprise data environment, the increasing volume of data, distributed architecture, and complex application dependencies challenge traditional query-tuning methods. Observability enhances query optimization by providing constant, fine-grained visibility into query behavior, resource consumption, and systemic interactions. Taking advantage of this data shifts th [...]

Launching the State of MariaDB 2025 survey (from MariaDB Foundation Blog)

pWe want to know how you’re really using MariaDB. Not the marketing version. Not the idealized case study. The real story—what you’re building, what tools you’re using, what’s working, and what’s frustrating. … /p pContinue reading \"Launching the State of MariaDB 2025 survey\"/p pThe post Launching the State of MariaDB 2025 survey appeared first on MariaDB [...]

Introducing Tungsten Dashboard v8.0.2 (from Continuent Blog)

Tungsten Dashboard v8.0.2 introduces major performance improvements, real-time cluster visibility, and enhanced usability with an intuitive Add/Edit Cluster workflow, namespace visibility, and configurable light/dark themes. The release also includes a redesigned installer with configuration reset, Docker Compose plugin support, and self-signed certificate generation. New tools like collect-diag.pl [...]

Introducing Tungsten Cluster & Tungsten Replicator v8.0.1 (from Continuent Blog)

Tungsten Cluster & Tungsten Replicator v8.0.1 focus on improving security, configuration management, and observability. The release introduces tpm INI upgrade and validation enhancements, dual MySQL SSL certificate for seamless certificate rotation, and new Prometheus metrics for deeper Replicator insights. It also delivers multiple CLI and stability fixes and adds certification for MariaDB 11. [...]

Sunday, 05. October 2025

Measuring scaleup for Postgres 18.0 with sysbench (from Small Datum)

pThis post has results to measure scaleup for Postgres 18.0 on a 48-core server./pptl;dr/pp/pulliPostgres continues to be boring (in a good way)/liliResults are mostly excellent/liliA few of the range query tests have a scaleup that is less than great but I need time to debug/li/ulpBuilds, Configuration & Hardware/ppThe server has an AMD EPYC 9454P 48-Core Processor with AMD SMT disabled, 128G [...]

Performance Framework Autobench3's Profiler Runner – MySQL Benchmarking Series #5 (from One-Time MySQL Community/Ecosystem Posts)

When chasing changes in performance, it’s not enough to know which commit introduced the change — we need to understand how it has changed workloads. [...]

Friday, 03. October 2025

When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World (from MariaDB Foundation Blog)

pThe news has circulated quietly in industry corners, but the implications are far too significant to brush aside: Oracle seems to have ended the Open Source era of MySQL. … /p pContinue reading \"When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World\"/p pThe post When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World appeared first on MariaDB.org./p [...]

Get Ready for MySQL HeatWave at Oracle AI World 2025! (from The Oracle MySQL Blog)

This blog gives you a complete overview of MySQL HeatWave sessions so you can plan your agenda, mark your calendar, and make the most of the event. [...]

Failing 100 Real World Postgres Dumps (from DoltHub Blog)

We're continuing to make progress on DoltgreSQL, which is a version of Dolt built to be a drop-in replacement for PostgreSQL. Dolt is a drop… [...]

Thursday, 02. October 2025

MariaDB C++ Connector 1.1.7 and 1.0.6 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.7 and 1.0.6 releases. Release Notes MariaDB Connector/C++ […] [...]

Data Integrity in a Database: How to Ensure Accuracy and Security (from Devart MySQL Tool Blog)

pLearn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now./p pThe post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog./p [...]

Success Story: zvoove Switzerland AG – From Legacy Systems to Scalable Solutions with MariaDB (from MariaDB Foundation Blog)

pPhillippe Balzli, CTO at zvoove Switzerland AG, shared in an interview with Kaj Arnö of MariaDB Foundation how the company navigated legacy software, rapid growth, and evolving customer needs – … /p pContinue reading \"Success Story: zvoove Switzerland AG – From Legacy Systems to Scalable Solutions with MariaDB\"/p pThe post Success Story: zvoove Switzerland AG – From Legacy Syste [...]

Bring your data to your code with Azure’s Data API Builder (from InfoWorld)

pAzure is now so big it’s hard to keep on top of all its features, let alone drill down into its ever-growing line of developer tools. That’s not surprising; in the past two decades or so, it’s become the place where Microsoft builds its own and its customer-facing products./p pThat internal developer focus eventually brings tools to the rest of us, as internal APIs and se [...]

Using Microsoft’s Data API builder for Azure databases (from InfoWorld)

pMicrosoft Azure is now so big it’s hard to keep on top of all its features, let alone drill down into its ever-growing line of developer tools. That’s not surprising. In the past two decades, Azure has become the place where Microsoft builds all of its products, both the tools for its own use and those for its customers./p pThat internal developer focus eventually brings [...]

Multi-Region MySQL for SaaS: Architecture Patterns (from Continuent Blog)

An in-depth guide to multi-region MySQL for SaaS, covering design principles, challenges, and proven architecture patterns for global scale.Tags: SaaSArchitecturemulti-region mysql [...]

MySQL Basics: Change Is Good—Updating and Deleting Table Data (from The Oracle MySQL Blog)

Learn how to responsibly update or delete your MySQL data—including the concept of soft deletes—using engaging library metaphors and practical SQL examples. This post guides beginners through UPDATE and DELETE statements, safety tips, and real-world scenarios. [...]

Measuring scaleup for MariaDB with sysbench (from Small Datum)

pThis post has results to measure scaleup for MariaDB 11.8.3 on a 48-core server./pptl;dr/pp/pulliScaleup is better for range queries than for point queries/liliFor tests where results were less than great, the problem appears to be mutex contention within InnoDB/li/ulp/ppBuilds, Configuration & Hardware/ppThe server has an AMD EPYC 9454P 48-Core Processor with AMD SMT disabled, 128G of RAM and [...]

Wednesday, 01. October 2025

Dbeaver: For postgres 2 mysql data migration. (from MySQL-Med)

Want to migrate Postgres data to MySQL/MariaDB with an open-source community tool that will knock your socks off? Please keep reading... Continue reading → [...]

Understanding Foreign Data Wrappers in PostgreSQL (from MinervaDB Blog)

Understanding Foreign Data Wrappers in PostgreSQL: A Complete Guide to postgres_fdw Introduction In today’s distributed data landscape, organizations often need to access and integrate data from multiple database systems. PostgreSQL Foreign Data Wrappers (FDWs)provide an [...] [...]

Vercel v0 Works with Dolt (from DoltHub Blog)

Dolt is the world's first version-controlled relational database. Dolt lets you branch, fork, clone, merge, and diff your relational data… [...]

Larger than RAM Vector Indexes for Relational Databases (from PlanetScale Blog)

A new hybrid design for scalable vector indexes and a reference implementation in MySQL [...]

Tuesday, 30. September 2025

MariaDB and AI: Building the Bridge That Really Matters (from MariaDB Foundation Blog)

pNot what AI can do for MariaDB – but what MariaDB can do for AIbr I have hinted at this before (This Month in MariaDB – … /p pContinue reading \"MariaDB and AI: Building the Bridge That Really Matters\"/p pThe post MariaDB and AI: Building the Bridge That Really Matters appeared first on MariaDB.org./p [...]

Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave (from MySQL expert Diary)

pNatural Language to SQL in MySQL HeatWave makes data accessible to everyone, not just SQL experts. By turning plain English into optimized queries, it removes barriers and speeds up insights. While best practices help ensure accuracy, the feature already shows how LLMs are transforming the way we work with data. With the NL_SQL routine, asking your database questions is as simple as asking a colle [...]

MySQL Basics: Filling the Gaps—Inserting Data into Your Tables (from The Oracle MySQL Blog)

Learn how to bring life to your database by inserting records into your MySQL tables! This post shows beginners how to use INSERT statements—with lighthearted library metaphors, approachable SQL examples, and helpful tips for common pitfalls. A perfect next step on your MySQL journey. [...]

Multi-stage Docker Builds for Dolt (from DoltHub Blog)

Imagine if every change to your database was as traceable as every line of code in your Git repository. What if you could branch your… [...]

Monday, 29. September 2025

Meta’s Infrastructure Evolution and the Advent of AI (from Engineering at Meta)

p  Over the past 21 years, Meta has grown exponentially from a small social network connecting a few thousand people in a handful of universities in the U.S. into several apps and novel hardware products that serve over 3.4 billion people throughout the world. Our infrastructure has evolved significantly over the years, growing from a [...]/p pRead More.../p pThe post Meta’s Infrastructure Evo [...]

MariaDB Bangalore Hackathon: Ideation Phase Closing (from MariaDB Foundation Blog)

pThe final days are here for the Foundation’s first large-scale hackathon, the MariaDB Python Hackathon we’re organising in partnership with BangPypers (the Bangalore Python Meetup, a group with about 14,000 members) and HackerEarth (a Hackathon organiser). … /p pContinue reading \"MariaDB Bangalore Hackathon: Ideation Phase Closing\"/p pThe post MariaDB Bangalore Hackathon: Ideat [...]

Common Table Expressions in MySQL: How and Why with Examples (from DoltHub Blog)

In this guide, learn how to use common table expressions (CTEs) in MySQL, what they're good for, and try out some simple examples. What's a… [...]

Sunday, 28. September 2025

Readyset MySQL BR Conf 2025 Challenge – Sorteio de R$500 (from Readyset Blog)

pObrigado por participar do MySQL BR Conf 2025 e celebrar os 30 anos do MySQL! Tivemos um tempo fantástico conectando com vocês e mal podemos esperar para ver os resultados do desafio. /pComo participar para ter a chance de ganhar um prêmio em [...]

Friday, 26. September 2025

MySQL and MariaDB GPL licence error? (from SQL And Its Sequels (Ocelot Blog))

To comply with GPL requirements, MySQL and MariaDB include a COPYING or LICENSE file, which has You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA. and maybe something’s wrong with… Continue Reading MySQL and MariaDB GPL licence error? [...]

Announcing SQLyog 13.3.1 (from Webyog Blog)

pWe’re excited to announce the release of SQLyog 13.3.1, packed with new features, important fixes, and updates to keep SQLyog running smoothly with the latest MySQL and MariaDB versions. What’s […]/p pThe post Announcing SQLyog 13.3.1 appeared first on Webyog./p [...]

PG NYC 2025 (from Dave's MySQL Stuff)

p PG NYC 2025 starts November 29th, and you can find me in the DBeaver booth.  This event has become one of my favorites, packed with three days of intense content. And it will all happen less than a week after the release of PG 18./ppTickets are still available if you can make it to Manhattan./ppAnd I will be demoing new DBeaver features, including talking to the AI Assistant. Pleas [...]

MySQL 8.0 End of Life Support: What Are Your Options? (from Percona Database Blog)

♦We’ve mentioned this a few times here on the blog already, but in case you missed it, MySQL 8.0’s end-of-life date is April 2026. This probably sounds forever away, but it’s going to sneak up before you know it. Maybe you’ve been putting off thinking about it, or maybe you’re already weighing your options but […] [...]

Datagraph releases an extension of RonDB, a Common Lisp NDB API (from Mikael Ronstrom)

pDatagraph develops a Graph database called Dydra that can handle SPARQL, GraphQL and Linked Data Platform (LDP). Dydra stores a revisioned history, this means that you have access to the full history of your data. This could be a development of some document, a piece of software, a piece of HW like a SoC (System-on-a-Chip) or a building or something else. Essentially any data./ppThis blog describe [...]

Passbolt becomes Silver Sponsor of MariaDB Foundation (from MariaDB Foundation Blog)

pMariaDB Foundation is delighted to announce that Passbolt has joined as a Silver Sponsor, further strengthening the European open source ecosystem.Passbolt is the European open source platform for secure credential collaboration. … /p pContinue reading \"Passbolt becomes Silver Sponsor of MariaDB Foundation\"/p pThe post Passbolt becomes Silver Sponsor of MariaDB Foundation appeared first on [...]

Thursday, 25. September 2025

MariaDB 12.2 preview available (from MariaDB Foundation Blog)

pWe are pleased to announce the availability of a preview of the MariaDB 12.2 series. MariaDB 12.2 will be a rolling release. … /p pContinue reading \"MariaDB 12.2 preview available\"/p pThe post MariaDB 12.2 preview available appeared first on MariaDB.org./p [...]

MySQL HeatWave on AWS Now in Mexico (from The Oracle MySQL Blog)

We’re excited to announce the general availability of MySQL HeatWave in a new AWS region — Mexico Central (Querétaro) — reinforcing our commitment to expanding globally and meeting growing customer demand. [...]

Spec-driven AI coding with GitHub’s Spec Kit (from InfoWorld)

pMicrosoft and GitHub have made AI assistance a key part of their software development tools. Embedded in the latest Visual Studio and Visual Studio Code releases, GitHub Copilot puts a multifaceted pair programmer—combining AI-powered code completion, coding agents, and various Model Context Protocol servers—right inside your editor./p pThe resulting tool kit is especiall [...]

MySQL Basics: Table Manners – Setting up Your First Schema and Table (from The Oracle MySQL Blog)

Take your first hands-on steps in MySQL! This post teaches you how to create schemas and tables using relatable library analogies, beginner-friendly SQL examples, and tips to avoid common pitfalls. Perfect for newcomers, it’s your foundation for all future data adventures. [...]

Grafana's metrics backend for go-mysql-server (from DoltHub Blog)

We're building Dolt, the world's first and only version-controlled SQL database. Dolt's SQL engine, the part that parses SQL queries and… [...]

Wednesday, 24. September 2025

Indexing Materialized Views in PostgreSQL (from MinervaDB Blog)

Indexing Materialized Views in PostgreSQL What are Materialized Views? Materialized views in PostgreSQL are precompiled queries that store their results physically on disk, unlike regular views which are virtual and execute the underlying query each [...] [...]

Why Databases in Kubernetes Need Operators (from Continuent Blog)

Learn why Kubernetes alone isn’t enough for running stateful databases and how Operators solve challenges like failover, scaling, backups, and upgrades. Discover how Tungsten Operator brings proven MySQL clustering, replication, and enterprise-grade HA/DR into Kubernetes.Tags: kubernetesDatabaseoperatorMySQLHigh Availability [...]

Partnering with Cloudflare to bring you the fastest globally distributed applications (from PlanetScale Blog)

You can now easily set up PlanetScale databases with Cloudflare Workers using this native integration. [...]

Processes and Threads (from PlanetScale Blog)

Processes and threads are fundamental abstrations for operating systems. Learn how they work and how they impact database performance in this interactive article. [...]

Tuesday, 23. September 2025

Long-term storage and analysis of Amazon RDS events with Amazon S3 and Amazon Athena (from AWS Database Blog)

In this post, we show you how to implement an automated solution for archiving Amazon RDS events to Amazon Simple Storage Service (Amazon S3). We also discuss how to analyze the events with Amazon Athena which helps enable proactive database management, helps maintain security and compliance, and provides valuable insights for capacity planning and troubleshooting. [...]

Extracting and Substituting Text with Regular Expressions in PostgreSQL (from MinervaDB Blog)

Extracting and Substituting Text with Regular Expressions in PostgreSQL PostgreSQL provides a powerful built-in regex engine that enables sophisticated text manipulation through pattern matching, extraction, and substitution operations. Regular expressions are essential for data cleaning, [...] [...]

PostgreSQL 18: Accelerating Disk Reads with Asynchronous I/O (from MinervaDB Blog)

PostgreSQL 18 Asynchronous I/O: Accelerating Disk Reads with Asynchronous I/O The database world is about to witness a significant leap forward with PostgreSQL 18, scheduled for release on September 25, 2025. Among the many enhancements [...] [...]

TuningWizard Team Joins Releem: Building the Future of Database Management Together (from Releem Blog)

The TuningWizard team, led by founder Gabriel Ciciliani, is joining the Releem team — bringing SQL Query Optimization to Releem. [...]

Monitoring MySQL HeatWave on AWS: From Console to CloudWatch (from The Oracle MySQL Blog)

MySQL HeatWave on AWS extends its monitoring capabilities by integrating with Amazon CloudWatch, allowing you to view many additional metrics and track its history over time. [...]

dbForge Hits a New Milestone With 2025.2! (from Devart MySQL Tool Blog)

pNew dbForge milestone is achieved! This time, it brings us enhancements in AI Assistant, long-awaited user interface improvements, and further significant advancements in cloud support underway./p pInterested in learning more? Let's get started!/p pThe post dbForge Hits a New Milestone With 2025.2! appeared first on Devart Blog./p [...]

What MySQL configuration you hate the most? (from Kedar MySQL Blog)

pEver spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…/p The post What MySQL configuration you hate the most? first appeared on Change Is Inevitable. [...]

MySQL Basics: Getting TYPE-cast – Choosing the Right Data Type for the Job (from The Oracle MySQL Blog)

Demystify MySQL data types with this lighthearted guide for beginners! Learn how choosing the right type for each column—numbers, text, or dates—keeps your database organized, efficient, and easy to use. Packed with simple analogies, practical tips, and helpful examples, this post will help you master the essentials of structuring your tables in MySQL. [...]

Monday, 22. September 2025

Introducing Backup Validation and Backup Preparation in MySQL HeatWave (from The Oracle MySQL Blog)

Introducing Backup Validation and Backup Preparation in MySQL HeatWave [...]

PlanetScale for Postgres is now GA (from PlanetScale Blog)

PlanetScale for Postgres is now generally available. [...]

Saturday, 20. September 2025

Preventing Read-Write Conflicts: Lockless Concurrency in MySQL JSON Duality Views (from The Oracle MySQL Blog)

An overview of lockless optimistic concurrency control feature introduced for MySQL JSON Duality Views in version 9.4. [...]

Hands-on with JSON Duality Views in MySQL: From Creation to Day-to-Day Use (from The Oracle MySQL Blog)

An overview of DDL support for JSON Relational Duality Views introduced in version 9.4. [...]

Friday, 19. September 2025

Manipulating Data in MySQL JSON Duality Views: Deep Dive into DML Operations (from The Oracle MySQL Blog)

An overview of DML support for JSON Relational Duality Views introduced in version 9.4. [...]

Amazon RDS for MySQL announces Innovation Release 9.4 in Amazon RDS Database Preview Environment (from AWS What's New)

pAmazon RDS for MySQL now supports community MySQL Innovation Release 9.4 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 9.4 in the Amazon RDS Database Preview Environment which provides the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases.br br MySQ [...]

Oracle’s MySQL Layoffs — Strategy, Timing, and What It Means for Enterprise Customers (from One-Time MySQL Community/Ecosystem Posts)

The recent layoffs at Oracle’s MySQL team are not just another corporate restructuring. They are a signal — one that raises important questions for enterprises and the broader open-source community. [...]

Thursday, 18. September 2025

Dynamic view-based data masking in Amazon RDS and Amazon Aurora MySQL (from AWS Database Blog)

Data masking is an important technique in cybersecurity, allowing organizations to safeguard personally identifiable information (PII) and other confidential data, while maintaining its utility for development, testing, and analytics purposes. Data masking involves replacing original sensitive data with false, yet realistic information. This process helps ensure that the masked version preserves th [...]

Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar (from Shattered Silicon OSDB Blog)

pHow we squeezed 33% moreperformance out of tar on x86-64 Linux./p pThe post Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar appeared first on Shattered Silicon./p [...]

Help Shape the Future of Vector Search in MySQL (from Percona Database Blog)

♦AI and machine learning are seemingly everywhere, and that’s forcing every database company to think about vector search. Companies want to build things like smart search that actually understands what you mean, recommendation systems that know what you’ll like, and tools that can spot when something’s off. To make all of this work at the […] [...]

Monitoring and Managing MySQL Clusters Without Downtime (from Continuent Blog)

For organizations running mission-critical MySQL clusters, even brief service interruptions can translate to significant losses. Modern MySQL environments face unprecedented complexity through geographic distribution, diverse workload patterns, and stringent availability requirements. Traditional monitoring approaches cannot address these challenges effectively, requiring comprehensive strategies t [...]

MySQL Basics: Into the Shell—Cracking Open Your Database Journey (from The Oracle MySQL Blog)

This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time. [...]

Audit Log Filter Component (from Percona Community Blog)

pThe audit log filter component in MySQL 8.4 provides administrators with a powerful mechanism for auditing database activity at a fine-grained level. While it offers significant flexibility—such as selectively logging events based on users, hosts, or event types—it can also be challenging to understand and configure correctly./p pIn this article, we will examine how the audit log filter component [...]

Wednesday, 17. September 2025

Announcing MySQL AI (from The Oracle MySQL Blog)

Announcing the release of MySQL AI, an option to MySQL Enterprise Edition, that provides built-in predictive and generative AI capabilities and a vector store. [...]

MySQL with Diagrams Part Three: The Life Story of the Writing Process (from Percona Database Blog)

♦When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins — the moment the query is executed: [crayon-68e8c1986bbe4720595665/] The log […] [...]

Amazon RDS for MySQL announces Extended Support minor 5.7.44-RDS.20250818 (from AWS What's New)

pAmazon Relational Database Service (RDS) for MySQL now supports new Amazon RDS Extended Support minor version 5.7.44-RDS.20250818. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of MySQL. Learn more about upgrading your database instances, including minor and major version upgrades, in the Amazon RDS User Guide.br br Amazon RDS Extend [...]

Tuesday, 16. September 2025

Installing MariaDB Enterprise Kubernetes Operator on Ubuntu VM (from MariaDB Corporation Blog)

2. Install minikube & start minikubeminikube sets up a local Kubernetes clusterOffical guide: minikube start curl -LO github.com/kubernetes/minikube/releases/latest/download/minikube-linux-amd64 sudo install […] [...]

MySQL Deadlock Detection (from Releem Blog)

Understand, detect, and resolve deadlocks in your database with Releem’s automated monitoring and alerting. [...]

MySQL Basics: Understanding the Building Blocks of Databases (from The Oracle MySQL Blog)

Begin your hands-on MySQL adventure! This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time. [...]

Monday, 15. September 2025

Developing applications using LangChain and MySQL HeatWave GenAI – Part 1 (from The Oracle MySQL Blog)

Create a chatbot in LangChain using HeatWave GenAI [...]

Deploying Percona Operator for MongoDB Across GKE Clusters with MCS (from Percona Database Blog)

♦Ever needed a robust, highly available MongoDB setup that spans multiple Kubernetes clusters on GCP? This step-by-step guide shows you how to deploy the Percona Operator for MongoDB in two GKE clusters, linking them using Multi-Cluster Services (MCS) for seamless cross-cluster discovery and connectivity. Step 1: Prepare your GKE clusters & enable MCS 1. Prepare […] [...]

MySQL Podcast: InnoDB Cluster Group Replication (from Kedar MySQL Blog)

pI’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…/p The post MySQL Podcast: InnoDB Cluster Group Replication first appeared on Change Is Inevitable. [...]

Sunday, 14. September 2025

Mydbops Joins the MariaDB Foundation as a Silver Sponsor (from Mydbops Blog)

Mydbops is proud to announce its Silver Sponsorship of the MariaDB Foundation. Learn why we're committed to supporting the open-source community. [...]

Archiving MySQL Audit Logs into OCI Object Storage buckets using OCI Data Integration(OCI-DI) (from The Oracle MySQL Blog)

Customers need to analyze MySQL audit logs for compliance, monitoring, and troubleshooting, but managing large volumes in MySQL can be costly. An archival system addresses this by extracting logs and storing them in a cost-effective repository. OCI Object Storage offers durability, scalability, and easy integration. Once archived, logs can be analyzed using OCI Logging Analytics or third-party tool [...]

Zero-configuration TLS and password management best practices in MariaDB 11.8 (from Optimized by Otto)

♦pLocking down database access is probably the single most important thing for a system administrator or software developer to prevent their application from leaking its data. As MariaDB 11.8 is the first long-term supported version with a few new key security features, let’s recap what the most important things are every DBA should know about MariaDB in 2025./p pBack in the old days, MySQL a [...]

Saturday, 13. September 2025

Strategic Shift from Oracle to PostgreSQL (from MinervaDB Blog)

Introduction: The Strategic Shift from Oracle to PostgreSQL The “Why”: Drivers of Modernization The enterprise database landscape is undergoing a seismic shift. For decades, Oracle Database has been a cornerstone of corporate data infrastructure, renowned [...] [...]

Friday, 12. September 2025

Unlocking Simplicity: Setting Up REST Service for MySQL HeatWave (from The Oracle MySQL Blog)

Today’s developers strive for agility without sacrificing security or performance, especially when building data-driven apps and AI solutions. That’s why we’re excited to introduce the MySQL HeatWave REST Service (MRS), a fully managed, integrated solution that lets you create RESTful API endpoints instantly, directly from your MySQL HeatWave databases. There’s no need for backend coding, middlewar [...]

Postgres High Availability with CDC (from PlanetScale Blog)

Why a lagging client can stall or break failover, and how MySQL’s GTID model avoids it. [...]

Thursday, 11. September 2025

MariaDB Java Connector 3.5.6 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/J 3.5.6 release. Release Notes and Changelogs MariaDB Connector/J […] [...]

Postgres 18rc1 vs sysbench (from Small Datum)

pThis post has results for Postgres 18rc1 vs sysbench on small and large servers. Results for Postgres 18beta3 are here for a small and large server./pptl;dr/pp/pulliPostgres 18 looks great/liliI continue to see small CPU regressions in Postgres 18 for range queries that don't do aggregation on low-concurrency workloads. I have yet to explain that. /liliThe throughput for the scan microbenchma [...]

Monty Widenius 'heartbroken' at the extent of Oracle's MySQL job cuts (from The Register)

Original author of open source database 'not surprised' but 'saddened' as critics slam vendor's layoffs pOracle has instigated "widespread layoffs" across its core MySQL development team, sparking concern about the future of one of the world's most popular open-source databases.…/p [...]

In Depth MySQL Checks for HAProxy With Systemd Socket-Based Activation (from Continuent Blog)

Learn how to implement advanced MySQL health checks for HAProxy using systemd socket-based activation. Execute custom SQL queries for deeper database verification before routing traffic, replacing shallow TCP probes with intelligent failover decisions.Tags: haproxyMySQL health checkssystemd socket activationdatabase monitoringload balancer configuration [...]

Wednesday, 10. September 2025

Real-time analytics and simplified data pipelines with auto-refresh in MySQL HeatWave Lakehouse (from The Oracle MySQL Blog)

With automatic refresh of Lakehouse tables, MySQL HeatWave brings near real-time analytics and simplified data pipelines to data from object storage also. In this blog post we take a look at this feature, including setting it up, and its benefits. [...]

MariaDB Python Hackathon: Building Momentum with Quality Idea Submissions (from MariaDB Foundation Blog)

pThe MariaDB Python Hackathon is gaining impressive traction! Following our AMA session (Ask Me Anything) on Friday, September 5th, we’ve seen even more encouraging engagement. … /p pContinue reading \"MariaDB Python Hackathon: Building Momentum with Quality Idea Submissions\"/p pThe post MariaDB Python Hackathon: Building Momentum with Quality Idea Submissions appeared first on MariaDB [...]

The Onion framework – a new approach to Buildbot configuration (from MariaDB Foundation Blog)

pA framework that doesn’t make you cry.br Stay tuned to learn how you can get involved and contribute to the project!br If you don’t known what Buildbot is and what benefits it brings to MariaDB please check out this this quick introduction. … /p pContinue reading \"The Onion framework – a new approach to Buildbot configuration\"/p pThe post The Onion framework – a new [...]

Tuesday, 09. September 2025

Beyond EOL: The Real Benefits of Upgrading to MySQL 8.4 (from Percona Database Blog)

♦Right now, you’re probably hoping someone else will deal with this MySQL 8.0 end-of-life situation. Maybe your team can squeeze another few months out of it. Maybe Oracle will extend support. Maybe it won’t be as bad as everyone says. We get it.  You’ve got enough things going on without adding “major database upgrade” to […] [...]

Unleashing the Power of Data: Oracle & the AI Revolution (Live from TechCrunch) (from The Oracle MySQL Blog)

TechCrunch 2025 [...]

Monday, 08. September 2025

MariaDB Enterprise Server Q3 2025 Maintenance Releases with Backported Features (from MariaDB Corporation Blog)

New maintenance releases for MariaDB Enterprise Server 11.4.8-5, and 10.6.23-19 are now available. These releases include new backported features. Notable […] [...]

13 reasons SQL has got to go (from InfoWorld)

pFor all its popularity and success, SQL is a study in paradox. It can be clunky and verbose, yet for developers, it is often the simplest, most direct way to extract the data we want. It can be lightning quick when a query is written correctly, and slow as molasses when the query misses the mark. It’s decades old, but flush with new, bolted on features./p pThese paradoxes [...]

SIMD in Vector Search - “Hand-Tuned SIMD vs Compiler Auto-Vectorization” (from Zhao Song's Blog)

SIMD (Single instruction, multiple data) is often one of the key optimization techniques in vector search. In particular, when computing the distance between two vectors, SIMD can transform what was originally a one-dimensional-at-a-time calculation into 8- or 16-dimensions-at-a-time, significantly improving performance. [...]

Saturday, 06. September 2025

What can go wrong when using database transactions? (from Programming Brain)

Concurrency phenomena are anomalies that every software developer should know. [...]

Friday, 05. September 2025

This Month in MariaDB Foundation: August 2025 (from MariaDB Foundation Blog)

pAugust may have been a holiday month for many, but the MariaDB community certainly didn’t take a break. From Amsterdam to Bengaluru, from deep technical dives to festive dinners, August brought us fresh insights, new collaborations, and plenty of reasons to be excited about the road ahead. … /p pContinue reading \"This Month in MariaDB Foundation: August 2025\"/p pThe post This Month i [...]

PostgreSQL 18 to boost OLTP performance, but misses AI readiness (from InfoWorld)

pThe upcoming version of PostgreSQL 18, the latest release of the popular open-source database due later this month, will introduce performance-enhancing features, promising significant gains for online transactional processing (OLTP) workloads./p pHowever, according to industry experts, PostgreSQL 18 falls short in AI readiness despite rapid proliferation./p pPostgreSQ [...]

MySQL: Flag Codes from Country Codes (from Die wunderbare Welt von Isotopp)

pRegional Indicator Symbols in Unicode are the codes starting at codeU+1F1E6 /code to codeU+1F1FF/code. If you combine two of them in a valid ISO-3166-1 alpha-2 codes, they produce the flag corresponding to that code./p pWe want a function codeflag_emoji()/code that takes such a two-letter code and emits the appropriate Unicode codepoint:/p precodeSELECT flag_emoji('GB') AS gb, flag_emo [...]

Maxwell's Daemon Works with Dolt (from DoltHub Blog)

Dolt is the world's first version-controlled relational database. Dolt lets you branch, fork, clone, merge, and diff your relational data… [...]

Thursday, 04. September 2025

The Queen and the Thousand-and-One Story (from MariaDB Foundation Blog)

pIn the ancient tale of Scheherazade, it was not strength of arms or riches of gold that saved her life, but the power of storytelling. Each night, she told the king a tale so compelling that he postponed her execution — … /p pContinue reading \"The Queen and the Thousand-and-One Story\"/p pThe post The Queen and the Thousand-and-One Story appeared first on MariaDB.org./p [...]

August 2025 Recap: Azure Database for MySQL (from Azure for MySQL Blog)

pWe're excited to share a summary of the Azure Database for MySQL updates for the month of August 2025.  /p pJoin us live on our YouTube channel on September 11, 2025 for an exclusive webinar where we’ll dive deeper into these updates and answer your questions! Watch it live here./p Azure Database for MySQL 8.4 - General Availability  pWe’re excited [...]

Wednesday, 03. September 2025

August Product Update (from Readyset Blog)

♦pAs the world starts adding Earth, Wind and Fire back on to their playlists, here’s what’s new at Readyset: /pScaling WordPress Instantly with Readyset QueryPilotpLast month we launched Readyset QueryPilot, our zero-touch automatic caching solution, in beta for MySQL and early results are in./p [...]

How ElasticRun Adopted TiDB to Seamlessly Scale Peak E-Commerce Workloads (from PingCAP Blog)

pIn India’s dynamic e-commerce landscape, ElasticRun plays a pivotal role as the invisible infrastructure behind last-mile deliveries and deep rural distribution. The company’s ability to connect rural grocery stores to modern commerce hinges on technology and more specifically, a backend architecture that can keep up with relentless growth and fluctuating demand. But as their user […]/p pThe [...]

Delivering at Scale: How Ninja Van Powers Millions of Shipments with TiDB (from PingCAP Blog)

pFounded in 2014 in Singapore, Ninja Van is a leading last-mile logistics provider operating across six countries in Southeast Asia: Singapore, Malaysia, Indonesia, the Philippines, Vietnam, and Thailand — with nationwide coverage in each market. Ninja Van’s platform handles logistics for top-tier e-commerce players such as Amazon and Lazada. Offering services that span from parcel […]/p pThe [...]

Improving Performance of Vector Indexes Via VECTOR Columns (from DoltHub Blog)

We think everything is better with version control. That's why we made Dolt, the world's first version-controlled relational database. But… [...]

Tuesday, 02. September 2025

Automating Amazon RDS and Amazon Aurora recommendations via notification with AWS Lambda, Amazon EventBridge, and Amazon SES (from AWS Database Blog)

In this post, we walk through a solution that automates the notification of Amazon RDS and Aurora recommendations through email using AWS Lambda, Amazon EventBridge and Amazon Simple Email Service (Amazon SES). [...]

Collation improvements in Readyset (from Readyset Blog)

pHow often do you think about alphabetization?  Software engineers don’t typically think a lot about it.  How hard can it be to sort 26 letters, or maybe twice as many if you count lower and upper case?  But examination of real world alphabetization quickly reveals/p [...]

MariaDB passes MySQL in WordPress usage (from MariaDB Foundation Blog)

pIn May, Otto Kekäläinen emailed the developers mailing list with some interesting news. MariaDB had passed MySQL in WordPress usage. And this was not just wishful thinking, but according to the official WordPress statistics. … /p pContinue reading \"MariaDB passes MySQL in WordPress usage\"/p pThe post MariaDB passes MySQL in WordPress usage appeared first on MariaDB.org./p [...]

MariaDB Onwards and Upwards in September 2025 (from MariaDB Foundation Blog)

pThe MariaDB open source project keeps growing! The amount of unique external contributors to the MariaDB project is at an all time high, as well as Docker image downloads – … /p pContinue reading \"MariaDB Onwards and Upwards in September 2025\"/p pThe post MariaDB Onwards and Upwards in September 2025 appeared first on MariaDB.org./p [...]

Testing MySQL REST Service with Helidon and OCI GenAI (from lefred's blog)

Recently, I published an article related to MRS (MySQL REST Service), which we released as a lab. I wanted to explore how I could use this new cool feature within an application. I decided to create an application from scratch using Helidon. The application uses the Sakila sample database. Why Helidon? I decided to use […] [...]

XAMPP + Apache Friends need more Friends (from MariaDB Foundation Blog)

pXAMPP, Apache + MariaDB + PHP + Perl, is a valuable learning installer/product for new developers on Windows, Linux and MacOS. There needs to more maintainers, potentially you, for this product to remain useful. … /p pContinue reading \"XAMPP + Apache Friends need more Friends\"/p pThe post XAMPP + Apache Friends need more Friends appeared first on MariaDB.org./p [...]

Postgres 18 beta3, small server, sysbench (from Small Datum)

pThis has performance results for Postgres 18 beta3, beta2, beta1 and 17.6 using the sysbench benchmark and a small server. The working set is cached and the benchmark is run with low concurrency (1 connection). The goal is to search for CPU regressions. This work was done by Small Datum LLC and not sponsoredbr/pptl;dr/pp/pulliThere might be small regressions (~2%) for several range queri [...]

Monday, 01. September 2025

Mydbops Joins MariaDB Foundation as Silver Sponsor (from MariaDB Foundation Blog)

pWe are delighted to announce that Mydbops has joined the MariaDB Foundation as a Silver Sponsor!br Mydbops is a trusted leader in open-source database consulting, empowering organizations worldwide to design, optimize, and scale their MySQL and MariaDB environments. … /p pContinue reading \"Mydbops Joins MariaDB Foundation as Silver Sponsor\"/p pThe post Mydbops Joins MariaDB Foundation as S [...]

MaxScale: much more than a reverse SQL proxy (part 2) a nerdy yet comprehensive presentation (from The consistent voice)

pIn my previous story i explained what Maxscale is all about : a powerful database proxy developed by MariaDB plc that sits between client applications and backend servers, enabling advanced features like load balancing, query routing, and automatic failover. I also detailed there the value proposition for businesses around the world.brTime to dive deeper into the nerdy bits !! (yay !)/ppAt the hea [...]

Using MySQL HeatWave as a knowledge base with the OCI AI Agent Platform (from The Oracle MySQL Blog)

How to use MySQL HeatWave’s vector store as a knowledge base when using OCI’s Generative AI Agent Service [...]

DuckDB internals(1)-File Format Overview (from One-Time MySQL Community/Ecosystem Posts)

DuckDB is renowned for its high query performance. However, due to DuckDB's relatively short development history, there aren't many articles that deeply analyze its various modules. This series of articles will dissect DuckDB from the source code level. This article, as the first in the DuckDB source code analysis series, will begin by introducing the file format, focusing on the storage of metadat [...]

Saturday, 30. August 2025

Cassandra Consistency Level Guide: Mastering Data Consistency in Distributed Systems (from MinervaDB Blog)

Unlocking Cassandra Consistency Levels for Better Data Management: Mastering Cassandra Consistency Levels in Distributed Systems Introduction Apache Cassandra’s consistency levels are fundamental to understanding how this distributed NoSQL database manages data across multiple nodes. As [...] [...]

Mastering MySQL EXPLAIN Format: Optimizing Query Performance in MySQL 8.0.32 (from MinervaDB Blog)

Mastering MySQL EXPLAIN Format: Optimizing Query Performance in MySQL 8.0.32 Database performance optimization is critical for modern applications, and understanding how MySQL executes queries is fundamental to achieving optimal performance. The EXPLAIN statement provides information [...] [...]

Real-Time Streaming: Integrating TiDB Cloud Changefeed with StreamNative Cloud (from PingCAP Blog)

pAt PingCAP, our mission with TiDB Cloud is to make data easier, faster, and more powerful for developers and enterprises. Today, we’re taking that vision one step further with a new capability: streaming real-time data changes directly from TiDB Cloud into the StreamNative Cloud ecosystem. This integration, powered by TiDB Cloud’s Changefeed feature, gives you […]/p pThe post Real-Time Strea [...]

Friday, 29. August 2025

Introducing Natural Language to SQL for MySQL HeatWave (from The Oracle MySQL Blog)

Announcing the release of a new Natural Language to SQL (NL2SQL) feature for MySQL HeatWave. This innovative capability enables users to easily convert questions expressed in natural language into SQL queries, simplifying data analysis and accelerating insights. [...]

PostgreSQL Monitoring with ProxySQL (from ProxySQL Blog)

pThis blogpost dives into the latest advancements in ProxySQL's monitoring capabilities, specifically about the recently added monitoring support for PostgreSQL, as well as serve as a guide for you through ProxySQL configuration process, showcasing inspecting monitoring data, error handling and how ProxySQL will ensure high availability and resilience for your PostgreSQL deployments. As a [...]/p p [...]

Two Models, One World: Introducing JSON Relational Duality Views in MySQL HeatWave (from The Oracle MySQL Blog)

An overview of the support for JSON Relational Duality Views introduced in version 9.4 and made available in the MySQL HeatWave managed cloud service and elsewhere. [...]

Log Anomaly Detection with MySQL HeatWave AutoML (from The Oracle MySQL Blog)

This post discusses log anomaly detection; key use cases and the challenges faced in identifying anomalies within log data. [...]

Azure Database for MySQL 8.4 Now Generally Available (from Azure for MySQL Blog)

pWe’re excited to announce that Azure Database for MySQL – Flexible Server now supports MySQL 8.4 in General Availability (GA). This means you can create new MySQL 8.4 servers on Azure fully supported for production workloads. MySQL 8.4 is a long-term supported release from the MySQL community, bringing the latest features and improvements while emphasizing stability. With Azure’s managed serv [...]

Diegesis becomes Silver Sponsor of MariaDB Foundation to champion digital transformation in an open-source environment (from MariaDB Foundation Blog)

pDiegesis, the London-based business and technology consultancy, is pleased to announce that it has joined the non-profit MariaDB Foundation as a Silver Sponsor to ensure one of the world’s most popular database servers – … /p pContinue reading \"Diegesis becomes Silver Sponsor of MariaDB Foundation to champion digital transformation in an open-source environment\"/p pThe post Die [...]

Personal opinion : MariaDB (re)acquires SkySQL (from The consistent voice)

Personal opinion : MariaDB plc (re)acquires SkySQLpFollowing the news of MariaDB plc (re)acquiring SkySQL announced in the Register or TechIntelPro , i wanted to share my thought about that significant move./ppMariaDB’s decision to bring SkySQL back home is particularly interesting, especially in the context of today’s AI-driven hype. SkySQL had originally been spun off in 2023 because it was burni [...]

Unit Tests for your Dolt Database (from DoltHub Blog)

Dolt is the only database with a built-in testing framework called Dolt CI. We've talked a lot about how AI agents work better with tests in… [...]

Thursday, 28. August 2025

MariaDB Enterprise Kubernetes Operator 25.08: Next-Level Disaster Recovery and Expanded Platform Support (from MariaDB Corporation Blog)

[...]

MySQL “Got an Error Reading Communication Packet”: Complete Troubleshooting Guide (from MinervaDB Blog)

MySQL “Got an Error Reading Communication Packet”: Complete Troubleshooting Guide – MySQL Error Reading Communication Packet The “Got an error reading communication packet” error, also known as MySQL Error Reading Communication Packet, is one of [...] [...]

What a difference 2 years makes: MariaDB buys back SkySQL (from The Register)

Bringing DBaaS back on board in face off with Oracle pIt's less than two years since MariaDB spun out SkySQL, but it's already unspinning the database-as-a-service outfit, which has since been marinated in AI sauce.…/p [...]

How I Use Multiple Agents in Parallel (from DoltHub Blog)

At DoltHub, we've been at the forefront of exploring how AI agents can remodel software development, writing extensively about our… [...]

Wednesday, 27. August 2025

Accelerate database migration using virtual target mode in AWS DMS Schema Conversion (from AWS Database Blog)

AWS recently announced virtual target mode in AWS Database Migration Service (AWS DMS) Schema Conversion. This feature helps you start migration planning without provisioning target databases. In this post, we show you how to get started using virtual target mode in AWS DMS Schema Conversion. [...]

Bun JS toolkit adds MySQL driver, secrets API, YAML, and more (from The Register)

Feature bloat, or added value for this JavaScript toolkit? pThe Bun team has released version 1.2.21 of its JavaScript bundler and runtime, written in Zig, adding features including built-in drivers for MySQL and SQLite, a YAML parser, and a secrets manager for tools and local development.…/p [...]

How to design a DBMS for Telco requirements (from Mikael Ronstrom)

p My colleague Zhao Song presented a walkthrough of the evolution of the DBMSs and how it relates to Google Spanner, Aurora, PolarDB and MySQL NDB Cluster./ppI had some interesting discussions with him on the topic and it makes sense to return to the 1990s when I designed NDB Cluster and the impact on the recovery algorithms from the requirements for a Telco DBMS./ppA Telco DBMS is a DBMS [...]

MariaDB buys back the company it sold two years ago (from InfoWorld)

pMariaDB, a company that as recently as last year was very much in transition due in part to the fact its new CEO, Rohit de Souza, is a specialist in preparing organizations for acquisition and resale, went in another direction Tuesday by making an acquisition of its own. /p pIt brought SkySQL, the cloud-based database-as-a-service (DBaaS) platform which it spun off in lat [...]

Tuesday, 26. August 2025

Understanding Cloud-Native Databases: A Complete Guide for Modern Applications (from MinervaDB Blog)

Understanding Cloud-Native Databases: A Complete Guide for Modern Applications Cloud-native databases represent a fundamental shift in how organizations store, manage, and access their data in the modern digital landscape. As businesses increasingly migrate to cloud [...] [...]

PostgreSQL VACUUM Guide: Complete Best Practices for Database Maintenance (from MinervaDB Blog)

PostgreSQL VACUUM Guide: Complete Best Practices for Database Maintenance PostgreSQL’s VACUUM process is a critical maintenance operation that ensures optimal database performance and prevents storage bloat. This comprehensive guide covers everything you need to know [...] [...]

Why Most MySQL HA Setups Fail – And How to Fix Them (from Continuent Blog)

After two decades of helping enterprises achieve continuous MySQL operations, we've probably seen it all. The midnight calls about failed failovers. The "highly available" systems that went down for hours during a simple maintenance window. The multi-million-dollar applications that were brought to their knees by a single database node failure.Tags: best practicesHigh AvailabilityDisaster Reco [...]

PostgreSQL vs Microsoft SQL Server: The Ultimate Database Comparison Guide for 2025 (from MinervaDB Blog)

PostgreSQL vs Microsoft SQL Server: The Ultimate Database Comparison Guide for 2025 Choosing the right database management system can make or break your organization’s data strategy. Two powerhouses dominate the enterprise database landscape: PostgreSQL and [...] [...]

Unlocking AI Potential: A Complete Guide to Vector Database Capabilities in PostgreSQL (from MinervaDB Blog)

Unlocking AI Potential: A Complete Guide to Vector Database Capabilities in PostgreSQL The landscape of database management is rapidly evolving as artificial intelligence applications become integral to modern business operations. Traditional relational databases, while excellent [...] [...]

GeeksGoPeaks Svalbard Expedition 2025 (from Peter Zaitsev)

pSvalbard Hiking Trip What is Svalbard anyway ? Svalbard is an archipelago off the north coast of Norway and is a very interesting place from many angles. It is the northernmost place you can easily get to – a regularly scheduled 3-hour flight from Oslo takes you to Longyearbyen, the capital of the Archipelago, and […]/p pThe post GeeksGoPeaks Svalbard Expedition 2025 appeared first on [...]

MySQL 5.6 thru 9.4: small server, Insert Benchmark (from Small Datum)

pThis has results for the Insert Benchmark on a small server with InnoDB from MySQL 5.6 through 9.4. The workload here uses low concurrency (1 client), a small server and a cached database. I run it this way to look for CPU regressions before moving on to IO-bound workloads with high concurrency.brbr/pptl;dr/pp/pulligood news - there are no large regressions after MySQL 8.0/lilibad news - there are [...]

Monday, 25. August 2025

Unleashing TiDB Scalability: The Next Generation of DDL Execution (from PingCAP Blog)

pSchema changes at scale can be a nightmare for SaaS applications. Slow index creation, long-running schema modifications, and scalability limits can disrupt operations, making real-time database evolution nearly impossible. TiDB has been tackling these challenges head-on, continuously pushing the boundaries of distributed SQL and DDL execution. Last year, we boosted index creation speed by 10x, en [...]

Releasing ProxySQL v3.0.2! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 3.0.2 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL and PostgreSQL, with a GPL license! It is freely usable and accessible according to the GNU GPL v3.0 license. It can be downloaded from the ProxySQL Repository or for a Docker [...]/p pThe post Releasing ProxySQL v3.0.2! appeared first on ProxySQL. [...]

Skeema 1.13 released (from Skeema Blog)

pSkeema v1.13 has been released! This new version provides significant performance improvements, and adds support for recent database server versions such as MariaDB 11.8 LTS. It also includes important deprecation logging to help you prepare for upcoming changes in Skeema v2./p [...]

Amazon RDS for MariaDB now supports MariaDB 11.8 with MariaDB Vector support (from AWS What's New)

pAmazon RDS for MariaDB now supports MariaDB major version 11.8, the latest long-term maintenance release from the MariaDB community. This release supports MariaDB 11.8.3 minor version.br br Amazon RDS for MariaDB 11.8 now supports the MariaDB Vector feature, allowing you to store vector embeddings in your database and use retrieval-augmented generation (RAG) when building your Artificial Intellige [...]

Don’t Trust, Verify: How MyDumper’s Checksums Validates Data Consistency (from Percona Database Blog)

♦How do you know if your backup is truly reliable? The last thing you want is to discover your data is corrupted during a critical restore or during a migration. While MyDumper is a powerful tool for logical backups, its -M option takes backup integrity to the next level by creating checksums. This often-overlooked feature […] [...]

Sunday, 24. August 2025

25 Advanced MySQL DBA Questions and Answers: Master Database Administration (from MinervaDB Blog)

25 Advanced MySQL DBA Questions and Answers: Master MySQL Database Administration Database administrators face increasingly complex challenges in today’s data-driven world. This comprehensive guide covers 25 advanced MySQL DBA questions that test deep technical knowledge [...] [...]

Generating Numeric Sequences in MySQL: A Comprehensive Guide (from MinervaDB Blog)

Generating Numeric Sequences in MySQL: A Comprehensive Guide Numeric sequences are fundamental building blocks in database management, serving as unique identifiers, counters, and data generation tools. Whether you need to create sequential IDs, generate test [...] [...]

Saturday, 23. August 2025

🚀 Build the Future with Python & MariaDB – Win $10,000 and Dinner with the MySQL & MariaDB Founder! (from MariaDB Foundation Blog)

pImagine hacking your way to $10,000 in prizes (sponsored by MariaDB plc) – and topping it off with an exclusive dinner in Finland with Monty Widenius, the legendary creator of MySQL and MariaDB. … /p pContinue reading \"🚀 Build the Future with Python & MariaDB – Win $10,000 and Dinner with the MySQL & MariaDB Founder!\"/p pThe post 🚀 Build the Future with Python & MariaDB – [...]

Friday, 22. August 2025

How to optimize Amazon RDS and Amazon Aurora database costs/performance with AWS Compute Optimizer (from AWS Database Blog)

In this post, we dive deeper into database optimization for your Amazon Relational Database Service (Amazon RDS), exploring how you can use AWS Compute Optimizer recommendations to make cost-aware resource configuration decisions for your MySQL and PostgreSQL databases. [...]

MySQL 8.0 Deprecated Features: What You Need to Know (from Percona Database Blog)

♦If you manage a MySQL database, you’ve probably heard the news: MySQL 8.0 is heading for its End of Life (EOL), and taking center stage is MySQL 8.4, the first-ever Long-Term Support (LTS) release. This is great news for all of us who value stability, as it means a more predictable, enterprise-ready platform for the […] [...]

Thursday, 21. August 2025

Sysbench for MySQL 5.6 thru 9.4 on a small server (from Small Datum)

pThis has performance results for InnoDB from MySQL 5.6.51, 5.7.44, 8.0.43, 8.4.6 and 9.4.0 on a small server with sysbench microbenchmarks. The workload here is cached by InnoDB and my focus is on regressions from new CPU overheads. This work was done by Small Datum LLC and not sponsored. /pptl;dr/pp/pulliLow concurrency (1 client) is the worst case for regressions in modern MySQL/l [...]

Best Practices for Managing MongoDB Log Files and System Resources (from MinervaDB Blog)

Best Practices for Managing MongoDB Logs and System Resources MongoDB’s performance and reliability heavily depend on proper log file management and system resource optimization. As your database grows, implementing effective monitoring and maintenance strategies becomes [...] [...]

An Overview of DDL Algorithms in MySQL 8: Enhancing Schema Changes (from MinervaDB Blog)

An Overview of DDL Algorithms in MySQL 8 DDL: Enhancing Schema Changes Database schema modifications have long been a source of concern for database administrators, particularly in high-traffic production environments where downtime can be costly. [...] [...]

Behind the Magic: How Readyset Speeds Up Queries with Streaming Dataflow (from Readyset Blog)

pDatabase performance is often the bottleneck in high-traffic web applications. Whether you're serving user dashboards, product catalogs, or personalized content, the same SQL queries get executed repeatedly. Caching sounds like the natural solution. However, traditional caching can be challenging to implement correctly: you need to manually add cache/p [...]

MariaDB Connector/C 3.4.7, and 3.3.17 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.4.7, and 3.3.17. Release Notes and Changelogs MariaDB Connector/C […] [...]

MySQL Router 8.4: How to Deal with Metadata Updates Overhead (from Percona Database Blog)

♦It may be surprising when a new InnoDB Cluster is set up, and despite not being in production yet and completely idle, it manifests a significant amount of writes visible in growing binary logs. This effect became much more spectacular after MySQL version 8.4. In this write-up, I will explain why it happens and how to address […] [...]

How to reach 100M Key lookups using REST server with Python clients (from Mikael Ronstrom)

p A few months ago I decided to run a benchmark to showcase how RonDB 24.10 can handle 100M Key lookups per second using our REST API server from Python client. This exercise is meant to show both how RonDB can scale to handle throughput requirements as well as latency requirements for Personalised Recommendation systems that are commonly used by companies such as Spotify, E-commerce sites and [...]

Deep dive into Clang sanitizer testing with MariaDB (Post Event) (from MariaDB Foundation Blog)

pEarlier I posted that this presentation was about to happen, and it did! I presented to a keen audience of over 20 people live, and number who watched later (it was in a rather early US time, however attracted a number of attendees from Europe, India, Thailand all the way to east of Australia at UTC+10:30. … /p pContinue reading \"Deep dive into Clang sanitizer testing with MariaDB (Post Eve [...]

Unlocking Regional Insights with the Location Based Capabilities REST API (from Azure for MySQL Blog)

pManaging MySQL Flexible Server deployments across Azure regions often means navigating differences in available features, SKUs, storage options, backup retention periods, or high availability configurations. These variations can directly impact performance, cost, and resilience, making it critical to choose the right region for each workload. That’s where the Location-Based Capability Set – List A [...]

Wednesday, 20. August 2025

Typical Mistakes in Open Source Sales (from Peter Zaitsev)

pOne key way Open Source Software is different from classic Commercial software is that not every user is going to be a customer. In fact, for most successful Open Source projects, the number of users and uses is orders of magnitude more than the number of customers and “paid” deployments. You may argue Commercial Open […]/p pThe post Typical Mistakes in Open Source Sales appeared first on Pe [...]

July 2025 At Releem: Recommendations Impact & Redundant Index Detection (from Releem Blog)

This month brings a deeper query insights, and smarter health checks, so you get a clear, real-time view of database activity and can respond to problems in record time. [...]

Tuesday, 19. August 2025

From Outages to Velocity: Designing a Resilient, Elastic Data Layer with Distributed SQL (from PingCAP Blog)

pMost companies suffer from a serious problem that limits their growth, and most don’t even know it. By the time they find out, it’s costing them millions in missed opportunities for product progress. It’s an infrastructure bottleneck — the root cause of most major issues with online applications. It causes downstream outages. It slows, and […]/p pThe post From Outages to Velocity: Designing [...]

WordPress with QueryPilot: Instant Database Scaling Without Code Changes (from Readyset Blog)

IntroductionpWe at Readyset, recently launched the public beta of QueryPilot, an automatic query caching layer designed to make scaling relational databases effortless. QueryPilot analyzes real-time query traffic, identifies high-impact patterns, and transparently caches results, without requiring code changes or database tuning. /ppIn an effort to show how easy/p [...]

Vibe code with AWS databases using Vercel v0 (from AWS Database Blog)

In this post, we explore how you can use Vercel’s v0 generative UI to build applications with a modern UI for AWS purpose-built databases such as Amazon Aurora, Amazon DynamoDB, Amazon Neptune, and Amazon ElastiCache. [...]

Archive Smarter, Query Faster: Unlocking MySQL Performance with HeatWave (from MySQL expert Diary)

pAs databases grow, DBAs and developers often face a tough choice:br + Keep historical data in production tables and risk slow queriesbr + Archive it and lose fast access/p pWith HeatWave, you don’t have to choose. You can archive old partitions, keep recent data in production, and still run lightning-fast queries across all your data./p The post Archive Smarter, Query Faster: Unlocking MySQL Per [...]

Demand Sales Forecasting with HeatWave Regression for Manufacturing Company (from MySQL Solutions - On Premises & Cloud)

p /pIntroduction pIn the manufacturing sector, demand forecasting is the heartbeat of efficient operations. Knowing how many units of a product will sell in the future allows companies to optimize production schedules, manage inventory, and align supply chain decisions with actual customer demand./p pTraditionally, demand forecasting requires building machine learning pipelines, exporting sale [...]

Telco's Customer Churn Prediction using HeatWave AutoML (from MySQL Solutions - On Premises & Cloud)

Introduction pIn today’s hyper-competitive telecom landscape, customer churn—the likelihood of a subscriber leaving a service provider—has emerged as one of the biggest challenges. Acquiring new customers is expensive, while retaining existing ones directly boosts profitability. According to industry benchmarks, reducing churn by even 5% can increase profits by 25%–95%./p pFor telecom operators (te [...]

Monday, 18. August 2025

Demystifying the AWS advanced JDBC wrapper plugins (from AWS Database Blog)

In 2023, AWS introduced the AWS advanced JDBC wrapper, enhancing the capabilities of existing JDBC drivers with additional functionality. This wrapper enables support of AWS and Amazon Aurora functions on top of an existing PostgreSQL, MySQL, or MariaDB JDBC driver of your choice. This wrapper supports a variety of plugins, including the Aurora connection tracker plugin, the limitless connection pl [...]

Announcing Amazon Aurora MySQL 3.10 as long-term support (LTS) release (from AWS What's New)

pStarting today, long-term support (LTS) will also be provided on Aurora MySQL 3.10 (compatible with MySQL 8.0.42) minor version. Database clusters that use LTS releases can stay on the same minor version for at least three years or until end of standard support for the major version, whichever is sooner. During the lifetime of an Aurora MySQL LTS release, new patches introduce fixes for select hig [...]

Google adds VM monitoring to Database Center amid enterprise demand (from InfoWorld)

pGoogle has updated its AI-powered database fleet management offering — Database Center — with the capability to monitor self-managed databases running on its own compute virtual machines (VMs)./p pSeveral enterprises run their databases, such as PostgreSQL and MySQL, on compute VMs as they offer more flexibility, scalability, and cost-effectiveness when compared to dedica [...]

MySQL 9.4 – Thank you for your contributions! (from The Oracle MySQL Blog)

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. In this post we list the contributions we included in the latest version of MySQL. [...]

MySQL 9.4 – Thank you for your contributions! (from lefred's blog)

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

Friday, 15. August 2025

3 Tips to Scale Multi-Tenant SaaS Data Without Pain (from PingCAP Blog)

pOne of the most persistent challenges facing engineering leaders is how to design a scalable, secure, and cost-efficient multi-tenant SaaS architecture. While multi-tenancy enables shared infrastructure and rapid onboarding, it also introduces significant complexity, especially at scale. In a recent webinar Kathryn Sizemore, Principal Solutions Architect at TiDB, explored the realities of building [...]

Amazon RDS for MariaDB now supports community MariaDB minor versions 11.4.8, 10.11.14 and 10.6.23 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports community MariaDB minor versions 11.4.8, 10.11.14 and 10.6.23. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can leverage [...]

Comparing Cursor Agent to Claude Code (from DoltHub Blog)

Cursor Agent was released last week on August 7. I compared all the coding agents in a recent article using real world tasks on our open… [...]

Thursday, 14. August 2025

A Message for MySQL Galera Cluster Users: Our Commitment to Your High Availability (from Galera Blog)

In an ever-evolving technology landscape, clarity and commitment are paramount. With MariaDB’s recent acquisition of Codership, the creators of Galera Cluster, we want to provide a clear path forward for users who depend on high availability. By bringing the architects of Galera Cluster under the same roof as our own database experts, we are not […] [...]

A Message For MySQL Galera Cluster Users: Our Commitment To Your High Availability (from MariaDB Corporation Blog)

In an ever-evolving technology landscape, clarity and commitment are paramount. With MariaDB’s recent acquisition of Codership, the creators of Galera […] [...]

MySQL Commands To Gather Runtime Statistics For Database Performance Assessment (from The Oracle MySQL Blog)

This post explains how to collect metrics on connections, resource usage, query performance and database characteristics. [...]

How To Select The Best Shape When Migrating From On-Premise MySQL To HeatWave On Oracle Cloud Infrastructure (from The Oracle MySQL Blog)

This post will give you some information and tips on how to select the appropriate MySQL HeatWave shape when migrating your on-premise MySQL instance to Oracle Cloud Infrastructure. [...]

Top 5 Security Risks of Running MySQL 8.0 After Its EOL (from Percona Database Blog)

♦Your MySQL database has been running smoothly for years. Your team knows it inside and out. Everything just… works. Why rock the boat with an upgrade? Here’s why: MySQL 8.0 reaches its end-of-life date in April 2026. After this date, there’s no safety net; staying on end-of-life software means you’re taking on all the responsibility […] [...]

What’s After Happily Ever After? (from MariaDB Foundation Blog)

pThis week, I turn 50 — my golden jubilee, if we’re speaking in royal terms.br Once upon a time, a much younger woman wandered into the magical forest of open source. … /p pContinue reading \"What’s After Happily Ever After?\"/p pThe post What’s After Happily Ever After? appeared first on MariaDB.org./p [...]

Announcing Dolt MCP (from DoltHub Blog)

AI agents need branches and Dolt is the only SQL database with branches. This means that agents also need Dolt. Today, we're excited to… [...]

Wednesday, 13. August 2025

Database Scaling Solutions: Mydbops, TiDB & AWS Meetup (from Mydbops Blog)

Explore practical solutions for database scaling from our workshop with Mydbops, TiDB, and AWS. Learn how Distributed SQL solves common bottlenecks and see what's next in data. [...]