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

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

Bringing Oracle’s Associative Arrays to MariaDB (from MariaDB Foundation Blog)

pOne of the standout features of Oracle PL/SQL is the associative array — a versatile and efficient in-memory data structure that developers rely on for fast temporary lookups, streamlined batch processing, and dynamic report generation. … /p pContinue reading \"Bringing Oracle’s Associative Arrays to MariaDB\"/p pThe post Bringing Oracle’s Associative Arrays to MariaDB appe [...]

Tuning TiDB Server Parameters for Optimal Performance (from MinervaDB Blog)

Tuning TiDB Server Parameters for Optimal Performance: A Technical Guide - Optimize TiDB Server Parameters TiDB's performance heavily depends on proper configuration of server parameters. This guide covers essential tuning strategies to maximize your TiDB [...] [...]

Webinar Recap: Mastering the New MySQL 8.4 Audit Log Filter | Mydbops (from Mydbops Blog)

Missed our webinar on Secure Auditing in MySQL 8.4? Here are the key takeaways on the powerful new Audit Log Filter, from JSON rules to performance tuning. [...]

Thursday, 03. July 2025

How Conga Transforms Revenue Lifecycle Management with TiDB (from PingCAP Blog)

pToday’s businesses require seamless, scalable, and intelligent revenue lifecycle management solutions that can efficiently handle transactional and analytical workloads. Conga, a recognized leader in revenue management, is a pioneering company transforming the revenue operations space through a unique blend of cloud-agnostic architecture and cutting-edge hybrid transactional/analytical processing [...]

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

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

HeatWave MySQL Database Audit (from MySQL expert Diary)

pHeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detec [...]

MySQL Analysis: With an AI-Powered CLI Tool (from Another MySQL DBA)

MySQL Analysis: With an AI-Powered CLI Tool pAs DBAs with MySQL we often live on a Linux terminal window. We also enjoy free options when available. This post shows an approach that allows us to stay on our terminal window and still use an AI-powered tool. You can update to use other direct AI providers but I set this example up to use aimlapi.com as it brings multiple AI models to your terminal f [...]

How to Use AI for MySQL: Optimizing Queries and Database Management  (from Devart MySQL Tool Blog)

pBoost your MySQL performance with AI for MySQL. Learn how AI tools can optimize queries, enhance troubleshooting, and automate database management. Get started now!/p pThe post How to Use AI for MySQL: Optimizing Queries and Database Management  appeared first on Devart Blog./p [...]

AI for Data Analytics: Unlocking the Power of Data Insights (from Devart MySQL Tool Blog)

pThis article explores how AI tools accelerate insights, automate SQL, enhance forecasting, and reduce technical barriers, empowering developers and business users. Discover top AI solutions, real-world use cases, and how to integrate AI effectively into your analytics stack./p pThe post AI for Data Analytics: Unlocking the Power of Data Insights appeared first on Devart Blog./p [...]

A Tale of Two Databases: How PostgreSQL and MySQL Handle Torn Pages (from Percona Database Blog)

♦Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases. As a long-time open source database administrator, I have always been fascinated by the differences in how these two databases handle various challenges and how DBAs who know one of these technologies often […] [...]

Alibaba Cloud launches Eigen+ to cut costs and boost reliability for enterprise databases (from InfoWorld)

pAlibaba Cloud has developed a new cluster management system called Eigen+ that achieved a 36% improvement in memory allocation efficiency while eliminating Out of Memory (OOM) errors in production database environments, according to research presented at the recent SIGMOD conference./p pThe system addresses a fundamental challenge facing cloud providers: how to maximize m [...]

The principles of extreme fault tolerance (from PlanetScale Blog)

The principles and processes we follow for fault tolerance. [...]

Wednesday, 02. July 2025

AWS DMS validation: A custom serverless architecture (from AWS Database Blog)

AWS DMS customers might choose not to use the data validation feature provided by the AWS DMS service due to the time it takes to complete validation after a load, a large dataset transfer or a data reload, where business requires rapid availability of data in the target environment. As a result, you might opt to perform validation manually or use a single pass full load only validation, which requ [...]

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

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

Register now for the MySQL Global Forum – a Free Virtual Event (from The Oracle MySQL Blog)

Reflecting on 30 Years of MySQL and Looking Ahead This year marks an incredible milestone as MySQL celebrates 30 years of powering applications worldwide! Whether you’re a long-time fan or just starting your journey, you’re invited to join the MySQL Global Forum a virtual event bringing together MySQL leaders, experts, and community members from around the globe. [...]

Boost your MySQL apps: why enterprises are migrating MySQL databases to Azure (from Azure for MySQL Blog)

pMySQL is one of the world’s most popular open-source databases, and for good reason. It’s cost-effective, scalable, and familiar to millions of developers. But if your enterprise is running MySQL on-premises, you might be missing out on huge benefits in cost savings, performance, and agility. Recent findings from an ESG Economic Validation report, commissioned by Microsoft, reveal just how advanta [...]

How to Create a Database from Scratch: A Step-by-Step Guide  (from Devart MySQL Tool Blog)

pThis guide covers how to build a high-performance database from the ground up; schema design, indexing, security, and optimization included. Aimed at engineers and architects, it also shows how AI tools like dbForge Edge accelerate development across MySQL, PostgreSQL, SQL Server, and Oracle./p pThe post How to Create a Database from Scratch: A Step-by-Step Guide  appeared first on Devart Blog./p [...]

Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 2: Test Results (from Percona Database Blog)

♦In the first post of this series (Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 1: How-To), I presented my test environment and methodology and explained how to install ReadySet, ProxySQL, and HAproxy and configure them to work with PostgreSQL. In this final part, I present the different test scenarios […] [...]

The Agentic Software Engineer (from DoltHub Blog)

As some of you know, I've been enthusiastically touting Claude Code, and coding agents in general in this space lately. I've been using… [...]

Tuesday, 01. July 2025

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

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

TiDB SCaiLE 2025 Call for Proposals (CFP) is Now Open! (from PingCAP Blog)

pTiDB SCaiLE 2025, our new global conference for builders, operators, and AI infrastructure leaders shaping data-intensive systems, has officially opened its 2025 call for proposals (CFP). Formerly known as HTAP Summit, we’ve rebranded the event to reflect a bolder vision: helping leading companies scale smarter and build faster across distributed SQL, cloud-native architecture, and GenAI […] [...]

Amazon Aurora MySQL and Amazon RDS for MySQL integration with Amazon SageMaker is now available (from AWS What's New)

pOn June 30, 2025, AWS announced that Amazon Aurora MySQL-Compatible Edition and Amazon RDS for MySQL now support zero-ETL integration with Amazon SageMaker, enabling near real-time data availability for analytics workloads. This integration automatically extracts and loads data from MySQL tables into your lakehouse where it's immediately accessible through various analytics engines and machine lea [...]

Hetzner Becomes Gold Sponsor of the MariaDB Foundation: Powering Our Build Infrastructure (from MariaDB Foundation Blog)

pWe are delighted to welcome Hetzner as a Gold Sponsor of the MariaDB Foundation!br Hetzner’s exceptional commitment to supporting our infrastructure has a direct and strategic impact on our operations. … /p pContinue reading \"Hetzner Becomes Gold Sponsor of the MariaDB Foundation: Powering Our Build Infrastructure\"/p pThe post Hetzner Becomes Gold Sponsor of the MariaDB Foundation: P [...]

Galera Cluster for MySQL 8.0.42-26.23 and 8.4.5-26.23 (from MinervaDB Blog)

Galera Cluster for MySQL 8.0.42-26.23 and 8.4.5-26.23: Complete Technical Guide Introduction The latest release of Galera Cluster 4 for MySQL brings significant improvements with versions 8.0.42-26.23 and 8.4.5-26.23, released on June 24, 2025 1. This [...] [...]

MySQL InnoDB Cluster Deployment Guide (from Mydbops Blog)

Learn how to deploy, manage, and scale MySQL InnoDB Cluster for high availability, performance, and security in transactional workloads. [...]

Announcing PlanetScale for Postgres (from PlanetScale Blog)

PlanetScale now supports Postgres [...]

Monday, 30. June 2025

Seamlessly connect to your HeatWave MySQL from VS Code using the MySQL Shell Extension (from The Oracle MySQL Blog)

In the previous post, we explored how the MySQL Shell extension for Visual Studio Code brings database development directly into your editor. In this follow-up, we'll walk through how to connect to a HeatWave MySQL database which is hosted in the cloud on Oracle Cloud Infrastructure (OCI) and how to browse schemas and run queries, all without leaving VS Code. Here is an architecture diagram that gi [...]

Fintech startups choose HeatWave MySQL (from The Oracle MySQL Blog)

Fintech (financial technology) companies continue to disrupt the financial services industry. The technology they rely on is paramount; it often determines their ability to deliver an innovative solution exhibiting the performance, scalability, security, reliability, and cost-efficiency that will sway customers. Let’s consider in this blog why 3 fintech startups migrated to HeatWave MySQL, and the [...]

MySQL Shell in VS Code: A Modern Way to Work with Your Data (from The Oracle MySQL Blog)

Modern development demands tools that minimize context switching and improve efficiency. The MySQL Shell extension for Visual Studio Code makes that possible by bringing powerful database interaction directly into the developer's workspace. With seamless support for connecting, querying, and scripting in SQL, Javascript, and TypeScript - all inside the familiar VS Code environment - it helps develo [...]

Building Horizontally Scalable RDS Infrastructure (from MinervaDB Blog)

Building Horizontally Scalable RDS Infrastructure: A Complete Guide to Optimal Database Performance – Build Horizontally Scalable RDS Infrastructure Introduction As applications grow and user demands increase, traditional vertical scaling of RDS instances hits physical and [...] [...]

The MySQL SQL Error 1064 Blues (from Dave's MySQL Stuff)

p /pp       Writing error messages is an art. Sadly, most of us lack talent in that area. One of the prime examples that you see with SQL User Interfaces is the MySQL SQL Error 1064./ppSQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select @var' at line 2/pp/ppEr [...]

Toying around with MariaDB : query cache edition (from The consistent voice)

Toying around with MariaDB : query cache editionpMariaDB’s query cache , as explained here is a legacy memory-based mechanism which stores the results of SELECT queries to avoid recalculating them when identical queries are executed again. When a SELECT query is run, MariaDB first checks if the result already exists in the cache and returns it directly if found, which significantly improves perform [...]

MySQL Legend 2024. Q&A with Shlomi Noach (from ODBMS.org)

Q1. Congratulations for your title of MySQL Legend 2024. What is your role now that you are a Legend and how do you support the MySQL community? I have been involved with the MySQL... [...]

Percona Bug Report: June 2025 (from Percona Community Blog)

pAt Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way./p pWe constantly update our bug reports and monitor other boards [...]

Saturday, 28. June 2025

Vector Index Algorithms in Milvus (from MinervaDB Blog)

Mastering Vector Index Algorithms in Milvus: IVF, HNSW, and Beyond – A Complete Performance Guide Vector similarity search is the cornerstone of modern AI applications, from recommendation systems to semantic search. Milvus, as a leading [...] [...]

Extending Milvus with Custom Plugins and Extensions (from MinervaDB Blog)

Extending Milvus with Custom Milvus Plugins and Extensions: A Complete Developer Guide Vector databases have become the backbone of modern AI applications, and Milvus stands out as a leading open-source solution. While Milvus offers robust [...] [...]

On Deploying AI at the Enterprise Level. Q&A with Nadeem Asghar. (from ODBMS.org)

Q1. What are the main performance and scalability challenges when deploying AI at the enterprise level? Generating reliable business insights at “the speed of now” requires getting an assortment of bespoke or legacy business... [...]

Friday, 27. June 2025

Supercharging AWS database development with AWS MCP servers (from AWS Database Blog)

Amazon Aurora, Amazon DynamoDB, and Amazon ElastiCache are popular choices for developers powering critical workloads, including global commerce platforms, financial systems, and real-time analytics applications. To enhance productivity, developers are supplementing everyday tasks with AI-assisted tools that understand context, suggest improvements, and help reason through system configurations. Mo [...]

Milvus Migration Strategies (from MinervaDB Blog)

Milvus Migration Strategies: From Legacy Systems to Modern Vector Databases Introduction As organizations increasingly adopt AI-driven applications requiring similarity search and vector operations, migrating from traditional databases to specialized vector databases like Milvus has become [...] [...]

Leveling up Amazon RDS with AWS Graviton4: Benchmarks (from AWS Database Blog)

In November 2024, AWS introduced the latest evolution of its custom-designed ARM-based processors with Graviton4, delivering significant performance and efficiency improvements for Amazon RDS for PostgreSQL, MySQL, and MariaDB and Amazon Aurora. In this post, we focus on Amazon RDS for PostgreSQL and compare the performance of the new Graviton4 instances to both Graviton3 and Graviton2. Using bench [...]

Managing PostgreSQL on Kubernetes with Percona Everest’s REST API (from Percona Database Blog)

♦I’ve been working with Kubernetes and databases for the past few months, and I’m enjoying learning and exploring more about Percona Everest’s features. Percona Everest is a free, open source tool that makes it easier for teams to manage databases in the cloud. In a Cloud Native world, everything is programmable, including databases. Percona Everest […] [...]

Nextcloud joins MariaDB Foundation as Silver Sponsor, strengthening the European open source backbone (from MariaDB Foundation Blog)

pWe are proud to welcome Nextcloud GmbH to the MariaDB Foundation sponsor family as a Silver Sponsor. As the world’s most popular privacy-focused platform for secure file sharing, collaboration, and communication, Nextcloud stands as a pillar of digital sovereignty — a value that resonates deeply with MariaDB Foundation’s mission./p pThe post Nextcloud joins MariaDB Foundation as Silver Sponsor, st [...]

PostgreSQL Threat Modeling for FinTech (from MinervaDB Blog)

PostgreSQL Threat Modeling for FinTech: Building Advanced Secured Database Infrastructure Introduction Financial technology companies handle sensitive data that makes them prime targets for cyber attacks. PostgreSQL, while robust and feature-rich, requires comprehensive threat modeling to [...] [...]

Thursday, 26. June 2025

Track MySQL Table Activity: Know your Hot, Cold, and Static Tables (from The Oracle MySQL Blog)

It's incredibly useful to know which tables in your MySQL databases are seeing active changes versus those tables that are more static. To do this, we need to examine DML (Data Manipulation Language) activity—specifically, updates, inserts, and deletes. MySQL offers various mechanisms to gather this information. [...]

Percona XtraDB Cluster: Our Commitment to Open Source High Availability (from Percona Database Blog)

♦At Percona, we’ve always been dedicated to providing robust, open source solutions that meet our users’ evolving needs. Percona XtraDB Cluster (PXC) stands as a testament to this commitment, offering a highly available and scalable solution for your MySQL and Percona Server for MySQL deployments. We understand that database high availability is critical for your […] [...]

Handle CSV files with HeatWave MySQL (from MySQL expert Diary)

pEfficiently loading CSV data into your MySQL environment is a crucial step for many analytical workloads, especially when dealing with the substantial datasets common in today's data-driven world. Both MySQL Shell's parallel import utility and HeatWave's Auto Parallel Load feature offer robust and effective solutions, each catering to slightly different needs and environments./p pMySQL Shell's uti [...]

MariaDB 12.1 preview available (from MariaDB Foundation Blog)

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

Wednesday, 25. June 2025

MySQL Entity Relationship Maps With DBeaver (from Dave's MySQL Stuff)

p  Even the most experienced database professionals are known to feel a little anxious when peering into an unfamiliar database. Hopefully, they will inspect how the data is normalized and how the various tables are combined to answer complex queries.  Entity Relationship Maps (ERM) provide a visual overview of how tables are related and can document the structure of the data./pp&nbs [...]

Using Percona Everest Operator CRDs to Manage Databases in Kubernetes (from Percona Database Blog)

♦Percona Everest is a free and open source tool for running and managing databases like PostgreSQL, MySQL, and MongoDB inside Kubernetes. It simplifies things by providing three ways to work with your databases: a web interface (UI), a set of commands (API), and direct access through Kubernetes itself using built-in tools like kubectl. Note: Before […] [...]

How to Convert MS Access Database to MySQL (from Devart MySQL Tool Blog)

pMicrosoft Access is a relational system for managing databases that is used to create small-scale databases for a single user or small teams. MySQL is a robust open-source relational database management system for more extensive data volumes and web applications./p pThe post How to Convert MS Access Database to MySQL appeared first on Devart Blog./p [...]

Galera Cluster for MySQL 8.0.42-26.23 and 8.4.5-26.23 released (from Galera Blog)

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.42-26.23 (release notes, download), with Galera replication library 4.23 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.5-26.23 (release notes, download); it [...]

Tuesday, 24. June 2025

Crest Infosolutions LLC Joins MariaDB Foundation as Silver Sponsor (from MariaDB Foundation Blog)

pAccelerating Digital Transformation Through Open Source Innovationbr The MariaDB Foundation is proud to welcome Crest Infosolutions LLC as a Silver Sponsor, marking a significant step forward in fostering enterprise-grade open-source adoption. … /p pContinue reading \"Crest Infosolutions LLC Joins MariaDB Foundation as Silver Sponsor\"/p pThe post Crest Infosolutions LLC Joins MariaDB Founda [...]

Why Switch.ch Chose MariaDB: A Swiss Case Study in Open Source, Digital Sovereignty, and Academic IT (from MariaDB Foundation Blog)

pAt the MariaDB Foundation, we’re constantly engaging with users, partners, and collaborators to understand how MariaDB fits into their infrastructure—and what we can do better. A recent conversation between our Executive Chairman Kaj Arnö … /p pContinue reading \"Why Switch.ch Chose MariaDB: A Swiss Case Study in Open Source, Digital Sovereignty, and Academic IT\"/p pThe pos [...]

Sysadmin’s Inconceivable Tales: The Hanging Build – Part 2 (from Shattered Silicon OSDB Blog)

pIn part 1 of this post we were investigating an odd issue with a build process, running in docker, seemingly hanging on one particular server, but running successfully on others, and put a fix in place. In this post we take a deep dive through the system to understand what is actually happening and why […]/p pThe post Sysadmin’s Inconceivable Tales: The Hanging Build – Part 2 app [...]

Sysadmin’s Inconceivable Tales: The Hanging Build – Part 1 (from Shattered Silicon OSDB Blog)

pThe Problem I was facing a rather odd issue in our build pipeline, and needed to get to the bottom of it before it became a showstopper. We use docker images to build our software, which allows us to easily build for different distributions and different architectures without, in theory (foreshadowing: theory is not reality), […]/p pThe post Sysadmin’s Inconceivable Tales: The Hanging [...]

Protect Your MySQL Databases: Simple Security Steps Anyone Can Follow (from Webyog Blog)

pDatabase breaches are happening more and more often, with no signs of slowing down. Your MySQL databases and the important data they hold could be at risk right now. Recent […]/p pThe post Protect Your MySQL Databases: Simple Security Steps Anyone Can Follow appeared first on Webyog./p [...]

MySQL Meetups and Events with 30 years of MySQL Celebration! - UPDATED (from The Oracle MySQL Blog)

meetups&events with 30Y ann.celebration [...]

MongoDB FTDC (from MinervaDB Blog)

MongoDB’s FTDC: A Powerful Tool for Performance Monitoring and Troubleshooting MongoDB’s Full Time Diagnostic Data Capture (FTDC) is an essential built-in mechanism that continuously monitors and captures diagnostic data from your MongoDB deployments. This powerful [...] [...]

Roman Agabekov, Author at MySQL Blog by Releem (from Releem Blog)

Explore articles by Roman Agabekov, author at MySQL Blog by Releem. Insights, tips, and best practices for MySQL performance, optimization, and database management. [...]

MySQL Group Replication vs MariaDB Galera Cluster (from MinervaDB Blog)

MySQL Group Replication vs MariaDB Galera Cluster: Choosing the Right High Availability Solution When implementing high availability for MySQL and MariaDB databases, two prominent solutions stand out: MySQL Group Replication and MariaDB Galera Cluster. Both [...] [...]

Troubleshooting InnoDB Write Performance Bottlenecks (from MinervaDB Blog)

Troubleshooting InnoDB Write Performance Bottlenecks: A Complete Technical Guide Introduction InnoDB write performance bottlenecks can severely impact MySQL database operations, leading to slow query execution, increased response times, and poor user experience. Understanding how to [...] [...]

May 2025 at Releem: Configuration History for MySQL & MariaDB (from Releem Blog)

This month, we’re excited to roll out a refreshed dashboard design and several new features aimed at making your job easier and your databases even more secure. [...]

11 Best AI Coding Assistants: Top Tools Every Developer Needs in 2025  (from Devart MySQL Tool Blog)

pThis guide cuts through the hype and highlights the best AI coding assistants for 2025, with real-world insights on performance, integration, and usability. Discover which tools stand out—and why./p pThe post 11 Best AI Coding Assistants: Top Tools Every Developer Needs in 2025  appeared first on Devart Blog./p [...]

Monday, 23. June 2025

Optimizing Azure Database for MySQL (from MinervaDB Blog)

Optimizing Azure Database for MySQL: A Complete Guide to Performance, Scalability, and High Availability – Optimize Azure Database for MySQL Azure Database for MySQL has become the go-to managed database solution for enterprises seeking robust, [...] [...]

Migrate a self-managed MySQL database to Amazon Aurora MySQL using AWS DMS homogeneous data migrations (from AWS Database Blog)

In this post, we provide a comprehensive, step-by-step guide for migrating an on-premises self-managed encrypted MySQL database to Amazon Aurora MySQL using AWS DMS homogeneous data migrations over a private network. We show a complete end-to-end example of setting up and executing an AWS DMS homogeneous migration, consolidating all necessary configuration steps and best practices. [...]

Build Smarter with MariaDB MCP Server: AI-Ready, Vector-Enabled (from MariaDB Corporation Blog)

[...]

New Silver Sponsor: Releem Boosts MariaDB Performance with Smarter Tuning and Optimization (from MariaDB Foundation Blog)

pWe’re delighted to welcome Releem as the newest Silver Sponsor of the MariaDB Foundation!br Releem is a database performance management platform that helps teams ensure consistent and reliable database performance through continuous profiling, configuration tuning, and SQL query optimization. … /p pContinue reading \"New Silver Sponsor: Releem Boosts MariaDB Performance with Smarter Tu [...]

Securing User Accounts in PostgreSQL (from MinervaDB Blog)

Securing User Accounts in PostgreSQL: A Comprehensive Technical Guide PostgreSQL’s robust security framework provides multiple layers of protection for user accounts, but proper configuration is essential to prevent unauthorized access and data breaches. This guide [...] [...]

Sunday, 22. June 2025

Principles and Metrics for MongoDB Capacity Planning and Sizing (from MinervaDB Blog)

Principles and Metrics for MongoDB Capacity Planning and Sizing: A Comprehensive Technical Guide MongoDB capacity planning and sizing require a systematic approach to ensure optimal performance, cost-effectiveness, and scalability. This comprehensive guide explores the fundamental [...] [...]

Saturday, 21. June 2025

MySQL Full-Stack Optimization and Enterprise Support (from MinervaDB Blog)

MinervaDB: The Gold Standard for 24×7 MySQL Support Full-Stack Optimization and Enterprise Support The MySQL Performance Challenge in Enterprise Environments In today’s data-driven economy, MySQL powers some of the world’s largest applications—from Facebook’s social graph [...] [...]

Personal opinion : Maria what ? (from The consistent voice)

Personal opinion : Maria what ?pOne year ago exactly, i did post my first linkedin article (also available here on medium or here in french) with the goal of becoming a regular author on subjects such as architecture, data, databases et MariaDB in particular. A few days before, Alejandro Duarte was posting about some confence he attended and sspoke at as Developer advocate for MariaDB. While discus [...]

Friday, 20. June 2025

Apache Kafka for DBAs (from MinervaDB Blog)

Apache Kafka Architecture Deep Dive: A DBA’s Complete Guide to Stream Processing Excellence As database administrators increasingly face demands for real-time data processing and event-driven architectures, Master Apache Kafka has emerged as the de facto [...] [...]

MySQL Orchestrator Failover Behavior During Replication Lag (from Percona Database Blog)

♦Managing farms of MySQL servers under a replication environment is very efficient with the help of a MySQL orchestrator tool. This ensures a smooth transition happens when there is any ad hoc failover or a planned/graceful switchover comes into action. Several configuration parameters play a crucial role in controlling and influencing failover behavior. In this […] [...]