Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

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

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

Thursday, 08. May 2025

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 • 10 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 • 15 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 • 19 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 • 20 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

Wednesday, 07. May 2025

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

pWe at MariaDB Foundation are thrilled to see Amazon at the forefront of applying artificial intelligence to open source contributions — with MariaDB as their pilot.  … /p pContinue reading \"Amazon’s AI-agents for MariaDB Contributions\"/p pThe post Amazon’s AI-agents for MariaDB Contributions appeared first on MariaDB.org./p [...]
Published Wednesday, 07. May 2025 14:18 • a day 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

Tuesday, 06. May 2025

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

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

Monday, 05. May 2025

April Product Update (from Readyset Blog)

Readyset's February update: Grupo Ótima Digital cuts MySQL load by 30%, a new CYBERTEC partnership, product updates, FOSDEM highlights, and more! 🚀 [...]
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

Saturday, 03. May 2025

Uncle bob vs SQL (from The consistent voice)

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

Friday, 02. May 2025

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

pAtlassian, a global leader in project management and team collaboration, offers widely adopted products like Jira, Confluence, and Forge. As Atlassian’s SaaS platforms scale, so too do their data infrastructure needs, such as scaling millions of database tables efficiently and cost-effectively. That’s where TiDB comes in. This post explores how TiDB empowers Atlassian’s Forge platform [̷ [...]
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 [...]
Published Friday, 02. May 2025 17:00 • 7 days ago

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

pAmazon Relational Database Service (RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton4-based M8g database instances in Europe (Ireland) Region and R8g database instances in AWS GovCloud (US-West) Region. For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page.br br Graviton4-based instances provide up to a 40% performance improveme [...]
Published Friday, 02. May 2025 17:00 • 7 days ago

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

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

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

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

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

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports M7i database (DB) instances in Asia Pacific (Jakarta), South America (Sao Paulo), AWS GovCloud (US-East) and AWS GovCloud (US-West) regions. R7i DB instances are now supported in South America (Sao Paulo), AWS GovCloud (US-East) and AWS GovCloud (US-West) Regions. M7i and R7i are the latest Intel based [...]
Published Friday, 02. May 2025 17:00 • 7 days ago

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

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

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

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

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

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

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

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

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

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

ProxySQL Works with Dolt (from DoltHub Blog)

ProxySQL is an open source high performance, high availability, database-protocol-aware proxy for MySQL and PostgreSQL servers. As a reverse… [...]
Published Friday, 02. May 2025 00:00 • 7 days ago

Thursday, 01. May 2025

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

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

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

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

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

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

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

We make Dolt, the world's first version controlled SQL database. If you're making a database, you need to be fast, so performance has always… [...]
Published Thursday, 01. May 2025 00:00 • 8 days ago

Wednesday, 30. April 2025

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

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post. [...]
Published Monday, 28. April 2025 19:41 • 11 days ago | Updated Wednesday, 30. April 2025 14:16 • 9 days ago

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

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

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

Q1. What is your role at Oracle? I am a Developer advocate for MySQL. Some of my duties include producing content through blog posts and short form videos. I also get to speak at... [...]
Published Wednesday, 30. April 2025 06:21 • 9 days ago

Tuesday, 29. April 2025

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

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

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

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

Selling Software: Conferences (from DoltHub Blog)

Conferences are sales events we reluctantly spend money on even though our attendance has not generated a single sale. Why do we keep going… [...]
Published Tuesday, 29. April 2025 00:00 • 10 days ago

Announcing Vitess 22 (from PlanetScale Blog)

Vitess 22 is now generally available [...]
Published Tuesday, 29. April 2025 00:00 • 10 days ago

Announcing Vitess 22 (from Vitess)

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

Monday, 28. April 2025

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

pOne of the most commonly misunderstood configurations in MySQL is related to parallel replication threads in MySQL, and more importantly how do I monitor my replica to ensure its configured effectively. /pBackground on parallel replicationpTraditionally, MySQL replication was single threaded where changes applied on a writer database are fetched by a replica and applied serially on a replica [...]
Published Monday, 28. April 2025 23:32 • 10 days ago | Updated Monday, 28. April 2025 23:32 • 10 days ago

MySQL & Heatwave Summit Recap (from Marcelo Altmann)

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

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

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

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

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

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

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

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

Connecting to MySQL HeatWave in OCI [...]
Published Monday, 28. April 2025 09:13 • 11 days ago

Sunday, 27. April 2025

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

[...]
Published Sunday, 27. April 2025 00:00 • 12 days ago

Friday, 25. April 2025

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

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

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

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.4.2 GA release. Release Notes MariaDB Connector/Node.js MariaDB […] [...]
Published Friday, 25. April 2025 20:54 • 13 days ago

Anatomy Of A SQL Engine (from DoltHub Blog)

May marks five years since Dolt adopted go-mysql-server. Today we summarize the current state of GMS by walking through a query's journey… [...]
Published Friday, 25. April 2025 00:00 • 14 days ago

Thursday, 24. April 2025

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

This is a guest post by Libing Song from Alibaba Cloud. This blog post introduces a new feature which speeds […] [...]
Published Thursday, 24. April 2025 22:14 • 14 days ago

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

This is a guest post by Libing Song from Alibaba Cloud. If the transaction takes 30 minutes to execute, it […] [...]
Published Thursday, 24. April 2025 22:13 • 14 days ago

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

Learn how the Continuent team designed a secure and effective REST API for Tungsten Clustering, including best practices for using POST, PUT, verbs, idempotent actions, and more in real-world scenarios.Tags: REST APIbest practicessecuritytungsten cluster [...]
Published Thursday, 24. April 2025 18:19 • 15 days ago

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

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

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

The `SHOW PROCESSLIST` command in MySQL is a crucial tool for database administrators to monitor active threads and take control of ongoing operations. [...]
Published Thursday, 24. April 2025 14:14 • 15 days ago

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

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

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

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

Wednesday, 23. April 2025

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

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

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

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

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

[...]
Published Wednesday, 23. April 2025 14:37 • 16 days ago

Coding Agents Suck Too (from DoltHub Blog)

If you've been following our recent blog posts you know that I've been quite critical of LLMs, AI agents, and the companies that tout them… [...]
Published Wednesday, 23. April 2025 00:00 • 16 days ago

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

MySQL 9.3.0 was released last week (April 15, 2025), and one particular update caught my attention: [...]
Published Wednesday, 23. April 2025 00:00 • 16 days ago

Tuesday, 22. April 2025

Reduce RDS Costs (from Shattered Silicon OSDB Blog)

pRDS is often the most expensive part of companies' AWS infrastructures. Here we will explore ways to reduce RDS costs by over 22x./p pThe post Reduce RDS Costs appeared first on Shattered Silicon./p [...]
Published Tuesday, 22. April 2025 18:05 • 17 days ago

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

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

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

When a database starts acting up, the first question is always "which queries are causing the problem?" Setting up proper query monitoring is fundamental to maintaining a MySQL database. Database troubleshooting without proper query visibility is basicall [...]
Published Tuesday, 22. April 2025 10:49 • 17 days ago

MySQL Optimization Center (from Releem Blog)

Everything you need to monitor, tune, and optimize MySQL databases for top performance. [...]
Published Tuesday, 22. April 2025 08:22 • 17 days ago

Doltgres Data Imports (from DoltHub Blog)

Doltgres has been improving by leaps and bounds lately, and in case you missed it... we just hit our beta milestone last week! 🎉 Dolt is… [...]
Published Tuesday, 22. April 2025 00:00 • 17 days ago

Monday, 21. April 2025

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

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

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

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

Saturday, 19. April 2025

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

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

Friday, 18. April 2025

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

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

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

This blog will guide you through setting up and managing On-premises (External) MySQL DB systems in OCI, ensuring optimal performance and operational insights. In this part, we will cover the prerequisite steps before registering and managing External MySQL DB systems. [...]
Published Friday, 18. April 2025 19:52 • 21 days ago

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

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

Thursday, 17. April 2025

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

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

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

Set up MySQL InnoDB Cluster with MySQL Shell for high availability and scalability. Follow our step-by-step guide on install, config, and best practices. [...]
Published Thursday, 17. April 2025 16:56 • 22 days ago

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

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

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

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

Switching Memory Allocator in MariaDB (from DBPEDIABLOGS)

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

Why Doltgres over Dolt? (from DoltHub Blog)

In case you missed it, we shipped a Beta version of Doltgres yesterday. We worked on Doltgres for a year and a half and it finally hit our… [...]
Published Thursday, 17. April 2025 00:00 • 22 days ago

Wednesday, 16. April 2025

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

Q1. You have 18 years of experience in mission-critical database design. What are the main lessons you have learned in all these years? Test, test, and test one more time! When I started at... [...]
Published Wednesday, 16. April 2025 11:15 • 23 days ago

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

This blog outlines how to set up Oracle Heatwave MySQL disaster recovery copy for the production database using the OCI Console level full backup, copying the backup to another region, building the disaster recovery database from the primary backup and setting up the in-bound replication channel from primary to disaster recovery database. [...]
Published Wednesday, 16. April 2025 06:18 • 23 days ago

Doltgres Beta Launch (from DoltHub Blog)

Dolt is the world's first and only version-controlled SQL database. It's a database that you can branch and merge, fork and clone, push and… [...]
Published Wednesday, 16. April 2025 00:00 • 23 days ago

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

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

Tuesday, 15. April 2025

HOMELAB (from Another MySQL DBA)

pJust for fun.../ppNumerous options exist for testing MySQL and general database instances./ppThis is just an example of how you can use Proxmox to have a simple fast setup for repeatable testing and access./ppThis example is a nice and cheap option to have a home lab for MySQL and anything else you want./ppThe homelab virtualization I picked was Proxmox and Openmediavaul&n [...]
Published Tuesday, 15. April 2025 23:26 • 23 days ago | Updated Tuesday, 15. April 2025 23:26 • 23 days ago

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

pWe are delighted to welcome Tempesta Technologies as a Silver Sponsor of the MariaDB Foundation!br Tempesta Technologies is the developer of Tempesta FW, an open-source hybrid of a web accelerator and a multi-layer firewall. … /p pContinue reading \"Tempesta Technologies Becomes Silver Sponsor of MariaDB Foundation\"/p pThe post Tempesta Technologies Becomes Silver Sponsor of MariaDB Foundat [...]
Published Tuesday, 15. April 2025 16:52 • 24 days ago

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

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

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

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

When indexes make SQL queries slower (from Vettabase)

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

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

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

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

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

Should Doltgres have a CLI? (from DoltHub Blog)

It's Doltgres Beta week here at DoltHub. In eager anticipation of tomorrow's Doltgres Beta launch, I have an appetizer to get you interested… [...]
Published Tuesday, 15. April 2025 00:00 • 24 days ago

Monday, 14. April 2025

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

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

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

In this post, we explore key strategies and AWS tools to help you successfully migrate your high-throughput relational database while minimizing business disruption. [...]
Published Monday, 14. April 2025 21:49 • 24 days ago

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

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

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

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

MariaDB Catalogs preview containers available (from MariaDB Foundation Blog)

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

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

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

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

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

An Introduction to Adaptive Encoding (from DoltHub Blog)

Arguably the most important design decision in a database is one that most users probably never think about: how your data is actually… [...]
Published Monday, 14. April 2025 00:00 • 25 days ago

Sunday, 13. April 2025

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

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

Saturday, 12. April 2025

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

TiDB scaling for enterprise applications: 70%+ storage savings, millisecond latency at millions QPS, and reduced infrastructure costs - case studies from MySQL & Aurora migrations. [...]
Published Saturday, 12. April 2025 05:59 • 27 days ago

Battle of the Mallocators (from Small Datum)

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

Friday, 11. April 2025

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

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

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

Struggling with slow PHP MySQL performance? Learn how to easily detect and fix slow and frequent queries to speed up your application with less manual work. [...]
Published Friday, 11. April 2025 18:52 • 28 days ago

Azure Database for MySQL - March 2025 updates and latest feature roadmap (from Azure for MySQL Blog)

pWe're excited to share a summary of the Azure Database for MySQL announcements from last month, as well as the latest roadmap of upcoming features!/p April 2025 Live Webinar pThese updates and the latest roadmap are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every month, at 7:30 AM Pacific time. Below [...]
Published Friday, 11. April 2025 16:21 • 28 days ago

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

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

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

With EXPLAIN, you can figure out exactly why a query is underperforming. Maybe it’s looking at too many rows, ignoring indexes, or struggling with joins. This understanding is key for developers and database administrators who are aiming to optimize perfo [...]
Published Friday, 11. April 2025 13:20 • 28 days ago

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

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

Getting started with Open WebUI (from dbi Blog)

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

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

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

Thursday, 10. April 2025

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

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

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

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

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

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

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

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

Wednesday, 09. April 2025

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

[...]
Published Wednesday, 09. April 2025 22:13 • 29 days ago

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

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

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

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

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

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

Tuesday, 08. April 2025

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

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

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

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

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

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

Selling Software: SaaS Tools Review (from DoltHub Blog)

Last week, we introduced a new blog series called "Selling Software", named after the Netflix smash hit, Selling Sunset. DoltHub happens to… [...]
Published Tuesday, 08. April 2025 00:00 • 1 months ago

Monday, 07. April 2025

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

We are excited to announce that HeatWave on AWS is now available in the US West (Oregon) and Asia Pacific (Seoul) AWS regions, in addition to US East (N.Virginia), Europe (London), Europe (Frankfurt), Asia Pacific (Tokyo), and Asia Pacific (Mumbai). [...]
Published Monday, 07. April 2025 19:50 • 1 months ago

Announcing the Database Frontiers Virtual Conference! (from Vettabase)

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

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

pWe had the pleasure on Friday to take individual calls with everybody who submitted to the ideation phase of the MariaDB AI RAG hackathon.  … /p pContinue reading \"MariaDB’s AI RAG Hackathon is underway\"/p pThe post MariaDB’s AI RAG Hackathon is underway appeared first on MariaDB.org./p [...]
Published Monday, 07. April 2025 08:41 • 1 months ago

Saturday, 05. April 2025

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

pThe following post was written by Stefano Petrilli, who contributed UUIDv4 and UUIDv7 implementations to MariaDB. Thank you, Stefano! … /p pContinue reading \"Always use the right UUID in MariaDB\"/p pThe post Always use the right UUID in MariaDB appeared first on MariaDB.org./p [...]
Published Saturday, 05. April 2025 19:00 • 1 months ago

Friday, 04. April 2025

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

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

Thursday, 03. April 2025

PostgreSQL Temporary Data Performance Optimization (from MinervaDB Blog)

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

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

pAmazon RDS for MariaDB now supports MariaDB Innovation Release 11.8 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MariaDB. You can deploy MariaDB 11.8 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases.br br MariaDB 11 [...]
Published Thursday, 03. April 2025 17:00 • 1 months ago

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

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

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

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

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

This blog explores how to monitor HeatWave backups using OCI’s Monitoring and Alarm services and includes details on how to set up alarms that instantly notify the user in case of backup failures, enabling quick action. [...]
Published Thursday, 03. April 2025 05:38 • 1 months ago

Wednesday, 02. April 2025

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

[...]
Published Wednesday, 02. April 2025 20:44 • 1 months ago

March Product Update (from Readyset Blog)

Readyset's February update: Grupo Ótima Digital cuts MySQL load by 30%, a new CYBERTEC partnership, product updates, FOSDEM highlights, and more! 🚀 [...]
Published Wednesday, 02. April 2025 17:30 • 1 months ago

Optimistic and Pessimistic Locking in TiDB (from Mydbops Blog)

Learn how TiDB handles concurrency with optimistic and pessimistic locking. Understand the differences, benefits, and when to use each method for high-performance distributed database management. [...]
Published Wednesday, 02. April 2025 04:57 • 1 months ago

Tuesday, 01. April 2025

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

In this article, we’re going to explore MySQL index creation. We’re going to cover the fundamentals of index syntax with examples, take a look at MySQL workbench’s index capabilities, and discuss some advanced indexing techniques. [...]
Published Tuesday, 01. April 2025 17:15 • 1 months ago

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

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

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

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

Is MongoDB Truly Open Source? A Critical Look at SSPL (from Percona Database Blog)

♦This post was originally published in April 2023 and was updated in April 2025. When asked “Is MongoDB open source?”, at Percona, our definitive answer is “no.” Let’s start with this: MongoDB is accurately referred to as source-available software. Whereas many open source software offerings — like the community version of MySQL — use the […] [...]
Published Tuesday, 01. April 2025 12:00 • 1 months ago

How to Run MongoDB on Kubernetes: Solutions, Pros and Cons (from Percona Database Blog)

♦This blog was originally published in August 2022 and was updated in April 2025. In this blog, we’ll examine the increasingly popular practice of running MongoDB on Kubernetes. We will explore various solutions and approaches to this setup, from direct deployments as a stateful application to utilizing specialized operators and considering cloud-based solutions, guiding you […] [...]
Published Tuesday, 01. April 2025 09:00 • 1 months ago

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

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

Monday, 31. March 2025

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

pIf you use a MySQL/MariaDB database, you know it can become slow or consume too many resources if not properly ... /p pRead More/p pThe post How to Optimize Database Performance With MySQLTuner appeared first on RoseHosting./p [...]
Published Monday, 31. March 2025 17:30 • 1 months ago

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

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

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

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

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

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

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

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

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

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

Saturday, 29. March 2025

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

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

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

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

Friday, 28. March 2025

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

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

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

pThe ideation phase of the MariaDB AI RAG Hackathon is nearing its deadline on Monday (by end of March). br We have several cool submissions so far. … /p pContinue reading \"Last chance to apply to AI RAG Hackathon\"/p pThe post Last chance to apply to AI RAG Hackathon appeared first on MariaDB.org./p [...]
Published Friday, 28. March 2025 09:39 • 1 months ago

Thursday, 27. March 2025

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

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.5.3, 3.4.2, and 3.3.4 releases. Download Now Release […] [...]
Published Thursday, 27. March 2025 22:26 • 1 months ago

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

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

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

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

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

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

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

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

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

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

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

pNeed MySQL database hosting? Learn how to host a MySQL database on cloud, VPS, or local servers. Compare costs, features, and providers. /p pThe post How to Host MySQL Databases: Best Methods & Hosting Solutions appeared first on Devart Blog./p [...]
Published Thursday, 27. March 2025 15:34 • 1 months ago

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

pLearn how to use ENUM in MySQL to store predefined values efficiently. Find syntax, examples, and best practices for the ENUM data type./p pThe post ENUM Data Type in MySQL: Syntax, Examples and Best Practices appeared first on Devart Blog./p [...]
Published Thursday, 27. March 2025 14:53 • 1 months ago

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

pLooking for the best database for data analytics? Compare top-rated systems for data analytics, real-time processing, and big data. Find the right solution today!/p pThe post How to Choose the Right Database for Data Analytics appeared first on Devart Blog./p [...]
Published Thursday, 27. March 2025 14:33 • 1 months ago

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

Learn how to optimize MySQL replication performance in Tungsten Cluster by tuning the Applier settings. Improve replication speed, minimize commit overhead, and balance data availability with advanced tuning techniques.Tags: replicationdatabase performance tuningHigh Availabilityreplication tuning [...]
Published Thursday, 27. March 2025 13:36 • 1 months ago

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

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

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

We were recently asked to support Galera Manager on ARM architectures (aarch64), and while we do support Galera Cluster on aarch64 for Galera Cluster Enterprise Edition (EE) in Galera Cluster for MySQL 8.0, we do not make such builds for our community release. This also means that for Galera Manager we are firmly just based […] [...]
Published Thursday, 27. March 2025 07:14 • 1 months ago

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

In this post, we demonstrate how to perform an incremental dump of data using MySQL Shell by leveraging the `util.dumpBinlogs()` function. [...]
Published Thursday, 27. March 2025 04:00 • 1 months ago

Wednesday, 26. March 2025

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

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

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

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

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

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

Tuesday, 25. March 2025

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

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

PlanetScale vectors is now GA (from PlanetScale Blog)

You can now use vector search and storage in your PlanetScale MySQL database. [...]
Published Tuesday, 25. March 2025 12:00 • 1 months ago

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

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

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

In this article you will see how to create embeddings of your database's content and store those vectors in MySQL HeatWave. Then you will discover the power of HeatWave GenAI to RAG your data with LLMs [...]
Published Tuesday, 25. March 2025 09:54 • 1 months ago

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

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

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

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

Monday, 24. March 2025

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

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

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

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

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

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

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

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

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

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

Saturday, 22. March 2025

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

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

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

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

Troubleshooting MariaDB Memory Leaks (from Mydbops Blog)

Learn how we resolved MariaDB memory leaks by switching to Jemalloc. Discover step-by-step troubleshooting process and how this fix reduced memory usage by 60%. [...]
Published Saturday, 22. March 2025 05:55 • 2 months ago

Thursday, 20. March 2025

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

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

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

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

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

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

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

[...]
Published Thursday, 20. March 2025 13:21 • 2 months ago | Updated Thursday, 20. March 2025 13:21 • 2 months ago

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

A novel technique for implementing dynamic language interpreters in Go, applied to the Vitess SQL evaluation engine [...]
Published Thursday, 20. March 2025 00:00 • 2 months ago

Wednesday, 19. March 2025

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

New maintenance releases for MariaDB Enterprise Server 11.4.5-3, 10.6.21-17, and 10.5.28-22 are now available. These releases include new backported features. […] [...]
Published Wednesday, 19. March 2025 22:21 • 2 months ago

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

How to use MySQL HeatWave on AWS and OCI and connect them to replicate. [...]
Published Wednesday, 19. March 2025 17:46 • 2 months ago

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

In the previous post, we saw how to deploy MySQL HeatWave on Amazon. Multicloud refers to the coordinated use of cloud services from multiple providers. In addition to our previous post, where we deployed MySQL HeatWave on Amazon, we will explore how to connect with another cloud service. Oracle has partnered with Microsoft to offer […] [...]
Published Wednesday, 19. March 2025 16:43 • 2 months ago

Tuesday, 18. March 2025

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

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

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

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

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

An introduction to how to manage MySQL NDB Cluster (NDB) using MySQL Cluster Manager (MCM). A walk-through of managing NDB in a multi-host setup, backup and restore, scaling NDB, and upgrading NDB. [...]
Published Tuesday, 18. March 2025 09:00 • 2 months ago

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

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

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

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