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.

Friday, 29. August 2025

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

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 – 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 – Win $10,000 and Dinner wit [...]

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

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

Cost-Benefit Analysis: RDS vs Aurora vs Aurora Serverless (from MinervaDB Blog)

Cost-Benefit Analysis: RDS vs Aurora vs Aurora Serverless Choosing the right AWS database service requires careful consideration of pricing models, performance characteristics, and operational requirements. This comprehensive analysis examines Amazon RDS, Aurora, and Aurora Serverless [...] [...]

What is Distributed SQL (from MinervaDB Blog)

What is Distributed SQL? A Complete Guide to Modern Database Architecture Introduction In today’s data-driven world, businesses need databases that can scale globally while maintaining the reliability and consistency of traditional SQL systems. Distributed SQLrepresents [...] [...]

MongoDB TTL Indexes (from MinervaDB Blog)

MongoDB TTL Indexes: Automatic Document Expiration for Efficient Data Management Introduction In modern database management, handling temporary or time-sensitive data efficiently is crucial for maintaining optimal performance and storage utilization. MongoDB’s Time-To-Live (TTL) indexes provide [...] [...]

Using replicaSetHorizons in MongoDB (from Percona Database Blog)

♦When 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 will explain the Horizons feature of Percona Server for MongoDB. Let’s start by looking at what happens behind the scenes […] [...]

Amazon RDS for PostgreSQL, MySQL, and MariaDB now supports M6i database instances in additional AWS regions (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports M6i database (DB) instances in AWS GovCloud (US-West), AWS GovCloud (US-East), Asia Pacific (Hyderabad) and Asia Pacific (Jakarta) regions.br br M6i DB instances are available for Amazon RDS for PostgreSQL version 17.1 and higher, 16.1 and higher, 15.4 and higher, 14.9 and higher, and 13.11 and higher. [...]

Amazon RDS for PostgreSQL, MySQL, and MariaDB now supports M7i database instances in AWS Asia Pacific (Melbourne) region (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports M7i database (DB) instances in AWS Asia Pacific (Melbourne) region. M7i is the latest Intel based offering and is available with a new maximum instance size of 48xlarge, which brings 50% more vCPU and memory than the maximum size of M6i instance type.br br M7i DB instances are available for Amazon RDS f [...]

Amazon RDS for PostgreSQL, MySQL, and MariaDB now supports R7g database instances in additional AWS Regions (from AWS What's New)

pAmazon Relational Database Service (RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton3-based R7g in AWS GovCloud (US-East), Asia Pacific (Osaka), Europe (Zurich), Asia Pacific (Jakarta), Israel (Tel Aviv) and Canada West (Calgary) regions. Graviton3-based instances provide up to a 30% performance improvement over Graviton2-based instances on RDS for open-source databases depending [...]

Amazon Aurora now supports R7g database instances in additional AWS Regions (from AWS What's New)

pAWS Graviton3-based R7g database instances are now generally available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in Asia Pacific (Osaka), Asia Pacific (Jakarta), Canada West (Calgary), Europe (Zurich), Europe (Paris), Israel (Tel Aviv), Middle East (UAE) and AWS GovCloud (US-East) regions. Graviton3 instances provide up to 30% performance improvemen [...]

Amazon RDS for PostgreSQL, MySQL, and MariaDB now supports M8g and R8g database instances in additional AWS Regions (from AWS What's New)

pAmazon Relational Database Service (RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton4-based M8g database instances in Asia Pacific (Hyderabad) and Asia Pacific (Tokyo) regions and R8g database instances in AWS US West (N. California) regions. For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page.br br Graviton4-based instances p [...]

Amazon Aurora now supports R8g database instances in the AWS US West (N. California) region (from AWS What's New)

pAWS Graviton4-based R8g database instances are now generally available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in the AWS US West (N. California) region. R8g instances offer larger instance sizes, up to 48xlarge and features an 8:1 ratio of memory to vCPU, and the latest DDR5 memory. Graviton4-based instances provide up to a 40% performance improv [...]

Sunday, 20. July 2025

Choosing the Right Database: MariaDB vs. MySQL, PostgreSQL, and MongoDB (from MinervaDB Blog)

Choosing the Right Database: MariaDB vs. MySQL, PostgreSQL, and MongoDB Selecting the right database management system (DBMS) is one of the most critical decisions in software development. With numerous options available, developers often find themselves [...] [...]

10 Essential JSON Functions in MySQL 8.0 (from MinervaDB Blog)

10 Essential JSON Functions in MySQL 8.0: Complete Guide for Developers MySQL 8.0 revolutionized JSON data handling with powerful new functions that bridge the gap between NoSQL flexibility and relational database structure. Whether you’re a [...] [...]

Friday, 18. July 2025

5 Reasons Why Amazon Aurora Fails to Scale Large, Complex Workloads (from PingCAP Blog)

pAs digital services become more intelligent, personalized, and data-intensive, the infrastructure supporting them must evolve as well. Today’s applications aren’t just storing data, they’re making real-time decisions on it, often across globally distributed environments with high user concurrency and strict uptime requirements. Amazon Aurora, a fully managed relational database from AWS, is a comm [...]

How Can AI Talk to My Database Part Two: MySQL and Gemini (from Percona Database Blog)

♦My first experiments creating an MCP Server to provide AI access to a PostgreSQL database using the FastMCP Python framework and Anthropic’s and OpenAI’s APIs highlighted an important requirement: for now, these two APIs can only communicate with an MCP server through HTTPS over a public URL. While researching how to make this work (which […] [...]

Thursday, 17. July 2025

From Hypothesis to Validation: How User Research Shaped TiDB Cloud’s New Navigation (from PingCAP Blog)

pDesigning intuitive navigation in a cloud database platform is no small task. TiDB Cloud offers powerful features, but as capabilities expand, so does the complexity of its interface. Users often work across multiple roles, organizations, and environments. If they can’t find what they need quickly, it slows them down and weakens their trust in the […]/p pThe post From Hypothesis to Validatio [...]

“I Am Not Building Cadillacs Anymore” (from MariaDB Foundation Blog)

pThe Ford–Cadillac Parablebr In 1902, Henry Ford’s second car company was taken over by investors and renamed Cadillac. The designs were his. The engineering was his. … /p pContinue reading \"“I Am Not Building Cadillacs Anymore”\"/p pThe post “I Am Not Building Cadillacs Anymore” appeared first on MariaDB.org./p [...]

Scaling Observability: Why TiDB Moved from Prometheus to VictoriaMetrics (from PingCAP Blog)

pFrom the outset, Prometheus has served as a go-to tool for real-time performance metric collection, storage, querying, and observability in TiDB. Additionally, TiDB supports offline diagnostics using TiDB Clinic, which allows for replaying collected metrics to investigate historical issues. Figure 1. How TiDB Clinic provides offline diagnostics. However, as deployments scaled, so did the challenge [...]

MariaDB Thread Contention Troubleshooting (from MinervaDB Blog)

Troubleshooting MariaDB Thread Contention: Expert Solutions for High-Performance Database Operations Understanding MariaDB Thread Contention Thread contention in MariaDB occurs when multiple threads compete for the same resources, leading to performance degradation and system bottlenecks. This [...] [...]

Troubleshooting ProxySQL in High-Velocity Data Ingestion: Critical Pitfalls and Expert Solutions (from MinervaDB Blog)

Troubleshooting ProxySQL in High-Velocity Data Ingestion: Critical Pitfalls and Expert Solutions Understanding the Challenge: ProxySQL in High-Performance Environments ProxySQL serves as the critical middleware layer in high-velocity data ingestion platforms built on Percona XtraDB Cluster [...] [...]

Amazon OpenSearch Service now supports integration with Amazon Aurora MySQL and PostgreSQL (from AWS What's New)

pAmazon OpenSearch Service now allows seamless ingestion of data from Amazon Aurora MySQL and PostgreSQL, enabling customers to take advantage of advanced search capabilities like full-text, hybrid and vector search on their data in relational databases. Customers can now synchronize their data from Amazon Aurora MySQL and PostgreSQL to Amazon OpenSearch Service within seconds of it being written w [...]

Amazon OpenSearch Service now supports integration with Amazon RDS for MySQL and PostgreSQL (from AWS What's New)

pAmazon OpenSearch Service now allows seamless ingestion of data from Amazon RDS for MySQL and PostgreSQL, enabling customers to take advantage of advanced search capabilities like full-text, hybrid and vector search on their data in relational databases. Customers can now synchronize their data from Amazon RDS for MySQL and PostgreSQL to Amazon OpenSearch Service within seconds of it being written [...]

Deploying High Availability and Disaster Recovery MySQL on OCI like a devops (from lefred's blog)

We all know MySQL InnoDB ClusterSet, a solution that links multiple InnoDB Clusters and Read Replicas asynchronously to easily generate complex MySQL architectures and manage them without burdensome commands. All this thanks to the MySQL Shell’s AdminAPI. This is an example of MySQL InnoDB ClusterSet using two data centers: Let’s explore how we can automate […] [...]

Wednesday, 16. July 2025

Options for MySQL or MariaDB Connector C libraries (from SQL And Its Sequels (Ocelot Blog))

Some Connector/C options can have better explanations than what’s in the MySQL or MariaDB manuals. Here they are. Files Putting together the MySQL and MariaDB Connector/C manuals’ words, Connector/C reads these files in this order: /etc/my.cnf MYSQL always. MariaDB only if DEFAULT_SYSCONFDIR not defined /etc/mysql/my.cnf MySQL always. MariaDB only if DEFAULT_SYSCONFDIR not defined SYSCO [...]

Enterprise MariaDB Operations (from MinervaDB Blog)

Enterprise MariaDB Operations: Strategic MariaDB Solutions for Database Leadership Executive Summary for CTOs and Technical Leadership In an era where data infrastructure directly impacts business outcomes, MariaDB has become the backbone of mission-critical applications across [...] [...]

How to rapidly deploy databases on bare metal, VMs, and containers (from Severalnines Blog)

pWhat happens when your new application needs a production-ready database cluster in hours, not days? If you’re relying on traditional deployment methods that involve manual provisioning, tedious configuration, and complex integrations, then good luck. But what if you could achieve cloud-like deployment speeds for your database infrastructure, whether it’s on bare metal, virtual machine [...]

Leveraging Prolly Trees for Efficient Table Merging (from DoltHub Blog)

tl,dr: We're adding a new algorithm for that should massively speed up merges when two branches modify the same table but different regions… [...]

Tuesday, 15. July 2025

MariaDB Python Connector 1.1.13 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Python 1.1.13 release. Release Notes MariaDB Connector/Python 1.1.13 MariaDB […] [...]

Implementing Percona Audit Plugin for Percona XtraDB Cluster with ProxySQL (from MinervaDB Blog)

Implementing Percona Audit Plugin for Percona XtraDB Cluster with ProxySQL Introduction Database auditing is crucial for compliance, security monitoring, and forensic analysis in enterprise environments. The Percona Audit Plugin provides comprehensive database activity logging for [...] [...]

Instant Schema Prototyping: VS Code + AI + MariaDB MCP (from MariaDB Corporation Blog)

The process goes like this: Running the MariaDB MCP Server using Docker Compose You can start a MariaDB MCP Server […] [...]

10 Essential Tips for Getting Started with SQLyog (from Webyog Blog)

pFirst Steps for Beginners Databases power most of our digital world today, and managing them well is very important. SQLyog is a helpful tool for database administrators and developers that […]/p pThe post 10 Essential Tips for Getting Started with SQLyog appeared first on Webyog./p [...]

I beat the MariaDB optimizer: from 94 seconds to just 55 milliseconds (from The consistent voice)

I beat the MariaDB optimizer: from 94 seconds to just 55 millisecondspSome client of mine recently migrated from MySQL 8 to MariaDB 11.4CS. YAY to them !!!!/ppAs a side effect, this particular query saw a massive performance drop down to 1min 34sec from 148ms. NAY to this !!!!/ppreSELECTbr sd.ID,br sd.NUMERO_DOSSIER,br sd.LAST_SYNC_DATE,br sd.NS_REFERENCE,br sd.METIER,br sd.STATUS [...]

Monday, 14. July 2025

MyDumper Refactors Locking Mechanisms (from Percona Database Blog)

♦In my previous blog post, Understanding trx-consistency-only on MyDumper Before Removal, I talked about --trx-consistency-only removal, in which I explained that it acts like a shortcut, reducing the amount of time we have to block the write traffic to the database by skipping to check if we are going to backup any non-transactional tables. Now, […] [...]

MariaDB Foundation Welcomes Rumahweb as a Silver Sponsor (from MariaDB Foundation Blog)

pWe are thrilled to announce that Rumahweb, one of Indonesia’s most trusted and long-standing web hosting providers, has joined the MariaDB Foundation as a Silver Sponsor. … /p pContinue reading \"MariaDB Foundation Welcomes Rumahweb as a Silver Sponsor\"/p pThe post MariaDB Foundation Welcomes Rumahweb as a Silver Sponsor appeared first on MariaDB.org./p [...]

Per-table unique FOREIGN KEY constraint names – new feature in MariaDB 12.1 (from MariaDB Foundation Blog)

pFor historical reasons, the handling of FOREIGN KEY constraints in MariaDB Server is somewhat peculiar. Unlike CHECK constraints, which are being enforced at the query execution layer for all tables, FOREIGN KEY constraint definitions will simply be ignored unless the underlying storage engine supports them. … /p pContinue reading \"Per-table unique FOREIGN KEY constraint names – new f [...]

Exploring the Internals of pgvector (from Zhao Song's Blog)

pgvector brings vector similarity search capabilities to the PostgreSQL. Thanks to PostgreSQL’s flexible extension architecture, pgvector can focus purely on implementing the vector index: defining the vector data type, implementing index operations like insert, search, and vacuum, managing index page and tuple formats, and handling WAL logging. PostgreSQL handles the rest — index file and page buf [...]

Friday, 11. July 2025

WiredTiger Storage Engine Internals (from MinervaDB Blog)

Mastering MongoDB Performance: WiredTiger Storage Engine Internals Explained MongoDB’s WiredTiger storage engine powers millions of applications worldwide, yet its internal mechanisms remain a mystery to many developers. Understanding its caching, checkpointing, and compression systems is [...] [...]

The FinTech Scalability Crisis: How Distributed SQL Unlocks Innovation with Zero Downtime Operations (from PingCAP Blog)

pThe FinTech industry is innovating at record speed. From embedded payments and AI-driven fraud detection to real-time credit scoring and risk analytics, financial services are becoming faster, smarter, and more personalized. But behind the scenes, many platforms are still powered by legacy databases and architectures built for a different era. Traditional systems are struggling to […]/p pThe [...]

Innodb_file_per_table - Best Practices of tuning MySQL (from Releem Blog)

Best Practices of Using MySQL Innodb_file_per_table [...]

Make JSON DEPTH unlimited – new feature in MariaDB 12.1 (from MariaDB Foundation Blog)

pAt some point, nearly every developer encounters a common challenge: working with deeply nested JSON only to run into an arbitrary depth limit imposed by the database. … /p pContinue reading \"Make JSON DEPTH unlimited – new feature in MariaDB 12.1\"/p pThe post Make JSON DEPTH unlimited – new feature in MariaDB 12.1 appeared first on MariaDB.org./p [...]

Thursday, 10. July 2025

Now in Public Preview: Custom Port Support in Azure Database for MySQL – Flexible Server (from Azure for MySQL Blog)

Why Custom Ports? pBy default, MySQL servers listen on port 3306. While this works well for most setups, some organizations need custom port configurations—for example, to comply with network security policies, reduce port conflicts, or streamline integration with legacy systems./p pWith this update, you can now choose a custom port number when creating your VNet-injected MySQL Flexible Server—givi [...]

MongoDB Indexing Strategy and Execution Plans (from MinervaDB Blog)

MongoDB Indexing Strategy and Execution Plans: Mastering Query Performance Optimization – Mastering MongoDB Indexing Introduction Mastering MongoDB Indexing is crucial for developers looking to enhance their database efficiency and speed. MongoDB’s query performance hinges on [...] [...]

TiDB Cloud’s New Navigation: Built for Context, Clarity, and Scale (from PingCAP Blog)

pIn June 2025, TiDB Cloud introduced a major update to its console navigation. This is more than a UI refresh. It’s a foundational shift that brings the interface in line with how users actually manage distributed databases across multiple teams, projects, and environments. This redesign makes it easier to stay oriented, take action, and scale […]/p pThe post TiDB Cloud’s New Navigation: Buil [...]

Innodb_redo_log_capacity - Best Practices of tuning MySQL (from Releem Blog)

Best Practices of Using MySQL Innodb_redo_log_capacity [...]

Wednesday, 09. July 2025

New Monitoring Capabilities for MySQL in OCI Database Management (from The Oracle MySQL Blog)

We're now expanding OCI Database Management capabilities with a new set of enhanced monitoring features - designed to reduce operational burden on DBAs and developers, strengthen observability, and support high availability across modern MySQL deployments. [...]

MariaDB Documentation Got a Major Upgrade: Welcome to Our New Unified Docs Platform! (from MariaDB Corporation Blog)

[...]

June Product Update (from Readyset Blog)

♦pHi there, hope you’re keeping cool as summer heats up! Let’s dive into what’s new at Readyset: /p💬 Product UpdatespReadyset Cloud/pulliImproved concurrency management and cache reliability enabling a more predictable and resilient system. Improvements include thread-safe request limiting, enhanced lifecycle tracking,/li/ul [...]

making MariaDB cloud native : a (fairy ?) tale of decoupling compute from storage (from The consistent voice)

making MariaDB cloud native : a (fairy ?) tale of decoupling compute from storagepSince my early days with MariaDB, i loved the internal deisgn of the server, especially the link in between execution plan and data retrieval from storage. For thos who dont know, as displayed in the schema below, MariaDB (and MySQL of course) treats storage as plugin. Which means Monty & friends had to think of a [...]

ClusterControl now supports PowerBroker pbrun for secure privilege management (from Severalnines Blog)

pWe’re pleased to share the release of ClusterControl v2.3.3, introducing major enhancements for elevated user privileges with Privileged Access Management integration of BeyondTrust’s PowerBroker pbrun, as well as support for MongoDB 8.0 and MariaDB 11.8 major versions and dark mode for our recently added Watchlists feature. PowerBroker pbrun integration pbrun is a command-line utility provi [...]

MySQL: Release Notes Database (from Die wunderbare Welt von Isotopp)

pI’ve hacked together a horrible thing in Python, and made it available in mysql-release-notes on GitHub./p pIt’s a Python project (done with codeuv/code) that downloads all MySQL release notes, dumps them into a release_notes folder, and then parses them, pushing everything into a database./p pIt uses SQLAlchemy and mysqlclient to connect to the database./p pIt generates a schema (not preserving [...]

Tuesday, 08. July 2025

How TalentNeuron optimized data operations and cut costs and modernized with Amazon Aurora I/O-Optimized (from AWS Database Blog)

For years, TalentNeuron, a leader in talent intelligence and workforce planning, has been empowering organizations with data-driven insights by collecting and processing vast amounts of job board data. In this post, we share three key benefits that TalentNeuron realized by using Amazon Aurora I/O-Optimized as part of their new data platform: reduced monthly database costs by 29%, improved data vali [...]

TiDB Cloud Dedicated Now in Public Preview on Microsoft Azure: Distributed SQL, Anywhere You Need It (from PingCAP Blog)

pWe’re excited to announce that TiDB Cloud Dedicated is now available on Microsoft Azure, in public preview. With this launch, TiDB Cloud now runs on all three major public cloud platforms—AWS, Google Cloud, and Azure—giving you greater flexibility to deploy distributed SQL where it best fits your strategy. For enterprise teams already invested in Azure, […]/p pThe post TiDB Cloud Dedic [...]

Caching (from PlanetScale Blog)

Every time you use a computer, the cache is working to ensure your experience is fast. [...]

Monday, 07. July 2025

When Query Optimization Isn’t Enough: Solving MySQL Overload with Caching (from Readyset Blog)

pConsider the perfect scenario: the database is running on reliable hardware, MySQL has been finely tuned, and queries have been reviewed and optimized. Despite this, sustained business growth inevitably leads to an increase in workload over time. When this happens, even optimized queries can begin to overwhelm the system, not/p [...]

Sunday, 06. July 2025

MongoDB Contention Deep Dive (from MinervaDB Blog)

MongoDB Contention Deep Dive: Dissecting Lock Escalation, WiredTiger Bottlenecks, and Distributed System Pathologies Monday’s database meltdown wasn’t just another performance hiccup—it was a perfect storm of distributed systems anti-patterns, storage engine contention, and architectural debt [...] [...]

To BLOB or not to BLOB? The image storage dilemma (from Vettabase)

Years ago, it was extremely common to store user-uploaded images and other multimedia contents in a database. This practice became less common over time, but I still hear questions like: would it be a bad idea to store images in our database? Or, more specifically: how bad would it be to store images in a database? In this article, we’ll discuss the pros and cons. We’ll briefly discuss [...]

Saturday, 05. July 2025

TiDB Selection Framework for Enterprise Architecture (from MinervaDB Blog)

TiDB Selection Framework for Enterprise Architecture: A Technical Decision Guide TiDB is an open-source distributed SQL database that provides Hybrid Transactional and Analytical Processing (HTAP) capabilities with MySQL compatibility . This technical assessment outlines the [...] [...]

Friday, 04. July 2025

Advanced TiDB SQL Optimization (from MinervaDB Blog)

Advanced TiDB SQL Optimization: Mastering Execution Plans, Indexes, and Join Algorithms Introduction In the rapidly evolving landscape of distributed databases, TiDB has emerged as a powerful solution that combines the scalability of NoSQL systems with [...] [...]