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, 24. April 2025

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)

pRDS is often the most expensive part of companies' AWS infrastructures. Here we will explore ways to reduce RDS costs by over 22x./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. [...]

Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization (from Releem Blog)

In this article, we’re going to explore MySQL index creation. We’re going to cover the fundamentals of index syntax with examples, take a look at MySQL workbench’s index capabilities, and discuss some advanced indexing techniques. [...]

MySQL Performance Parameters that Releem improves - MySQL Query Optimization (from Releem Blog)

Complete list of MySQL Performance Parameters that Releem optimizes [...]

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

MariaDB Catalogs preview containers available (from MariaDB Foundation Blog)

pGet an early look at MariaDB Catalogs—our multi-tenant database feature. No compiling needed! Just pull the image from quay.io and set MARIADB_CATALOGS to get started. Try it out and help shape the future of MariaDB!/p pThe post MariaDB Catalogs preview containers available appeared first on MariaDB.org./p [...]

Codership has been selected to participate in the Japan IT Week 2025 Business Mission, organised by the @EU Business Hub! (from Galera Blog)

We’re thrilled to announce that Codership has been selected to participate 2025 EU Business Mission, organized by the EU Business Hub.  Codership will join Japan IT Week  tradeshow 23-25.4 at Tokyo Big Sight. Please come and visit us! Our booth number is 39-6 and stand 28. #EUBusinessHub #EUForeignPolicy [...]

Deep dive into Clang sanitizer testing with MariaDB (from MariaDB Foundation Blog)

pMariaDB uses Clang’s memory, address, and undefined behavior sanitizers are used for identify coding flaws during the continuous development and testing process. MariaDB would like to share via an online event on how easy perform the same sanitizer checking. … /p pContinue reading \"Deep dive into Clang sanitizer testing with MariaDB\"/p pThe post Deep dive into Clang sanitizer testing [...]

An Introduction to Adaptive Encoding (from DoltHub Blog)

Arguably the most important design decision in a database is one that most users probably never think about: how your data is actually… [...]

Sunday, 13. April 2025

MySQL Data Archiving basics – considerations, mistakes, best practices (from Kedar MySQL Blog)

pThis blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…/p The post MySQL Data Archiving basics – considerations, mistakes, best practices first appeared on Change Is Inevitable. [...]

Saturday, 12. April 2025

Scaling TiDB for Large-Scale Applications: Webinar Highlights (from Mydbops Blog)

TiDB scaling for enterprise applications: 70%+ storage savings, millisecond latency at millions QPS, and reduced infrastructure costs - case studies from MySQL & Aurora migrations. [...]

Battle of the Mallocators (from Small Datum)

pIf you use RocksDB and want to avoid OOM then use jemalloc or tcmalloc and avoid glibc malloc. That was true in 2015 and remains true in 2025 (see here). The problem is that RocksDB can be an allocator stress test because it does an allocation (calls malloc) when a block is read from storage and then does a deallocation (calls free) on eviction. These allocations have very different lifetimes as s [...]

Friday, 11. April 2025

Introducing sub-issues: Enhancing issue management on GitHub (from The GitHub Blog)

pExplore the iterative development journey of GitHub's sub-issues feature. Learn how we leveraged sub-issues to build and refine sub-issues, breaking down larger tasks into smaller, manageable ones./p pThe post Introducing sub-issues: Enhancing issue management on GitHub appeared first on The GitHub Blog./p [...]

Fix PHP MySQL Slow Queries - Find and Optimize Problem Queries Fast (from Releem Blog)

Struggling with slow PHP MySQL performance? Learn how to easily detect and fix slow and frequent queries to speed up your application with less manual work. [...]

Azure Database for MySQL - March 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 April 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. Below [...]

End-Of-Life of HeatWave MySQL 8.0 version (from The Oracle MySQL Blog)

MySQL 8.0 will reach End-Of-Life (EOL) in April 2026. This means that HeatWave MySQL will no longer provide support or updates for MySQL 8.0 after this date. Customers should upgrade to newer supported version of HeatWave MySQL 8.4 LTS much ahead of the April 2026 deadline. This announcement is to provide customers with sufficient time to migrate their DB systems from 8.0 to the latest LTS release [...]

How to use EXPLAIN to fix slow queries in MySQL (from Releem Blog)

With EXPLAIN, you can figure out exactly why a query is underperforming. Maybe it’s looking at too many rows, ignoring indexes, or struggling with joins. This understanding is key for developers and database administrators who are aiming to optimize perfo [...]

Automating Day 2 operations: Scaling, upgrades and maintenance (from Severalnines Blog)

pThe first launch of your database is not the end; it is the beginning of Day-2 operations. Day-2 operations include critical, ongoing tasks such as rolling upgrades, patching, capacity scaling, and continuous performance tuning. These tasks are essential to ensure high availability, security, and performance of your production environments. Manual execution of Day-2 operations by […]/p pThe [...]

Getting started with Open WebUI (from dbi Blog)

pEverybody is talking about AI, RAG and language models today. A lot of people are using ChatGPT or other tools to get answers to their questions, generate text or images. While this sometimes is really helpful (depending on how you use it) you still need to be skeptical about the information you get out of […]/p pL’article Getting started with Open WebUI est apparu en premier sur dbi Blog./p [...]

DuckDB Source Dive - #1 Exploring the DatabaseManager (from Zhao Song's Blog)

As the “SQLite for OLAP,” DuckDB has been gaining significant popularity. At Hopsworks, we’ve also had many interesting discussions around its design and capabilities. Diving into the source code of such a star project is both exciting and insightful. This post marks the beginning of my DuckDB Source Dive series, where I will break down and explain the internals of DuckDB from a source code perspec [...]

Thursday, 10. April 2025

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

pMarch was a busy month in the world of MariaDB!br Let’s explore the progress through the lens of the Six Goals for 2025, introduced in January.  … /p pContinue reading \"This month in MariaDB Foundation: Mar 2025\"/p pThe post This month in MariaDB Foundation: Mar 2025 appeared first on MariaDB.org./p [...]

A Deep Dive on Readyset Behind PgBouncer (from Readyset Blog)

pThe title of this post sets the stage for a compelling discussion, and I’ll start with a direct spoiler: Readyset is about performance. It delivers exceptional query acceleration because it behaves as an intelligent cache—without relying on traditional TTLs, background eviction processes, or complex locking mechanisms./p [...]

Galera Cluster vs InnoDB Cluster in MySQL 8.4 – preamble for SHOOTOUT webinar 15th of April (from Galera Blog)

MySQL 8.4 has two good options for High Availability clusters: Galera Cluster (and Percona XtraDB Cluster (PXC)) plus MySQL InnoDB Cluster. Both solutions are now mature enough, so what is the deciding factor? Workload characteristics, application compatibility (Galera is virtually synchronous; InnoDB Cluster offers 2 modes – single primary mode, which is one instance being […] [...]

Tell us how to DROP USER! (from MariaDB Foundation Blog)

pShortly, we will start coding a task, for which we would appreciate your input: How would you like to DROP USER?br Why do we ask?br DROP user (originating in MySQL in 2004) always used to just drop the account from the privilege tables, but left all existing connections active. … /p pContinue reading \"Tell us how to DROP USER!\"/p pThe post Tell us how to DROP USER! appeared first on MariaD [...]

Wednesday, 09. April 2025

MariaDB C Connector 3.4.5, 3.3.15, and 3.1.28 now available (from MariaDB Corporation Blog)

[...]

Percona Server for MySQL: Enhanced Encryption UDFs (from Percona Database Blog)

♦In Percona Server for MySQL 8.0.41 / 8.4.4, we introduced several improvements in Encryption User-Defined Functions. Added support for RSAES-OAEP (OAEP) padding for RSA encrypt / decrypt operations. Added support for RSASSA-PSS (PSS) padding for RSA sign / verify operations. Added new encryption_udf.legacy_padding_scheme component system variable. Normalized character set support for all Encryptio [...]

Google adds natural language query capabilities to AlloyDB (from InfoWorld)

pGoogle is enhancing AlloyDB, its fully managed database-as-a-service (DBaaS), to help developers build applications underpinned by generative AI./p pAnnounced at Google’s annual Cloud Next conference, the updates could give the PostreSQL-compatible AlloyDB an edge over PostgreSQL itself or other compatible offerings such as Amazon Aurora./p [ Related: Google Cloud Next [...]

Understanding Maintenance in HeatWave MySQL Service: A Deep Dive (from The Oracle MySQL Blog)

For users of HeatWave Service, the maintenance process can sometimes feel like a black box. What does it entail? How does it differ from version upgrades? When and how are updates applied? With questions like these swirling around, it’s time to unpack the mechanics of HeatWave maintenance and shed light on its purpose, scope, and flexibility. Whether you’re managing a production database or plannin [...]

Tuesday, 08. April 2025

Wrapping up the MariaDB Bucharest Meetup (from MariaDB Foundation Blog)

pThis past Friday was reserved for our very own cozy event in Bucharest, planned by the romanian squad of the MariaDB Foundation. With an audience ranging from students just starting out on their journey up to seniors with experience in multiple database servers and AI, lots of interesting talks took place. … /p pContinue reading \"Wrapping up the MariaDB Bucharest Meetup\"/p pThe post Wrappi [...]

Enhancing Your Database Connection Pooling for Improved Performance (from ProxySQL Blog)

pBusinesses often turn to caching solutions to improve database performance. It speeds up read and write operations by storing frequently accessed data in memory, significantly reducing network latency. However, you can improve performance even more by optimizing how your database manages user connections through connection pooling.  Connection pooling is essential in reducing the overhead [...]/p [...]

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

pIn this part 2 we focused on enhancing search relevance. We introduced reranking techniques using weighted distances of titles and excerpts to refine initial search results. Then we delved into leveraging article summaries for more effective semantic search, utilizing HeatWave's capability to execute JavaScript stored procedures for sanitizing HTML content and generating these summaries. Finally, [...]

Selling Software: SaaS Tools Review (from DoltHub Blog)

Last week, we introduced a new blog series called "Selling Software", named after the Netflix smash hit, Selling Sunset. DoltHub happens to… [...]

Monday, 07. April 2025

Announcement: HeatWave on AWS is now available in AWS US West (Oregon) and Asia Pacific (Seoul) regions (from The Oracle MySQL Blog)

We are excited to announce that HeatWave on AWS is now available in the US West (Oregon) and Asia Pacific (Seoul) AWS regions, in addition to US East (N.Virginia), Europe (London), Europe (Frankfurt), Asia Pacific (Tokyo), and Asia Pacific (Mumbai). [...]

Announcing the Database Frontiers Virtual Conference! (from Vettabase)

Hey database enthusiasts! We’re excited to announce Database Frontiers, a free virtual conference co-organised by Vettabase and BreachDirectory.com, happening on 15th October 2025. Database Frontiers is bringing together brilliant minds from across the database world to explore multiple technologies and platforms – not just one product. Our lineup features top-notch database professionals and [...]

MariaDB’s AI RAG Hackathon is underway (from MariaDB Foundation Blog)

pWe had the pleasure on Friday to take individual calls with everybody who submitted to the ideation phase of the MariaDB AI RAG hackathon.  … /p pContinue reading \"MariaDB’s AI RAG Hackathon is underway\"/p pThe post MariaDB’s AI RAG Hackathon is underway appeared first on MariaDB.org./p [...]

Saturday, 05. April 2025

Always use the right UUID in MariaDB (from MariaDB Foundation Blog)

pThe following post was written by Stefano Petrilli, who contributed UUIDv4 and UUIDv7 implementations to MariaDB. Thank you, Stefano! … /p pContinue reading \"Always use the right UUID in MariaDB\"/p pThe post Always use the right UUID in MariaDB appeared first on MariaDB.org./p [...]

Friday, 04. April 2025

Database Administration Query Repository (from Dave's MySQL Stuff)

p I have started a repository of handy SQL Queries for Database Administration, which I have collected over the years. Finding unused or duplicate indexes or queries without indexes and other information can speed up response times. Knowing statistics like cache hit rates can aid in planning upgrades. /ppI am currently populating this repo as I run across the queries as part of my 'spring [...]

Thursday, 03. April 2025

PostgreSQL Temporary Data Performance Optimization (from MinervaDB Blog)

pAdvanced PostgreSQL Temporary Data Performance Optimization and Diagnostics When addressing PostgreSQL temporary data performance degradation, database administrators should implement a systematic approach focusing on the following critical subsystems: Memory Buffer Architecture & Configuration temp_buffers: This [...]/p pThe post PostgreSQL Temporary Data Performance Optimization appeared fir [...]

Amazon RDS for MariaDB supports Innovation Release 11.8 in Amazon RDS Database Preview Environment (from AWS What's New)

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

First Steps in Contributing to MariaDB (from MariaDB Foundation Blog)

pAt MariaDB Day in February in Brussels, VP Engineering Vicențiu Ciurbaru delivered an inspiring presentation titled “Launch Your Open Source Career: First Steps in Contributing to MariaDB.” … /p pContinue reading \"First Steps in Contributing to MariaDB\"/p pThe post First Steps in Contributing to MariaDB appeared first on MariaDB.org./p [...]

Why contribute? Scratch your own itch! (from MariaDB Foundation Blog)

pScratch you own itch, and help others while at it!br Why do people contribute to Open Source projects?br The question is as old as Open Source and its predecessor Free Software: Why do people contribute? … /p pContinue reading \"Why contribute? Scratch your own itch!\"/p pThe post Why contribute? Scratch your own itch! appeared first on MariaDB.org./p [...]

HeatWave Service: Proactive Backup Monitoring (from The Oracle MySQL Blog)

This blog explores how to monitor HeatWave backups using OCI’s Monitoring and Alarm services and includes details on how to set up alarms that instantly notify the user in case of backup failures, enabling quick action. [...]

Wednesday, 02. April 2025

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

[...]

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

Optimistic and Pessimistic Locking in TiDB (from Mydbops Blog)

Learn how TiDB handles concurrency with optimistic and pessimistic locking. Understand the differences, benefits, and when to use each method for high-performance distributed database management. [...]

Tuesday, 01. April 2025

Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization (from Releem Blog)

In this article, we’re going to explore MySQL index creation. We’re going to cover the fundamentals of index syntax with examples, take a look at MySQL workbench’s index capabilities, and discuss some advanced indexing techniques. [...]

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

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

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

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

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

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

Monday, 31. March 2025

How to Optimize Database Performance With MySQLTuner (from RoseHosting Blog)

pIf you use a MySQL/MariaDB database, you know it can become slow or consume too many resources if not properly ... /p pRead More/p pThe post How to Optimize Database Performance With MySQLTuner appeared first on RoseHosting./p [...]

Write Latency, Solved: TiKV’s Journey to Smoother Performance (from PingCAP Blog)

pWhether you’re processing thousands of concurrent writes per second or scaling out infrastructure to meet a burst in demand, latency spikes can undermine user experience, reliability, and trust. At PingCAP, we obsess over these details. Our mission is to help teams build and scale confidently on distributed SQL. This post highlights how a subtle performance […]/p pThe post Write Latency, Sol [...]

SQL Aggregate Functions: Syntax, Use Cases, and Examples  (from Devart MySQL Tool Blog)

pGood aggregation drives clarity. Bad aggregation drives costs. Explore how SQL aggregate functions work, how they’re used in real-time analytics, and how tools like dbForge Edge help prevent slowdowns before they start./p pThe post SQL Aggregate Functions: Syntax, Use Cases, and Examples  appeared first on Devart Blog./p [...]

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

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

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

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

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

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

Saturday, 29. March 2025

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

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

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

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

Friday, 28. March 2025

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

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

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

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

Thursday, 27. March 2025

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Wednesday, 26. March 2025

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

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

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

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

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

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

Tuesday, 25. March 2025

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

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

PlanetScale vectors is now GA (from PlanetScale Blog)

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

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

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

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

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

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

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

Debian Salsa CI in Google Summer of Code 2025 (from Optimized by Otto)

♦pAre you a student aspiring to participate in the Google Summer of Code 2025? Would you like to improve the continuous integration pipeline used at salsa.debian.org, the Debian GitLab instance, to help improve the quality of tens of thousands of software packages in Debian?/p pThis summer 2025, I and Emmanuel Arias will be participating as mentors in the GSoC program. We are available to mentor st [...]

Monday, 24. March 2025

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

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

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

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

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

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

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

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

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

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

Saturday, 22. March 2025

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

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

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

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

Troubleshooting MariaDB Memory Leaks (from Mydbops Blog)

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

Thursday, 20. March 2025

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

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

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

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

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

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

Automating Machine Learning with MySQL HeatWave Service: A Guide for DBAs & Developers (from MySQL Solutions - On Premises & Cloud)

[...]

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

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

Wednesday, 19. March 2025

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

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

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

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

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

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

Tuesday, 18. March 2025

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

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

What Is MySQL: Definition, Features & Benefits Explained (from Devart MySQL Tool Blog)

pMySQL has stood the test of time—and for good reason. Learn how it handles structured data, supports ACID compliance, and scales from small web apps to cloud-native deployments. This deep dive has everything you need to know./p pThe post What Is MySQL: Definition, Features & Benefits Explained appeared first on Devart Blog./p [...]

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

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

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

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

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

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

The Real Failure Rate of EBS (from PlanetScale Blog)

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

Monday, 17. March 2025

Optimizing SQL Pagination in MySQL (from Readyset Blog)

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

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

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

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

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

Sunday, 16. March 2025

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

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

Saturday, 15. March 2025

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

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

Friday, 14. March 2025

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

pAmazon Relational Database Service (RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton4-based M8g database instances in the Europe (Spain), Europe (Stockholm), and Europe (London) Regions and R8g database instances in Europe (Ireland), Europe (Spain), Europe (Stockholm), Asia Pacific (Mumbai), Asia Pacific (Sydney), Asia Pacific (Tokyo) regions. br br Graviton4-based instances [...]

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

pAWS Graviton4-based R8g database instances are now generally available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in Europe (Ireland), Europe (Spain), Europe (Stockholm), Asia Pacific (Mumbai), Asia Pacific (Sydney), Asia Pacific (Tokyo) regions. R8g instances offer larger instance sizes, up to 48xlarge and features an 8:1 ratio of memory to vCPU, an [...]

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

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

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

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

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

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

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

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

Thursday, 13. March 2025

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

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

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

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

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

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

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

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

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

Explore the architectural differences between Amazon RDS, Aurora, and Aurora Serverless for MySQL databases on AWS. [...]

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

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

TiDB Distributed eXecution Framework DXF (from Mydbops Blog)

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

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

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

IO devices and latency (from PlanetScale Blog)

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

Wednesday, 12. March 2025

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

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

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

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

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

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

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

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

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

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

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

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

Tuesday, 11. March 2025

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

MySQL Meetups & celebration events [...]

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

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

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

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

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

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

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

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

Snowflake and Reserved Words (from DataGeek.blog)

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

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

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

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

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

Announcing PlanetScale Metal (from PlanetScale Blog)

Database goes brrrrrrrrrrr. [...]

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

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

Upgrading Query Insights to Metal (from PlanetScale Blog)

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

Monday, 10. March 2025

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

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

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

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

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

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

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

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

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

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

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

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

Sunday, 09. March 2025

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

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

Saturday, 08. March 2025

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

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

Friday, 07. March 2025

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

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

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

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

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

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

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

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

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

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

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

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

Thursday, 06. March 2025

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

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

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

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

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

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

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

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

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

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

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

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

MariaDB Honeypot (from Shinguz's Blog)

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

Wednesday, 05. March 2025

PostgreSQL Checkpointing and Background Writing Process (from MinervaDB Blog)

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

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

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

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

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

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

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

Tuesday, 04. March 2025

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

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