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, 29. May 2025

Identifying Cacheable Queries: Using tools like pt-query-digest or the MySQL sys schema to pinpoint queries that would benefit from caching (from Readyset Blog)

IntroductionpIt’s common for DBAs to optimize queries to address bottlenecks and reduce resource contention. However, in production workloads, the most resource-intensive queries aren’t always the longest-running ones. High-frequency queries that execute quickly but are called repeatedly can collectively consume significant resources, increasing overall latency and/p [...]

Pegadaian boosts both efficiency and customer satisfaction using MySQL Enterprise Edition (from The Oracle MySQL Blog)

In an era where customer expectations are higher than ever, and businesses must adapt to ever-changing technological landscapes, Pegadaian’s choice to implement MySQL Enterprise Edition has proven to be a strategic move. By upgrading their database infrastructure, the company has enhanced its application quality, ensured reliability, and most importantly, continued to deliver the high level of serv [...]

Insignia Financial Uses MySQL Enterprise Edition to Improve Performance and Reduce Costs (from The Oracle MySQL Blog)

In today’s fast-paced financial environment, ensuring that core systems are secure, high-performing, and cost-effective is essential for maintaining a competitive edge. For Insignia Financial, upgrading to MySQL Enterprise Edition has not only addressed the challenges of database performance, security, and administrative overhead but has also provided substantial savings in licensing costs. Read th [...]

How to Safely Upgrade InnoDB Cluster From MySQL 8.0 to 8.4 (from Percona Database Blog)

♦In this blog, we continue from where we left off in the previous post, InnoDB Cluster Setup: Building a 3-Node High Availability Architecture, where we demonstrated how to set up a MySQL InnoDB Cluster with three nodes to achieve high availability. Here, we walk through the step-by-step process of performing a rolling upgrade of that […] [...]

Helsinki Python Hackathon –  a role model for future MariaDB hackathons! (from MariaDB Foundation Blog)

pOne of the most fun and rewarding activities the past two-three months has been working with the participants in the Helsinki Python hackathon on MariaDB Vector. … /p pContinue reading \"Helsinki Python Hackathon –  a role model for future MariaDB hackathons!\"/p pThe post Helsinki Python Hackathon –  a role model for future MariaDB hackathons! appeared first on MariaDB.org./p [...]

Wednesday, 28. May 2025

Helsinki Python meetup with AI RAG and MariaDB Foundation (from MariaDB Foundation Blog)

pThe Helsinki Python meetup on Tuesday 27th May was hosted by MariaDB Foundation with nearly 100 participants of the 2600+ members of the Helsinki python meetup community.  … /p pContinue reading \"Helsinki Python meetup with AI RAG and MariaDB Foundation\"/p pThe post Helsinki Python meetup with AI RAG and MariaDB Foundation appeared first on MariaDB.org./p [...]

Building Intelligent AI Agents: A New Data Application Paradigm with MCP and TiDB (from PingCAP Blog)

pWe’ve entered the Agentic AI Era—a new phase where large language models (LLMs) go beyond understanding instructions to actively making decisions and autonomously executing tasks. In this landscape, the ability to efficiently integrate LLMs with external systems, particularly databases, has become critical for building truly powerful AI applications. The Model Context Protocol (MCP) has emer [...]

What is a Vector in AI and RAG? (from Programming Brain)

What exactly is a Vector embedding in AI apps and how to use them in RAG architectures? [...]

Introducing Full-Text Search for TiDB: Enhancing RAG Applications with Hybrid Search (from PingCAP Blog)

pAt PingCAP, we strive to make TiDB your all-in-one AI database, capable of handling any workload seamlessly to fulfill the demand of the fast-evolving AI ecosystem. With vector search already available in TiDB, we are now excited to announce the native support for full-text search (beta) in TiDB Cloud Serverless clusters. Full-text search allows you […]/p pThe post Introducing Full-Text Sear [...]

Why Fresh Data, SQL, and Unified Platforms Are Your Competitive Edge for AI Applications (from PingCAP Blog)

pDelivering truly personalized AI experiences is complex. It requires Large Language Models (LLMs) to access relevant personal or organizational information and possess the intelligence to translate needs into tangible actions. This pursuit has been a key direction in GenAI application development. With foundational models like GPT-4o and DeepSeek-V2 becoming genuinely practical, their reasoning an [...]

MariaDB to Dolt Replication (from DoltHub Blog)

Dolt is the world's first and only version-controlled SQL database. It gives you the power of a SQL database to quickly and expressively… [...]

Tuesday, 27. May 2025

Troubleshooting Thread Contention in Apache Cassandra (from MinervaDB Blog)

pMastering Thread Contention in Apache Cassandra: A DBA’s Complete Guide As Cassandra DBAs, we’ve all been there—your cluster is running smoothly until suddenly latencies spike, CPU usage soars, but throughput plummets. Welcome to the world [...]/p pThe post Troubleshooting Thread Contention in Apache Cassandra appeared first on The WebScale Database Infrastructure Architecture, Enginee [...]

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

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

The Best MySQL Active/Active Solution Gets Better! (from Continuent Blog)

Discover how Tungsten Cluster v8 builds on the already powerful v7, adding Kubernetes support, REST API v2, stronger security, and lots of enhancements to redefine MySQL clustering.Tags: MySQLactive/activetungsten clusterClusteringkubernetes [...]

AWS adds observability support to Aurora PostgreSQL Limitless (from InfoWorld)

pAmazon Web Services (AWS) has added observability support to its managed Aurora PostgreSQL Limitless service to help enterprises monitor the health of their database fleet and troubleshoot issues around it./p pObservability of databases is crucial for enterprise stakeholders, including DevOps engineers, application developers, and database administrators (DBAs), as it all [...]

Driving Real-Time Engineering Insights with MySQL Enterprise Edition: The Power Behind Nibana’s ESEC Platform (from The Oracle MySQL Blog)

ESEC leverages MySQL Enterprise Edition from Oracle to process millions of transactions in real-time, ensuring that stakeholders across the organization have access to accurate and timely insights. Whether it's a design consultancy firm managing a few hundred licenses or a multinational corporation tracking thousands of users working across the globe, ESEC scales to meet the complexity of diverse o [...]

Union Mobile Financial Technology Co., Ltd. (UMF) Chooses MySQL Enterprise Edition for its Mobile Financial Systems (from The Oracle MySQL Blog)

UMF’s choice of MySQL Enterprise Edition has proven to be a critical component in delivering secure, stable, and affordable mobile financial systems to their clients. From protecting sensitive customer data to ensuring system uptime and supporting cost-conscious businesses, MySQL continues to help UMF lead the way in the mobile financial technology space. For UMF, MySQL is not just a database solut [...]

Parkson Credit Levels Up Security with MySQL Enterprise Edition (from The Oracle MySQL Blog)

Parkson Credit’s selection of MySQL Enterprise Edition has allowed the company to significantly enhance its security, availability, and operational efficiency. The comprehensive suite of features, from enterprise encryption to high availability and disaster recovery, ensured that Parkson Credit not only met regulatory requirements but also provided a seamless and secure experience for their custome [...]

Monday, 26. May 2025

HeatWave REST Service - The Ultimate REST Builder for Databases, Now Available Everywhere (from The Oracle MySQL Blog)

We’re thrilled to announce the general availability of the HeatWave REST Service – a powerful, fully managed cloud service that lets you instantly create RESTful API endpoints directly from your HeatWave MySQL databases, without writing a single line of backend code. [...]

Comparing DevOps tooling approaches: Terraform, Ansible, Chef, Puppet, and DIY scripting (from Severalnines Blog)

pIn today’s DevOps landscape, Infrastructure as Code (IaC) tools like Terraform, Ansible, Chef, and Puppet have become essential for automating infrastructure provisioning and configuration, streamlining deployment processes, improving consistency, and enhancing scalability, especially in heterogenous, large-scale environments. While DIY (homegrown) scripts provide flexibility necessary to serve sp [...]

Reviewing the Internals of MariaDB’s Vector Index 2 (from Zhao Song's Blog)

[...]

Sunday, 25. May 2025

The Round Table Expands: A Queen’s Reflections on Unity and Momentum (from MariaDB Foundation Blog)

pLegend says Queen Guinevere once presided over a court where knights debated honor and destiny. In my version, the knights bring code diffs, sponsorship agreements, and opinions on open source governance. … /p pContinue reading \"The Round Table Expands: A Queen’s Reflections on Unity and Momentum\"/p pThe post The Round Table Expands: A Queen’s Reflections on Unity and Momentum appeared fir [...]

Saturday, 24. May 2025

ACID at Scale: Why MySQL Needs a Distributed SQL Alternative (from PingCAP Blog)

pMySQL’s simplicity and robust single-instance ACID guarantees have made it a developer favorite for years. The familiar ease of use, quick installation, and a rich ecosystem contribute to its widespread adoption. InnoDB, its default storage engine, ensures Atomicity, Consistency, Isolation, and Durability (ACID), which are vital for data integrity and defined as follows: However, this [̷ [...]

Friday, 23. May 2025

Ironclad Security for Your MySQL Databases (from The Oracle MySQL Blog)

Your MySQL databases are the backbone of your operations, housing invaluable and often sensitive information. But with increasing cyber threats and evolving regulatory landscapes, securing them can feel like an overwhelming challenge. Can you build a security program that's not just compliant, but truly resilient against the ever-present dangers of data breaches and cyberattacks? The good news is, [...]

What Oracle Missed, We Fixed: More Performant Query Processing in Percona Server for MySQL (from Percona Database Blog)

♦At Percona, we constantly search for ways to make query processing more performant. Our activities include continuous monitoring of Percona Server for MySQL performance by doing performance regression tests. We also challenge Percona Server for MySQL with newly designed tests and analyze bottlenecks for possible improvements. Among our activities in this area is monitoring what […] [...]

.NET Aspire update includes AI debugging via GitHub Copilot (from InfoWorld)

p.NET Aspire 9.3, the latest version of Microsoft’s cloud-ready stack for building distributed applications, has been released. The current update leverages GitHub Copilot as an AI debugging assistant./p pIntroduced May 19 and billed as a minor release, .NET Aspire 9.3 makes AI-based Copilot available in the Aspire dashboard. Copilot supercharges the dashboard’s OpenTeleme [...]

Scoped Vector Search with the MyVector Plugin for MySQL – Part I (from AskDba)

Semantic Search with SQL Simplicity and Operational Control Introduction Vector search is redefining how we work with unstructured and semantic data. Until recently, integrating it into traditional relational databases like MySQL required external services, extra infrastructure, or awkward workarounds. That changes with the MyVector plugin — a native vector indexing and search extension purpose-bui [...]

Thursday, 22. May 2025

Amazon Aurora Global Database introduces support for up to 10 secondary Regions (from AWS Database Blog)

In this post, we dive deep into Amazon Aurora Global Database's new support for up to 10 secondary Regions and explore use cases it unlocks. An Aurora Global Database consists of one primary Region and up to 10 read-only secondary Regions for low-latency local reads. [...]

MariaDB Community Server 11.4.7 and 10.11.13 releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.7, and 10.11.13 maintenance releases. See the release […] [...]

Amazon Aurora reduces cross-Region Global Database Switchover time to typically under 30 seconds (from AWS What's New)

pAmazon Aurora for MySQL and Amazon Aurora for PostgreSQL now offer faster Global Database cross-Region switchover, reducing recovery time for read/write operations to typically under 30 seconds and enhancing availability for applications operating at a global scale.br br With Global Database, a single Aurora cluster can span multiple AWS Regions, providing disaster recovery from Region-wide outage [...]

Managing Resource Isolation: Optimizing Performance Stability in TiDB (from PingCAP Blog)

pIn complex business environments, resource isolation is critical to ensure stability, performance, and efficient resource utilization. TiDB offers robust features for resource control, allowing you to achieve efficient resource isolation across multiple levels: This blog focuses on best practices for flow-based resource isolation, helping you understand how to control and isolate workloads at runt [...]

long_query_time for Optimal Query Monitoring (from Shattered Silicon OSDB Blog)

pProblem In order to facilitate query monitoring in MySQL and MariaDB, you have two options for sourcing the data: performance_schema slow_query_log performance_schema is cheap, but it lacks some of the important information. Specifically, it provides little or no visibility of any queries that run as prepared statements (unless they haven’t been torn down yet – […]/p pThe post lo [...]

OS Platform End of Life (EOL) Announcement for Ubuntu 20.04 LTS (from Percona Community Blog)

pUbuntu 20.04 LTS (Focal Fossa) is scheduled to reach its official end of life on May 31, 2025. In alignment with the upstream vendor’s lifecycle, we are also ending platform support for Ubuntu 20.04 for all our MySQL related product offerings. This date and others are published in advance on our Percona Release Lifecycle Overview page./p pAs part of our support policy, Percona will continue [...]

How to Convince Your DBA to Run Dolt (from DoltHub Blog)

So, you found this cool, new database with all the version control features of Git. It's got a funny name, Dolt. It looks like it fits your… [...]

Wednesday, 21. May 2025

Azure Database for MySQL bindings for Azure Functions (General Availability) (from Azure for MySQL Blog)

pWe’re thrilled to announce the general availability (GA) of Azure Database for MySQL Input and Output bindings for Azure Functions—a powerful way to build event-driven, serverless applications that seamlessly integrate with your MySQL databases./p Key Capabilities pWith this GA release, your applications can use:/p ul liInput bindings that allow your function to retrieve data from a [...]

MySQL Hypergraph Optimizer (from The Oracle MySQL Blog)

Let's have a look at the new MySQL Optimizer: Hypergraph [...]

Amazon RDS now supports easy retrieval of engine lifecycle support dates (from AWS What's New)

pAmazon RDS announces a new capability that helps you view engine lifecycle support dates for your databases. This new feature provides a centralized and convenient place to access engine support dates, offering greater control over your database lifecycle management.br br You can view start and end dates for RDS Standard Support and RDS Extended Support for RDS and Aurora major engine versions thr [...]

MySQL Hypergraph Optimizer (from lefred's blog)

During the last MySQL & HeatWave Summit, Wim Coekaerts announced that a new optimizer is available and is already enabled in MySQL HeatWave. Let’s have a quick look at it and how to use it. The first step is to verify that Hypergraph is available: The statement won’t return any error if the Hypergraph Optimizer […] [...]

Evaluate MariaDB’s Powerful Database Proxy: Introducing MaxScale Trial (from MariaDB Corporation Blog)

[...]

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

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

Using dlt to get data from Db2 to PostgreSQL (from dbi Blog)

pFor a recent project at one of our customers we needed to get data from a Db2 database into PostgreSQL. The first solution we thought of was the foreign data wrapper for Db2. This is usually easy to setup and configure and all you need are the client libraries (for Db2 in this case). But […]/p pL’article Using dlt to get data from Db2 to PostgreSQL est apparu en premier sur dbi Blog./p [...]

Introducing Tungsten Dashboard v8: A New Era for MySQL Cluster Management (from Continuent Blog)

Discover Tungsten Dashboard v8, the next-gen UI for MySQL & MariaDB clusters. Featuring a new communication protocol, improved security, and user-friendly operation triggers. Learn how to upgrade and streamline your database infrastructure today!Tags: tungsten dashboardtungsten clusterdemogui [...]

Tuesday, 20. May 2025

Never-Down MySQL: A Blueprint for Uninterrupted Business Operations (from The Oracle MySQL Blog)

Uninterrupted IT is vital. MySQL Reference Architectures for High Availability offers blueprints to ensure your MySQL databases are always available, minimizing costly downtime. From Bronze to Platinum, these tiers provide tailored solutions for on-premises, cloud, or hybrid environments. [...]

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.5.29 and 10.6.22 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports community MariaDB minor versions 10.5.29 and 10.6.22. 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 automatic [...]

Announcing key maintenance experience enhancements for Azure Database for MySQL (from Azure for MySQL Blog)

pWe are pleased to share a set of major enhancements to the maintenance experience for Azure Database for MySQL, designed to give customers more control, visibility, and predictability over how maintenance is orchestrated across their environments. These improvements are now available through the Azure Portal and are the direct result of feedback from users managing MySQL at scale./p Virtual Canary [...]

InnoDB Cluster: Set Up Router and Validate Failover (from Percona Database Blog)

♦Setting up an InnoDB Cluster requires three key components: Group Replication, MySQL Shell, and MySQL Router. In the previous post, we covered the process of building a 3-node InnoDB Cluster. In this post, we shift our focus to configuring MySQL Router and validating failover functionality. Environment overview We are using three InnoDB Cluster nodes along […] [...]

Ten Years On, We Set Off Again: My Journey with TiDB (from PingCAP Blog)

pFrom day one, PingCAP has been a company built by and for builders. In this special 10-year reflection, our very first employee and SVP of Product & Engineering shares the raw, unfiltered journey behind TiDB—from the first lines of Go code to running mission-critical workloads across the globe. We hope this inspires the next generation […]/p pThe post Ten Years On, We Set Off Again: My J [...]

Vault Works with Dolt (from DoltHub Blog)

At DoltHub, we're building Dolt, the world's first fully version controlled SQL database. It's a MySQL compatible SQL database that supports… [...]

Monday, 19. May 2025

Must-read MySQL blog posts from ACEs (from Oracle ACE Program)

In April, Oracle ACEs from all around the world created more than 600 blog posts and articles, sharing tips and tricks, insights, and knowledge on various platforms. We have highlighted some of them for you to read and enjoy, focusing on MySQL. [...]

An Introduction to Dictionary Operations in Data Masking Component (from Percona Database Blog)

♦In this blog post, we will describe typical usage scenarios for dictionary operations in the Data Masking Component, which is available in Percona Server for MySQL as an open source alternative to Oracle’s enterprise version. In particular, we will consider the following functions. gen_dictionary() – a function that returns a random term from a dictionary. gen_blocklist() – […] [...]

MEM is dead, long live Oracle Database Management (from lefred's blog)

MySQL Enterprise Monitor, aka MEM, retired in January 2025, after almost 20 years of exemplary service! What’s next? Of course, plenty of alternatives exist, open source, proprietary, and on the cloud. For MySQL customers, we provide two alternatives: This post focuses on the latter, as there is no apparent reason to deploy an Oracle Database […] [...]

Releasing MariaDB for Universities: Lecture Materials for a New Generation (from MariaDB Foundation Blog)

pWe have long had a vision: that learning relational databases with MariaDB should be accessible to everyone — students, educators, and self-learners alike. Today, MariaDB Foundation and MariaDB plc together take a major step forward in realizing that vision. … /p pContinue reading \"Releasing MariaDB for Universities: Lecture Materials for a New Generation\"/p pThe post Releasing Maria [...]

MEM is dead, long live Oracle Database Management (from The Oracle MySQL Blog)

In this post, we will see how to use Oracle DB Management to monitor an on-premise MySQL instance. [...]

Build 2025: Announcing Key Improvements in Azure Database for MySQL (from Azure for MySQL Blog)

pToday, we're announcing a series of updates to Azure Database for MySQL designed to improve failover performance, operational visibility, and version support for developers and DBAs. These enhancements help you build more resilient applications, manage maintenance with greater control, and stay current with the latest MySQL releases. /p p /p pEnhanced failover performance with High-Avail [...]

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

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

Sunday, 18. May 2025

is SQL a high level API (from The consistent voice)

pSQL stands for Structured Query Language, a declarative, standardized programming language (Turing complete, by the way) specifically designed to manage and manipulate data stored in relational databases./ppAPIs, or Application Programming Interfaces, are sets of rules, protocols, and tools that enable software systems to exchange data and functionality without exposing the internal workings of ea [...]

RocksDB 10.2 benchmarks: large & small servers with a cached workload (from Small Datum)

pI previously shared benchmark results for RocksDB using the larger server that I have. In this post I share more results from two other large servers and one small server. This is arbitrary but I mean >= 20 cores for large, 10 to 19 cores for medium and less than 10 cores for small./pptl;dr/pulliThere are several big improvements/liliThere might be small regression in fillseq performance, I wil [...]

Friday, 16. May 2025

Building and testing MySQL 8.0.42 / 8.4.5 / 9.3.0 on macOS (from Laurynas Biveinis' blog)

p Previously: 8.0.41 / 8.4.4 / 9.2.0 /p p MySQL 8.0.42 / 8.4.5 / 9.3.0 are out, and as usual, I have built and tested the new releases on macOS, due to its popularity as the server OS, of course. /p Build p The 8.0 series don't build with the current XCode clang because of bug 118026 (Build failed with apple clang 17). That's inconvenient, but Homebrew-packaged LLVM clang versions 14 to 18 buil [...]

New Silver Sponsor: Senticore Technologies Chooses MariaDB for High-Performance Engineering and AI Applications (from MariaDB Foundation Blog)

pWe welcome Senticore Technologies as a Silver Sponsor. Senticore, a leader in engineering and manufacturing applications, focuses on cutting-edge AI solutions, particularly for the aerospace and defense sectors, and powers critical systems worldwide. … /p pContinue reading \"New Silver Sponsor: Senticore Technologies Chooses MariaDB for High-Performance Engineering and AI Applications\"/p pT [...]

ClusterControl adds Kubernetes Database Operator management in v2.3.2 (from Severalnines Blog)

pClusterControl v2.3.2 is here and is taking its first sincere step into the cloud native world with its Kubernetes operator management panelTech Preview and support for PostgreSQL’s cloudnative-pg and MySQL’s MOCO operators. It also comes with new major versions for PG and MySQL, as well as a new metrics watchlist mode for improved situational awareness! […]/p pThe post ClusterControl adds K [...]

Thursday, 15. May 2025

Let Your Database Recommend the Indexes: Smarter Tuning in TiDB (from PingCAP Blog)

pIndex tuning has always been one of the most effective ways to speed up database queries—but it’s also one of the most time-consuming and complex. When we first introduced the TiDB Index Advisor as a command-line tool in a previous blog, our goal was to simplify index selection for real-world workloads. Now, with TiDB 8.5, […]/p pThe post Let Your Database Recommend the Indexes: Smarter Tuni [...]

New in Percona Everest 1.6.0: Easily Deploy PMM with a Single Helm Command (from Percona Database Blog)

♦Monitoring your databases is critical, especially in Kubernetes environments where visibility and automation are key. That’s why, in Percona Everest 1.6.0, we introduced a highly requested feature: the ability to automatically deploy Percona Monitoring and Management (PMM) as part of the Everest Helm chart using just one flag. This simplifies the process for teams who […] [...]

Learn MySQL Performance (from Hack MySQL)

pEvery year new cohorts of programmers, DBAs, managers, and more learn MySQL. After MySQL and HeatWave Summit 2025 a few weeks ago, I realized what job needs to be done for these people and how I could help them make progress: revamping this website to focus on “the path”./p [...]

A quick look at MySQL EE, free for developers (from lefred's blog)

MySQL provides the MySQL Community Edition, the Open-Source version. In addition, there is the Enterprise Edition for our Commercial customers and MySQL HeatWave, our managed database service (DBaaS) on the cloud (OCI, AWS, etc.). But do you know developers can freely use MySQL Enterprise for non-commercial use? The full range of MySQL Enterprise Edition features […] [...]

Our pledge to help improve the accessibility of open source software at scale (from The GitHub Blog)

pGitHub takes the Global Accessibility Awareness Day (GAAD) pledge./p pThe post Our pledge to help improve the accessibility of open source software at scale appeared first on The GitHub Blog./p [...]

Creating a Highly Available HeatWave Database System Using Oracle Cloud Shell (from The Oracle MySQL Blog)

In this blog, we will walk through the process of creating a HeatWave HA Database system using Oracle Cloud Shell. [...]

Wednesday, 14. May 2025

MySQL Query Optimization: Best Practices to Improve Performance (from Releem Blog)

Nothing kills a great app faster than slow database queries. Teams often optimize everything else – frontend code, server architecture, caching layers – only to discover their database queries are the actual bottleneck. Your users won't notice all the cle [...]

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization (from Releem Blog)

Text search in MySQL doesn't have to be inefficient. MySQL's full-text indexing transforms how your applications find and handle large volumes of unstructured text. Instead of the glacial pace of LIKE queries scanning every character, you get a search sys [...]

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide (from Releem Blog)

An index helps MySQL find the data it needs without scanning an entire table. For a handful of rows, this might not seem important. But in a table with hundreds of thousands or millions of rows, the difference between having a lookup structure and lacking [...]

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

pStarting today, Amazon Aurora MySQL - Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.40 through Aurora MySQL v3.09. In addition to several security enhancements and bug fixes, MySQL 8.0.40 contains enhancements that improve database availability when handling large number of tables and reduce InnoDB issues related to redo logging, and index handling.br br Aurora MySQL 3 [...]

Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB now offer Reserved Instances for R8g and M8g instances (from AWS What's New)

pCustomers running Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB databases can now purchase Reserved Instances for Graviton4-based R8g and M8g instances. These instances provide larger sizes up to 48xlarge with an 8:1 ratio of memory to vCPU and the latest DDR5 memory. Graviton4-based instances deliver up to 40% performance improvement and 29% better price-performance compared to equival [...]

Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB now offer Reserved Instances for R7i and M7i instances (from AWS What's New)

pCustomers running Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB databases can now purchase Reserved Instances for R7i and M7i instances. These instances are powered by custom 4th Generation Intel Xeon Scalable processors and provide larger sizes up to 48xlarge with an 8:1 ratio of memory to vCPU and the latest DDR5 memory.br br Reserved Instances offer significant savings over On-Demand [...]

Tuesday, 13. May 2025

Scaling Amazon RDS for MySQL performance for Careem’s digital platform on AWS (from AWS Database Blog)

Careem powers rides, deliveries, and payments across the Middle East, North Africa and South Asia. As Careem grew, so did its data infrastructure challenges. Their monolithic 270 TB Amazon RDS for MySQL database consisting of one writer and five read replicas— experienced performance issues due to increased storage utilization, slow queries, high replica lag, and increased Amazon RDS cost. In this [...]

Amazon CloudWatch Database Insights applied in real scenarios (from AWS Database Blog)

In this post, we show how you can use Amazon CloudWatch Database Insights for troubleshooting your Amazon RDS and Amazon Aurora resources. CloudWatch Database Insights serves as a database observability solution offering a tailored experience for DevOps engineers, application developers, and database administrators. This tool is designed to accelerate database troubleshooting processes and address [...]

A Brief History of MySQL Replication (from Marcelo Altmann)

pWhile preparing slides for a presentation, I found myself researching about the history of MySQL Replication and decided to write some key moments of this wonderful functionality of MySQL./p♦pReplication has been one of MySQL’s most powerful and relied-upon features since the early days — long before it had things like foreign keys or even subqueries. It’s one of the foundational pillars that made [...]

Oracle Dev Days 2025 – French Edition (from MySQL expert Diary)

pJoin the Oracle Dev Days – French Edition, from May 20 to 22, 2025!br This must-attend event (in French) offers a rich program exploring the latest advancements in AI, databases, cloud, and Java./p pJoin me on May 21 at 2:00 PM for the day dedicated to “Database & AI.” I’ll be presenting “Building an AI-Powered Search Engine with HeatWave GenAI.” I’ll show you how to go beyond the limits of t [...]

Secure Architectures for MariaDB and Galera in AWS: VPCs and Security Groups (from Vettabase)

Running any production database deployment in the cloud requires careful consideration of both performance and security. In this article, I’ll share a battle-tested approach for deploying a MariaDB Galera cluster with replicas, a ProxySQL layer in front of them, and monitoring for all these technologies via PMM. The focus will be on building solid security boundaries. Security Requirements We [...]

MariaDB Vector is available on OPEA (from MariaDB Foundation Blog)

pI think you’ve come to expect that every collaboration with Intel leads to meaningful, well-executed projects that bring great value to the community. This time, we’re spreading our wings towards empowering enterprises to deploy AI solutions, and we’re excited to show how MariaDB Vector fits into the Open Platform for Enterprise AI (OPEA). … /p pContinue reading \"MariaDB V [...]

MySQL Cookbook: Solutions for Database Developers and Administrators (from ODBMS.org)

Authors:   Sveta Smirnova  (Author), Alkin Tezuysal  (Author)  For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That’s where this cookbook comes in. When... [...]

MySQL: FLUSH HOSTS (from Die wunderbare Welt von Isotopp)

pSometimes, MySQL throws an error like this:/p blockquote pHost ‘…’ is blocked because of many connection errors/p pUnblock with ‘mysqladmin flush-hosts’/p/blockquote pThis typically means that MySQL has blocked a host after too many connection errors. The usual fix is to run:/p precodemysqladmin flush-hosts /code/prepor/p precodemysql> FLUSH HOSTS; /* deprecated s [...]

SHOW statements in Doltgres (from DoltHub Blog)

Last month we announced the Beta release of Doltgres, the world's first and only version-controlled postgres-compatible SQL database. We're… [...]

Monday, 12. May 2025

Request for comments: Skeema v2 roadmap (from Skeema Blog)

pDevelopment of Skeema v2 is now underway, with a release target of later this year. We’re excited to share an overview of the potential changes, and would love to hear your feedback./p [...]

MySQL Query Optimization with Releem (from Vlad Mihalcea's Blog)

pIntroduction In this article, I’m going to show you how to optimize the queries executed by a Spring application running on MySQL using Releem. For a short introduction about Releem, check out this previous article, in which I explained how to set up Releem to collect metrics from your MySQL database. Spring Petclinic application The application under test is going to be the well-known Sprin [...]

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

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

Update on MariaDB Community Server Q2 2025 maintenance releases (from MariaDB Corporation Blog)

[...]

InnoDB Cluster Setup: Building a 3-Node High Availability Architecture (from Percona Database Blog)

♦Modern applications need to be highly available and easy to scale. A three-node MySQL InnoDB Cluster—built on MySQL Group Replication and connected through MySQL Router—provides a reliable way to support critical workloads. To set up this architecture, you start by deploying three MySQL server instances. In this example, the nodes are assigned the following hostname-to-IP […] [...]

What GenAI Means for Your Application Data Architecture (from PingCAP Blog)

pGenerative AI (GenAI) is finding its way into almost every kind of software — and for good reason. It offers a chance to create more valuable, intelligent experiences for users, while strengthening the moat around your product’s data and capabilities. But adding GenAI features, whether to an existing system or a new project, often means […]/p pThe post What GenAI Means for Your Application D [...]

Improve Primary Selection on Failover in MySQL Group Replication (from The Oracle MySQL Blog)

The latest update to MySQL Enterprise Edition, version 9.3, introduces a significant enhancement focused on improving primary selection on failover. This update includes an improvement to Group Replication primary failover, providing users with a better selection method of a new primary based on the member's most current data. This enhancement results in a seamless experience during failover, maint [...]

MySQL at 30: Still important but no longer king (from InfoWorld)

pThis month MySQL turns 30. Once the bedrock of web development, MySQL remains immensely popular. But as MySQL enters its fourth decade, it ironically has sown the seeds of its own decline, especially relative to Postgres. Oracle, the steward over MySQL since 2010, may proclaim MySQL is “the world’s favorite database,” but that has been objectively false for a long time, as s [...]

Optimize Database Performance with HeatWave's Enhanced Read Operations (from The Oracle MySQL Blog)

Managing read traffic efficiently is crucial for maintaining a high-performing database. With Read Endpoints playing a critical role in directing read traffic, having a flexible, configurable and scalable Read Endpoint solution is a must for ensuring high availability and performance in the DB system, or simplifying application configurations. [...]

Without Good Data, AI is Useless (from The Oracle MySQL Blog)

When training AI models, it is important to use "good" data. Without good data, the model si pretty much useless. In this post, I share what I learned when trying to train an AI model for use in Episode 89 of MySQL Shorts. [...]

Sunday, 11. May 2025

Anomaly Detection with HeatWave AutoML (from The Oracle MySQL Blog)

Anomaly detection is an effective technique for finding abnormalities in data. HeatWave AutoML offers an automated machine learning pipeline for anomaly detection based on patented algorithm that can detect various types of anomalies and provides better accuracy compared to other anomaly detection techniques. It also supports semi-supervised learning, Principal Component Analysis (PCA) and internal [...]

Saturday, 10. May 2025

Floating-Point Columns and AUTO_INCREMENT Changes in MySQL 8 (from Mydbops Blog)

Learn why MySQL 8.4 has deprecated AUTO_INCREMENT with FLOAT, DOUBLE, and DECIMAL columns. Understand the risks, migration steps, and best practices for maintaining data integrity. [...]

Reviewing the Internals of MariaDB’s Vector Index (from Zhao Song's Blog)

1. How It’s implemented [...]

Friday, 09. May 2025

Choosing The Correct Shape When Migrating MySQL From On-Premise to HeatWave in OCI (from The Oracle MySQL Blog)

This post provides information on how to choose the appropriate shape when migrating your MySQL workload from on-premise to HeatWave (MySQL) in Oracle Cloud Infrastructure. The post also provides some additional information for a successful migration. [...]

MySQL 9.3! Thank you for your contributions! (from The Oracle MySQL Blog)

Before the MySQL & HeatWave Summit, we released MySQL 9.3, the latest Innovation Release. The event was terrific, and I had the chance to meet some of the MySQL contributors. As usual, we released bug fixes for 8.0 and 8.4 LTS, but I focus on the newest release in this post. [...]

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

Before the MySQL & HeatWave Summit, we released MySQL 9.3, the latest Innovation Release. The event was terrific, and I had the chance to meet some of the MySQL contributors. As usual, we released bug fixes for 8.0 and 8.4 LTS, but I focus on the newest release in this post.We included patches and code […] [...]

Impressive Submissions at the MariaDB AI RAG Hackathon (from MariaDB Foundation Blog)

pOn Monday we had our final submission day for the MariaDB AI RAG Hackathon. We got several high quality replies in both tracks: integration and innovation. … /p pContinue reading \"Impressive Submissions at the MariaDB AI RAG Hackathon\"/p pThe post Impressive Submissions at the MariaDB AI RAG Hackathon appeared first on MariaDB.org./p [...]

Improving Semi-join Performance in MySQL (from The Oracle MySQL Blog)

This blog post describes the latest performance improvement in semi-join / anti-join queries. [...]

Password Management in MySQL 8: Switching Between Authentication Plugins (from Mydbops Blog)

Explore MySQL 8.4 authentication with caching_sha2_password, covering caching, fast and full authentication to boost security and performance. [...]

Generating Golang Source Files at Build-Time with go:generate (from DoltHub Blog)

If you want to start a shouting match over Thanksgiving dinner, try asking your drunk uncle if generating source code from templates is a… [...]

Thursday, 08. May 2025

Handling duplicate rows in MariaDB and MySQL (from Vettabase)

Most tables have a concept of “duplicate rows”, where duplicates should never be allowed. Typical examples are: But should happen when the application tries to insert a duplicate? This depends from case to case. The possible effects are the following: Let’s see how to handle each of these cases in SQL, in a simple way, without re-inventing the wheel. You will save yourself some us [...]

Deploying External Read Replica in MySQL InnoDB Cluster (from Percona Database Blog)

♦Innodb Cluster or ClusterSet topologies already have secondary instances that can act as a failover for primary or also offload read requests. However, with MySQL 8.4, we now have the feasibility of adding a separate async replica to the cluster for serving various special/ad-hoc queries or some reporting purposes. This will also help offload read traffic away […] [...]

Enhance Data Protection in HeatWave (from The Oracle MySQL Blog)

This blog describes two new properties of a HeatWave MySQL database system (DB system) on OCI: database and access mode. These DB system properties can be used to update the DB system read-write setting and restrict access only to administrator accounts. [...]

Making it Easy to Load and Query CSV Files with HeatWave Lakehouse (from The Oracle MySQL Blog)

In this blog we will see how HeatWave Lakehouse automates the detection of dialects when loading CSV (Comma Separated Value) files from object storage. [...]

AI Features Available in HeatWave Always Free Tier (from The Oracle MySQL Blog)

HeatWave offers a variety of AI features - and many of these features are available in the Always Freed tier. In this post we discuss some of the performance differences when training an AI model and doing predictive analysis. [...]

Wednesday, 07. May 2025

Amazon’s AI-agents for MariaDB Contributions (from MariaDB Foundation Blog)

pWe at MariaDB Foundation are thrilled to see Amazon at the forefront of applying artificial intelligence to open source contributions — with MariaDB as their pilot.  … /p pContinue reading \"Amazon’s AI-agents for MariaDB Contributions\"/p pThe post Amazon’s AI-agents for MariaDB Contributions appeared first on MariaDB.org./p [...]

MySQL Routing Guidelines: A Practical Guide to Management and Configuration (from The Oracle MySQL Blog)

Learn how to configure and manage MySQL Routing Guidelines using MySQL Shell's AdminAPI, with step-by-step examples for InnoDB Cluster, ClusterSet, and ReplicaSet - Enabling smarter and more dynamic query routing. [...]

Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw (from MariaDB Foundation Blog)

pRight after the recent MariaDB Meetup in London, I had the pleasure of sitting down with Steve Shaw – founder and CEO of HammerDB, former Principal Engineer at Intel, and board member of the MariaDB Foundation. … /p pContinue reading \"Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw\"/p pThe post Open Source Performance, Benchmarks and MariaDB: A Convers [...]

RocksDB 10.2 benchmarks: large server (from Small Datum)

p This post has benchmark results for RocksDB 10.x, 9.x, 8.11, 7.10 and 6.29 on a large server./pp\tl;dr/pp/pulliThere are several big improvements/liliThere are no new regressions/liliFor the block cache hyperclock does much better than LRU on CPU-bound tests/li/ulp/pSoftwarepI used RocksDB versions 6.0.2, 6.29.5, 7.10.2, 8.11.4, 9.0.1, 9.1.2, 9.2.2, 9.3.2, 9.4.1, 9.5.2, 9.6.2, 9.7.4, 9.8.4, [...]

Tuesday, 06. May 2025

RocksDB on a big server: LRU vs hyperclock, v2 (from Small Datum)

pThis post shows that RocksDB has gotten much faster over time for the read-heavy benchmarks that I use. I recently shared results from a large server to show the speedup from the hyperclock block cache implementation for different concurrency levels with RocksDB 9.6. Here I share results from the same server and different (old and new) RocksDB releases./ppResults are amazing on a large (48 cores) [...]

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.6, 10.11.12, 10.6.22, and 10.5.29 maintenance releases. See […] [...]

From User to Contributor: Fixing and Enhancing MySQL Tools (from Marcelo Altmann)

pWorking with open source tools is always a rewarding experience. You can dig into the source code to understand how things work or troubleshoot issues as they come up. And when you do, there’s a great opportunity to give back — whether by fixing a bug or adding a new feature./p♦pAt Readyset, which is fully written in Rust, we make heavy use of the MySQL Rust driver. Since we benefit from these ope [...]

Tungsten Cluster v8: Expanding Enterprise-Grade MySQL High Availability with Powerful New Features and Tools (from Continuent Blog)

New release includes nearly 30 new features, enhanced API support and advanced performance optimizations.Tags: tungsten clusterReleasefeaturesbug fixesimprovements [...]

Ignite 2024: New innovations in Azure Database for MySQL (from Azure for MySQL Blog)

pThe Azure Database for MySQL team is thrilled to unveil a suite of new features and innovations that are designed to empower both developers and enterprise organizations with the ability to get more out of their data with robust performance and efficiency, advanced security, and greater scalability for their applications./p pWhether you're looking to leverage cutting-edge innovations, accelerate t [...]

Monday, 05. May 2025

April 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! 🚀 [...]

AWS DMS implementation guide: Building resilient database migrations through testing, monitoring, and SOPs (from AWS Database Blog)

In this post, we present proactive measures for optimizing AWS DMS implementations from the initial setup phase. By using strategic planning and architectural foresight, organizations can enhance their replication system’s reliability, improve performance, and avoid common pitfalls. [...]

Database Protection Guide: Best Practices for Ensuring Database Security (from Devart MySQL Tool Blog)

pDatabase security is essential for protecting sensitive information. Get key tips on best practices, managing threats, and ensuring privacy. /p pThe post Database Protection Guide: Best Practices for Ensuring Database Security appeared first on Devart Blog./p [...]

How MCP could add value to MongoDB databases (from InfoWorld)

pMongoDB has added Anthropic’s Model Context Protocol (MCP) to all its databases, including Atlas, to help developers accelerate software development and manage database administrative tasks./p pMCP, which has seen a rise in popularity since its release in November last year, is an open protocol that allows AI agents inside applications to access external tools and data to [...]

Database Normalization in SQL: Key Steps, Benefits, and Examples (from Devart MySQL Tool Blog)

pLearn the importance of database normalization, its benefits, and key techniques. Understand SQL normalization and improve your database design./p pThe post Database Normalization in SQL: Key Steps, Benefits, and Examples appeared first on Devart Blog./p [...]

Saturday, 03. May 2025

Uncle bob vs SQL (from The consistent voice)

pI came across this umpteenth release from Uncle Bob Martin today: x.com/unclebobmartin/status/1917558113177108537/ppIn his codex of clean architecture, UIs and DBs are plugins that should be interchangeable. Yet now he’s ranting about SQL and RDBMS and talking about using low-level functions to process data. This makes no sense in terms of his architectural ideology, because what is SQL apart from [...]

Friday, 02. May 2025

Scaling 3 Million Tables: How TiDB Powers Atlassian Forge’s SaaS Platform (from PingCAP Blog)

pAtlassian, a global leader in project management and team collaboration, offers widely adopted products like Jira, Confluence, and Forge. As Atlassian’s SaaS platforms scale, so too do their data infrastructure needs, such as scaling millions of database tables efficiently and cost-effectively. That’s where TiDB comes in. This post explores how TiDB empowers Atlassian’s Forge platform [̷ [...]

Amazon Aurora now supports R8g database instances in the AWS GovCloud (US-West) Region (from AWS What's New)

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

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 Europe (Ireland) Region and R8g database instances in AWS GovCloud (US-West) Region. For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page.br br Graviton4-based instances provide up to a 40% performance improveme [...]

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

pAWS Graviton3-based R7g database instances are now generally available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in Middle East (Bahrain) and AWS GovCloud (US-West) Regions. Graviton3 instances provide up to 30% performance improvement over Graviton2 instances for Aurora depending on database engine, version, and workload.br br Graviton3 processors [...]

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

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton2-based T4g database instances in Asia Pacific (Malaysia) region. T4g database instances provide a baseline level of CPU performance, with the ability to burst CPU usage at any time for as long as required. For complete information on pricing and regional availability, please refer to the Am [...]

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

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports M7i database (DB) instances in Asia Pacific (Jakarta), South America (Sao Paulo), AWS GovCloud (US-East) and AWS GovCloud (US-West) regions. R7i DB instances are now supported in South America (Sao Paulo), AWS GovCloud (US-East) and AWS GovCloud (US-West) Regions. M7i and R7i are the latest Intel based [...]

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

pAmazon Relational Database Service (RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton3-based M7g database instances in Asia Pacific (Jakarta), Middle East (UAE), South America (Sao Paulo), Asia Pacific (Osaka), Asia Pacific (Melbourne), Israel (Tel Aviv), Europe (Zurich) and AWS GovCloud (US-East) Regions. R7g is now supported in Middle East (Bahrain), South America (Sao Paulo) and [...]

MongoDB Operators Explained: Features, Limitations, and Open Source Alternatives (from Percona Database Blog)

♦If you’ve tried running MongoDB on Kubernetes, you’ve likely run into some unique challenges. Stateful workloads like replica sets and sharded clusters can be messy in containers, and things that should be easy, like backups, scaling, failovers, and upgrades, suddenly take more time and attention than they should. That’s exactly what good MongoDB Operators are […] [...]

RAVATAR becomes Silver Sponsor of MariaDB Foundation (from MariaDB Foundation Blog)

pWe’re excited to welcome RAVATAR as our Silver Sponsor! A bold innovator in artificial intelligence, RAVATAR is defining the emerging Face of AI through high-quality interactive digital humans and real-time AI avatars. … /p pContinue reading \"RAVATAR becomes Silver Sponsor of MariaDB Foundation\"/p pThe post RAVATAR becomes Silver Sponsor of MariaDB Foundation appeared first on MariaD [...]

The impact of innodb_doublewrite_pages in MySQL 8.0.41 (from Small Datum)

pAfter reading a blog post from JFG on changes to innodb_doublewrite_pages and bug 111353, I wanted to understand the impact from that on the Insert Benchmark using a large server.brbrI test the impact from:/pp/pulliusing a larger (non-default) value for innodb_doublewrite_pages/lilidisabling the doublewrite buffer/li/ulp/pptl;dr/pp/pulliUsing a larger value for innodb_doublewrite_pages improves QP [...]

MySQL and HeatWave Summit 2025: 2 Days of Innovation, Learning, and Collaboration (from The Oracle MySQL Blog)

On April 22-23rd, 2025, the Oracle Conference Center in Redwood Shores, California, buzzed with excitement as the MySQL and HeatWave Summit 2025 kicked off. The MySQL and HeatWave Summit is the largest gathering of MySQL users, developers and product experts in the world. The summit brought together developers, DBAs, experts, and users for this two day event packed with learning, networking, and ce [...]

ProxySQL Works with Dolt (from DoltHub Blog)

ProxySQL is an open source high performance, high availability, database-protocol-aware proxy for MySQL and PostgreSQL servers. As a reverse… [...]

Thursday, 01. May 2025

Redis bets big on an open source return (from InfoWorld)

pToday, Redis makes a dramatic return to its open source roots, offering Redis 8 under the AGPLv3 license. The shift follows a similar move by Elastic in August 2024 and completes the company’s somewhat circuitous licensing path. In both cases, I suspect that neither company ever really wanted to leave open source. The irony is that the very thing that most threatened to hurt [...]

The Queen, the contributions and the wardrobe (from MariaDB Foundation Blog)

pI suppose not all of my readers have a first hand (or even second hand) experience of the girls-night-in. So let me shed some light on this sacred ritual of tea, sympathy and soul-baring conversation that zigzags from the ridiculous to the profound and back again in under 30 seconds. … /p pContinue reading \"The Queen, the contributions and the wardrobe\"/p pThe post The Queen, the contribut [...]

Open source has a ‘massive role to play’ in AI orchestration platforms, says Microsoft CEO (from InfoWorld)

pMicrosoft CEO Satya Nadella says he is “very optimistic” that technology has sufficiently advanced to support more complex, next-gen capabilities such as multi-agent AI orchestration, and open source is a key component./p pChips are getting better, cycle times are faster, and system software, model architecture, and kernels are constantly being optimized, resulting in wha [...]

Understanding Homebrew, the Version-Controlled Package Manager (from DoltHub Blog)

We make Dolt, the world's first version controlled SQL database. If you're making a database, you need to be fast, so performance has always… [...]

Wednesday, 30. April 2025

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages) (from J-F Gagné's MySQL Blog)

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post. [...]

NATS goes Nuts – Quite Unique Open Source controversy (from Peter Zaitsev)

pIt’s no longer surprising when a corporate-owned open source project abruptly shifts to a more restrictive ‘source-available’ license, such as SSPL or BSL. However, foundation-backed open source software has traditionally offered greater stability in this regard. While commercial sponsors may change and funding levels can fluctuate, the underlying software license has generally remaine [...]

On MySQL Training Programs. Q&A with Scott Stroz (from ODBMS.org)

Q1. What is your role at Oracle? I am a Developer advocate for MySQL. Some of my duties include producing content through blog posts and short form videos. I also get to speak at... [...]

Tuesday, 29. April 2025

Announcing Generation 7i instance support for Amazon RDS on AWS Outposts (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) on AWS Outposts now supports generation 7i instances for Amazon RDS for MySQL on Outposts and amazon RDS for PostgreSQL on Outposts. Amazon RDS on Outposts allows you to deploy fully managed database instances in your on-premises environments. AWS Outposts is a fully managed service that extends AWS infrastructure, AWS services, APIs, and tools to vi [...]

MariaDB Vector and RAG at foss-north 2025 (from MariaDB Foundation Blog)

pI had the delight of being accepted to talk about “Making AI transparent with RAG on your own data” at foss-north 2025 in Gothenburg, Sweden. … /p pContinue reading \"MariaDB Vector and RAG at foss-north 2025\"/p pThe post MariaDB Vector and RAG at foss-north 2025 appeared first on MariaDB.org./p [...]

Selling Software: Conferences (from DoltHub Blog)

Conferences are sales events we reluctantly spend money on even though our attendance has not generated a single sale. Why do we keep going… [...]

Announcing Vitess 22 (from PlanetScale Blog)

Vitess 22 is now generally available [...]

Announcing Vitess 22 (from Vitess)

Announcing Vitess 22 # The Vitess maintainers are happy to announce the release of version 22.0.0, along with version 2.15.0 of the Vitess Kubernetes Operator. This release is the first to benefit from a 6-month-long development cycle, after our recent change to the release cadence. Version 22.0.0 comes with significant enhancements to query serving and cluster management. These changes have allowe [...]

Monday, 28. April 2025

(Yet another) blog on monitoring Multi-threaded replication in MySQL (from Marc Reilly)

pOne of the most commonly misunderstood configurations in MySQL is related to parallel replication threads in MySQL, and more importantly how do I monitor my replica to ensure its configured effectively. /pBackground on parallel replicationpTraditionally, MySQL replication was single threaded where changes applied on a writer database are fetched by a replica and applied serially on a replica [...]

MySQL & Heatwave Summit Recap (from Marcelo Altmann)

pLast week, I had the chance to attend the MySQL & HeatWave Summit, where I also got to talk about Readyset. It was a jam-packed two days, full of back-to-back sessions focused on MySQL HeatWave and Enterprise features. Alongside all the technical deep dives, there were also great Community talks showcasing some of the largest MySQL deployments out there. Tons of learning, lots of interesting c [...]

Readyset Private on Azure VM: A Hands-On Guide to Caching Performance (MySQL Edition) (from Readyset Blog)

p"What if scaling reads didn’t require replicas, rewrites, or added infrastructure complexity? This post walks you through running Readyset—a caching layer purpose-built for real-time SQL acceleration—on Azure VM with MySQL. In just a few commands, you'll launch a MySQL database, deploy/p [...]

Best Free and Paid MySQL Monitoring Tools [2025] (from ScaleGrid Blog)

pMonitoring MySQL databases is essential for maintaining performance, detecting issues early, and ensuring efficient resource use by tracking critical metrics. With MySQL supporting various applications, it’s important to have the right tools in place to monitor database health and performance. Proper monitoring helps finding slow queries, resource limitations, and security issues before they affec [...]

New Silver Sponsor: Kinsta Chooses MariaDB for Scalable, Open WordPress Hosting (from MariaDB Foundation Blog)

pWe’re pleased to welcome Kinsta as a Silver Sponsor of the MariaDB Foundation. Kinsta, one of the leading managed WordPress hosting providers, powers thousands of websites globally with a platform built for speed, scalability, and security — … /p pContinue reading \"New Silver Sponsor: Kinsta Chooses MariaDB for Scalable, Open WordPress Hosting\"/p pThe post New Silver Sponsor: K [...]

Connecting to MySQL HeatWave in OCI (from The Oracle MySQL Blog)

Connecting to MySQL HeatWave in OCI [...]

Sunday, 27. April 2025

How Many B+Tree Searches Are Hidden Inside a MySQL Insert? (from Zhao Song's Blog)

[...]

Friday, 25. April 2025

Benchmarking MySQL Server With mysqlslap: Estimating Capacity, Not Absolute Limits (from Another Boring Tech Blog)

pWhen I’m working with MySQL, I care not just about whether a single query is slow, but how much total load the server can handle before performance starts to drop. Tools like mysqlslap help by generating synthetic workloads to simulate multiple clients and measure the server’s Queries Per Second (QPS). In this post, I’ll walk through.../p pO post Benchmarking MySQL Server With mysqlslap: Estimatin [...]

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

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

Anatomy Of A SQL Engine (from DoltHub Blog)

May marks five years since Dolt adopted go-mysql-server. Today we summarize the current state of GMS by walking through a query's journey… [...]

Thursday, 24. April 2025

Binlog Commit Optimization For Large Transaction (from MariaDB Corporation Blog)

This is a guest post by Libing Song from Alibaba Cloud. This blog post introduces a new feature which speeds […] [...]

Rollback Prepared Transactions Asynchronously During Binlog Crash Recovery (from MariaDB Corporation Blog)

This is a guest post by Libing Song from Alibaba Cloud. If the transaction takes 30 minutes to execute, it […] [...]

Guidelines to Writing a Great REST API (from Continuent Blog)

Learn how the Continuent team designed a secure and effective REST API for Tungsten Clustering, including best practices for using POST, PUT, verbs, idempotent actions, and more in real-world scenarios.Tags: REST APIbest practicessecuritytungsten cluster [...]

TiDB Performance Hotspots: How to Identify and Fix Issues Using Top SQL (from PingCAP Blog)

pHotspots are silent performance killers in distributed databases. They rarely trigger alerts — instead, they quietly erode throughput, increase tail latency, and leave your engineering team guessing. If you’re running TiDB at scale and suddenly one TiKV node is running hot while others sit idle, you’re likely facing a hotspot. In this post, we’ll walk […]/p pThe post TiDB Performance Hotspot [...]

Show MySQL Process List - Mastering MySQL’s SHOW PROCESSLIST Command (from Releem Blog)

The `SHOW PROCESSLIST` command in MySQL is a crucial tool for database administrators to monitor active threads and take control of ongoing operations. [...]

Using Terraform to deploy Azure Database for MySQL with Private Endpoint (from Azure for MySQL Blog)

pThis blog post describes how to use Terraform to deploy an Azure Database for MySQL flexible server with a private endpoint in a virtual network./p Prerequisites pBefore beginning this process, be sure that you have/p ul liAn Azure subscription. If you don’t have one already, create an Azure free account. Currently, with an Azure free account, you can try Azure Database for MySQL free for 12 [...]

A Unique Foreign Key issue in MySQL 8.4 (from Kedar MySQL Blog)

pRecently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At…/p The post A Unique Foreign Key issue in MySQL 8.4 first appeared on Change Is Inevitable. [...]

Wednesday, 23. April 2025

Amazon Redshift adds history mode support to 8 third-party SaaS applications (from AWS What's New)

pAmazon Redshift now supports history mode for zero-ETL integrations with eight third-party applications including Salesforce, ServiceNow, and SAP. This addition complements existing history mode support for Amazon Aurora PostgreSQL-compatible and MySQL-compatible, DynamoDB, and RDS for MySQL databases. The expansion enables you to track historical data changes without Extract, Transform, and Load [...]

TiDB Spring Launch 2025: Breaking Barriers to AI and SaaS Scale with One Unified Platform (from PingCAP Blog)

pTeams are building more ambitious systems—AI, SaaS, global scale—and running into familiar challenges along the way: Complexity, performance, and reliability. TiDB Spring Launch 2025 is a major step forward in solving those problems. It introduces new product capabilities designed to make hard things—like scaling SaaS platforms or powering AI features—feel a lot more manageable, all […]/p pT [...]

Simplify Database Management with the MariaDB Enterprise Kubernetes Operator (from MariaDB Corporation Blog)

[...]

Coding Agents Suck Too (from DoltHub Blog)

If you've been following our recent blog posts you know that I've been quite critical of LLMs, AI agents, and the companies that tout them… [...]

Is MySQL Ready for Running in Containers? (from Zhao Song's Blog)

MySQL 9.3.0 was released last week (April 15, 2025), and one particular update caught my attention: [...]

Tuesday, 22. April 2025

Reduce RDS Costs (from Shattered Silicon OSDB Blog)

pIntroduction Reducing RDS costs is often the first thing that company owners and CFOs ask engineers to do, because it is frequently the most expensive part of the corporate I.T. infrastructure. We covered the topic of reducing RDS costs previously, but it proved so popular that we decided to do a deeper dive into the […]/p pThe post Reduce RDS Costs appeared first on Shattered Silicon./p [...]

How to Resolve Disk Space Issues in PMM: Case Study (from Kedar MySQL Blog)

pRecently, I encountered a Percona Monitoring and Management (PMM) server that was rapidly approaching complete disk exhaustion. This post outlines the steps taken to identify the issue and reclaim disk…/p The post How to Resolve Disk Space Issues in PMM: Case Study first appeared on Change Is Inevitable. [...]

Advanced MySQL Query Monitoring: Best Practices for Real-Time Analysis and Metrics (from Releem Blog)

When a database starts acting up, the first question is always "which queries are causing the problem?" Setting up proper query monitoring is fundamental to maintaining a MySQL database. Database troubleshooting without proper query visibility is basicall [...]

MySQL Optimization Center (from Releem Blog)

Everything you need to monitor, tune, and optimize MySQL databases for top performance. [...]

Doltgres Data Imports (from DoltHub Blog)

Doltgres has been improving by leaps and bounds lately, and in case you missed it... we just hit our beta milestone last week! 🎉 Dolt is… [...]

Monday, 21. April 2025

Migrate SQL Server user databases from Amazon EC2 to Amazon RDS Custom using Amazon EBS snapshots (from AWS Database Blog)

In this post, we present a practical approach to one of the most significant challenges organizations face when adopting Amazon RDS Custom for SQL Server: migrating large datasets from SQL Server on Amazon EC2 to Amazon RDS Custom for SQL Server efficiently and cost-effectively. By using SQL Server’s native detach and attach method combined with EBS snapshots, you can migrate your databases without [...]

Speeding Up Percona XtraDB Cluster State Transfers with Kubernetes Volume Snapshots (from Percona Database Blog)

♦When using the Percona Operator for MySQL based on Percona XtraDB Cluster (PXC), it’s common to encounter scenarios where cluster nodes request a full State Snapshot Transfer (SST) when rejoining the cluster. One typical scenario where a State Snapshot Transfer (SST) is required is when a node has been offline long enough that the GCache […] [...]

Saturday, 19. April 2025

Battle of the Mallocators: part 2 (from Small Datum)

pThis post addresses some of the feedback I received from my previous post on the impact of the malloc library when using RocksDB and MyRocks. Here I test:/pp/pulliMALLOC_ARENA_MAX with glibc malloc/liullisee here for more background on MALLOC_ARENA_MAX. By default glibc can use too many arenas for some workloads (8 X number_of_CPU_cores) so I tested it with 1, 8, 48 and 96 arenas./li/ullicompiling [...]

Friday, 18. April 2025

Manage External MySQL DB systems in OCI (from The Oracle MySQL Blog)

This is the second part of our series on managing on-premises (External) MySQL DB systems in Oracle Cloud Infrastructure (OCI). In this blog, we cover the registration process, fleet monitoring, key metrics, alarms, and events to help you optimize performance and gain operational insights. Ensure that the prerequisites from the first part are completed and that you have the necessary permissions to [...]

Prerequisites for Managing On-premises MySQL DB systems in OCI (from The Oracle MySQL Blog)

This blog will guide you through setting up and managing On-premises (External) MySQL DB systems in OCI, ensuring optimal performance and operational insights. In this part, we will cover the prerequisite steps before registering and managing External MySQL DB systems. [...]

Run PostgreSQL on Kubernetes: A Practical Guide with Benchmarks and Best Practices (from Percona Database Blog)

♦Remember when running databases in Kubernetes felt like a gamble? When unpredictable storage performance and complex state management made stability a constant battle? Thankfully, those days are largely behind us. With better tools, smarter operators, and field-tested strategies, you can now confidently deploy PostgreSQL on Kubernetes, especially when you need scale, automation, and platform consi [...]

Thursday, 17. April 2025

Migrating from Azure Database for MariaDB to Azure Database for MySQL using MyDumper/MyLoader (from Azure for MySQL Blog)

pMariaDB, the open-source relational database management system created by MySQL’s original developers, is designed to be highly compatible with MySQL. It supports the same SQL syntax, data types, and connectors as MySQL, allowing for a seamless transition of applications or databases that previously used MySQL./p pWith the pending retirement of Azure Database for MariaDB, we have received numerous [...]

How to Set Up InnoDB Cluster Using MySQL Shell (from Mydbops Blog)

Set up MySQL InnoDB Cluster with MySQL Shell for high availability and scalability. Follow our step-by-step guide on install, config, and best practices. [...]

What’s New in MySQL 8.4 LTS: Key Enhancements Explained (from Percona Database Blog)

♦MySQL has been evolving rapidly, and with the recent release of MySQL 8.4, there’s a lot to unpack. While MySQL 8.4 is officially dubbed a Long-Term Support (LTS) release, many features introduced between 8.0 and 8.4 have now matured into defaults or become deprecated/removed. This blog provides a comprehensive, side-by-side comparison of the key differences […] [...]

The Queen’s Gambit: Through the Looking Glass into the Query Optimizer (from MariaDB Foundation Blog)

pThere’s a question I like to ask people sometimes—especially at turning points:br “What’s your word?”br One word to capture how you feel, where you are, or what’s driving you right now. … /p pContinue reading \"The Queen’s Gambit: Through the Looking Glass into the Query Optimizer\"/p pThe post The Queen’s Gambit: Through the Looking Glass into the Query O [...]

Switching Memory Allocator in MariaDB (from DBPEDIABLOGS)

What is a Memory Allocator? A memory allocator is a low-level component in a program (or the OS) that manages the heap memory. It also provides dynamic memory when the program requests it during the runtime. malloc malloc (short for memory allocate) is a standard C library function defined in <stdlib.h>. It doesn’t allocate memory […] [...]

Why Doltgres over Dolt? (from DoltHub Blog)

In case you missed it, we shipped a Beta version of Doltgres yesterday. We worked on Doltgres for a year and a half and it finally hit our… [...]

Wednesday, 16. April 2025

On MySQL Ecosystem.  Q&A with Vinicius Grippa (from ODBMS.org)

Q1. You have 18 years of experience in mission-critical database design. What are the main lessons you have learned in all these years? Test, test, and test one more time! When I started at... [...]

Set up Cross-Region Oracle Heatwave MySQL Disaster Recovery Copy in OCI (from The Oracle MySQL Blog)

This blog outlines how to set up Oracle Heatwave MySQL disaster recovery copy for the production database using the OCI Console level full backup, copying the backup to another region, building the disaster recovery database from the primary backup and setting up the in-bound replication channel from primary to disaster recovery database. [...]

Doltgres Beta Launch (from DoltHub Blog)

Dolt is the world's first and only version-controlled SQL database. It's a database that you can branch and merge, fork and clone, push and… [...]

Going Full-Time as an Open Source Developer (from Optimized by Otto)

♦pAfter careful consideration, I’ve decided to embark on a new chapter in my professional journey. I’ve left my position at AWS to dedicate at least the next six months to developing open source software and strengthening digital ecosystems. My focus will be on contributing to Linux distributions (primarily Debian) and other critical infrastructure components that our modern society dep [...]

Tuesday, 15. April 2025

HOMELAB (from Another MySQL DBA)

pJust for fun.../ppNumerous options exist for testing MySQL and general database instances./ppThis is just an example of how you can use Proxmox to have a simple fast setup for repeatable testing and access./ppThis example is a nice and cheap option to have a home lab for MySQL and anything else you want./ppThe homelab virtualization I picked was Proxmox and Openmediavaul&n [...]

Tempesta Technologies Becomes Silver Sponsor of MariaDB Foundation (from MariaDB Foundation Blog)

pWe are delighted to welcome Tempesta Technologies as a Silver Sponsor of the MariaDB Foundation!br Tempesta Technologies is the developer of Tempesta FW, an open-source hybrid of a web accelerator and a multi-layer firewall. … /p pContinue reading \"Tempesta Technologies Becomes Silver Sponsor of MariaDB Foundation\"/p pThe post Tempesta Technologies Becomes Silver Sponsor of MariaDB Foundat [...]

Percona Server for MySQL Data Masking Enhanced with Dictionary Term Cache (from Percona Database Blog)

♦In Percona Server for MySQL 8.0.41 / 8.4.4, we significantly re-designed the Data Masking Component. In particular, we made the following changes: Changed the user on behalf of whom we execute internal queries for dictionary operations. Introduced an in-memory dictionary term cache that allows significant speed-up of dictionary operations. Introduced masking_dictionaries_flush() User Defined Funct [...]

From MySQL to Oracle ACE Pro: A Milestone in My Database Journey (from AskDba)

I’m incredibly honored to share some exciting news—I’ve been recognized as an Oracle ACE Pro by Oracle! This recognition is deeply meaningful to me, not just as a personal milestone but as a reflection of the ongoing work I’ve poured into the database community for over three decades. It’s also a reminder of how powerful […] [...]

When indexes make SQL queries slower (from Vettabase)

During our SQL optimisation training courses, I always stress the need of understanding how databases run SQL queries internally. Which is easier and more intuitive than you’d think, anyway. But if you overlook this aspect, there is always a risk of sticking to simple solutions, and consider them universal even if they aren’t. A typical example is… add an index on the columns used [...]

sysbench linked to latest libmysql (from MySQL 9.3) (from lefred's blog)

If you are testing MySQL with sysbench, here is a RPM version for Fedora 31 and OL 8 & 9 linked with the last libmysql (libmysqlclient.so.24) from MySQL 9.3. This version of sysbench is from the latest master branch in GitHub. I used version 1.1, but this is to make a differentiation with the code […] [...]

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

pIn this latest post, the final part of my series on building an AI-powered search engine with HeatWave GenAI, I dive into enhancing AI-powered search by embedding full article content into HeatWave./p pBy cleaning HTML, chunking content, generating embeddings, and running semantic similarity searches directly within HeatWave, we unlock highly relevant, context-rich search results.br If you're buil [...]

Should Doltgres have a CLI? (from DoltHub Blog)

It's Doltgres Beta week here at DoltHub. In eager anticipation of tomorrow's Doltgres Beta launch, I have an appetizer to get you interested… [...]

Monday, 14. April 2025

MySQL Brazil Meetup 2025 – Aniversário de 30 Anos! (from Another Boring Tech Blog)

pParece mentira, mas o MySQL está completando 30 anos em 2025. Três décadas de código aberto, performance, confiabilidade (sim, a gente sabe dos bugs também 😅) e uma comunidade incrível que cresce a cada ano. E, claro, isso merece ser comemorado! 📍 Onde e quando? Vamos nos reunir em São Paulo, no dia 4 de.../p pO post MySQL Brazil Meetup 2025 – Aniversário de 30 Anos! apareceu primeiro em Ano [...]

Challenges and strategies of migrating a high-throughput relational database (from AWS Database Blog)

In this post, we explore key strategies and AWS tools to help you successfully migrate your high-throughput relational database while minimizing business disruption. [...]

Vertical Scaling of MySQL vs. Horizontal Scaling with Readyset: A Cost and Performance Analysis in the Cloud (from Readyset Blog)

pScaling relational databases in the cloud often creates a tension between cost and performance. As workloads grow—especially read-heavy ones powering analytics, dashboards, or reports—latency increases and infrastructure bills spike. The default response is usually vertical scaling: increase instance size, add more CPU and memory. While effective/p [...]

Vettabase Becomes Silver Sponsor of MariaDB Foundation (from MariaDB Foundation Blog)

pWe are excited to announce that Vettabase has joined the MariaDB Foundation as a Silver Sponsor!br Vettabase is a trusted provider of database consulting services, with a strong focus on open-source technologies. … /p pContinue reading \"Vettabase Becomes Silver Sponsor of MariaDB Foundation\"/p pThe post Vettabase Becomes Silver Sponsor of MariaDB Foundation appeared first on MariaDB.org./p [...]