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.

Tuesday, 01. April 2025

Choosing the Right Storage for PostgreSQL on Kubernetes: A Benchmark Analysis (from Percona Database Blog)

♦As more organizations move their PostgreSQL databases onto Kubernetes, a common question arises: Which storage solution best handles its demands? Picking the right option is critical, directly impacting performance, reliability, and scalability. For stateful workloads like PostgreSQL, storage must offer high availability and safeguard data integrity, even under intense, high-volume conditions. To [...]

Kubernetes Sidecar Containers Explained: Benefits, Use Cases, and What’s New (from Percona Database Blog)

♦Kubernetes is becoming a popular choice for running containerized applications. While the core idea is to have a single container running the application in a Pod, there are many cases where one or more containers need to run alongside the application container, such as containers for capturing logs, metrics, etc. This approach is typically referred […] [...]

“Amen” statement for committing transactions (from MariaDB Foundation Blog)

pEvery once in a while a truly inspiring contribution comes to us at MariaDB. Today’s timely contribution was from Sigma, and their inspiring contribution was in pull request 3937 which adds the AMEN statement for committing transactions. … /p pContinue reading \"“Amen” statement for committing transactions\"/p pThe post “Amen” statement for committing transactio [...]

Monday, 31. March 2025

Optimizing cost savings: The advantage of Amazon Aurora over self-managed open source databases (from AWS Database Blog)

In this post, we highlight often overlooked architectural designs and the inherent features of Aurora that optimize costs when deploying an open source database. The following sections examine various use cases, contrasting typical self-managed database configurations and their associated costs with the equivalent solution on Aurora, highlighting potential cost savings and operational efficiencies. [...]

Readyset Cloud Is Now AWS FTR Approved: A New Era for Scalable PostgreSQL and MySQL Caching (from Readyset Blog)

pWe’re excited to announce a major milestone: Readyset Cloud has officially achieved AWS Foundational Technical Review (FTR) approval! This certification validates that Readyset meets AWS’s high standards for cloud-native security, reliability, and operational excellence—and it reaffirms our commitment to AWS as the preferred platform/p [...]

MySQL Date Format: Understanding Date, Time, and Datetime in MySQL (from Devart MySQL Tool Blog)

pTime zones, truncation, formatting nightmares—oh MySQL, why so complex? Learn the key differences between TIMESTAMP and DATETIME, when to use each, and how to prevent time-based bugs in your queries./p pThe post MySQL Date Format: Understanding Date, Time, and Datetime in MySQL appeared first on Devart Blog./p [...]

Saturday, 29. March 2025

How can you transfer backed-up data to a MariaDB Replica? (from MinervaDB Blog)

pTransferring Backed-Up Data to a MariaDB Replica: Methods and Best Practices MariaDB replication provides data redundancy, load distribution, and disaster recovery capabilities by maintaining synchronized copies of databases across multiple servers. When setting up a [...]/p pThe post How can you transfer backed-up data to a MariaDB Replica? appeared first on The WebScale Database Infrastructure O [...]

MariaDB, an Open Source Alternative (from MariaDB Foundation Blog)

pWe live in a world where national interests intertwine with IT vendor interests. Interest is currently booming in “European Alternatives“. I’m happy to note that MariaDB Server is unaffected by considerations related to protectionism. … /p pContinue reading \"MariaDB, an Open Source Alternative\"/p pThe post MariaDB, an Open Source Alternative appeared first on MariaDB.org. [...]

Friday, 28. March 2025

The Accidental Queen of the Database Dominion – Month one (from MariaDB Foundation Blog)

pExactly one month ago, I found myself stepping into the role of CEO at MariaDB Foundation. It was a bit like being handed the keys to a beloved old ship and being told, “Don’t worry, it mostly steers itself… … /p pContinue reading \"The Accidental Queen of the Database Dominion – Month one\"/p pThe post The Accidental Queen of the Database Dominion – Month one a [...]

Last chance to apply to AI RAG Hackathon (from MariaDB Foundation Blog)

pThe ideation phase of the MariaDB AI RAG Hackathon is nearing its deadline on Monday (by end of March). br We have several cool submissions so far. … /p pContinue reading \"Last chance to apply to AI RAG Hackathon\"/p pThe post Last chance to apply to AI RAG Hackathon appeared first on MariaDB.org./p [...]

Thursday, 27. March 2025

MariaDB Java Connector 3.5.3, 3.4.2, and 3.3.4 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.5.3, 3.4.2, and 3.3.4 releases. Download Now Release […] [...]

MySQL and MariaDB client .so libraries on Linux (from SQL And Its Sequels (Ocelot Blog))

The MySQL library is libmysqlclient.so, the MariaDB library is libmariadbclient.so or libmariadb.so. I’ll list some quirks that I think are relatively unknown but good to know. I’ll end with a pointer to a function that’s good to have. mysql and mariadb clients don’t themselves use .so libraries To illustrate, here’s the file mysql.dir/link.txt that I… Continue R [...]

Postgres 17.4 vs sysbench on a large server, revisited part 2 (from Small Datum)

pI recently shared two posts (here and here) with results for sysbench on a large server using Postgres versions 10 through 17. In general there were several large improvements over time, but one small regression that arrived in Postgres 11.x. This blog post provides more details on the problem using results from Postgres 10.23, 11.22 and 17.4.brbrThe regression occurs starting in Postgres 11.22 be [...]

Scaling Beyond Limits: How EasyPost Future-Proofed Its Infrastructure with Distributed SQL (from PingCAP Blog)

pWhen legacy infrastructure hits its limits, innovation isn’t just a choice — it’s a necessity. For EasyPost, a leader in logistics technology, scaling up meant more than just more hardware. It meant a fundamental shift in their approach to data.  In this customer story, we explore how EasyPost’s infrastructure team, led by Head of Infrastructure […]/p pThe post Scaling Beyond Limits: Ho [...]

Secure by Design: How TiDB Cloud Protects Your Data and Simplifies Compliance (from PingCAP Blog)

pWhen security controls fail, the consequences aren’t just technical—they’re financial, legal, and reputational. A single database misconfiguration cost one company $10 million in fines. TiDB Cloud prevents these risks, offering enterprise-grade security without unnecessary complexity. In this post, we’ll explore how TiDB Cloud protects your data, compare the security features of its Serverless and [...]

Key Differences Between VARCHAR And CHAR in MySQL  (from Devart MySQL Tool Blog)

pMost database performance issues don’t start with complex queries or heavy traffic—they begin at the foundation: data type selection. One seemingly small decision—CHAR vs. VARCHAR—can dictate whether your database remains fast and efficient or bloated and sluggish as it scales.  It’s a mistake even experienced developers make, and it’s easy to see why. At a […]/p pThe post Key Differenc [...]

How to Host MySQL Database: Best Methods & Hosting Solutions (from Devart MySQL Tool Blog)

pNeed MySQL database hosting? Learn how to host a MySQL database on cloud, VPS, or local servers. Compare costs, features, and providers. /p pThe post How to Host MySQL Database: Best Methods & Hosting Solutions appeared first on Devart Blog./p [...]

ENUM Data Type in MySQL: Syntax, Examples and Best Practices (from Devart MySQL Tool Blog)

pLearn how to use ENUM in MySQL to store predefined values efficiently. Find syntax, examples, and best practices for the ENUM data type./p pThe post ENUM Data Type in MySQL: Syntax, Examples and Best Practices appeared first on Devart Blog./p [...]

How to Choose the Right Database for Data Analytics (from Devart MySQL Tool Blog)

pLooking for the best database for data analytics? Compare top-rated systems for data analytics, real-time processing, and big data. Find the right solution today!/p pThe post How to Choose the Right Database for Data Analytics appeared first on Devart Blog./p [...]

Turbo-Charge Your MySQL Cluster: Performance Tuning Tungsten Replication (from Continuent Blog)

Learn how to optimize MySQL replication performance in Tungsten Cluster by tuning the Applier settings. Improve replication speed, minimize commit overhead, and balance data availability with advanced tuning techniques.Tags: replicationdatabase performance tuningHigh Availabilityreplication tuning [...]

MySQL TIMESTAMPDIFF() Function: Syntax, Examples & Use Cases (from Devart MySQL Tool Blog)

pThe TIMESTAMPDIFF() function in MySQL calculates differences between two points in time. This article explores TIMESTAMPDIFF(), covering its syntax, everyday use cases, and best practices for real-world applications./p pThe post MySQL TIMESTAMPDIFF() Function: Syntax, Examples & Use Cases appeared first on Devart Blog./p [...]

Galera Cluster and Galera Manager on ARM / aarch64 (from Galera Blog)

We were recently asked to support Galera Manager on ARM architectures (aarch64), and while we do support Galera Cluster on aarch64 for Galera Cluster Enterprise Edition (EE) in Galera Cluster for MySQL 8.0, we do not make such builds for our community release. This also means that for Galera Manager we are firmly just based […] [...]

Doing a 'Incremental' Dump With MySQL Shell (from The Oracle MySQL Blog)

In this post, we demonstrate how to perform an incremental dump of data using MySQL Shell by leveraging the `util.dumpBinlogs()` function. [...]

Wednesday, 26. March 2025

Hytera Leverages MySQL Enterprise Edition to Enhance Equipment Performance and Boost Data Security (from The Oracle MySQL Blog)

Based in China, Hytera Communications Corporation Limited is a global leader in providing innovative communications technologies and solutions. MySQL Enterprise Edition has enhanced both the performance and security of their systems, enabling them to deliver high-quality, reliable solutions to their customers. With MySQL’s competitive advantages, Hytera can continue to drive customer satisfaction a [...]

Optimizing Backup Verification: How to Enhance Performance and Reliability in TiDB (from PingCAP Blog)

pWith the release of TiDB 8.5, TiDB BR (Backup & Restore) has made a significant change: Full-table checksum verification is now turned off by default during backups. This update boosts backup efficiency by cutting unnecessary overhead while keeping data integrity intact. In this post, we’ll explain how TiDB has optimized backup verification, the expected performance […]/p pThe post [...]

Setting Up a ProxySQL Cluster: A Comprehensive Guide for High Traffic Databases (from ProxySQL Blog)

pHigh-traffic databases present significant challenges, especially when managing and optimizing performance across large, distributed environments. According to a recent survey, 47% of IT leaders report that poor data management hinders their ability to make strategic decisions. Additionally, 31% claim it prevents them from staying ahead of the competition. Inefficient data management blocks the ab [...]

Ajax in Node.js: How to Build a Live Search Feature (from Code For Geek)

Ajax search is a crucial feature in modern web applications, allowing users to quickly find information without reloading the entire page. This tutorial will guide you through creating an Ajax search box using Node.js and MySQL, with Bootstrap and Typeahead.js for the front-end. Setting Up the Project First, create a new Node.js project and install […] [...]

Tuesday, 25. March 2025

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

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

PlanetScale vectors is now GA (from PlanetScale Blog)

You can now use vector search and storage in your PlanetScale MySQL database. [...]

A Conversation with Michal Schorm: MariaDB in Red Hat and Fedora (from MariaDB Foundation Blog)

pIn a recent conversation, I had the pleasure of speaking with Michal Schorm, the maintainer of MariaDB packages for Red Hat and Fedora – and newly elected Observer on the MariaDB Foundation Board. … /p pContinue reading \"A Conversation with Michal Schorm: MariaDB in Red Hat and Fedora\"/p pThe post A Conversation with Michal Schorm: MariaDB in Red Hat and Fedora appeared first on Mari [...]

MySQL HeatWave as Vector Store and more with GenAI (from The Oracle MySQL Blog)

In this article you will see how to create embeddings of your database's content and store those vectors in MySQL HeatWave. Then you will discover the power of HeatWave GenAI to RAG your data with LLMs [...]

Give MariaDB Jira votes and comments (from MariaDB Foundation Blog)

pMariaDB has had a voting feature in its issue tracker Jira since the dawn of time, but it hasn’t got much active attention. Despite that, there are now many Jira community items that have collected a fair amount of votes over the years. … /p pContinue reading \"Give MariaDB Jira votes and comments\"/p pThe post Give MariaDB Jira votes and comments appeared first on MariaDB.org./p [...]

Monday, 24. March 2025

MySQL HeatWave as Vector Store and more (from lefred's blog)

MySQL HeatWave integrates GenAI capabilities into MySQL on OCI. We have demonstrated how HeatWave GenAI can leverage RAG’s capability to utilize ingested documents (unstructured data) in LakeHouse and generate responses to specific questions or chats. See: The common theme here is the use of data stored in Object Storage (LakeHouse). I previously discussed how to […] [...]

Live Shard Data Archive: Export and Ingestion to StarRocks for Validation (from Airtable Engineering Blog)

♦OverviewpAt Airtable, we store our application or “base-scoped” data on a number of sharded MySQL instances in Amazon’s Relational Database Service (RDS). Each Airtable base is associated with a single one of these sharded instances, and as the base and the data in the base changes, we store some append-only data associated with the history of the base. This data powers features such as undo and r [...]

MariaDB SEQUENCE: a Simple Approach to Synthetic Data (from Vettabase)

MariaDB SEQUENCE is a storage engine that generates a sequence of positive integer numbers. However, in this article I will show you that it’s easy to use SEQUENCE to generate more complex sequences, that are not necessarily numeric. This is a very convenient way to generate relatively simple synthetic data. Numeric sequences SEQUENCE generates a numeric sequence, even though these numbers ca [...]

Percona XtraBackup 8.4 Pro: Reduce Server Locking by up to 4300X (from Percona Database Blog)

♦When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona XtraBackup 8.4 Pro introduces improvements in how DDL (Data Definition Language) locks (aka Backup Locks) are managed, allowing for reduced locking during backups. In this post, we’ll explore the impact of these enhancements. TL;DR (Summary) […] [...]

One week left to join AI RAG Hackathon by Helsinki Python meetup (remote participation possible) (from MariaDB Foundation Blog)

pOne week left to join the AI RAG Hackathon with MariaDB Vector and Python! br Winners get to demo at the Helsinki Python meetup in May, receive merit and publicity from MariaDB Foundation and Open Ocean Capital, and prizes from Finnish verkkokauppa.com.  … /p pContinue reading \"One week left to join AI RAG Hackathon by Helsinki Python meetup (remote participation possible)\"/p pTh [...]

Saturday, 22. March 2025

TiDB Index Optimization: Detect and Remove Unused Indexes for Better Performance (from PingCAP Blog)

pIndexes are essential for optimizing database query performance, reducing the need to scan large amounts of data. However, as applications evolve, business logic changes, and data volume grows, indexing inefficiencies emerge. This leads to: Left unaddressed, these indexing issues can cause higher storage costs, degraded performance, and operational inefficiencies. That’s why regular index audits a [...]

Stored Procedures in MariaDB: Smarter, Easier and More Powerful (from Vettabase)

MariaDB supports stored procedures written in procedural SQL. Which essentially means “SQL with IF’s and loops”. Most DBMSs do the same, but every project supports different, incompatible syntaxes. MariaDB implemented Oracle’s dialect, called PL/SQL. The base of the current procedural language was implemented in MySQL, before MariaDB existed. As far as I know, MySQL Communit [...]

Troubleshooting MariaDB Memory Leaks (from Mydbops Blog)

Learn how we resolved MariaDB memory leaks by switching to Jemalloc. Discover the step-by-step troubleshooting process, key insights, and how this fix reduced memory usage by 60%. [...]

Thursday, 20. March 2025

How InnoDB Change Buffer Influences MySQL Performance? (from MinervaDB Blog)

pThe InnoDB change buffer is a memory structure that improves MySQL performance by caching changes to secondary indexes when their pages aren’t in the buffer pool. Here’s how it works: Key Performance Benefits Reduces Disk [...]/p pThe post How InnoDB Change Buffer Influences MySQL Performance? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQ [...]

Optimizing Database Performance with InnoDB Memory Structures (from MinervaDB Blog)

pInnoDB is MySQL’s default storage engine, and understanding its memory structures is essential for optimizing database performance. Therefore, this blog explains InnoDB’s key memory structures and how to tune them effectively. Key InnoDB Memory Structures [...]/p pThe post Optimizing Database Performance with InnoDB Memory Structures appeared first on The WebScale Database Infrastructu [...]

Percona Monitoring and Management 2: Clarifying the End-of-Life and Transition to PMM 3 (from Percona Database Blog)

♦At Percona, we’re committed to providing you with the best database monitoring and management tools. With the release of Percona Monitoring and Management 3 (PMM 3), we’re now entering a critical phase in the lifecycle of PMM 2. We understand that PMM 2 remains a vital tool for many of our users, and we want […] [...]

Faster interpreters in Go: Catching up with C++ (from PlanetScale Blog)

A novel technique for implementing dynamic language interpreters in Go, applied to the Vitess SQL evaluation engine [...]

Wednesday, 19. March 2025

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

New maintenance releases for MariaDB Enterprise Server 11.4.5-3, 10.6.21-17, and 10.5.28-22 are now available. These releases include new backported features. […] [...]

Multicloud: replicating from HeatWave MySQL on AWS to OCI (from The Oracle MySQL Blog)

How to use MySQL HeatWave on AWS and OCI and connect them to replicate. [...]

Multicloud: replicating from HeatWave MySQL on AWS to OCI (from lefred's blog)

In the previous post, we saw how to deploy MySQL HeatWave on Amazon. Multicloud refers to the coordinated use of cloud services from multiple providers. In addition to our previous post, where we deployed MySQL HeatWave on Amazon, we will explore how to connect with another cloud service. Oracle has partnered with Microsoft to offer […] [...]

Tuesday, 18. March 2025

Contrib RFC: Counters for Slow InnoDB Sync Reads (from J-F Gagné's MySQL Blog)

I just submitted a MySQL Contribution and I would like to gather feedback about it.  Depending on the received feedback, I might submit an updated contribution.  The contribution is Counters for Slow InnoDB Sync Reads, and its goal is to make MySQL easier to operate on “complex” IO subsystems (like network drives in the cloud). The bug report / feature request Bug #117740 : [...]

Easy Management of MySQL NDB Cluster with MCM (from The Oracle MySQL Blog)

An introduction to how to manage MySQL NDB Cluster (NDB) using MySQL Cluster Manager (MCM). A walk-through of managing NDB in a multi-host setup, backup and restore, scaling NDB, and upgrading NDB. [...]

Future-proof ISV applications with Oracle HeatWave (from The Oracle MySQL Blog)

This blog describe how ISVs can take advantage of HeatWave to future-proof their applications. HeatWave can help them quickly and easily integrate AI capabilities to enhance customer experience. HeatWave can also help them improve operational efficiency and reduce costs by running multiple workloads within a single cloud service—with high performance, security, uptime, and cost-effective scalabilit [...]

Setting Up and Monitoring MongoDB 8 Replica Sets with PMM 3 Using Docker: A Beginner-Friendly Guide (from Percona Community Blog)

This guide explains how to set up a MongoDB 8 Replica Set and monitor it using PMM 3, all within Docker. We’ll guide you through the steps to create a local environment, configure the necessary components, and connect them for effective monitoring and management. The guide is written in detail for beginners. In the conclusion section there are ready configurations for the experienced. The rec [...]

The Real Failure Rate of EBS (from PlanetScale Blog)

Our experience running AWS EBS at scale for critical workloads [...]

Monday, 17. March 2025

Optimizing SQL Pagination in MySQL (from Readyset Blog)

Optimize SQL pagination for peak performance—learn about different pagination options and how Readyset's caching engine can enhance pagination. [...]

How MySQL Enterprise Edition Helps Government Agencies Reduce Costs (from The Oracle MySQL Blog)

Discover how MySQL Enterprise Edition helps government agencies reduce IT costs by up to 90% while enhancing security, scalability, and efficiency. Learn how transitioning from costly legacy systems to MySQL can optimize budgets, improve service delivery, and support digital transformation. [...]

Percona Server for MySQL 8.4.2 vs 8.0.40: Comparison of Variables and Keywords (from Percona Database Blog)

♦In this blog, we will look at the differences between LTS (Long Term Stable) versions of Percona Server for MySQL. Released in April 2019, MySQL 8.0 represented a major change from the previous version, 5.7, introducing significant changes to the data dictionary and enabling many features and enhancements. It also provided no direct downgrade path, […] [...]

Sunday, 16. March 2025

At what level of concurrency do MySQL 5.7 and 8.0 become faster than 5.6? (from Small Datum)

pAre MySQL 5.7 and 8.0 faster than 5.6? That depends a lot on the workload -- both types of SQL and amount of concurrency. Here I summarize results from sysbench on a larger server (48 cores) using 1, 4, 6, 8, 10, 20 and 40 clients to show how things change./pptl;dr/pp/pullithe workload here is microbenchmarks with a database cached by InnoDB/lili5.7.44 is faster than 8.0.x at all concurrency level [...]

Saturday, 15. March 2025

Postgres 17.4 vs sysbench on a large server, revisited (from Small Datum)

pI recently shared results for Postgres vs sysbench on a large server. The results were mostly boring (it is rare for me to spot regressions in Postgres) but there was one microbenchmark where there was a problem. The problem microbenchmark does a range scan with aggregation and the alleged regression arrived in Postgres 11. With advice from Postgres experts it looked like the problem was an interm [...]

Friday, 14. March 2025

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 the Europe (Spain), Europe (Stockholm), and Europe (London) Regions and R8g database instances in Europe (Ireland), Europe (Spain), Europe (Stockholm), Asia Pacific (Mumbai), Asia Pacific (Sydney), Asia Pacific (Tokyo) regions. br br Graviton4-based instances [...]

Amazon Aurora now supports R8g database instances in additional AWS Regions (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 Europe (Ireland), Europe (Spain), Europe (Stockholm), Asia Pacific (Mumbai), Asia Pacific (Sydney), Asia Pacific (Tokyo) regions. R8g instances offer larger instance sizes, up to 48xlarge and features an 8:1 ratio of memory to vCPU, an [...]

MariaDB C++ Connector 1.1.6 and 1.0.5 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.6 and 1.0.5 releases. Download Now Release Notes […] [...]

The EXPLAIN command and its variants in MariaDB and MySQL (from Vettabase)

For a very long time, the EXPLAIN command remained the same in the MariaDB and MySQL world. It was good enough in most cases, but the community welcomed the implementation of extensions and variants. However, MariaDB and MySQL improved it in different ways. So, if you’re familiar with one of these two databases, and you happen to use the other, you might not be aware of which options you have [...]

PRGH-1030 when doing restore-node -g on ODA (from dbi Blog)

pIntroduction Patching your Oracle Database Appliance from 19.20 or earlier release to 19.21 or newer release implies the use of Data Preserving Reprovisioning (DPR). Most of the time, and with an adequate preparation, the DPR works fine. But if something goes wrong at the restore-node -g step, you will need some troubleshooting and maybe opening […]/p pL’article PRGH-1030 when doing restore- [...]

Join Us Online: Stream About Percona Toolkit for MySQL! (from Percona Community Blog)

Are you passionate about databases and want to stay on top of the latest advancements in MySQL and Percona Toolkit? You’re in luck! We are excited to invite you to our upcoming online stream, where we’ll delve into some exciting changes and updates. Date: March 27, 2025 Time: 13:30 GMT / 9:30 ET Streaming Live on: LinkedIn and YouTube About the Event Our featured speaker, Sveta Smirnova [...]

Thursday, 13. March 2025

High Availability on AWS with MariaDB Galera Cluster and MariaDB MaxScale (from MariaDB Corporation Blog)

Running MariaDB on AWS? You have a number of different ways to accomplish this from setting it up yourself to […] [...]

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

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

The Cloud Repatriation Debate: Why Compute Flexibility Is the Real Trend (from Continuent Blog)

Discover the truth behind the cloud repatriation trend and why compute flexibility is the real trend for modern IT strategies. This blog explores the growing shift toward hybrid-cloud solutions, balancing cloud scalability with on-premises control to optimize costs, performance, and compliance. Learn how Tungsten Cluster enables seamless data replication, high availability, and database flexibility [...]

Database Failover: Ensuring Seamless Transitions with ProxySQL (from ProxySQL Blog)

pWhen was the last time your database experienced an unexpected failover? If it was seamless, consider yourself lucky, as most organizations struggle with significant downtime during failovers.  Downtime can cost large organizations a staggering $9,000 per minute during outages. The financial toll can escalate to over $5 million per hour for industries with high stakes, [...]/p pThe post Database F [...]

Building a Scalable Multi-Tenant Architecture with ProxySQL (from ProxySQL Blog)

pAs cloud applications grow in scale and complexity, multi-tenant architecture has become essential for organizations prioritizing cost efficiency, scalability, and optimized resource use. By enabling multiple customers, or “tenants,” to share a single instance of software and infrastructure, multi-tenancy drives down operational costs while allowing companies to focus on core business goals. Most [...]

AWS MySQL Architecture: Amazon RDS vs. Aurora vs. Serverless (from Mydbops Blog)

Explore the architectural differences between Amazon RDS, Aurora, and Aurora Serverless for MySQL databases on AWS. Learn their benefits, limitations, and how to choose the right architecture for your business. [...]

Build an AI-Powered Search Engine with HeatWave GenAI (part 1) (from MySQL expert Diary)

pDiscover how to build an AI-powered search engine for your applications using HeatWave GenAI. This approach leverages large language models (LLMs) for semantic search, offering a smarter alternative to traditional SQL and full-text search methods. By using embeddings—vector representations of words—the search engine understands context and intent, delivering more relevant results./p pIn this artic [...]

TiDB Distributed eXecution Framework DXF (from Mydbops Blog)

Learn how TiDB’s Distributed eXecution Framework (DXF) enhances task scheduling, resource management, and execution performance for large-scale database operations. [...]

Automatic Health Check in MySQL Group Replication (from The Oracle MySQL Blog)

Automatic Health Check in MySQL Group Replication [...]

IO devices and latency (from PlanetScale Blog)

Take an interactive journey through the history of IO devices, and learn how IO device latency affects performance. [...]

Wednesday, 12. March 2025

Where can you find MySQL during March 2025 - May 2025 (from The Oracle MySQL Blog)

Where is MySQL Mar-May 2025 [...]

Preventing data theft : Galera edition (from The consistent voice)

Preventing data theft : Galera editionpGalera Cluster is a synchronous multi-master replication solution for MySQL, MariaDB, and Percona XtraDB. It offers high availability and data consistency across multiple database nodes. While built into MariaDB server, it remains a separate third-party library for MySQL and Percona XtraDB./ppMany believe that securing data streams with TLS and encrypting data [...]

HeatWave Scheduling Cross-Region DB System Backups (from The Oracle MySQL Blog)

Blog post for HeatWave scheduling cross-region DB system backups support. [...]

Best MySQL GUI Tools for Linux (from Devart MySQL Tool Blog)

pLinux has the reputation of an operating system for programmers. So, if you are a software developer who designs MySQL-based solutions, chances are high that you will do it on Linux. Thus, it would be great to have a MySQL IDE for Linux to simplify the work. But the question arises: is there an appropriate Linux DB tool for MySQL with a GUI?/p pThe post Best MySQL GUI Tools for Linux appeared firs [...]

This month in MariaDB Foundation: Feb 2025 (from MariaDB Foundation Blog)

p“The act of measuring disturbs the system and changes its state.” is a quote attributed to Werner Heisenberg. While I am uncertain about whether Heisenberg ever uttered those exact words, I am certain that the quote “What doesn’t get measured, doesn’t get managed” … /p pContinue reading \"This month in MariaDB Foundation: Feb 2025\"/p pThe post This month [...]

MariaDB reboots DBaaS plans with open source at the core (from The Register)

Five years after it launched its first database service, the MySQL fork is trying again pMariaDB says it is building a database-as-a-service based on open source principles after offloading its old DBaaS before going into private ownership.…/p p!--#include virtual='/data_centre/_whitepaper_textlinks_top.html' --/p [...]

MySQL Cluster Manager for MySQL NDB Cluster (from The Oracle MySQL Blog)

An introduction to how to manage MySQL NDB Cluster (NDB) using MySQL Cluster Manager (MCM). A walk-through of basic MCM usage. [...]

Tuesday, 11. March 2025

Upcoming MySQL meetups & MySQL 30 Years Celebration Events (from The Oracle MySQL Blog)

MySQL Meetups & celebration events [...]

MySQL Performance Optimization Pitfalls: 9 Common Mistakes and How to Avoid Them (from Releem Blog)

Tuning MySQL often starts with some basic adjustments – maybe you tweak a setting or add an index and see a quick boost. But those simple fixes rarely hold up long-term, like when your database gets more traffic or your data grows, because they don’t tack [...]

Evolving Intercom’s database infrastructure: Lessons and progress (from Intercom Blog)

An update on the progress we've made since launching an overhaul of Intercom's database architecture with Vitess and PlanetScale. Find out how PlanetScale Metal has changed the game, unlocking greater scalability, performance improvements, and zero-downtime maintenance. [...]

Amazon Aurora Pricing: The many surprising costs of running an Aurora database (from PlanetScale Blog)

Amazon Aurora is pitched as a straightforward and scalable database service on AWS, but there are associated costs that you might not be aware of. [...]

Ready for the Enterprise: New Solution Updates from Percona (from Percona Database Blog)

♦The latest releases from Percona bring targeted improvements that help organizations streamline deployments, strengthen security, and optimize performance in demanding enterprise environments. From Kubernetes-native database management to security-hardened monitoring, these updates ensure businesses can scale efficiently while maintaining high availability and compliance. Percona Everest: Simplifi [...]

Snowflake and Reserved Words (from DataGeek.blog)

pOne of the things that fascinates me about SQL is the extreme limits on reserved words, especially when compared with most procedural languages. I’ve written about using reserved words for IBM Db2 and MySQL. I thought I’d explore the issue for Snowflake.… Read the rest /p [...]

Resource Principals: Configuring Access to Object Storage for HeatWave Lakehouse (from The Oracle MySQL Blog)

In this blog we will describe how to configure Dynamic Groups and Policies so that HeatWave Lakehouse can access and read content from as well as write content back to object storage. To configure this access, there are three topics we will cover: (i) Identity Domains, (ii) Dynamic Groups, and (iii) Policies. [...]

Cash App on PlanetScale Metal (from Cash App Code Blog)

Cash App moves to PlanetScale to drive efficiencies [...]

Announcing PlanetScale Metal (from PlanetScale Blog)

Database goes brrrrrrrrrrr. [...]

PlanetScale Metal: There’s no replacement for displacement (from PlanetScale Blog)

Learn how PlanetScale Metal was built and how we ensured it is safe. [...]

Upgrading Query Insights to Metal (from PlanetScale Blog)

Our experience upgrading the Query Insights database to PlanetScale Metal [...]

Monday, 10. March 2025

Azure Database for MySQL triggers for Azure Functions (Public Preview) (from Azure for MySQL Blog)

pDevelopers can now accelerate development time and focus only on the core business logic of their applications, for developing event-driven applications with Azure Database for MySQL as the backend data store./p p /p pWe are excited to announce that you can now invoke an Azure Function based on changes to an Azure Database for MySQL table. This new capability is made possible through the  [...]

How MySQL Enterprise Edition Secures Government Data and Ensures Regulatory Compliance (from The Oracle MySQL Blog)

Learn how MySQL Enterprise Edition empowers government agencies to secure sensitive data, comply with stringent regulations like NIST and DISA STIG, and achieve digital transformation goals—all while reducing costs by up to 90%. [...]

Best MySQL GUI Tools [2025] (from ScaleGrid Blog)

pManaging MySQL through the command line is powerful—but not always the most user-friendly experience, especially when working with large datasets, building queries, or handling administrative tasks. That’s where MySQL GUIs come in. A graphical user interface (GUI) helps simplify how you interact with your MySQL databases. Whether you’re a developer, database administrator, or data analyst,.../p p& [...]

Extending MySQL 5.7: Percona Releases Post-End-of-Life Source Code to the Community (from Percona Database Blog)

♦Percona is excited to announce the community release of our MySQL 5.7 End-of-Life (EOL) source code for both Percona Server for MySQL (PS) version 5.7.44-52 and Percona XtraDB Cluster (PXC) version 5.7.44-31.65.5. This release is an accumulation of several customer-only releases we’ve done as part of our post-EOL support for MySQL 5.7, and we’re happy […] [...]

Join our AI Hackathon with MariaDB Vector (from MariaDB Foundation Blog)

pWe are excited to announce a hackathon with MariaDB Vector and Python. Since we are reaching outside our bubble, let’s start from the beginning: br MariaDB, the open-source database powers the world’s most demanding applications, from Wikipedia to global financial institutions. … /p pContinue reading \"Join our AI Hackathon with MariaDB Vector\"/p pThe post Join our AI Hacka [...]

How to Get the Best out of Google Analytics Data with HeatWave Lakehouse (from The Oracle MySQL Blog)

This blog provides a guide on how to seamlessly transfer data from Google Analytics to HeatWave, a high-performance data warehouse designed for analytics. It walks through the necessary steps to connect both platforms, explaining how to extract, transform, and load your Google Analytics data into HeatWave for optimized processing and analysis. [...]

Sunday, 09. March 2025

Deploying MySQL InnoDB ClusterSet Across Kubernetes Clusters Using Cilium (from The Oracle MySQL Blog)

This blog delves into deploying InnoDB ClusterSet with MySQL Operator across multiple Kubernetes clusters using Cilium. It illustrates how Cilium facilitates seamless connectivity between clusters, enabling them to operate as a unified entity, as though they were part of a single cluster. [...]

Saturday, 08. March 2025

Comprehensive Guide to Troubleshooting Unexpected NULL Values in MariaDB (from MinervaDB Blog)

pUnderstanding NULL Values in MariaDB When encountering unexpected NULL values in MariaDB databases, a methodical troubleshooting approach is essential. NULL values can appear for numerous reasons, from application logic issues to database configuration problems. This [...]/p pThe post Comprehensive Guide to Troubleshooting Unexpected NULL Values in MariaDB appeared first on The WebScale Database I [...]

Friday, 07. March 2025

Long-term backup options for Amazon RDS and Amazon Aurora (from AWS Database Blog)

In this post, we show you several long-term data backup strategies and how to effectively implement them in the AWS environment, with a focus on Amazon Relational Database Service (Amazon RDS) and Amazon Aurora. [...]

Accelerating Query Performance: The Benefits of TiDB’s In-Memory Engine (IME) (from PingCAP Blog)

pIf you’ve ever struggled with slow queries or high resource consumption in your database, you’re not alone. Many databases, including those built on Multi-Version Concurrency Control (MVCC), face query performance degradation over time. While MVCC is essential for managing concurrent access, excessive historical data scanning can slow down queries and overload system resources — a […]/p pThe [...]

HeatWave Always Free Tier Disaster Recovery Support (from The Oracle MySQL Blog)

Blog post for HeatWave always free tier disaster recovery support. [...]

Making CREATE/DROP SCHEMA Truly Atomic in MySQL (from The Oracle MySQL Blog)

This blog discusses atomicity in MySQL's CREATE/DROP SCHEMA operations, examines issues in earlier versions, and shows how atomicity was achieved, using crash scenarios for illustration. [...]

Cut Costs and Simplify MongoDB Deployments using ZFS (from Shattered Silicon OSDB Blog)

pReduce storage and operational costs of MongoDB deployments through use of ZFS compression./p pThe post Cut Costs and Simplify MongoDB Deployments using ZFS appeared first on Shattered Silicon./p [...]

Oracle Technology Roundtable for Digital Natives – Let’s have a look at AI, Cloud and HeatWave (from dbi Blog)

pYesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich. It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI, machine learning, vector processing, analytics and transaction processing across data in Data Lake and MySQL databases. It […]/p pL’article Oracle Technology Roun [...]

Thursday, 06. March 2025

Comparing Vitess and TiDB: Cross-Shard Queries, Consistency, and AZ Outages (from PingCAP Blog)

pTiDB focuses on simplicity, transparency, and high availability, providing a robust foundation for distributed SQL workloads. While concerns about cross-shard queries and availability zone (AZ) outages are valid, TiDB’s architecture minimizes these risks, ensuring reliable and efficient application performance. However, when comparing TiDB and Vitess — an orchestrator for sharded MySQL instan [...]

Multicloud: deploying a MySQL HeatWave instance on AWS (from The Oracle MySQL Blog)

How to deploy MySQL HeatWave on AWS [...]

Multicloud: deploying a MySQL HeatWave instance on AWS (from lefred's blog)

Multicloud is a cloud adoption strategy that utilizes services from multiple cloud providers rather than relying on just one. This approach enables organizations to take advantage of the best services for specific tasks, enhances resilience, and helps reduce costs. Additionally, a multicloud strategy offers the flexibility necessary to meet regulatory requirements and increases options for […] [...]

Enabling FIPS Mode - MySQL Server, Linux, OpenSSH, and OpenSSL 3 (from The Oracle MySQL Blog)

Ensuring FIPS compliance is crucial for securing sensitive data and meeting compliance objectives. For those of you unfamiliar with the term, FIPS (Federal Information Processing Standards) are a set of standards and guidelines issued by the U.S. National Institute of Standards and Technology (NIST) for use in federal computer systems. This blog provides a step-by-step guide to enabling FIPS mode o [...]

Smarter Query Routing with MySQL Routing Guidelines (from The Oracle MySQL Blog)

Announcing and introducing MySQL Routing Guidelines - A smarter, more flexible, and declarative approach to query routing in MySQL InnoDB Cluster, ClusterSet, and ReplicaSet. [...]

Continuent Tungsten — From Complexity to Clarity: 6 Ways To Unlock the Power of tungsten.ini (from Continuent Blog)

Managing Tungsten Cluster configurations can be challenging, especially when dealing with powerful, yet complex tungsten.ini files. To simplify the process, the new tpm ini command provides an easy way to create, validate, and manage configuration files, helping database administrators streamline their workflow. This new command is available as part of our upcoming V8 software release.Tags: tu [...]

MariaDB Honeypot (from Shinguz's Blog)

pIn our MariaDB advanced training courses, which we hold approximately every two months, we use machines that are directly exposed to the Internet with a public IP address.br Warning: You should NEVER expose a database directly to the Internet without protection!br Typically, it takes less than 72 hours (3 days) before we are exposed to the first external access attempts./pp /ppThis looks somethin [...]

Wednesday, 05. March 2025

PostgreSQL Checkpointing and Background Writing Process (from MinervaDB Blog)

pPostgreSQL checkpointing is crucial in maintaining data integrity and ensuring consistent database performance. It works in tandem with background writing processes to manage disk I/O efficiently, reducing the risk of data loss in the event [...]/p pThe post PostgreSQL Checkpointing and Background Writing Process appeared first on The WebScale Database Infrastructure Operations Experts in PostgreS [...]

Getting Started with Readyset on MySQL! (from Readyset Blog)

Readyset is a drop-in SQL caching engine. It automatically caches query results to improve response times without requiring application changes. [...]

Rewinding Time in MariaDB Databases: System-Versioning and Application-Time (from MariaDB Corporation Blog)

Have you ever needed to rewind time in your database to see data as it looked a year ago or […] [...]

Preventing and recovering from accidental deletion of an Azure Database for MySQL flexible server (from Azure for MySQL Blog)

pAccidental deletion of critical Azure resources, such as Azure Database for MySQL flexible servers, can disrupt operations. To help avoid such accidental deletions, you can use a couple of options, including Azure Resource Locks and Azure Policy. This post explains how to implement these mechanisms, and how to revive a dropped MySQL flexible server by using the Azure CLI. /p blockquote p [...]

Tuesday, 04. March 2025

MySQL Discovery and Assessment in Azure Migrate - Public Preview (from Azure for MySQL Blog)

pMySQL, one of the most popular databases, is a cornerstone of the LAMP stack, powering countless web applications with its reliability, performance, and ease of use. As businesses grow, the need for scalable and efficient database solutions becomes paramount. This is where Azure Database for MySQL comes into play. Migrating from on-premises to Azure Database for MySQL offers numerous benefits, inc [...]

February Product Update (from Readyset Blog)

Readyset's February update: Grupo Ótima Digital cuts MySQL load by 30%, a new CYBERTEC partnership, product updates, FOSDEM highlights, and more! 🚀 [...]

ClusterControl brings flexible pay-as-you-go self-serve experience to on-prem workloads (from Severalnines Blog)

pOur brand promise, “Database ops your way”, rests on three pillars: accessibility, portability and selection. That is why we’re thrilled to share that ClusterControl’s powerful automation platform for managing on-prem and hybrid deployments is now available as a pay-as-you-go, monthly subscription! Let’s dive into the details! ClusterControl adds Self-Service plan for greater optionality Clu [...]

MySQL 9.2 : thank you for your contributions! (from The Oracle MySQL Blog)

Thank you to all contributors that have their patches added to MySQL 9.2 [...]

Report from the Board (from MariaDB Foundation Blog)

pOpenness, Adoption, Continuity: You’ve heard me repeating our mantra like a broken record. Today is the next episode – and the theme du jour is about our Board Meetings, which we have minuted publicly on mariadb.org/bodminutes/ since October 2020. … /p pContinue reading \"Report from the Board\"/p pThe post Report from the Board appeared first on MariaDB.org./p [...]

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

At the beginning of the year, we released MySQL 9.2, the latest Innovation Release. Sorry for the delay, but I was busy with the preFOSDEM MySQL Belgian Days and FOSDEM MySQL Belgium Days. Of course, we released bug fixes for 8.0 and 8.4 LTS, but in this post, I focus on the newest release. Within […] [...]

Monday, 03. March 2025

Advanced Strategies for Proactive MySQL Performance Optimization (from Releem Blog)

Proactive optimization shifts the focus to preventing issues, catching bottlenecks early, and keeping performance steady under load. Instead of waiting for slowdowns, it’s time to discover advanced tuning techniques – like continuous monitoring, automatio [...]

On HeatWave MySQL: Query Execution, Performance, Benchmarks, and Vector type. Q&A with Kaan Kara. (from ODBMS.org)

Q1. You are working as a lead developer mainly responsible for query execution in HeatWave MySQL. What are the challenges that you try to solve?  HeatWave is an in-memory data processing engine, so for... [...]

Saturday, 01. March 2025

AWS MySQL Showdown: Key Insights from Our RDS vs. Aurora vs. Serverless Webinar (from Mydbops Blog)

Explore key insights from Mydbops MyWebinar 41 on AWS MySQL services. Compare RDS, Aurora, and Serverless in terms of architecture, performance, high availability, and cost efficiency. [...]

Friday, 28. February 2025

How To Check The Available Memory In Your HeatWave MySQL Cluster Via SQL (from The Oracle MySQL Blog)

This blog post gives you a quick and easy SQL statement to check the available memory in your HeatWave MySQL cluster. [...]

MySQL now reports 3 decimal places for milliseconds (from Marcelo Altmann)

MotivationpAt Readyset, we frequently analyze query latency to fine-tune performance. Our built-in metrics provide end-to-end timing breakdowns, helping us measure everything from query parsing to execution (whether it’s a cache hit or miss)./p♦Query latency varying from 5 microseconds(μs) on p50 to 12.5 microseconds(μs) on p99pWe often deal with extremely fast queries — some completing in as littl [...]

Deep Dive into MySQL - Implicit Locks (from Zhao Song's Blog)

The previous 2 blog posts introduced MySQL’s locking mechanisms for insert and locking read operations. [...]

Thursday, 27. February 2025

Database Insights provides on-demand analysis for RDS MySQL and RDS MariaDB (from AWS What's New)

pAmazon CloudWatch Database Insights expands the availability of its on-demand analysis experience to the RDS for MySQL and RDS for MariaDB database engines. This feature leverages machine learning models to help identify performance bottlenecks during the selected time period, and gives advice on what to do next.br br This launch allows you to analyze database performance monitoring data for a tim [...]

Migrate very large databases to Amazon Aurora MySQL using MyDumper and MyLoader (from AWS Database Blog)

In this post, we discuss how to migrate MySQL very large databases (VLDBs) from a self-managed MySQL database to Amazon Aurora MySQL-Compatible Edition using the MyDumper and MyLoader tools. [...]

MySQL Reserved Words: What You Need to Know  (from Devart MySQL Tool Blog)

pLearn about MySQL reserved words, their impact on database design, and how to avoid common errors. Find practical tips, examples, and resources for managing reserved words effectively./p pThe post MySQL Reserved Words: What You Need to Know  appeared first on Devart Blog./p [...]

How to Set Up the Development Environment for MySQL Shell Plugins for Python (from TusaCentral - MySQL Blogs)

pMySQL Shell is a powerful tool for managing MySQL databases, and one of its most exciting features is the ability to extend its functionality using plugins. If you're a Python developer, you can create custom plugins to automate tasks, add new commands, or♦br integrate MySQL Shell with other tools. However debugging the python code could be cumbersome for mysql-shell given the python code requires [...]

Best MySQL Management, Monitoring, and Optimization Tools in 2025 (from Releem Blog)

We’ve done the legwork to bring you a solid list of the best tools for your monitoring, managing, and optimizing needs. [...]

Why TLS for MySQL is difficult (from Daniël's Database Blog)

pThe internet has changed to a place where most protocols like HTTP etc now use secure connections with TLS by default./p pWhile both HTTP and the MySQL Protocol use TLS for secure connections there are still many differences which make it difficult for MySQL to benefit from the same advancements as HTTP has seen in the last so many years./p What is TLS? pTLS stands for Transport Layer Security and [...]

Wednesday, 26. February 2025

Time’s Up! How TiDB Efficiently Handles Expired Data (from PingCAP Blog)

pManaging large-scale data efficiently is a critical challenge for modern databases, especially when dealing with time-sensitive data that can quickly become outdated. Starting from TiDB 6.5 and becoming generally available in TiDB 7.0, TTL (Time To Live) automates the deletion of expired data, offering a powerful, customizable solution for maintaining data freshness while minimizing operational [& [...]

What Triggers a Continuent Tungsten Cluster Failsafe-Shun? (from Continuent Blog)

Learn what triggers Tungsten Cluster failsafe-shun and how it helps maintain high availability in MySQL database clusters. Discover key factors and best practices for managing automatic node shunning.Tags: tungsten clusterfailsafe-shunHigh Availabilityfailover [...]

Amazon RDS now provides visibility into IAM DB Authentication metrics and logs (from AWS What's New)

pAmazon Relational Database Service (RDS) IAM Database Authentication (IAM DB Auth) now provides enhanced observability through metrics and logs. It enables customers to investigate and resolve authentication issues when connecting to RDS databases.br br Database connection authentication issues can occur due to multiple reasons such as configuration or permission issues with your IAM policy, using [...]

Reduced operational downtime with new ALTER TABLE features (from MariaDB Corporation Blog)

Reduced operational downtime with new Online Schema Change We recently released MariaDB Enterprise Server 11.4 as part of the MariaDB […] [...]

Does Artificial Intelligence Query MySQL Better Than You? (from Dave's MySQL Stuff)

p The signal-to-noise ratio in the hype for Artificial Intelligence is incredibly high. There are many claims that AI will replace software developers. Many years ago, developers were told to find other jobs as a new programming language was designed to be written by nonprogrammers, replacing expensive coders. The Common Business Orientated Language, or COBOL, was a big hit and is still very p [...]

Amazon RDS Data API for Aurora is now available in 10 additional AWS regions (from AWS What's New)

pRDS Data API for Aurora Serverless v2 and Aurora provisioned PostgreSQL-Compatible and MySQL-Compatible database clusters is now available in Africa (Cape Town), Asia Pacific (Hong Kong), Asia Pacific (Jakarta), Asia Pacific (Malaysia), Asia Pacific (Osaka), Europe (Milan), Europe (Stockholm), Middle East (Bahrain), Middle East (UAE), and South America (São Paulo) regions. RDS Data API allows you [...]

Amazon RDS for MariaDB supports minors 11.4.5, 10.11.11, 10.6.21, 10.5.28 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 11.4.5, 10.11.11, 10.6.21, and 10.5.28. 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 [...]

Feedback from the Postgres community about the vector index benchmarks (from Small Datum)

pThis is a response to some of the feedback I received from the Postgres community about my recent benchmark results for vector indexes using MariaDB and Postgres (pgvector). The work here isn't sponsored and required ~2 weeks days of server time and a few more hours of my time (yes, I contribute to the PG community)./pptl;dr/pp/pulliindex create is ~4X faster when using ~4 parallel workers. I hope [...]

Using VS Code and Docker to Debug MySQL Crashes (from Percona Database Blog)

♦Typically, we receive customer tickets regarding crashes or bugs, where we request a core dump to analyze and identify the root cause or understand the unexpected behavior. To read the core dumps, we also request the linked libraries used by the server’s MySQL. However, there’s a more efficient way to achieve our goal: by using […] [...]

Tuesday, 25. February 2025

Galera Cluster for MySQL 8.0.41-26.22 and 8.4.4-26.22 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.41-26.22 (release notes, download), with Galera replication library 4.22 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.4-26.22 (release notes, download); it [...]

Comparing the Best Database Management Systems (from Devart MySQL Tool Blog)

pCompare the top database management systems (DBMS) like MySQL, SQL Server, PostgreSQL, MongoDB, Oracle, and more. Learn about their features, advantages, and the best use cases to choose the right database for your project./p pThe post Comparing the Best Database Management Systems appeared first on Devart Blog./p [...]

Announcing DoltHub Robot Blogger (from DoltHub Blog)

Today we're excited to share our open-source Robot Blogger tool 🤖! If you've not been following along, I wrote about my experience learning… [...]

Monday, 24. February 2025

Updated MariaDB ODBC and Python Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/ODBC 3.2.5, Connector/ODBC 3.1.21, and Connector/Python 1.1.12. Download Now MariaDB […] [...]

Understanding MySQL Global Transaction Identifiers (GTIDs) And Their Role in Replication (from The Oracle MySQL Blog)

Learn about how Global Transaction Identifiers (GTID's) and how they are used with MySQL replication. [...]

InnoDB deep dive : commit phase (from The consistent voice)

InnoDB deep dive : commit phasepEvery time you COMMIT a statement in InnoDB, a carefully orchestrated sequence of events takes place to ensure your data remains safe and consistent. Understanding how InnoDB handles transaction commits is crucial for anyone serious about database reliability and performance. The key to this process lies in a misunderstood configuration parameter: innodb_flush_log_at [...]

Understanding trx-consistency-only on MyDumper Before Removal (from Percona Database Blog)

♦I have been working on MyDumper for over three years now, and I usually don’t use the tax-consistency-only feature during backups because it wasn’t an option I quite understood. So, when reviewing another issue, I stepped into a curious scenario, and I finally got it and decided to share with you what I learned and when it should […] [...]

MariaDB and the GROUP BY error (from Vettabase)

Developers who are not familiar with SQL are often confused by MariaDB and MySQL’s infamous GROUP BY error. From time to time, customers ask us to explain it, so it’s time we publish an article on this topic. The error I’m talking about is the following: Let’s see what this error means, and how to rewrite a query accordingly. Understanding the error The error components are [...]

Rancher and Galera Cluster in the partner repository (from Galera Blog)

If you’ve ever wanted to deploy Galera Cluster on Rancher by SUSE, you now can since Galera Cluster is a partner chart in their repository. This means Codership’s Galera Cluster is a SUSE Ready Verified partner. A direct link to the HELM charts for MySQL/Galera Cluster is here. What is Rancher? Rancher is a Kubernetes […] [...]

Sunday, 23. February 2025

MySQL / MariaDB Post-Upgrade Performance Anomalies (from Shattered Silicon OSDB Blog)

pUpgrading MySQL or MariaDB introduces new features but can cause performance anomalies, due to changes in query optimizer algorithms./p pThe post MySQL / MariaDB Post-Upgrade Performance Anomalies appeared first on Shattered Silicon./p [...]

Saturday, 22. February 2025

30th Anniversary Edition (from AskDba)

In this edition of the blog post, I want to summarize my three decades (excluding my internships) of hustle in Information Technology. This is not only a tribute to my 30th anniversary in the field but also a show of appreciation for those with whom I’ve crossed paths—sharing knowledge, experiences, and moments of blood, sweat, […] [...]

Friday, 21. February 2025

This month in MariaDB Foundation: Jan 2025 (from MariaDB Foundation Blog)

pFocus, focus, focus! That’s the mantra of any successful organisation. With great input from our Board, we’ve managed to condense our strategic planning for 2025 into six goals. … /p pContinue reading \"This month in MariaDB Foundation: Jan 2025\"/p pThe post This month in MariaDB Foundation: Jan 2025 appeared first on MariaDB.org./p [...]

Dolt for Beginners: Schemas (from DoltHub Blog)

The Dolt for Beginners series focuses on topics people getting started with Dolt will likely be interested in. Most of our other blog… [...]

Thursday, 20. February 2025

Public Preview announcement - Unified migration experience in Azure DMS (from Azure for MySQL Blog)

pWe are excited to announce that Azure Database Migration Service (DMS) now supports seamless migration of your MySQL on-premises or Virtual Machine (VM) workloads to Azure Database for MySQL - Flexible Server. This new feature, now available in public preview, allows you to use physical backup files of the MySQL server for migration. /p p /p pBy restoring your physical data files directl [...]

Azure Database for MySQL - January 2025 updates and latest feature roadmap (from Azure for MySQL Blog)

pWe're excited to share a summary of the Azure Database for MySQL announcements from last month, as well as the latest roadmap of upcoming features!/p February 2025 Live Webinar pThese updates and the latest roadmap are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every month, at 7:30 AM Pacific time. Be [...]

Meeting NIS2 Challenges with MySQL Enterprise Edition (from The Oracle MySQL Blog)

The NIS2 Directive strengthens EU cybersecurity standards by expanding sector coverage and imposing stricter requirements. This document outlines how MySQL Enterprise Edition can help organizations meet these demands, focusing on key areas for securing MySQL database servers within the NIS2 framework. [...]

MySQL Rockstars 2024 (from The Oracle MySQL Blog)

These are the MySQL Rockstars 2024 winners ! [...]

Wednesday, 19. February 2025

Unleashing 50x Performance: In-Depth Analysis of TiDB DDL Framework Optimizations (from PingCAP Blog)

pManaging schema changes in traditional databases often leads to downtime, blocking, and operational complexity. TiDB has long simplified this process with its online DDL capabilities, allowing developers to evolve their databases without disrupting applications. As user bases and data volumes have surged, however, index creation was increasingly becoming a performance bottleneck. To address this, [...]

A Deep Dive into OpenSSL, FIPS, and MySQL (from The Oracle MySQL Blog)

FIPS compliance is crucial for numerous MySQL deployments, especially within government agencies and organizations subject to regulatory mandates. The alignment of FIPS 140-3 with ISO/IEC 19790 broadens the applicability of these requirements. This blog clarifies the relationship between FIPS, OpenSSL, and MySQL. [...]

Amazon RDS for MySQL supports new minor versions 8.0.41 and 8.4.4 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor versions 8.0.41 and 8.4.4. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MySQL, and to benefit from the bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more about the enhancements in RDS for MySQL 8 [...]

My database communities (from Small Datum)

pI have been working on databases since 1996. In some cases I just worked on the product (Oracle & Informix), in others I consider myself a member of the community (MySQL, Postgres & RocksDB). And for MongoDB I used to be in the community./ppI worked on Informix XPS in 1996. I chose Informix because I could live in Portland OR and walk to work. I was fresh out of school, didn't know much ab [...]

Highlights from preFOSDEM MySQL Belgian Days 2025 (from The Oracle MySQL Blog)

This is a recap of the preFOSDEM MySQL Belgian Days 2025 [...]

What’s New At Releem - February 2025 (from Releem Blog)

See what's new in Releem in February 2025. ✨ This month, we’re delivering key improvements in monitoring and query analytics to help you monitor and optimize database servers with even greater confidence. [...]

Percona Monitoring and Management 3 and rootless containers (from Percona Community Blog)

In today’s landscape, where security breaches are a constant concern, reducing potential attack vectors is a top priority for any organization. Percona Monitoring and Management (PMM) has established itself as a reliable solution for database performance monitoring. With the release of PMM version 3, Percona has significantly strengthened its security posture, notably by introducing support f [...]

Tuesday, 18. February 2025

Decoding MySQL's GTID_TAGGED_LOG_EVENT (from Daniël's Database Blog)

table { margin: 1em 0; border-collapse: collapse; width: 100%; overflow-x: auto; display: block; font-variant-numeric: lining-nums tabular-nums; } table caption { margin-bottom: 0.75em; } tbody { margin-top: 0.5em; border-top: 1px solid #1a1a1a; border-bottom: 1px solid #1a1a1a; } th { border-top: 1px solid #1a1a1a; padding: 0.25em 0.5em 0.25em 0.5em; } td { padding: 0.125em 0.5em 0.25em 0.5em; } [...]

Codership is pleased to announce that we have been selected to join the European Innovation Council Pavilion at MWC 2025 in Barcelona (from Galera Blog)

Codership is pleased to announce that we have been selected to join the European Innovation Council Pavilion at MWC 2025 in Barcelona, taking place from 3 to 6 March! This international trade fair is the largest and most influential connectivity event in the world, where industry leaders, startups, and investors come together to shape the […] [...]

Learning About RAG (from DoltHub Blog)

Dolt recently added support for vector indexes, which are a type of index used commonly in RAG (Retrieval-Augmented Generation) applications… [...]

Monday, 17. February 2025

On Data Migration. Q&A with Eric Hanson (from ODBMS.org)

Q1. What are the typical challenges when performing data migration?  Performing data migration requires you to decide what to migrate, build tables in the target system with the right schema, do initial movement of... [...]

MariaDB 11.7.2 and MariaDB 11.8.1 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.8.1, the Release Candidate (RC) in the long-term MariaDB 11.8 release, and MariaDB 11.7.2, the latest Generally Available (GA) rolling release. … /p pContinue reading \"MariaDB 11.7.2 and MariaDB 11.8.1 now available\"/p pThe post MariaDB 11.7.2 and MariaDB 11.8.1 now available appeared first on MariaDB.org./p [...]

The Potential of Query Attributes in MySQL (from Daniël's Database Blog)

Introduction pQuery Attributes are a relatively new feature of the MySQL Protocol. This is availble since MySQL 8.0.23./p pBefore Query Attributes were introduced there already was already another similar feature: Connetion Attributes, which provides per-connection metadata in the form of key/value pairs./p pThis is what connection attributes look like:/p precodemysql> SELECT ATTR_NAME, ATTR_VAL [...]

Exploiting the Powerful Filtering Capabilities of Tungsten Replicator (from Continuent Blog)

In this blog we take a look at how you can use Tungsten Replicator to replicate data from multiple sources, and merge into a single target using 3 simple yet effective filters.Tags: MySQLMariaDBreplication filtersfiltering [...]

More MariaDB releases, right before the webinar! (from Galera Blog)

So we initially planned to use MariaDB Server 11.7 for the upcoming webinar on 19 February, but we decided that it would be wise to upgrade to 11.8 RC which just became a release candidate. 11.7 is a short term release, and it comes with the all important Vector support, which we are pleased to […] [...]

How to Use IAM Roles for Service Accounts (IRSA) with Percona Operator for MongoDB on AWS (from Percona Community Blog)

Introduction Percona Operator for MongoDB is an open-source solution designed to streamline and automate database operations within Kubernetes. It allows users to effortlessly deploy and manage highly available, enterprise-grade MongoDB clusters. The operator simplifies both initial deployment and setup, as well as ongoing management tasks like backups, restores, scaling, and upgrades, ensuring sea [...]

Sunday, 16. February 2025

Vector indexes, MariaDB & pgvector, large server, dbpedia-openai dataset (from Small Datum)

pThis post has results from ann-benchmarks to compare MariaDB and Postgres with a larger dataset, dbpedia-openai at 100k, 500k and 1M rows. It has 1536 dimensions and uses angular (cosine) as the distance metric. By larger I mean by the standards of what is in ann-benchmarks. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation./pptl;dr/pulliIndex creat [...]

Saturday, 15. February 2025

Vector indexes, large server, dbpedia-openai dataset: MariaDB, Qdrant and pgvector (from Small Datum)

pMy previous post has results for MariaDB and pgvector on the dbpedia-openai dataset. This post adds results from Qdrant. This uses ann-benchmarks to compare MariaDB, Qdrant and Postgres (pgvector) with a larger dataset, dbpedia-openai at 500k rows. The dataset has 1536 dimensions and uses angular (cosine) as the distance metric. This work was done by Small Datum LLC and sponsor [...]

Friday, 14. February 2025

Node Groups in TiDB Cloud: The Key to Scaling Workloads with Predictable Performance and Control (from PingCAP Blog)

pAs modern applications scale, ensuring consistent, predictable performance across different workloads becomes increasingly challenging. Transactional queries, real-time analytics, and batch jobs often compete for resources, leading to slowdowns, inefficient resource allocation, and unpredictable database behavior. With Node Groups in TiDB Cloud, organizations can assign dedicated TiDB node compute [...]

Tuning MariaDB timeouts that affect applications (from Vettabase)

MariaDB has many configurable timeouts. Some of them can only be configured by DBAs (database administrators). Others can be adjusted by developers in the application code, though DBAs can configure defaults. MariaDB timeouts can be grouped in these categories: But why would one change the default timeouts? Isn’t it dangerous? Actually the default timeouts are very high, so they are only hit [...]

Beyond the Basics: Digging into MySQL Variables (from Releem Blog)

This guide unpacks the key contrasts between user-defined variables, which are dynamic parameters assigned within your queries, and system variables, which control the broader performance and settings of your MySQL database. [...]

Orchestrator (for Managing MySQL) High Availability Using Raft (from Percona Database Blog)

♦As we know, Orchestrator is a MySQL high availability and replication management tool that aids in managing farms of MySQL servers. In this blog post, we discuss how to make the Orchestrator (which manages MySQL) itself fault-tolerant and highly available. When considering HA for the Orchestrator one of the popular choices will be using the Raft consensus. […] [...]

Database Performance Tuning Techniques (from Releem Blog)

Learn what database tuning is and how to improve performance with effective methods. Explore key database tuning techniques, optimize queries, indexing, and resource management to ensure a stable and fast system. [...]

Forecast MySQL IOPS (from MinervaDB Blog)

pThis technical guide offers a comprehensive approach to forecasting MySQL Input/Output Operations Per Second (IOPS) using Performance Schema metrics. Since understanding and accurately predicting IOPS is crucial for database performance optimization, capacity planning, and maintaining [...]/p pThe post Forecast MySQL IOPS appeared first on The WebScale Database Infrastructure Operations Experts in [...]

Thursday, 13. February 2025

TiDB Cloud CONNECTED Care: Elevate Your Support with Seamless, Real-Time Connectivity (from PingCAP Blog)

pTiDB Cloud has always delivered a high-performance, distributed SQL solution. However, we’re now taking it a step further with TiDB Cloud CONNECTED Care, our refreshed support service. Whether you’re a new customer exploring TiDB Cloud or an existing user looking to upgrade to Enterprise or Premium tiers, CONNECTED Care offers seamless, real-time connectivity, ensuring you […]/p pThe p [...]

How GaadiBazaar reduced database costs by 40% with Aurora MySQL Serverless (from AWS Database Blog)

GaadiBazaar draws on over 25 years of vehicle finance expertise from Cholamandalam to connect vehicle buyers and sellers. Their mission is to enable hassle-free transactions at fair prices through buyer-seller interactions and end-to-end financial assistance. This post shows you how GaadiBazaar, an online platform for buying and selling vehicles, achieved significant database cost savings by migrat [...]

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

pAmazon Relational Database Service (RDS) for MySQL announces Amazon RDS Extended Support minor version 5.7.44-RDS.20250103. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of MySQL. Learn more about the bug fixes and patches in this version in the Amazon RDS User Guide.br br Amazon RDS Extended Support provides you more time, up to thr [...]

Announcing Yearly LTS Releases for MariaDB Community Server (from MariaDB Corporation Blog)

In order to give MariaDB community users predictability on when long term maintenance (LTS) versions will be available, MariaDB is […] [...]

Announcing MariaDB Community Server 11.7 GA with Vector Search and MariaDB Community Server 11.8 RC (from MariaDB Corporation Blog)

MariaDB Community Server 11.7 is now generally available (GA), and 11.8 is available as a release candidate (RC)! Both reinforce […] [...]

SingleStore Unveils No-Code Solution Designed to Cut Data Migration from Days to Hours (from ODBMS.org)

By streamlining data transfer and Change Data Capture, SingleStore Flow makes it easier for customers to harness its capabilities to power applications, analytics and AI. February 13, 2025 09:00 AM Eastern Standard Time SAN... [...]

Succeed with HeatWave – Part 3 (from The Oracle MySQL Blog)

This is the third part of our blog series showcasing how customers succeed with HeatWave. [...]

1995-2025: 30 years! (from The Oracle MySQL Blog)

MySQL turns 30 and we will celebrate this milestone all over the globe! [...]

How MySQL Enterprise Edition Supports Government Digital Transformation (from The Oracle MySQL Blog)

This blog post summarizes how MySQL supports government IT priorities, from cybersecurity protection to modernization, cost savings, and workforce transformation. [...]

Wednesday, 12. February 2025

Grupo Ótima Digital Trusts Readyset to Scale Growing MySQL Infrastructure (from Readyset Blog)

Brazil’s leading provider of messaging solutions, Group Ótima Digital, seamlessly integrates Readyset’s database scaling platform to scale their existing MySQL infrastructure with ZERO code changes [...]

5 Ways to Look at a Tungsten Active-Active MySQL Replication Issue (from Continuent Blog)

Replication is one of the most critical components of database management, especially in an Active-Active multi-primary composite cluster. However, with great flexibility comes the occasional hiccup. If you’re grappling with intermittent replication failures for a table in your Tungsten Cluster setup, here are five practical approaches to diagnose and resolve the issue.Tags: active-active repl [...]

New Year Reality Check: Slowing Down to better Move Forward (from The consistent voice)

pFollowing up on my “New Year, New Me” post — let’s be real, that whole idea is kinda bs right ? Change doesn’t just magically happen because the calendar flips to January. The idea we can reinvent ourselves overnight is unrealistic, and words without intents (and therefore actions) just sets us up for failure more than anything. But that doesn’t mean the end of year holidays and the weeks after ar [...]

MariaDB 11.8 is LTS (from MariaDB Foundation Blog)

pConfirming what you probably already expected: MariaDB Server 11.8 will be a long-term support release. br Now a Release Candidate – GA in Maybr With MariaDB Vector as the lead new feature, MariaDB 11.8 succeeds the previous LTS MariaDB 11.4 from a year ago. … /p pContinue reading \"MariaDB 11.8 is LTS\"/p pThe post MariaDB 11.8 is LTS appeared first on MariaDB.org./p [...]

Building generative AI apps locally (from Programming Brain)

Learn how to set up and run AI embedding models locally with MariaDB to store and query vector embeddings efficiently. [...]

Moving documentation in-product with the dolt_help table (from DoltHub Blog)

Dolt is the world's first and only version-controlled SQL database. As the only product in its category, there's a lot for our customers to… [...]

Tuesday, 11. February 2025

MySQL vs MongoDB: Best Choice for You (from ScaleGrid Blog)

pChoosing the right database often comes down to MongoDB vs MySQL. This article will help you understand the core differences in data structure, scalability, and use cases. Whether you need a relational database for complex transactions or a NoSQL database for flexible data storage, we’ve got you covered. Key Takeaways MySQL is a relational database.../p p<p>The post MySQL vs MongoDB: Best Ch [...]