Planet for the MySQL Community

MySQL performance tuning pricing - Releem ^{(from Releem Blog)}

Use Releem for FREE or upgrade to one of our powerful premium plans. [...]

Published Thursday, 08. May 2025 21:50 • 12 hours ago

Handling duplicates 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 • 17 hours 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 • 20 hours 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 • 22 hours 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 • a day 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 • a day 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 • 2 days 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 • 2 days 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 • 2 days 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 • 2 days ago | Updated Wednesday, 07. May 2025 00:20 • 2 days 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 • 5 months ago | Updated Tuesday, 06. May 2025 22:41 • 2 days 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 • 3 days 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 • 3 days 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 • 3 days ago

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

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

Published Tuesday, 06. May 2025 06:14 • 3 days 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 • 4 days 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 • 4 days 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 • 4 days 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 • 4 days 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 • 4 days ago

Best Database Diagram Tools– Free and Paid ^{(from Devart MySQL Tool Blog)}

pScalable systems live or die by schema clarity. That’s why most engineers now use database diagram tools to map, manage, and document their structures. But not all tools are built for modern, fast-moving teams. Here’s a look at the top database diagram tools making a difference in 2025./p pThe post Best Database Diagram Tools– Free and Paid appeared first on Devart Blog./p [...]

Published Monday, 05. May 2025 10:33 • 4 days 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 • 6 days 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 • 7 days 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 [...]