Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

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

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

Thursday, 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. This blog explains InnoDB’s key memory structures and how to tune them effectively. Key InnoDB Memory Structures 1. [...]/p pThe post Optimizing Database Performance with InnoDB Memory Structures appeared first on The WebScale Database Infrastructure Opera [...]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

MariaDB C Connector 3.4.4, 3.3.14, and 3.1.27, and Java Connector 3.5.2 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.4.4, 3.3.14, and 3.1.27, and Connector/Java 3.5.2. Download Now … Continued [...]

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

♦A critical security vulnerability has been identified in the following software that Percona has made available: PMM Open Virtual Appliance (OVA) installations, version 2.38 and above. This vulnerability does not extend to Docker or Amazon Machine Images (AMIs). The Common Vulnerabilities and Exposures (CVE) identifier for this issue is CVE-2025-26701. Immediate actions required UPGRADE IMMEDIATEL [...]

Building an Interactive LLM Chatbot with HeatWave Using Python (from MySQL expert Diary)

pAI-powered applications require robust and scalable database solutions to manage and process large amounts of data efficiently. HeatWave is an excellent choice for such applications, providing high-performance OLTP, analytics, machine learning and generative artificial intelligence capabilities./p pIn this article, we will explore a Python 3 script that connects to an HeatWave instance and enables [...]

Vector indexes, MariaDB & pgvector, large server, large dataset: part 1 (from Small Datum)

pThis post has results from ann-benchmarks to compare MariaDB and Postgres with a larger dataset, gist-960-euclidean.  Previous posts (here and here) used fashion-mnist-784-euclidean which is a small dataset. By larger I mean by the standards of what is in ann-benchmarks. This dataset has 1M rows and 960 dimensions. The fashion-mnist-784-euclidean dataset has 60,000 rows and 784 dimensions. Bo [...]

Monday, 10. February 2025

MySQL Performance Tuning with Releem (from Vlad Mihalcea's Blog)

pIntroduction If your application uses MySQL and you’re interested in getting the best out of it via performance tuning and monitoring, then Releem is a very nice tool that can assist you in your endeavor. I discovered Releem from Roman Agabekov’s posts on social media. Roman is the founder of this tool, and since his posts about MySQL performance tuning are very insightful, I decided t [...]

Google’s generative AI Toolbox for Databases to help connect agents with databases (from InfoWorld)

pGoogle’s cloud computing division, Google Cloud, has added a new generative AI Toolbox for Databases to help enterprise developers connect agent-based generative AI applications to its databases./p pThe new Toolbox, which is currently in public beta, is an open-source server designed to streamline the creation, deployment, and management of AI agents capable of querying d [...]

Dolt for Beginners: Importing MySQL Dumps (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… [...]

Friday, 07. February 2025

Encrypt PostgreSQL Data at Rest on Kubernetes (from Percona Database Blog)

♦The upcoming Percona Operator for PostgreSQL v2.6.0 release introduces support for PostgreSQL 17, which opens exciting possibilities for data security. Since pg_tde comes pre-installed in Percona’s official PostgreSQL 17 images, this release presents an excellent opportunity to implement Transparent Data Encryption in your Kubernetes-deployed databases. Let’s look at how to configure a [...]

MariaDB Day Brussels Aftertaste 2025-02 (from MariaDB Foundation Blog)

pBack from Brussels! With a bit of time to reflect, I’d like to share the aftertaste from our MariaDB Day, our very own FOSDEM Fringe Event. … /p pContinue reading \"MariaDB Day Brussels Aftertaste 2025-02\"/p pThe post MariaDB Day Brussels Aftertaste 2025-02 appeared first on MariaDB.org./p [...]

Thursday, 06. February 2025

Using TLS with MySQL 5.7 in Golang (from Skeema Blog)

pNew versions of the Go programming language are released every six months, and occasionally these releases tighten and modernize the standard library’s defaults for encryption behavior. Although these new defaults improve security, they can be problematic when connecting to older server software, such as MySQL 5.7, which is no longer being updated./p [...]

MySQL Router bootstrap & “conf-set-option” (from MySQL-Med)

How to parameterize your MySQL Router whilst bootstrapping: quick-n-easy with --conf-set-option. Continue reading → [...]

Wednesday, 05. February 2025

HeatWave MySQL: Latest Enhancements in DB System access mode and security (from The Oracle MySQL Blog)

Modern cloud databases need to offer flexibility in workload management, security and cross-region availability. To address these evolving demands, we have introduced new capabilities in HeatWave MySQL that improves operational efficiency and enables even more sophisticated deployment patterns. [...]

7 Amazing Benefits of Tungsten Active-Active Replication for MySQL (from Continuent Blog)

Discover the benefits of Tungsten Active-Active Clustering for MySQL. Learn how this solution ensures high availability, scalability, low-latency data access, and disaster recovery for businesses with global operations.Tags: tungsten clusterreplicationHigh AvailabilityscalabilityDisaster Recoverylow-latencyCloud [...]

MariaDB 11.4.5, 10.11.11, 10.6.21 and 10.5.28 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.4.5, MariaDB 10.11.11, MariaDB 10.6.21 and MariaDB 10.5.28, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates). … /p pContinue reading \"MariaDB 11.4.5, 10.11.11, 10.6.21 and 10.5.28 now available\"/p pThe post MariaDB 11.4.5, 10.11.11, 1 [...]

Dolt sql-server removes user and password arguments (from DoltHub Blog)

In the Dolt 1.49.0 release, we removed the ability to specify a username and an optional password when starting a sql-server. These… [...]

Tuesday, 04. February 2025

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.5, 10.11.11, 10.6.21, and 10.5.28 maintenance releases. See … Continued [...]

Writing User Defined Functions for MariaDB in Go (from MinervaDB Blog)

pThis guide provides a comprehensive walkthrough for creating User Defined Functions (UDFs) in MariaDB using the Go programming language. UDFs allow you to extend MariaDB’s functionality by implementing custom functions that can be called directly [...]/p pThe post Writing User Defined Functions for MariaDB in Go appeared first on The WebScale Database Infrastructure Operations Experts in Pos [...]

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

Ths blog represents the second part of our "Succeed with HeatWave" blog series, outlining how customers use HeatWave GenAI and HeatWave AutoML to accelerate their AI initiatives. [...]

Monday, 03. February 2025

January Product Update (from Readyset Blog)

Discover Readyset's December highlights: MySQL demo launch, product updates, AWS re:Invent recap, and upcoming events to kick off 2025! [...]

16 Best MySQL GUI Clients for macOS (from Devart MySQL Tool Blog)

pTake a look at the most convenient and user-friendly MySQL GUI tools (clients) that help you tackle a variety of database development, management, and administration tasks on macOS./p pThe post 16 Best MySQL GUI Clients for macOS appeared first on Devart Blog./p [...]

Friday, 31. January 2025

Blazing-Fast Cluster Recovery: How TiDB 8.1 Redefines Large-Scale Data Restoration (from PingCAP Blog)

pBackup and restore are critical for ensuring business continuity, with the Recovery Time Objective (RTO) serving as a key metric for assessing restore performance. As TiDB continues to grow in popularity for its scalability, many users have datasets reaching hundreds of terabytes (TBs). That means the challenge of ensuring a fast RTO for such large […]/p pThe post Blazing-Fast Cluster Recove [...]

Dolt database: first impressions (from Vettabase)

You might know that we maintain a list of Awesome Innovative Databases on GitHub. At the time of this writing, the first item in the list of active projects is curious: Dolt. If English isn’t your mother tongue, you might not know that it is a synonymous for idiot or… git. Someone told me that probably Linus chosen the name git because of its assonance with get and didn’t consider [...]

Your MySQL & MariaDB Galera Cluster and Galera Manager Best Practice Resources (from Galera Blog)

Happy 2025, it is a fresh year, and there have been plenty of resources to help you gain the most out of your Galera Cluster (be it on MySQL or MariaDB Server) and Galera Manager deployments, so here is a quick “best practices” guide. Did you know that in under 15 minutes, you can Deploy […] [...]

Why MariaDB Galera Cluster 11.4? (from Galera Blog)

If you read Changes and Improvements in MariaDB 11.4 you might think there are no MariaDB Galera Cluster changes in this long-term series, maintained until May 2029, but this is far from the truth. There are a few things that you can totally benefit from in MariaDB Galera Cluster, and this series continues from Why […] [...]

Changing HeatWave MySQL shape and configuration with minimal downtime (from The Oracle MySQL Blog)

The Oracle HeatWave MySQL service offers users the flexibility to modify DB system shapes and configuration, enabling them to adapt to changing workloads and enhance performance. In this blog post we'll share insights into the latest changes related to DB system shape and configuration changes, mostly focusing on the high availability and read replicas support. [...]

MySQL Partitioning in 8.0 (from Mydbops Blog)

Discover MySQL 8.0 partitioning strategies, including RANGE, HASH, LIST, and KEY partitioning, plus new subpartitioning features. Learn how to optimize database performance with partitioning best practices. [...]

Available now: OCI Database Management and Ops Insights for on-premises MySQL databases (from The Oracle MySQL Blog)

OCI Database Management and OCI Ops Insights services deliver advanced capabilities to simplify the monitoring of External MySQL databases, offer detailed granular insights, and reduce the burden of managing infrastructure resources. Additionally, as a cloud-native, managed solution, these services eliminate the need to maintain the monitoring solution itself. [...]

Percona Operator for MongoDB 1.19: Remote Backups, Auto-Generated Passwords, and More! (from Percona Community Blog)

The latest release of the Percona Operator for MongoDB, version 1.19, is here. It brings a suite of enhancements designed to streamline your MongoDB deployments on Kubernetes. This release introduces a technical preview of remote file server backups, simplifies user management with auto-generated passwords, supports Percona Server for MongoDB 8.0, and includes numerous other improvements and bug fi [...]

Thursday, 30. January 2025

JSON Showdown: Dolt vs MongoDB (from DoltHub Blog)

This is the fourth in a series of tests putting Dolt head-to-head against other database engines to see how they handle large JSON documents… [...]

Wednesday, 29. January 2025

Readyset and PerformanceDB Join Forces to Revolutionize MySQL Database Scaling in Brazil (from Readyset Blog)

We are thrilled to announce a transformative partnership with PerformanceDB, a leading database support and service provider, to better serve our customers across Brazil. [...]

On HeatWave, MySQL database and GenAI. Q&A with Nitin Kunal (from ODBMS.org)

Q1. You are one of the founding engineers of HeatWave. Can you tell us what are you current projects?  I am indeed one of the founding engineers of the HeatWave project, having written its first header file and designed and developed... [...]

Four reasons to visit MariaDB Day in Brussels (from MariaDB Foundation Blog)

pStill unsure about attending the MariaDB Day in Brussels on Saturday? Here are four reasons to turn up at our FOSDEM Fringe event.br 1.⁠ … /p pContinue reading \"Four reasons to visit MariaDB Day in Brussels\"/p pThe post Four reasons to visit MariaDB Day in Brussels appeared first on MariaDB.org./p [...]

Understanding and managing history list length in Azure Database for MySQL (from Azure for MySQL Blog)

pEfficient database management often requires digging deeply into metrics that reflect the internal state of the database server. While Azure Database for MySQL is already tuned for the best performance out of the box, workloads can vary significantly. One common performance issue arises from open transactions, those that stay active unintentionally because of bugs, errors in application logic, or [...]

Building and testing MySQL 8.0.41 / 8.4.4 / 9.2.0 on macOS (from Laurynas Biveinis' blog)

p Previously: 8.0.40 / 8.4.3 / 9.1.0 /p p Oracle released MySQL 8.0.41 / 8.4.4 / 9.2.0, and it's time for me to build and test it under macOS, of all things! /p p But first, a detour to the last set of releases Valgrind results, because its run took a few weeks on 9.1.0, and that's without code--big-test/code. A big part of tests timed out, or failed randomly. There appear no errors that are diag [...]

4 tiny Docker images for lightweight containers (from InfoWorld)

pDocker images can get pretty bulky if you’re not careful. Your typical Docker image includes everything you need to run a particular piece of software (such as the application language’s runtime) and everything those things depend on. Images in the hundreds of megabytes are common, often because they use as their base some variety of Linux distribution. Anything beyond a sta [...]

Percona Monitoring and Management 3.0.0-GA (from Percona Community Blog)

We’re excited to announce the release of Percona Monitoring and Management (PMM) 3.0.0 GA. The Percona Monitoring and Management (PMM) 3.0.0 release delivers major security and stability enhancements. Notable security improvements include rootless deployments and encryption of sensitive data, along with improved API authentication using Grafana service accounts. Deployment options have expand [...]

Tuesday, 28. January 2025

Vector indexes, MariaDB & pgvector, large server, small dataset: part 2 (from Small Datum)

pThis post has results for vector index support in MariaDB and Postgres. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation. This is part 2 in a series that compares QPS and recall for the fashion-mnist-784-euclidean dataset using from 1 to 48 concurrent sessions on a large server. This is part 2 and part 1 is here. /ppThe purpose of this post is to explai [...]

Vector indexes, MariaDB & pgvector, large server, small dataset: part 1 (from Small Datum)

pThis post has results for vector index support in MariaDB and Postgres. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation. /ppMy previous posts (here and here) used a server with 8 cores and 32G of RAM. While that was OK for one of the smaller datasets from ann-benchmarks it wasn't enough for larger datasets and the problem was the amount of memory used by th [...]

TiProxy in TiDB: Achieve Zero Downtime Upgrades (from Mydbops Blog)

Discover TiProxy in TiDB, a powerful proxy component for load balancing, connection persistence, service discovery, and zero downtime upgrades. [...]

What’s New in TiDB 8.5? (from Mydbops Blog)

Discover the groundbreaking features of TiDB 8.5.0 LTS, including improved performance, scalability, security, and enhanced TiProxy capabilities. [...]

MySQL latest performance review (from TusaCentral - MySQL Blogs)

pThis article is focused on describing the latest performance benchmarking executed on the latest release of MySQL and Percona. ♦/p pIn this set of tests I have used the machine described here.  /p Assumptions pThere are many ways to run tests, and we know that results may vary depending on how you play with many factors, like the environment or the MySQL server settings. However, if [...]

Monday, 27. January 2025

Why MariaDB Galera Cluster 10.11? (from Galera Blog)

Why MariaDB Server with Galera Cluster 10.11, you might ask? Well, there are plenty of Galera Cluster improvements that one might consider, and know that it rolls up with features that we have been contributing in the rolling short-term releases from 10.7/10.8/10.9/10.10. So, MariaDB Server 10.11 is a long-term support release which means you get […] [...]

How can we tune Redo Buffer in InnoDB for optimal performance? (from MinervaDB Blog)

pOptimizing InnoDB’s redo buffer is a critical aspect of MySQL database performance tuning. This technical document explores various strategies and configurations to enhance the efficiency of the redo buffer system, which plays a vital role [...]/p pThe post How can we tune Redo Buffer in InnoDB for optimal performance? appeared first on The WebScale Database Infrastructure Operations Experts [...]