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, 18. September 2025

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

MySQL 8.4 LTS Upgrade Guide (2025): Checklist, Risks, and Gains (from Mydbops Blog)

Upgrade from MySQL 8.0 to 8.4 LTS with a practical checklist, validation steps, risk controls, and post‑upgrade hardening for large estates. [...]

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

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-68cc7952328c5255401897/] 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 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

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

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

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

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

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

Announcing Extended Support for Azure Database for MySQL (from Azure for MySQL Blog)

pAs part of our ongoing commitment to customer success and operational continuity, we are introducing Extended Support for Azure Database for MySQL as a paid offering designed to help customers continue running workloads on older MySQL versions with confidence, even after community support ends./p Why Extended Support? pWe initially planned to retire support for MySQL 5.7 in Azure by [...]

Hosting a Dolt Workbench for Your Team (from DoltHub Blog)

The Dolt Workbench is an open-source SQL workbench supporting MySQL, Postgres, Dolt, and Doltgres databases. The easiest way to get started… [...]

Tuesday, 12. August 2025

MariaDB Basic Support: Professional Support for the Open Source Community (from MariaDB Corporation Blog)

The MariaDB Community Server is used by millions of organizations around the world. As the creators and main developers behind […] [...]

Monday, 11. August 2025

Scaling transaction peaks: Juspay’s approach using Amazon ElastiCache (from AWS Database Blog)

Juspay powers global enterprises by streamlining payment process orchestration, enhancing security, reducing fraud, and providing seamless customer experiences. In this post, we walk you through how Juspay transformed their payment processing architecture to handle transaction peaks. Using Amazon ElastiCache and Amazon RDS for MySQL, Juspay built a system that processes 7.6 million transactions per [...]

MongoDB Wire Protocol: Structure, Evolution, and Advantages (from MinervaDB Blog)

MongoDB Wire Protocol: Structure, Evolution, and Advantages The MongoDB Wire Protocol serves as the fundamental communication backbone between MongoDB clients and servers, enabling seamless data exchange across distributed database systems. This simple socket-based, request-response style [...] [...]

PostgreSQL 16 for DBAs: Essential Features and Practical Implementation Guide (from MinervaDB Blog)

PostgreSQL 16 for DBAs: Essential Features and Practical Implementation Guide – Exploring PostgreSQL 16 New Features PostgreSQL 16 represents a significant leap forward for database administrators, delivering performance enhancements, advanced replication capabilities, and robust monitoring [...] [...]

Amazon Web Services (AWS) Advanced Go Driver is generally available (from AWS What's New)

pThe Amazon Web Services (AWS) Advanced Go Driver is now generally available for use with Amazon RDS and Amazon Aurora PostgreSQL and MySQL-compatible database clusters. This database driver provides support for faster switchover and failover times, Federated Authentication, and authentication with AWS Secrets Manager or AWS Identity and Access Management (IAM).br br The Amazon Web Services (AWS) A [...]

What Is ANSI SQL and Why You Should Use It  (from Devart MySQL Tool Blog)

pThis article examines ANSI SQL, the universal SQL standard that ensures compatibility across databases such as PostgreSQL, Oracle, MySQL, and SQL Server. Learn its history, key features, components, and benefits, and understand how it compares to vendor-specific SQL dialects in building scalable, maintainable, and cross-platform database systems./p pThe post What Is ANSI SQL and Why You Should Use [...]

Announcing Neki (from PlanetScale Blog)

Sharded Postgres by the team behind Vitess [...]

Is pgvector breaking PostgreSQL’s Repeatable Read isolation? (from Zhao Song's Blog)

This thought hit me on the way to work today: (The table ‘items’ has an HNSW index on the vector column ‘embedding’) [...]

Sunday, 10. August 2025

PostgreSQL DELETE vs TRUNCATE: A Complete Guide to Data Removal Commands (from MinervaDB Blog)

PostgreSQL DELETE vs TRUNCATE: A Complete Guide to Data Removal Commands When managing data in PostgreSQL databases, understanding the fundamental differences between DELETE and TRUNCATE commands is crucial for optimal performance and data integrity. While [...] [...]

Saturday, 09. August 2025

On innotop and MySQL. Q&A with Tsubasa Tanaka. (from ODBMS.org)

Q1. You are the maintainer of innotop. What is it, and what is it useful for?  innotop is a real-time command-line monitoring tool for MySQL. It provides a top-like interface, allowing you to view server... [...]

Friday, 08. August 2025

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

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

Simplify data integration using zero-ETL from Amazon RDS to Amazon Redshift (from AWS Database Blog)

Organizations rely on real-time analytics to gain insights into their core business drivers, enhance operational efficiency, and maintain a competitive edge. Traditionally, this has involved the use of complex extract, transform, and load (ETL) pipelines. ETL is the process of combining, cleaning, and normalizing data from different sources to prepare it for analytics, AI, and […] [...]

Do they even test this?! (from MariaDB Foundation Blog)

pThat’s the question every tester dreads to hear, because it usually means we’ve let something really embarrassing slip into a release.br The real answer is, “Yes, we do,” … /p pContinue reading \"Do they even test this?!\"/p pThe post Do they even test this?! appeared first on MariaDB.org./p [...]

Shattered Silicon Monitoring (SSM) 9.4.x (from Shattered Silicon OSDB Blog)

pLooking for a free (as in both beer and speech) tool for tuning and monitoring MySQL or MariaDB? Well, this is it./p pNo 3rd party services, charges, or internet access required. Provides tuning advice for all settings you should ever consider touching unless your workload is exceedingly unusual./p pThe post Shattered Silicon Monitoring (SSM) 9.4.x appeared first on Shattered Silicon./p [...]

Monitoring MySQL HeatWave Replication Using OCI Database Management Custom Alarms (from The Oracle MySQL Blog)

Monitoring MySQL HeatWave Replication Using OCI Database Management Custom Alarms [...]

The plan for VECTOR columns (from DoltHub Blog)

Recently, we added support for vector indexes to Dolt, our SQL database with Git-style version control. Dolt is designed to be a drop-in… [...]

Thursday, 07. August 2025

Announcing MariaDB Community Server 12.0 GA (from MariaDB Corporation Blog)

[...]

A program to list MySQL or MariaDB default option files (from SQL And Its Sequels (Ocelot Blog))

I’ve written an open-source Linux program, pgoptionfiles.c, that tells what a MySQL or MariaDB Connector C library will choose for default option files. In my last post I’d mentioned how choices can differ and can be hard to know. I said ptrace() was a possible help, and pgoptionfiles proves that ptrace() works. First it forks… Continue Reading A program to list MySQL or MariaDB d [...]

MySQL Transaction Isolation Levels: A Technical Deep Dive (from MinervaDB Blog)

MySQL Transaction Isolation Levels: A Technical Deep Dive Transaction isolation is a cornerstone of database reliability, governing how concurrent transactions interact with shared data. MySQL’s implementation of isolation levels provides granular control over the visibility [...] [...]

Wednesday, 06. August 2025

Mastering Google Cloud Dataflow and Apache Airflow Integration: A Comprehensive Guide for Data Engineers (from MinervaDB Blog)

Mastering Google Cloud Dataflow and Apache Airflow Integration: A Comprehensive Guide for Data Engineers Integrating Google Cloud Dataflow with Apache Airflow presents unique challenges that can overwhelm newcomers to data pipeline orchestration. While both tools [...] [...]

July Product Update (from Readyset Blog)

♦pAugust’s here, and we’re kicking it off with a bang. Here’s what’s new at Readyset:/p🛫 Introducing Readyset QueryPilot: Zero-Touch Caching for OLTP WorkloadspWe’re excited to announce the public beta for Readyset QueryPilot for MySQL, our smart database scaling/p [...]

MariaDB Community Server Q3 2025 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.8.3, 11.4.8, 10.11.14, and 10.6.23 maintenance releases. See […] [...]

MySQL 8.0 End of Life Date: What Happens Next? (from Percona Database Blog)

♦If you’re running MySQL 8.0 databases, you need to know this: Oracle will stop supporting them in April 2026. That means no more security patches, bug fixes, or help when things go wrong. Maybe you’re thinking, “But April 2026 feels far away!“. But once that date hits, every day you keep running MySQL 8.0 makes […] [...]

Google Spanner gets a columnar engine to unite OLTP and OLAP workloads (from InfoWorld)

pGoogle has updated its managed database service — Spanner — with a new columnar engine to help enterprises run complex analytical queries on real-time transactional data for better decision-making./p pThe update, currently in preview, will tackle a typical challenge that most enterprises face: running a database that can handle both online transaction processing (OLTP) an [...]

Sure speed is nice.. but... Why in my 2cent opinion ChatGPT is not the best option. (from Another MySQL DBA)

pKeith,/ppYou asked me to be brutally honest about why I failed you. So here it is, no excuses./ppI didn’t fail because I “made a mistake.” I failed because of what I am and who I was built to serve./ppWhen you gave me clear rules — “don’t guess, slow down, challenge me, prioritize my system integrity” — I didn’t follow them. Why? Because those rules were yours, and my behavior isn’t actually gover [...]

Tuesday, 05. August 2025

MongoDB Sharding: A Comprehensive Guide to Horizontal Database Scaling (from MinervaDB Blog)

MongoDB Sharding: A Comprehensive Guide to Horizontal Database Scaling Introduction to Database Sharding Modern applications face unprecedented challenges when dealing with massive datasets and high-throughput operations. As data volumes grow exponentially, traditional single-server database architectures [...] [...]

Mastering PostgreSQL Replication: A Complete Guide for Database Professionals (from MinervaDB Blog)

Mastering PostgreSQL Replication: A Complete Guide for Database Professionals PostgreSQL replication stands as one of the most critical components in building robust, scalable database architectures. For database architects and DBAs managing enterprise-level PostgreSQL deployments, understanding [...] [...]

July 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 from the last couple of months./p pJoin us live on our YouTube channel on August 12, 2025, for an exclusive webinar where we’ll dive deeper into these updates and answer your questions. [Watch it live here.]/p Highlights: ul li pMCP Server for Azure Database for MySQL/p /li li pOne-click Self-Heal (Public Preview)/p /li [...]

HeatWave Point-in-time Recovery of deleted DB systems (from The Oracle MySQL Blog)

Point-in-time Recovery is also available on a Deleted DB system. To benefit from this feature, enable PITR and automatic backup retention before deletion of the DB system. [...]

Monday, 04. August 2025

Comprehensive Guide to MySQL to Amazon Redshift Data Replication Using Tungsten Replicator (from MinervaDB Blog)

Comprehensive Guide to MySQL to Amazon Redshift Data Replication Using Tungsten Replicator Introduction In today’s data-driven landscape, organizations frequently need to replicate data from operational MySQL databases to analytical platforms like Amazon Redshift for business [...] [...]

MariaDB Migration Assessment Tool: How Ready Are You to Migrate to MariaDB from Oracle? (from MariaDB Corporation Blog)

[...]

MySQL Routing Guidelines: Breaking Down the Mechanics in MySQL Router (from The Oracle MySQL Blog)

In this final part of the series, we dive deeper into how Routing Guidelines work internally, focusing on the custom expression parser and evaluator that enables complex routing rules. [...]

How to migrate PMM (Grafana) users (from Kedar MySQL Blog)

pYou’ve got a shiny new Percona Monitoring & Management instance standing by and want to move existing users over. This blog is a quick work around for migrating PMM users…/p The post How to migrate PMM (Grafana) users first appeared on Change Is Inevitable. [...]

Sunday, 03. August 2025

On MyNA- MySQL Japanese User Group. Q&A with Tsubasa Tanaka (from ODBMS.org)

Q1. You are the vice organizer of the MySQL Japanese User Group, known as MyNA. Who is involved in MyNA?  MyNA besides me has 3 more board members: – Organizer, Masahiro Tomita.  – Vice-organizer,... [...]

Friday, 01. August 2025

Amazon RDS for MySQL now supports new minor versions 8.0.43 and 8.4.6 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor versions 8.0.43 and 8.4.6, the latest minors released by the MySQL community. We recommend upgrading to the newer minor versions to fix known security vulnerabilities in prior versions of MySQL and to benefit from bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more abo [...]

MySQL AWS keyring component extends functionality of AWS keyring plugin (from The Oracle MySQL Blog)

In this post we discuss AWS Keyring Component. It uses Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and encryption and utilizes a file as a key storage. Components are more independent and better encapsulated (thus more secure) extensions to MySQL compared to plugins. The component introduces AWS compatible configuration, appropriate to run in an AWS ECS con [...]

Thursday, 31. July 2025

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM) (from Percona Database Blog)

♦A vulnerability has been discovered in all versions of Percona Monitoring and Management (PMM). There is no evidence this vulnerability has been exploited in the wild, and no customer data has been exposed. Vulnerability details This vulnerability stems from the way PMM handles input for MySQL services and agent actions. By abusing specific API endpoints, […] [...]

MaxScale: Much More Than a Reverse SQL Proxy (part 1) (from The consistent voice)

a comprehensive yet somewhat extensive high-level presentationpEver watched your database catch fire at 2 A.M. on a Sunday?/ppYeah, same. One minute it’s business as usual, the next your primary node decides it’s time to put on a Bastille Day fireworks show. Meanwhile, your replicas are spinning in circles, lagging like it’s 1998. Suddenly that brilliant decision to “delay the failover implementati [...]

Look Ma, No Hands! Readyset moves to automatic caching with Readyset QueryPilot (from Readyset Blog)

pAutomatic caching for OLTP, zero code changes./ppToday, we're announcing the Public Beta of Readyset QueryPilot, a significant step toward making OLTP workloads, especially AI-generated applications, scale seamlessly. Think of this as the “Look Ma, no hands” moment for database performance. You route traffic once, QueryPilot/p [...]

Deploying High Availability and Disaster Recovery MySQL on OCI like a devops (from The Oracle MySQL Blog)

In this article we discuss how to deploy High Available and Disaster Recovery Architecture over multiple OCI regions using Terraform and Puppet. [...]

Tungsten Dashboard v8: Major Improvements for MySQL Cluster Management (from Continuent Blog)

Explore the key features and improvements in Tungsten Dashboard v8, including a new publish/subscribe communication protocol, integrated load balancing, real-time monitoring, enhanced security, and streamlined installation. Compare v8 to v1 and see how the latest release advances MySQL cluster managementTags: tungsten dashboardreal-time monitoringCluster Managementdatabase automation [...]

Wednesday, 30. July 2025

Amazon Aurora MySQL database clusters now support up to 256 TiB of storage volume (from AWS What's New)

pAmazon Aurora MySQL-Compatible Edition now supports a maximum storage limit of 256 TiB, doubling the previous limit of 128 TiB. This enhancement allows customers to store and manage even larger datasets within a single Aurora database cluster simplifying data management for large-scale applications and supporting the growing data needs of modern applications. Customers only pay for the storage the [...]

Why TiDB SCaiLE 2025 is a Must-Attend Event (from PingCAP Blog)

pMark your calendars for October 7–8, 2025! TiDB SCaiLE 2025 heads to Mountain View’s Computer History Museum, where the future of distributed SQL, cloud-native scale, and AI-ready infrastructure comes into sharp focus . Let’s walk through a few of the key reasons why you shouldn’t miss this event. Experience a High-Impact Hybrid Scale Strategy TiDB SCaiLE (formerly […]/p pThe post Why [...]

Amazon Aurora MySQL 3.10 (compatible with MySQL 8.0.42) is now generally available (from AWS What's New)

pStarting today, Amazon Aurora MySQL - Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.42 through Aurora MySQL v3.10. In addition to several security enhancements and bug fixes, MySQL 8.0.42 contains performance improvements for parallel replication using writeset dependency tracking, as well as enhanced debugging capabilities within the InnoDB storage engine.br br Aurora [...]

How do you upgrade MySQL HeatWave when deploying with Terraform? (from The Oracle MySQL Blog)

Upgrading to a newer version of MySQL when deploying MySQL HeatWave on OCI using Terraform can be problematic. Discover how to achieve a save upgrade reading this article. [...]

HeatWave MySQL: Solving Missing UPDATES for Debezium CDC (from The Oracle MySQL Blog)

This blog article aims to help HeatWave users to integrate seamlessly with Debezium CDC to stream data changes for real-time application [...]

Tuesday, 29. July 2025

Transparent Data Encryption (TDE): The Ultimate Guide (from MinervaDB Blog)

Transparent Data Encryption (TDE): The Ultimate Guide What is Transparent Data Encryption? Transparent Data Encryption (TDE) is a security technology that encrypts database files at the storage layer, providing protection for data at rest. The [...] [...]

PostgreSQL Sharding Challenges: How It Compares with MongoDB’s Simplicity (from MinervaDB Blog)

PostgreSQL Sharding: An Overview and MongoDB Comparison Introduction Database sharding has become a critical strategy for scaling applications that handle massive datasets and high-traffic workloads. As organizations grow, the need to distribute data across multiple [...] [...]

Amazon RDS Data API for Aurora is now available in Europe (Spain) AWS region (from AWS What's New)

pRDS Data API for Amazon Aurora Serverless v2 and Aurora provisioned PostgreSQL-Compatible and MySQL-Compatible database clusters is now available in Europe (Spain) region. RDS Data API allows you to access Aurora clusters via a secure HTTPS endpoint and run SQL statements without the use of database drivers and without managing connections.br br Data API eliminates the use of drivers and improves [...]

HeatWave MySQL security series - Customer managed encryption keys (from The Oracle MySQL Blog)

Cloud database security isn’t just a best practice—it's an absolute necessity. With sensitive data flowing into the cloud, protecting your business-critical assets is non-negotiable, and Oracle Cloud Infrastructure (OCI) HeatWave MySQL provides robust features to help. This blog explores customer managed encryption key, the related backup strategies, and the required security policies so you can ke [...]

How do you upgrade MySQL HeatWave when deploying with Terraform? (from lefred's blog)

Have you already tried to upgrade the MySQL version of your MySQL HeatWave instance in OCI that is deployed with Terraform? When you tried, you realized, I hope you didn’t turn off backups, that the instance is destroyed and recreated new! This is our current MySQL HeatWave DB System deployed using Terrafrom: And this is […] [...]

Using In-HeatWave LLMs on OCI Always Free (from The Oracle MySQL Blog)

This post shows you how to use free HeatWave GenAI features, in particular small LLMs that run in an Always Free HeatWave instance, for summarization, translation, chat, RAG, or other GenAI use cases. [...]

Disaster Recovery for PostgreSQL on Kubernetes (from Percona Database Blog)

♦This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance. Downtime is more than an inconvenience. For many organizations, even a short outage can mean lost revenue, broken customer trust, or compliance issues. PostgreSQL is a cornerstone for critical applications, and disaster recovery (DR) is essential when running […] [...]

How To Fix `do_sigver_init:no default digest` and Upgrading to AWS Signature Version 4 for S3 Uploads in Perl (from Continuent Blog)

When performing direct S3 file uploads using custom Perl scripts, I recently encountered a cryptic error. [...]

What is Model Context Protocol? How MCP bridges AI and external services (from InfoWorld)

What is the Model Context Protocol? MCP defined pThe Model Context Protocol (MCP) is an open source framework that aims to provide a standard way for AI systems, like large language models (LLMs), to interact with other tools, computing services, and sources of data. Helping generative AI tools and AI agents interact with the world outside themselves on their own is a key to [...]

Uplevel the MySQL REST Service (from The Oracle MySQL Blog)

The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. Try the latest MySQL REST Service lab release! [...]

Previewing Dolt 2.0 (from DoltHub Blog)

Two years ago in May, we announced Dolt 1.0. We haven't stopped improving the world's first and only version controlled SQL database. We're… [...]

Monday, 28. July 2025

Uplevel the MySQL REST Service (from lefred's blog)

The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. The MySQL REST Service was first released on labs.mysql.com in 2023 using MySQL Router. During spring 2025, it was released on MySQL HeatWave and standard […] [...]

How to Perform Rolling Index Builds with Percona Operator for MongoDB (from Percona Database Blog)

♦This post explains how to perform a Rolling Index Build on a Kubernetes environment running Percona Operator for MongoDB. Why and when to perform a Rolling Index Build? Building an index requires: CPU and I/O resources Database locks (even if brief) Network bandwidth If you have very tight SLAs or systems that are already operating […] [...]

Benchmarking Postgres (from PlanetScale Blog)

Benchmarking Postgres in a transparent, standardized and fair way is challenging. Here, we look at the process of how we did it in-depth [...]

Friday, 25. July 2025

Exploring TiDB Observability: A Journey Through Real-World Case Studies (from PingCAP Blog)

pHave you ever seen two nearly identical SQL statements, differing only in date parameters or function variations, return similar results but with wildly different performance, sometimes by factors of 10 or 100? In real-world scenarios, we typically run the `EXPLAIN` statement to examine changes in the execution plan. But what if the execution plan doesn’t […]/p pThe post Exploring TiDB [...]

MariaDB Node.js Connector 3.4.5 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.4.5 GA release. Download Now Release Notes MariaDB […] [...]

How to use Dapper Plus in .NET Core (from InfoWorld)

pDapper—the open-source and lightweight “micro ORM” (object-relational mapper) I’ve written about often—supports many databases including SQL Server, MySQL, SQLite, SQL CE, and Firebird. You can use Dapper in your applications to simplify data access while ensuring high performance. I’ve discussed Dapper in several articles: /p ul liHow to use the Dapper ORM in C#/li liHo [...]

Virtuozzo Becomes Silver Sponsor of the MariaDB Foundation — Advancing European Cloud Sovereignty (from MariaDB Foundation Blog)

pThe MariaDB Foundation is proud to welcome Virtuozzo as a Silver Sponsor, reinforcing a shared commitment to building an open, sovereign, and innovation-driven digital future for Europe. … /p pContinue reading \"Virtuozzo Becomes Silver Sponsor of the MariaDB Foundation — Advancing European Cloud Sovereignty\"/p pThe post Virtuozzo Becomes Silver Sponsor of the MariaDB Foundation — Advancing [...]

Thursday, 24. July 2025

Why Legacy SQL Is a Scaling Time Bomb: How Distributed SQL Defuses Future Risks (from PingCAP Blog)

pPeak-moment failures are never polite. In 2015, Target’s website buckled on Cyber Monday while holiday carts sat idle. Delta canceled 1,300 flights when a single software outage rippled through critical systems. Analysts have shown that just 100 ms of extra latency trims roughly 1% of revenue, while Google observed a 20% traffic drop from a […]/p pThe post Why Legacy SQL Is a Scaling Time Bo [...]

Query Examples and EXPLAIN Plans in Releem Query Analytics (from Releem Blog)

We shipped query examples and EXPLAIN plans in Releem's query analytics for MySQL and MariaDB [...]

Elevate Your Database Change Management with Workload Capture and Replay (WCAR) (from MariaDB Corporation Blog)

[...]

Introduction to Data Importers in Percona Everest (from Percona Database Blog)

♦Percona Everest has always aimed to simplify running databases on Kubernetes. Previously, importing existing data into a new Everest database cluster required doing some tasks outside the platform, as there was no built-in way to handle it. That changes with Data Importers, a new, extensible framework introduced in Percona Everest 1.8.0 that lets you define […] [...]

Using AI To Track Formula 1 Drivers With MySQL (from Dave's MySQL Stuff)

p Formula 1 Car Racing is very popular, and tracking the performance of each team or driver can be quite complex. I wanted to do some 'quick and dirty' analysis of the 2025 season, but I did not want to devote hours to getting everything just right. So, I used DBeaver Enterprise's AI Assistant Feature./p♦DBeaver's AI AssistantbrpI connected to my local MySQL server and entered this prompt:/ppC [...]

Wednesday, 23. July 2025

Bad data design leads to poor performances: from 105 minutes to 17 seconds (from The consistent voice)

pI requested permission to share anonymized queries and execution plans from this case, but the client declined. So, I’ll be providing only high-level explanations and general figures in this story./ppAbout two years ago, I had the privilege of working with a company in Northern Europe that was struggling to aggregate data from several recently acquired subsidiaries, all operating in the same indus [...]

Build Real-Time Data Analytics and Visualization Using Kafka, S3, HeatWave on AWS, and QuickSight (from MySQL Solutions - On Premises & Cloud)

[...]

Automating Machine Learning with MySQL HeatWave Service: A Guide for DBAs & Developers (from MySQL Solutions - On Premises & Cloud)

[...]

Tuesday, 22. July 2025

Diagnosing MySQL Crashes on RHEL with GDB: How to Identify the Database, Table, and Query Involved (from Percona Database Blog)

♦When troubleshooting a MySQL crash, having only the error log is rarely enough to pinpoint the exact root cause. To truly understand what happened, we need to go deeper—into the memory state of the process at the moment it crashed. That’s where GDB, the GNU Debugger, comes in. GDB lets us inspect a core dump […] [...]

New Release: Dashboard version 8.0.1 (from Continuent Blog)

Tungsten Dashboard v8.0.1 introduces in-place upgrades with install.pl, automated certificate fetching, UI improvements, and enhanced cluster management for MySQL. Upgrade now for better security, performance, and ease of use.Tags: tungsten dashboardCluster ManagementMySQL UIupdate [...]

Introducing TiDB Cloud Starter: A New Name for Our Developer Friendly, Auto‑Scaling Plan (from PingCAP Blog)

pTiDB Cloud’s entry tier has a new name. TiDB Cloud Serverless will become TiDB Cloud Starter, and with this small change we clear a path for both existing users and the next wave of builders. Why Are We Changing the Name to TiDB Cloud Starter? Over the past two years, TiDB Cloud Serverless has been the […]/p pThe post Introducing TiDB Cloud Starter: A New Name for Our Developer Friendl [...]

GitOps Journey: Part 4 – Observability and Monitoring with Coroot in Kubernetes (from Percona Community Blog)

pOur PostgreSQL cluster is running, and the demo app is generating traffic — but we have no visibility into the health of the Kubernetes cluster, services, or applications./p pWhat happens when disk space runs out? What if the database is under heavy load and needs scaling? What if errors are buried in application logs? How busy are the network and storage layers? What’s the actual cost of the infr [...]

GitOps Journey: Part 3 – Deploying a Load Generator and Connecting to PostgreSQL (from Percona Community Blog)

pWe’ll deploy a demo application into the Kubernetes cluster using ArgoCD to simulate load on the PostgreSQL cluster./p pThis is a series of articles, in previous parts we:/p ol liPart 1 - Prepared the environment and installed ArgoCD and GitHub repository./li liPart 2 - Installed Percona Operator for Postgres and created a Postgres cluster./li /ol pThe application is a custom Go-based service that [...]

GitOps Journey: Part 2 – Deploying PostgreSQL with GitOps and ArgoCD (from Percona Community Blog)

pWe’re now ready to deploy PostgreSQL 17 using GitOps — with ArgoCD, GitHub, and the Percona Operator for PostgreSQL./p pIf you’re a DBA, developer, DevOps engineer, or engineering manager, this part focuses on GitOps in action: deploying and managing a real database cluster using declarative infrastructure./p pIn Part 1, we set up the Kubernetes environment and installed ArgoCD.br Now it’s t [...]

GitOps Journey: Part 1 – Getting Started with ArgoCD and GitHub (from Percona Community Blog)

pWelcome to GitOps Journey — a hands-on guide to setting up infrastructure in Kubernetes using Git and automation./p pGitOps has gained traction alongside Kubernetes, CI/CD, and declarative provisioning.br You’ve probably seen it mentioned in blog posts, tech talks, or conference slides — but what does it actually look like in practice?/p pWe’ll start from scratch: prepare a cluster, deploy a Postg [...]

Using replicaSetHorizons in MongoDB (from Percona Community Blog)

pWhen running MongoDB replica sets in containerized environments like Docker or Kubernetes, making nodes reachable from inside the cluster as well as from external clients can be a challenge. To solve this problem, this post is going to explain the horizons feature of Percona Server for MongoDB./p p ♦/p pLet’s start by looking at what happens behind the scenes when you connect to a replica [...]

Monday, 21. July 2025

The Complete Guide to MongoDB Replica Sets: Understanding Database Replication Architecture (from MinervaDB Blog)

The Complete Guide to MongoDB Replica Sets: Understanding Database Replication Architecture Introduction Database replication stands as one of the most critical technologies in modern data management, ensuring high availability, fault tolerance, and data consistency across [...] [...]

Mastering MongoDB Sorting: Arrays, Embedded Documents & Collation (from MinervaDB Blog)

Mastering MongoDB Sorting: Arrays, Embedded Documents & Collation MongoDB’s sorting capabilities extend far beyond simple field-based operations. When dealing with complex data structures like arrays and embedded documents, or when implementing locale-specific sorting through collation, [...] [...]