Planet for the MySQL Community

A New, Consistent Way to Monitor Replication Lag in MariaDB Community Server 11.8 LTS Release ^{(from MariaDB Corporation Blog)}

This blog post describes three new fields to monitor replication lag added in MariaDB Community Server 11.8 LTS and MariaDB […] [...]

Published Wednesday, 18. June 2025 18:41 • 10 hours ago

MariaDB 11.8 LTS: Parallel Dumps, PARSEC authentication, new SQL syntaxes, and more ^{(from Vettabase)}

MariaDB released a new Long Term Support version as Generally Available: 11.8. I always review MariaDB LTS versions once they’re GA, so it’s time to write a new review. Support and timeline MariaDB 11.8 is the latest Long Term Support version (LTS). The first Generally Available release is 11.8.2, released on 4 June 2025. This branch will be supported til June 2028, unless the [...]

Published Wednesday, 18. June 2025 10:46 • 18 hours ago

Building resilient applications: design patterns for handling database outages ^{(from AWS Database Blog)}

Database outages, whether planned or unexpected, pose significant challenges to applications. Planned outages for maintenance can be scheduled but still impact users. Unplanned outages are more disruptive and can happen at critical times. Even the most robust and resilient databases will inevitably experience outages, making application resiliency a critical consideration in modern system design. I [...]

Published Tuesday, 17. June 2025 19:30 • a day ago

Vectorized Query Processing for LLMs on MySQL HeatWave ^{(from MinervaDB Blog)}

Implementing Vectorized Query Processing for LLMs on MySQL HeatWave: A Complete Technical Guide Introduction The integration of Large Language Models (LLMs) with traditional database systems has created unprecedented demands for high-performance vector search capabilities. MySQL [...] [...]

Published Tuesday, 17. June 2025 18:07 • a day ago

Building AI Applications using frameworks with MariaDB Vector Store ^{(from MariaDB Corporation Blog)}

[...]

Published Tuesday, 17. June 2025 17:44 • a day ago

Implement row-level security in Amazon Aurora MySQL and Amazon RDS for MySQL ^{(from AWS Database Blog)}

Row-level security (RLS) is a security mechanism that enhances data protection in scalable applications by controlling access at the individual row level. It enables organizations to implement fine-grained access controls based on user attributes, so users can only view and modify data they’re authorized to access. This post focuses on implementing a cost-effective custom RLS solution using native [...]

Published Monday, 16. June 2025 19:48 • 2 days ago

Amazon RDS for MySQL announces Innovation Release 9.3 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

pAmazon RDS for MySQL now supports community MySQL Innovation Release 9.3 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.3 in the Amazon RDS Database Preview Environment which provides the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases.br br MySQ [...]

Published Monday, 16. June 2025 17:00 • 3 days ago

Meet dbForge AI Assistant: Your Invaluable Sidekick That Reinvents SQL Coding ^{(from Devart MySQL Tool Blog)}

pIf writing SQL code is part of your daily work, you won't be surprised by things like context-aware code completion, as-you-type syntax validation, and debugging. All of them are designed to enhance and speed up your SQL coding. But what if we said that you could completely reinvent your experience with an AI-powered assistant?/p pThe post Meet dbForge AI Assistant: Your Invaluable Sidekick That R [...]

Published Monday, 16. June 2025 13:26 • 3 days ago

Personal opinion : Maxscale license change ^{(from The consistent voice)}

Personal opinion : Maxscale license changepI realize i never made a presentation of one of the most advanced database proxy for MariaDB/MySQL : MariaDB Maxscale apart from this short introduction to the war of the 3 proxys./ppNow is not really the time and i will make sure to write an extensive one in the coming weeks. There is still something to discuss around that today : its licensing./ppSome of [...]

Published Monday, 16. June 2025 11:33 • 3 days ago

The key to Oracle’s AI future ^{(from InfoWorld)}

pOracle’s stock is finally catching up with its talk about cloud, fueled by surging infrastructure and AI demand. In its recent Q4 2025 earnings statement, the 46-year-old database giant surprised Wall Street with an 11% jump in revenue (to $15.9 billion) and bullish forecasts for the year ahead. Oracle’s stock promptly enjoyed its best week since 2001, leaping 24%. It’s rela [...]

Published Monday, 16. June 2025 09:00 • 3 days ago

Readyset: Scale PostgreSQL and MySQL Performance by 100x Without Code Changes ^{(from Readyset Blog)}

pReadyset is a database scalability and query caching platform designed to dramatically accelerate query performance without requiring code changes. Based on nearly a decade of research at MIT on database caching and incremental view maintenance, it is built to work seamlessly with PostgreSQL and MySQL. Readyset allows applications to scale/p [...]

Published Friday, 13. June 2025 14:10 • 6 days ago

Percona Earns Kubernetes Certified Services Provider Status for All Three Major Open Source Databases ^{(from Percona Database Blog)}

♦As a member of the Kubernetes Certified Services Provider program, Percona is now part of a select, “pre-qualified tier of vetted service providers who have deep experience helping enterprises successfully adopt Kubernetes…” Kubernetes (frequently abbreviated as K8s) has come a long way over the past decade. From being used almost exclusively for orchestrating stateless container […] [...]

Published Friday, 13. June 2025 12:47 • 6 days ago

Personal opinion : the future of Galera Cluster ^{(from The consistent voice)}

Personal opinion : the future of Galera ClusterpAs you already know, MariaDB plc acquired Codership Oy, editor of the Galera clustering solution on 2025, June 1st./ppThis acquisition makes a lot of sense given the tight integration of Galera into MariaDB server since MariaDB 10.0 in 2014. Galera Cluster brings distributed synchronous multi-master clustering to MariaDB, which differentiates it from [...]

Published Friday, 13. June 2025 11:14 • 6 days ago

How To Use HAProxy with a Tungsten Connector Farm ^{(from Continuent Blog)}

Learn how to use HAProxy with a Tungsten Connector farm to build a high-availability MySQL proxy layer. Explore deployment architectures, load balancing strategies, and HAProxy configuration examples.Tags: haproxyTungsten ConnectorHigh Availabilitydatabase proxyLoad Balancing [...]

Published Friday, 13. June 2025 08:36 • 6 days ago

Can you do RAG with Full Text Search in MariaDB? ^{(from MariaDB Foundation Blog)}

pWe continue our blog series on learning more about users of MariaDB. Searching LinkedIn for posts about MariaDB this morning we saw an impressive confident post about using MariaDB in a RAG solution named SemantiQ. … /p pContinue reading \"Can you do RAG with Full Text Search in MariaDB?\"/p pThe post Can you do RAG with Full Text Search in MariaDB? appeared first on MariaDB.org./p [...]

Published Friday, 13. June 2025 06:36 • 6 days ago

TiDB Runtime Dashboard: A Detailed Analysis with Use Cases ^{(from PingCAP Blog)}

pIn TiDB’s runtime environment, issues related to memory management, garbage collection (GC) behavior, and lock contention at the Go Runtime level can significantly impact system stability and performance. However, such problems are often difficult to reproduce and analyze directly. As a result, high-quality runtime monitoring metrics are essential for effective troubleshooting and performanc [...]

Published Thursday, 12. June 2025 16:29 • 7 days ago

Supporting INSERT...RETURNING Statements ^{(from DoltHub Blog)}

tl;dr: Dolt now supports statements, similar to MariaDB. See what this means for Dolt’s MySQL compatibility. Dolt is an open-source version… [...]

Published Thursday, 12. June 2025 00:00 • 7 days ago

MariaDB Enterprise Server Q2 2025 Maintenance Releases ^{(from MariaDB Corporation Blog)}

New maintenance releases for MariaDB Enterprise Server 11.4.7-4, 10.6.22-18, and 10.5.29-23 are now available. These releases include new backported features. […] [...]

Published Wednesday, 11. June 2025 21:18 • 7 days ago

Troubleshooting PostgreSQL Page Corruption ^{(from MinervaDB Blog)}

Troubleshooting PostgreSQL Page Corruption: A Technical Guide PostgreSQL page corruption is a critical database issue that can lead to data loss and application downtime. This comprehensive guide covers detection, diagnosis, and recovery strategies for database [...] [...]

Published Wednesday, 11. June 2025 10:23 • 8 days ago

Scarf Joins as Gold Sponsor of the MariaDB Foundation ^{(from MariaDB Foundation Blog)}

pScarf joins the MariaDB Foundation as a Gold Sponsor, bringing powerful analytics to help us understand and grow our open source community. Discover how this partnership supports transparency, adoption, and global collaboration./p pThe post Scarf Joins as Gold Sponsor of the MariaDB Foundation appeared first on MariaDB.org./p [...]

Published Tuesday, 10. June 2025 08:33 • 9 days ago

Claude Code is My New Best Friend ^{(from DoltHub Blog)}

Just one month ago, I wrote an article asking "Are Coding Agents One PageRank Away From Awesome?". Well, little did I know at the time, that… [...]

Published Tuesday, 10. June 2025 00:00 • 9 days ago

Building a multi-zone and multi-region SQL Server Failover Cluster Instance in Azure ^{(from InfoWorld)}

pMuch has been written about SQL Server Always On Availability Groups, but the topic of SQL Server Failover Cluster Instances (FCI) that span both availability zones and regions is far less discussed. However, for organizations that require SQL Server high availability (HA) and disaster recovery (DR) without the added licensing costs of Enterprise Edition, SQL Server FCI rema [...]

Published Monday, 09. June 2025 09:00 • 10 days ago

Why Swiss eCommerce Leader Glarotech Migrated from MySQL to MariaDB – and What’s Next for PepperShop ^{(from MariaDB Foundation Blog)}

pAfter 20 years on MySQL, Glarotech chose MariaDB for PepperShop. Learn what drove the switch and how they run a scalable eCommerce platform today./p pThe post Why Swiss eCommerce Leader Glarotech Migrated from MySQL to MariaDB – and What’s Next for PepperShop appeared first on MariaDB.org./p [...]

Published Monday, 09. June 2025 08:52 • 10 days ago

PostgreSQL JSON/JSONB Operations ^{(from MinervaDB Blog)}

Advanced JSON/JSONB Operations: When PostgreSQL Beats Document Databases PostgreSQL’s JSON and JSONB capabilities have evolved into a powerful alternative to dedicated document databases, offering the best of both relational and document-oriented worlds. Understanding when and [...] [...]

Published Sunday, 08. June 2025 18:40 • 10 days ago

PostgreSQL Cross-Region Replication ^{(from MinervaDB Blog)}

Cross-Region PostgreSQL Replication: Latency and Consistency Trade-offs Cross-region PostgreSQL replication presents a fundamental challenge in distributed database systems: balancing data consistency with acceptable latency. As organizations expand globally, understanding these trade-offs becomes critical for designing [...] [...]

Published Sunday, 08. June 2025 18:17 • 10 days ago

Cybersec : MariaDB, round2 ^{(from The consistent voice)}

Cybersec : MariaDB, round2pWhile being an Open source database management system developped and maintained by a team of immensely skilled developpers, MariaDB (and MySQL) is not immune to mismanagement and/or administrator-induced security risks./ppA not well known feature of MariaDB is init_file, a nice little parameter that allows to have a set of SQL statement executed once at each server startu [...]

Published Sunday, 08. June 2025 17:08 • 10 days ago

MariaDB 11.8 LTS Released ^{(from MariaDB Foundation Blog)}

pNow is a good time to upgrade to the freshest MariaDB Server. MariaDB 11.8 is the yearly long term support release for 2025. It’s the first LTS with support for MariaDB Vector, and it includes a number of other updates based on user requests. … /p pContinue reading \"MariaDB 11.8 LTS Released\"/p pThe post MariaDB 11.8 LTS Released appeared first on MariaDB.org./p [...]

Published Sunday, 08. June 2025 06:55 • 11 days ago

Seven Golden Rules for MongoDB Infrastructure Performance ^{(from MinervaDB Blog)}

The Ultimate Guide to MongoDB Infrastructure Performance: 7 Golden Rules for Enterprise-Scale Database Operations Master MongoDB deployment strategies, performance optimization, and high availability configurations for production environments Building a robust MongoDB infrastructure requires not only [...] [...]

Published Saturday, 07. June 2025 19:01 • 11 days ago

Logging MariaDB User Activity ^{(from MinervaDB Blog)}

Complete Guide to MariaDB User Activity Logging and Transaction Auditing for Performance & Security Introduction: Essential MariaDB Logging for Enterprise Operations Implementing comprehensive MariaDB user activity logging and transaction auditingis crucial for maintaining database security, [...] [...]

Published Saturday, 07. June 2025 18:31 • 11 days ago

MariaDB Galera Cluster Monitoring: ^{(from MinervaDB Blog)}

Implementing MariaDB Galera Cluster Observability: Complete Guide to Monitoring with Grafana and Prometheus for SRE Excellence Introduction: Building a Bulletproof MariaDB SRE Ecosystem In today’s data-driven landscape, MariaDB Galera Cluster observability is crucial for maintaining [...] [...]

Published Saturday, 07. June 2025 06:42 • 12 days ago

AWS MySQL Performance Comparison: RDS vs. Aurora vs. Aurora Serverless v2 ^{(from Mydbops Blog)}

Compare the performance of AWS MySQL services: RDS, Aurora, and Aurora Serverless v2. Explore architecture differences, latency, throughput, scaling, and optimization features to choose the best option for your workload. [...]

Published Saturday, 07. June 2025 04:27 • 12 days ago

Troubleshooting Cassandra Thread Contention Performance ^{(from MinervaDB Blog)}

pThe Complete Guide to Diagnosing and Troubleshooting Cassandra Thread Contention Performance Issues Thread contention in Apache Cassandra can severely impact your database performance, leading to increased latency, reduced throughput, and frustrated users. If you’re experiencing [...]/p pThe post Troubleshooting Cassandra Thread Contention Performance appeared first on The WebScale Database [...]

Published Friday, 06. June 2025 18:41 • 12 days ago

Building More Scalable GenAI Applications for Startups and Developers ^{(from TechCrunch)}

In this TechCrunch Sessions: AI event, Oracle shares a rundown of how MySQL HeatWave empowers you in building AI-based solutions in areas such as personal productivity, automating workflows for compliance, service, or support, and increasing efficiencies in healthcare, among others. By leveraging HeatWave’s built-in vector store, in-database LLMs, in-database machine learning capabilities, an [...]

Published Friday, 06. June 2025 18:30 • 12 days ago

Troubleshooting MariaDB Deadlock and Livelock ^{(from MinervaDB Blog)}

pComplete Guide to MariaDB Deadlock and Livelock Troubleshooting: Advanced Database Performance Optimization Introduction Database deadlocks and livelocks represent critical performance bottlenecks that can severely impact application responsiveness and system throughput. In MariaDB environments, understanding how [...]/p pThe post Troubleshooting MariaDB Deadlock and Livelock appeared first on The [...]

Published Friday, 06. June 2025 11:31 • 13 days ago

Enhancing Security in OCI: Using Network Security Groups with HeatWave MySQL ^{(from The Oracle MySQL Blog)}

Security is a foundational principle for cloud deployments, especially when dealing with mission-critical workloads like those managed by HeatWave MySQL. As applications and environments scale, fine-grained network control becomes critical not just for protecting sensitive data, but also for isolating systems, enforcing boundaries, and minimizing lateral movement within a Virtual Cloud Network (VCN [...]

Published Friday, 06. June 2025 01:41 • 13 days ago

May Product Update ^{(from Readyset Blog)}

♦pHi there, hope you’re enjoying a great start to the summer season! Let’s dive into what’s new at Readyset: /p📝 We're Taking Applications for QueryPilot Private Beta pWe’re now accepting applications for the private beta of QueryPilot, our/p [...]

Published Thursday, 05. June 2025 18:00 • 13 days ago

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.11.13 and 11.4.7 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports new community MariaDB minor versions 10.11.13 and 11.4.7. 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 autom [...]

Published Thursday, 05. June 2025 17:20 • 13 days ago

Scaling Metadata Management: Innovations in TiDB’s Placement Driver ^{(from PingCAP Blog)}

pAs TiDB scales to support larger deployments, its core metadata management hub—the Placement Driver (PD)—must evolve to meet growing demands. This post explores how TiDB addresses PD’s challenges, including scalability bottlenecks, stability risks, and storage limitations. In this post, we’ll cover: Whether you’re optimizing large-scale deployments or curious about TiDB’s architecture, this post h [...]

Published Thursday, 05. June 2025 15:48 • 14 days ago

Introducing Experimental Support for Stored Programs in JS in Percona Server for MySQL ^{(from Percona Database Blog)}

♦TL;DR Percona Server for MySQL now offers experimental support for stored programs in the JS language. This free and open source alternative to Oracle’s Enterprise/Cloud-only feature enables users to write stored programs in a more modern, convenient, and often more familiar language. It is still in active development, and we would very much like your […] [...]

Published Thursday, 05. June 2025 14:31 • 14 days ago

Query Optimisation: Using indexes for WHERE with multiple conditions ^{(from Vettabase)}

You have a beautiful application, but a page is slow. After some investigation, you find out that a query is unexpectedly slow, ruining user experience and causing frustration for you. It is a simple query with a WHERE clause and nothing else. You tried to build an index with all the columns mentioned in the query, but nothing changed. The EXPLAIN command shows that the index is not used, which see [...]

Published Thursday, 05. June 2025 09:01 • 14 days ago

MySQL Meetups and Events with 30 years of MySQL Celebration ^{(from ODBMS.org)}

MySQL Meetups: EMEA: JAPAC: External (3rd party) Events with MySQL, HeatWave & MySQL Celebration: EMEA: JAPAC: LAD: NA: More Upcoming Events with MySQL & HeatWave NA: Registration page [...]

Published Thursday, 05. June 2025 06:26 • 14 days ago

Database Performance Tuning in 2025 ^{(from MinervaDB Blog)}

pDatabase Performance Tuning in 2025: Why Traditional Buffer Metrics Fall Short in Modern Analytics The database performance tuning landscape has undergone a seismic shift, yet many experts remain anchored to traditional metrics that no longer [...]/p pThe post Database Performance Tuning in 2025 appeared first on The WebScale Database Infrastructure Architecture, Engineering and Operations Company [...]

Published Thursday, 05. June 2025 05:50 • 14 days ago

A Potential Optimization for Inserting into MySQL Unique Indexes ^{(from Zhao Song's Blog)}

In my previous blog, I discussed how many B+Tree searches MySQL performs when inserting a record, detailing the process for inserting into both the primary index and unique secondary indexes. [...]

Published Thursday, 05. June 2025 00:00 • 14 days ago

Latest LTS Version of MariaDB Community Server 11.8 is Now Available ^{(from MariaDB Corporation Blog)}

MariaDB Community Server 11.8 is now generally available (GA) for download. This is the latest long-term maintenance (also known as […] [...]

Published Wednesday, 04. June 2025 17:53 • 14 days ago

Troubleshooting HeatWave Replication Channel ^{(from MySQLHK)}

pHeatWave is a MySQL Database Service running on Cloud with powerful in-memory data warehouse service that provides fast and scalable analytics capabilities. One of the key features of HeatWave is its ability to replicate data from MySQL databases, allowing businesses to replicate data from MySQL source. The replicated deployment may help in horizontally scaling to allow multiple MySQL Servers with [...]

Published Wednesday, 04. June 2025 15:55 • 15 days ago | Updated Wednesday, 04. June 2025 15:55 • 15 days ago

Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk ^{(from J-F Gagné's MySQL Blog)}

I recently troubleshoot an interesting MySQL crash, and I think it is worth sharing (with the related bugs). MySQL crashed when the disk was full, you can see the free disk graph below. The Y-axis is in the tens of GiB scale and the X-axis is in the hour scale. Can you guess what happened ? Just to make sure we agree on the meaning of the graph above, let's describe it [...]

Published Wednesday, 04. June 2025 12:08 • 15 days ago | Updated Wednesday, 04. June 2025 12:29 • 15 days ago

Interesting Binary Logging Optimization in MariaDB ^{(from J-F Gagné's MySQL Blog)}

As I wrote in a LinkedIn post, I am working on a blog post related to binary logging of big transactions. I thought I would split this post in two, so here is the first part where I cover the recent binary logging optimization in MariaDB and its unspoken advantage. (And this post is a way for me to see if Planet MySQL is still blocking posts mentioning MariaDB. This censorship / [...]

Published Monday, 26. May 2025 22:50 • 23 days ago | Updated Wednesday, 04. June 2025 12:20 • 15 days ago

Troubleshooting Writes in Galera Cluster ^{(from MinervaDB Blog)}

pTroubleshooting WRITE Performance Bottlenecks in Galera Cluster Operations Understanding Galera Cluster Write Performance Galera Cluster uses synchronous replication, which means every write operation must be committed on all nodes before being acknowledged to the client. [...]/p pThe post Troubleshooting Writes in Galera Cluster appeared first on The WebScale Database Infrastructure Architecture, [...]

Published Wednesday, 04. June 2025 12:11 • 15 days ago

Horizontally Scaling MariaDB ^{(from MinervaDB Blog)}

pUnderstanding MariaDB Horizontal Scaling Horizontal scaling (scale-out) involves distributing database workload across multiple servers rather than upgrading a single server’s hardware. MariaDB offers several approaches to achieve horizontal scalability. Core Infrastructure Requirements 1. Hardware and [...]/p pThe post Horizontally Scaling MariaDB appeared first on The WebScale Database Inf [...]

Published Wednesday, 04. June 2025 11:53 • 15 days ago

Less Work is Faster: Database Caching Done Right ^{(from Readyset Blog)}

pEvery engineer eventually confronts the complexities of scaling applications and systems. At first glance, the solution seems straightforward: add more cores, introduce replicas, or distribute workloads. However, at scale, each decision quickly compounds in complexity, introducing unexpected overhead, rising costs, and increasingly fragile systems./ppThe reality is that effective scaling/p [...]

Published Tuesday, 03. June 2025 22:12 • 15 days ago

PostgreSQL 18 IOPS Optimization ^{(from MinervaDB Blog)}

pPostgreSQL 18 IOPS Optimization: Complete Performance Tuning Guide for High-Throughput Workloads Introduction PostgreSQL 18 introduces significant performance improvements, but achieving optimal IOPS (Input/Output Operations Per Second) requires careful configuration tuning. This comprehensive guide demonstrates how [...]/p pThe post PostgreSQL 18 IOPS Optimization appeared first on The WebScale D [...]

Published Tuesday, 03. June 2025 15:06 • 16 days ago

Youtube Semantic Search is the winner of MariaDB AI RAG Hackathon innovation track ^{(from MariaDB Foundation Blog)}

pLast week we announced the winners of the MariaDB AI RAG hackathon that we organized together with the Helsinki Python meetup group. Now is time to go for a deep dive into the innovation track winner. … /p pContinue reading \"Youtube Semantic Search is the winner of MariaDB AI RAG Hackathon innovation track\"/p pThe post Youtube Semantic Search is the winner of MariaDB AI RAG Hackathon [...]

Published Tuesday, 03. June 2025 07:42 • 16 days ago

What's new in PMM 3.2.0: Five major improvements you need to know ^{(from Percona Community Blog)}

pPMM 3.2.0 brings some long-awaited fixes and new capabilities. You can now install PMM Client on Amazon Linux 2023 with proper RPM packages, get complete MySQL 8.4 replication monitoring, and track MongoDB backups directly in PMM./p pHere’s what’s most important in this release:/p 1. Native Amazon Linux 2023 support - no more workarounds pWhat’s new: If you’ve been running [...]

Published Tuesday, 03. June 2025 00:00 • 16 days ago

Model Context Protocol (MCP) Server for Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pThe Model Context Protocol (MCP) is an open standard designed to facilitate seamless integration between AI applications and various external systems, including tools, data sources, and resources. MCP aims to standardize how AI models, such as large language models (LLMs), interact with external tools and data sources. MCP enables developers to build AI applications that can easily connect to MCP [...]

Published Monday, 02. June 2025 16:00 • 17 days ago

HeatWave MySQL security series: Achieving PCI DSS 4.0 Compliance ^{(from The Oracle MySQL Blog)}

For the Financial services Industry, PCI DSS compliance ensures the secure handling of cardholder data by organizations that process, store, or transmit credit card information. Payment Card Data Security Standard (PCI DSS) is designed to protect card holder information and ensure a secure environment for handling credit card data.While this is primarily used to secure credit card data, adhering to [...]

Published Monday, 02. June 2025 14:53 • 17 days ago

Vettabase is a MariaDB Foundation sponsor! ^{(from Vettabase)}

Vettabase is a MariaDB Foundation partner. We contributed documentation about automating MariaDB deployments and configuration management. [...]

Published Monday, 02. June 2025 09:34 • 17 days ago

Replacing MySQL Enterprise Monitor with Enterprise Manager ^{(from Severalnines Blog)}

pKeeping a close eye on MySQL databases is essential for maintaining top-notch performance, reliability, and security. For many years, MySQL Enterprise Monitor (MEM) was the go-to tool for monitoring, providing basic alerts, performance graphs, and straightforward query analysis. However, since it was phased out in January 2025, organizations have been looking for modern alternatives, with [… [...]

Published Monday, 02. June 2025 07:00 • 17 days ago

MariaDB Join Optimizer ^{(from MinervaDB Blog)}

pMariaDB Join Optimizer: Common Configuration Mistakes and Best Practices When configuring MariaDB’s join optimizer for better query performance, even experienced DBAs can make critical syntax errors that prevent optimizations from working properly. The Problem: Incorrect [...]/p pThe post MariaDB Join Optimizer appeared first on The WebScale Database Infrastructure Architecture, Engineering [...]

Published Monday, 02. June 2025 05:42 • 17 days ago

Dolt turns 10! Kind of. ^{(from DoltHub Blog)}

We're writing Dolt, the world's first and only version-controlled SQL database. And we've been at it for a long time, over six years! We… [...]

Published Monday, 02. June 2025 00:00 • 17 days ago

HeatWave MySQL security series - Transparent Data Encryption ^{(from The Oracle MySQL Blog)}

Transparent Data Encryption (TDE) in Oracle HeatWave MySQL, a fully managed database service within Oracle Cloud Infrastructure (OCI), is a security feature that protects sensitive data at rest by encrypting database files at the storage level without requiring application changes. It provides industrial level data protection from unauthorized access while meeting compliance regulations like GDPR, [...]

Published Friday, 30. May 2025 20:00 • 19 days ago

MariaDB’s acquisition of Codership: Why enterprises should care ^{(from InfoWorld)}

pStruggling database company MariaDB PLC is making further efforts to get back on its feet, good news for enterprises running MariaDB or looking to adopt it. At least, that’s what analysts think after hearing of MariaDB’s announcement that it is acquiring Finnish data replication software provider Codership./p p“The acquisition stresses MariaDB’s evolution into a complete, [...]

Published Friday, 30. May 2025 19:50 • 19 days ago

Teradata partners with Fivetran to assist data centralization in VantageCloud ^{(from InfoWorld)}

pTeradata has partnered with cloud-based data integration platform provider Fivetran to help joint enterprise customers bring their data stored in multiple locations to the former’s data analytics platform, VantageCloud, to centralize data and metadata for analytics and AI use cases./p pCustomers will be able to automatically move their data into VantageCloud using the Ter [...]

Published Friday, 30. May 2025 17:10 • 19 days ago

MariaDB ODBC Connector 3.2.6 and 3.1.22 now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/ODBC 3.2.6 release. Release Notes MariaDB Connector/ODBC 3.2.6 MariaDB […] [...]

Published Friday, 30. May 2025 17:01 • 19 days ago

Parameterized Queries: Complete Guide to SQL Query Parameterization ^{(from Devart MySQL Tool Blog)}

pImprove SQL query safety and performance with parameterized queries. Find out what a parameterized query is and how it protects your database. Click to learn more!/p pThe post Parameterized Queries: Complete Guide to SQL Query Parameterization appeared first on Devart Blog./p [...]

Published Friday, 30. May 2025 11:42 • 20 days ago

Tungsten Operator for Kubernetes: Cloud-Native MySQL Clustering, Simplified ^{(from Continuent Blog)}

Simplify MySQL clustering in Kubernetes with Tungsten Operator for Tungsten Cluster v8. Automate HA deployment, backups, & failover. Cloud-native MySQL is here!Tags: Tungsten Operatortungsten clusterkubernetesautomationHigh Availability [...]

Published Friday, 30. May 2025 09:11 • 20 days ago

Amazon Redshift Indexing for PostgreSQL DBAs ^{(from MinervaDB Blog)}

pAmazon Redshift Indexing for PostgreSQL DBAs: Performance Optimization Guide As a PostgreSQL DBA transitioning to Amazon Redshift, understanding the fundamental differences in indexing approaches is crucial for optimal performance. Unlike PostgreSQL’s traditional B-tree and hash [...]/p pThe post Amazon Redshift Indexing for PostgreSQL DBAs appeared first on The WebScale Database Infrastruct [...]

Published Friday, 30. May 2025 09:08 • 20 days ago

Model Context Protocol – MCP is the winner of the MariaDB AI RAG Hackathon integration track ^{(from MariaDB Foundation Blog)}

pWe recently announced the winners of the MariaDB AI RAG hackathon that we organized together with the Helsinki Python meetup group. Let’s deep dive into the integration track winner. … /p pContinue reading \"Model Context Protocol – MCP is the winner of the MariaDB AI RAG Hackathon integration track\"/p pThe post Model Context Protocol – MCP is the winner of the MariaDB AI RAG Ha [...]

Published Friday, 30. May 2025 07:13 • 20 days ago

How Flipkart Scales Over 1M QPS with Zero Downtime Maintenance ^{(from PingCAP Blog)}

pThis article is based on a technical presentation by the Flipkart engineering team at TiDB User Day India 2025. Flipkart is one of India’s largest e-commerce platforms, serving millions of users across a complex ecosystem. Its operations span the full customer journey, from product discovery to order placement, and finally to delivery. This includes three […]/p pThe post How Flipkart S [...]

Published Friday, 30. May 2025 05:54 • 20 days ago

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

Published Thursday, 29. May 2025 19:45 • 20 days ago

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

Published Thursday, 29. May 2025 17:43 • 20 days ago

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

Published Thursday, 29. May 2025 17:17 • 20 days ago

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

Published Thursday, 29. May 2025 13:17 • 21 days ago

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

Published Thursday, 29. May 2025 09:03 • 21 days ago

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

Published Wednesday, 28. May 2025 07:57 • 22 days ago

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

Published Wednesday, 28. May 2025 07:56 • 22 days ago

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

Published Wednesday, 28. May 2025 07:38 • 22 days ago

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

Published Wednesday, 28. May 2025 07:14 • 22 days ago

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

Published Wednesday, 28. May 2025 05:46 • 22 days ago

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

Published Wednesday, 28. May 2025 00:00 • 22 days ago

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

Published Tuesday, 27. May 2025 19:28 • 22 days ago

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

Published Tuesday, 27. May 2025 17:00 • 23 days ago

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

Published Tuesday, 27. May 2025 15:56 • 23 days ago

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

Published Tuesday, 27. May 2025 11:19 • 23 days ago

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

Published Tuesday, 27. May 2025 02:46 • 23 days ago

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

Published Tuesday, 27. May 2025 02:01 • 23 days ago

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

Published Tuesday, 27. May 2025 01:22 • 23 days ago

HeatWave REST Service - The Ultimate REST Builder for MySQL 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. [...]

Published Monday, 26. May 2025 19:18 • 23 days ago

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

Published Monday, 26. May 2025 10:02 • 24 days ago

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

[...]

Published Monday, 26. May 2025 00:00 • 24 days ago

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

Published Sunday, 25. May 2025 14:47 • 25 days ago

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

Published Saturday, 24. May 2025 20:20 • 25 days ago

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

Published Friday, 23. May 2025 16:22 • 27 days ago

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

Published Friday, 23. May 2025 13:21 • 27 days ago

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

Published Friday, 23. May 2025 09:00 • 27 days ago

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

Published Friday, 23. May 2025 01:21 • 27 days ago

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

Published Thursday, 22. May 2025 22:58 • 27 days ago

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

Published Thursday, 22. May 2025 17:03 • 27 days ago

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

Published Thursday, 22. May 2025 17:00 • 28 days ago

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

Published Thursday, 22. May 2025 15:13 • 28 days ago

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

Published Thursday, 22. May 2025 13:20 • 28 days ago

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

Published Thursday, 22. May 2025 00:00 • 28 days ago

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

Published Thursday, 22. May 2025 00:00 • 28 days ago

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

Published Wednesday, 21. May 2025 19:59 • 28 days ago

MySQL Hypergraph Optimizer ^{(from The Oracle MySQL Blog)}

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

Published Wednesday, 21. May 2025 18:01 • 28 days ago

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

Published Wednesday, 21. May 2025 17:00 • 29 days ago

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

Published Wednesday, 21. May 2025 15:33 • 29 days ago

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

[...]

Published Wednesday, 21. May 2025 14:34 • 29 days ago

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

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

Published Wednesday, 21. May 2025 13:45 • 29 days ago

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

Published Wednesday, 21. May 2025 11:34 • 29 days ago

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

Published Wednesday, 21. May 2025 08:07 • 29 days ago

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

Published Tuesday, 20. May 2025 18:57 • 29 days ago

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

Published Tuesday, 20. May 2025 17:00 • 30 days ago

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

Published Tuesday, 20. May 2025 16:00 • 30 days ago

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

Published Tuesday, 20. May 2025 15:35 • 30 days ago

RDS vs Aurora vs Aurora Serverless: A Real-World Cost Comparison for AWS Databases ^{(from Mydbops Blog)}

Understand the real cost of running MySQL on RDS, Aurora, or Aurora Serverless. Explore trade-offs, pricing models, and workload-based recommendations. [...]

Published Tuesday, 20. May 2025 05:49 • 30 days ago

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

Published Tuesday, 20. May 2025 02:23 • 1 months ago

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

Published Tuesday, 20. May 2025 00:00 • 1 months ago

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

Published Monday, 19. May 2025 17:49 • 1 months ago

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() – […] [...]

Published Monday, 19. May 2025 13:39 • 1 months ago

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

Published Monday, 19. May 2025 09:11 • 1 months ago

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

Published Monday, 19. May 2025 08:25 • 1 months ago

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

Published Monday, 19. May 2025 08:24 • 1 months ago

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

Published Monday, 19. May 2025 05:30 • 1 months ago

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

Published Monday, 19. May 2025 00:00 • 1 months ago

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

Published Sunday, 18. May 2025 16:37 • 1 months ago

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

Published Sunday, 18. May 2025 15:58 • 1 months ago | Updated Sunday, 18. May 2025 16:02 • 1 months ago

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

Published Friday, 16. May 2025 12:46 • 1 months ago | Updated Friday, 16. May 2025 12:46 • 1 months ago

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

Published Friday, 16. May 2025 08:59 • 1 months ago

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

Published Friday, 16. May 2025 07:00 • 1 months ago

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

Published Thursday, 15. May 2025 14:49 • 1 months ago

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

Published Thursday, 15. May 2025 13:59 • 1 months ago

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

Published Thursday, 15. May 2025 13:47 • 1 months ago

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

Published Thursday, 15. May 2025 12:21 • 1 months ago

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

Published Thursday, 15. May 2025 08:00 • 1 months ago

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

Published Thursday, 15. May 2025 05:30 • 1 months ago

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

Published Wednesday, 14. May 2025 23:45 • 1 months ago

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

Published Wednesday, 14. May 2025 22:45 • 1 months ago

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

Published Wednesday, 14. May 2025 21:35 • 1 months ago

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

Published Wednesday, 14. May 2025 18:40 • 1 months ago

How to Install MySQL on AlmaLinux 10 ^{(from RoseHosting Blog)}

pMySQL is one of the world’s most popular and widely used relational database management systems (RDBMS). Developed in 1995 by ... /p pRead More/p pThe post How to Install MySQL on AlmaLinux 10 appeared first on RoseHosting./p [...]

Published Wednesday, 14. May 2025 17:30 • 1 months ago

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

Published Wednesday, 14. May 2025 17:00 • 1 months ago

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

Published Wednesday, 14. May 2025 17:00 • 1 months ago

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

Published Tuesday, 13. May 2025 23:14 • 1 months ago

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

Published Tuesday, 13. May 2025 17:26 • 1 months ago

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

Published Tuesday, 13. May 2025 16:22 • 1 months ago

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

Published Tuesday, 13. May 2025 15:43 • 1 months ago

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

Published Tuesday, 13. May 2025 11:26 • 1 months ago

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

Published Tuesday, 13. May 2025 10:59 • 1 months ago

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

Published Tuesday, 13. May 2025 05:15 • 1 months ago

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

Published Tuesday, 13. May 2025 05:06 • 1 months ago

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

Published Tuesday, 13. May 2025 00:00 • 1 months ago

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

Published Monday, 12. May 2025 20:29 • 1 months ago

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

Published Monday, 12. May 2025 18:46 • 1 months ago

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

Published Monday, 12. May 2025 17:00 • 1 months ago

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

[...]

Published Monday, 12. May 2025 15:31 • 1 months ago

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

Published Monday, 12. May 2025 14:11 • 1 months ago

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

Published Monday, 12. May 2025 09:12 • 1 months ago

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

Published Monday, 12. May 2025 09:00 • 1 months ago

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

Published Monday, 12. May 2025 09:00 • 1 months ago

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

Published Monday, 12. May 2025 07:17 • 1 months ago

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

Published Monday, 12. May 2025 04:00 • 1 months ago

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

Published Sunday, 11. May 2025 23:52 • 1 months ago

Why AUTO_INCREMENT with Floating-Point Columns Is Deprecated in MySQL 8.4 ^{(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. [...]

Published Saturday, 10. May 2025 10:07 • 1 months ago

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

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

Published Saturday, 10. May 2025 00:00 • 1 months ago

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

Published Friday, 09. May 2025 15:29 • 1 months ago

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

Published Friday, 09. May 2025 13:11 • 1 months ago

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

Published Friday, 09. May 2025 13:10 • 1 months ago

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

Published Friday, 09. May 2025 12:18 • 1 months ago

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

Published Friday, 09. May 2025 08:42 • 1 months ago

MySQL 8 Password Management & Plugin Switching ^{(from Mydbops Blog)}

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

Published Friday, 09. May 2025 04:50 • 1 months ago

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

Published Friday, 09. May 2025 00:00 • 1 months ago

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

Published Thursday, 08. May 2025 16:48 • 1 months ago

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

Published Thursday, 08. May 2025 12:52 • 1 months ago

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

Published Thursday, 08. May 2025 11:36 • 1 months ago

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

Published Thursday, 08. May 2025 04:08 • 1 months ago

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

Published Thursday, 08. May 2025 04:00 • 1 months ago

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

Published Wednesday, 07. May 2025 14:18 • 1 months ago

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

Published Wednesday, 07. May 2025 13:00 • 1 months ago

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

Published Wednesday, 07. May 2025 05:51 • 1 months ago

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

Published Wednesday, 07. May 2025 00:20 • 1 months ago | Updated Wednesday, 07. May 2025 00:20 • 1 months ago

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

Published Saturday, 30. November 2024 01:54 • 7 months ago | Updated Tuesday, 06. May 2025 22:41 • 1 months ago

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

Published Tuesday, 06. May 2025 19:06 • 1 months ago

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

Published Tuesday, 06. May 2025 15:47 • 1 months ago

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

Published Tuesday, 06. May 2025 12:50 • 1 months ago

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

Published Monday, 05. May 2025 20:00 • 1 months ago

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

Published Monday, 05. May 2025 16:12 • 1 months ago

Best Synthetic Data Generators ^{(from Devart MySQL Tool Blog)}

pReal data slows teams down—and risks breaking compliance. Synthetic data by contrast flips the script, fueling faster development with privacy built in. But not every generator delivers the precision, flexibility, and scale modern teams expect. Find out which synthetic data tools lead in 2025./p pThe post Best Synthetic Data Generators appeared first on Devart Blog./p [...]

Published Monday, 05. May 2025 13:41 • 1 months ago

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

Published Monday, 05. May 2025 13:40 • 1 months ago

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

Published Monday, 05. May 2025 11:59 • 1 months ago

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

Published Monday, 05. May 2025 10:51 • 1 months ago

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

Published Saturday, 03. May 2025 04:35 • 2 months ago

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

Published Friday, 02. May 2025 17:54 • 2 months ago

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