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, 06. March 2025

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

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

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

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

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

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

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

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

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

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

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

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

MariaDB Honeypot (from Shinguz's Blog)

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

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

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

Wednesday, 05. March 2025

PostgreSQL Checkpointing and Background Writing Process (from MinervaDB Blog)

pPostgreSQL’s durability and performance rely heavily on its checkpointing and background writing processes. Understanding these mechanisms is crucial for developing optimal database applications. Write-Ahead Logging (WAL) PostgreSQL uses Write-Ahead Logging (WAL) as the foundation of [...]/p pThe post PostgreSQL Checkpointing and Background Writing Process appeared first on The WebScale Data [...]

Your First Steps with Readyset and MySQL Are Here! 🚀 (from Readyset Blog)

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

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

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

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

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

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

MySQL Meetups & celebration events [...]

Tuesday, 04. March 2025

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

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

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

ClusterControl brings flexible pay-as-you-go self-serve experience to on-prem workloads (from Severalnines Blog)

pOur brand promise, “Database ops your way”, rests on three pillars: accessibility, portability and selection. That is why we’re thrilled to share that ClusterControl’s powerful automation platform for managing on-prem and hybrid deployments is now available as a pay-as-you-go, monthly subscription! Let’s dive into the details! ClusterControl adds Self-Service plan for greater optionality Clu [...]

MySQL 9.2 : thank you for your contributions! (from The Oracle MySQL Blog)

Thank you to all contributors that have their patches added to MySQL 9.2 [...]

Report from the Board (from MariaDB Foundation Blog)

pOpenness, Adoption, Continuity: You’ve heard me repeating our mantra like a broken record. Today is the next episode – and the theme du jour is about our Board Meetings, which we have minuted publicly on mariadb.org/bodminutes/ since October 2020. … /p pContinue reading \"Report from the Board\"/p pThe post Report from the Board appeared first on MariaDB.org./p [...]

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

At the beginning of the year, we released MySQL 9.2, the latest Innovation Release. Sorry for the delay, but I was busy with the preFOSDEM MySQL Belgian Days and FOSDEM MySQL Belgium Days. Of course, we released bug fixes for 8.0 and 8.4 LTS, but in this post, I focus on the newest release. Within […] [...]

Monday, 03. March 2025

On HeatWave MySQL: Query Execution, Performance, Benchmarks, and Vector type. Q&A with Kaan Kara. (from ODBMS.org)

Q1. You are working as a lead developer mainly responsible for query execution in HeatWave MySQL. What are the challenges that you try to solve?  HeatWave is an in-memory data processing engine, so for... [...]

Saturday, 01. March 2025

AWS MySQL Showdown: Key Insights from Our RDS vs. Aurora vs. Serverless Webinar (from Mydbops Blog)

Explore key insights from Mydbops MyWebinar 41 on AWS MySQL services. Compare RDS, Aurora, and Serverless in terms of architecture, performance, high availability, and cost efficiency. [...]

Friday, 28. February 2025

How To Check The Available Memory In Your HeatWave MySQL Cluster Via SQL (from The Oracle MySQL Blog)

This blog post gives you a quick and easy SQL statement to check the available memory in your HeatWave MySQL cluster. [...]

MySQL now reports 3 decimal places for milliseconds (from Marcelo Altmann)

MotivationpAt Readyset, we frequently analyze query latency to fine-tune performance. Our built-in metrics provide end-to-end timing breakdowns, helping us measure everything from query parsing to execution (whether it’s a cache hit or miss)./p♦Query latency varying from 5 microseconds(μs) on p50 to 12.5 microseconds(μs) on p99pWe often deal with extremely fast queries — some completing in as littl [...]

Deep Dive into MySQL - Implicit Locks (from Zhao Song's Blog)

The previous 2 blog posts introduced MySQL’s locking mechanisms for insert and locking read operations. [...]

Thursday, 27. February 2025

Database Insights provides on-demand analysis for RDS MySQL and RDS MariaDB (from AWS What's New)

pAmazon CloudWatch Database Insights expands the availability of its on-demand analysis experience to the RDS for MySQL and RDS for MariaDB database engines. This feature leverages machine learning models to help identify performance bottlenecks during the selected time period, and gives advice on what to do next.br br This launch allows you to analyze database performance monitoring data for a tim [...]

Migrate very large databases to Amazon Aurora MySQL using MyDumper and MyLoader (from AWS Database Blog)

In this post, we discuss how to migrate MySQL very large databases (VLDBs) from a self-managed MySQL database to Amazon Aurora MySQL-Compatible Edition using the MyDumper and MyLoader tools. [...]

MySQL Reserved Words: What You Need to Know  (from Devart MySQL Tool Blog)

pLearn about MySQL reserved words, their impact on database design, and how to avoid common errors. Find practical tips, examples, and resources for managing reserved words effectively./p pThe post MySQL Reserved Words: What You Need to Know  appeared first on Devart Blog./p [...]

How to Set Up the Development Environment for MySQL Shell Plugins for Python (from TusaCentral - MySQL Blogs)

pMySQL Shell is a powerful tool for managing MySQL databases, and one of its most exciting features is the ability to extend its functionality using plugins. If you're a Python developer, you can create custom plugins to automate tasks, add new commands, or♦br integrate MySQL Shell with other tools. However debugging the python code could be cumbersome for mysql-shell given the python code requires [...]

Why TLS for MySQL is difficult (from Daniël's Database Blog)

pThe internet has changed to a place where most protocols like HTTP etc now use secure connections with TLS by default./p pWhile both HTTP and the MySQL Protocol use TLS for secure connections there are still many differences which make it difficult for MySQL to benefit from the same advancements as HTTP has seen in the last so many years./p What is TLS? pTLS stands for Transport Layer Security and [...]

Wednesday, 26. February 2025

Time’s Up! How TiDB Efficiently Handles Expired Data (from PingCAP Blog)

pManaging large-scale data efficiently is a critical challenge for modern databases, especially when dealing with time-sensitive data that can quickly become outdated. Starting from TiDB 6.5 and becoming generally available in TiDB 7.0, TTL (Time To Live) automates the deletion of expired data, offering a powerful, customizable solution for maintaining data freshness while minimizing operational [& [...]

What Triggers a Continuent Tungsten Cluster Failsafe-Shun? (from Continuent Blog)

Learn what triggers Tungsten Cluster failsafe-shun and how it helps maintain high availability in MySQL database clusters. Discover key factors and best practices for managing automatic node shunning.Tags: tungsten clusterfailsafe-shunHigh Availabilityfailover [...]

Amazon RDS now provides visibility into IAM DB Authentication metrics and logs (from AWS What's New)

pAmazon Relational Database Service (RDS) IAM Database Authentication (IAM DB Auth) now provides enhanced observability through metrics and logs. It enables customers to investigate and resolve authentication issues when connecting to RDS databases.br br Database connection authentication issues can occur due to multiple reasons such as configuration or permission issues with your IAM policy, using [...]

Reduced operational downtime with new ALTER TABLE features (from MariaDB Corporation Blog)

Reduced operational downtime with new Online Schema Change We recently released MariaDB Enterprise Server 11.4 as part of the MariaDB … Continued [...]

Does Artificial Intelligence Query MySQL Better Than You? (from Dave's MySQL Stuff)

p The signal-to-noise ratio in the hype for Artificial Intelligence is incredibly high. There are many claims that AI will replace software developers. Many years ago, developers were told to find other jobs as a new programming language was designed to be written by nonprogrammers, replacing expensive coders. The Common Business Orientated Language, or COBOL, was a big hit and is still very p [...]

Amazon RDS Data API for Aurora is now available in 10 additional AWS regions (from AWS What's New)

pRDS Data API for Aurora Serverless v2 and Aurora provisioned PostgreSQL-Compatible and MySQL-Compatible database clusters is now available in Africa (Cape Town), Asia Pacific (Hong Kong), Asia Pacific (Jakarta), Asia Pacific (Malaysia), Asia Pacific (Osaka), Europe (Milan), Europe (Stockholm), Middle East (Bahrain), Middle East (UAE), and South America (São Paulo) regions. RDS Data API allows you [...]

Amazon RDS for MariaDB supports minors 11.4.5, 10.11.11, 10.6.21, 10.5.28 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 11.4.5, 10.11.11, 10.6.21, and 10.5.28. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can leverage [...]

Feedback from the Postgres community about the vector index benchmarks (from Small Datum)

pThis is a response to some of the feedback I received from the Postgres community about my recent benchmark results for vector indexes using MariaDB and Postgres (pgvector). The work here isn't sponsored and required ~2 weeks days of server time and a few more hours of my time (yes, I contribute to the PG community)./pptl;dr/pp/pulliindex create is ~4X faster when using ~4 parallel workers. I hope [...]

Using VS Code and Docker to Debug MySQL Crashes (from Percona Database Blog)

♦Typically, we receive customer tickets regarding crashes or bugs, where we request a core dump to analyze and identify the root cause or understand the unexpected behavior. To read the core dumps, we also request the linked libraries used by the server’s MySQL. However, there’s a more efficient way to achieve our goal: by using […] [...]

Tuesday, 25. February 2025

Galera Cluster for MySQL 8.0.41-26.22 and 8.4.4-26.22 released (from Galera Blog)

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.41-26.22 (release notes, download), with Galera replication library 4.22 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.4-26.22 (release notes, download); it [...]

Comparing the Best Database Management Systems (from Devart MySQL Tool Blog)

pCompare the top database management systems (DBMS) like MySQL, SQL Server, PostgreSQL, MongoDB, Oracle, and more. Learn about their features, advantages, and the best use cases to choose the right database for your project./p pThe post Comparing the Best Database Management Systems appeared first on Devart Blog./p [...]

Announcing DoltHub Robot Blogger (from DoltHub Blog)

Today we're excited to share our open-source Robot Blogger tool 🤖! If you've not been following along, I wrote about my experience learning… [...]

Monday, 24. February 2025

Updated MariaDB ODBC and Python Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/ODBC 3.2.5, Connector/ODBC 3.1.21, and Connector/Python 1.1.12. Download Now MariaDB … Continued [...]

Understanding MySQL Global Transaction Identifiers (GTIDs) And Their Role in Replication (from The Oracle MySQL Blog)

Learn about how Global Transaction Identifiers (GTID's) and how they are used with MySQL replication. [...]

InnoDB deep dive : commit phase (from The consistent voice)

InnoDB deep dive : commit phasepEvery time you COMMIT a statement in InnoDB, a carefully orchestrated sequence of events takes place to ensure your data remains safe and consistent. Understanding how InnoDB handles transaction commits is crucial for anyone serious about database reliability and performance. The key to this process lies in a misunderstood configuration parameter: innodb_flush_log_at [...]

MariaDB and the GROUP BY error (from Vettabase)

Developers who are not familiar with SQL are often confused by MariaDB and MySQL’s infamous GROUP BY error. From time to time, customers ask us to explain it, so it’s time we publish an article on this topic. The error I’m talking about is the following: Let’s see what this error means, and how to rewrite a query accordingly. Understanding the error The error components are [...]

Rancher and Galera Cluster in the partner repository (from Galera Blog)

If you’ve ever wanted to deploy Galera Cluster on Rancher by SUSE, you now can since Galera Cluster is a partner chart in their repository. This means Codership’s Galera Cluster is a SUSE Ready Verified partner. A direct link to the HELM charts for MySQL/Galera Cluster is here. What is Rancher? Rancher is a Kubernetes […] [...]

Sunday, 23. February 2025

MySQL / MariaDB Post-Upgrade Performance Anomalies (from Shattered Silicon OSDB Blog)

pUpgrading MySQL or MariaDB introduces new features but can cause performance anomalies, due to changes in query optimizer algorithms./p pThe post MySQL / MariaDB Post-Upgrade Performance Anomalies appeared first on Shattered Silicon./p [...]

Saturday, 22. February 2025

30th Anniversary Edition (from AskDba)

In this edition of the blog post, I want to summarize my three decades (excluding my internships) of hustle in Information Technology. This is not only a tribute to my 30th anniversary in the field but also a show of appreciation for those with whom I’ve crossed paths—sharing knowledge, experiences, and moments of blood, sweat, […] [...]

Friday, 21. February 2025

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

pFocus, focus, focus! That’s the mantra of any successful organisation. With great input from our Board, we’ve managed to condense our strategic planning for 2025 into six goals. … /p pContinue reading \"This month in MariaDB Foundation: Jan 2025\"/p pThe post This month in MariaDB Foundation: Jan 2025 appeared first on MariaDB.org./p [...]

Dolt for Beginners: Schemas (from DoltHub Blog)

The Dolt for Beginners series focuses on topics people getting started with Dolt will likely be interested in. Most of our other blog… [...]

Thursday, 20. February 2025

Public Preview announcement - Unified migration experience in Azure DMS (from Azure for MySQL Blog)

pWe are excited to announce that Azure Database Migration Service (DMS) now supports seamless migration of your MySQL on-premises or Virtual Machine (VM) workloads to Azure Database for MySQL - Flexible Server. This new feature, now available in public preview, allows you to use physical backup files of the MySQL server for migration. /p p /p pBy restoring your physical data files directl [...]

Azure Database for MySQL - January 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 February 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. Be [...]

Meeting NIS2 Challenges with MySQL Enterprise Edition (from The Oracle MySQL Blog)

The NIS2 Directive strengthens EU cybersecurity standards by expanding sector coverage and imposing stricter requirements. This document outlines how MySQL Enterprise Edition can help organizations meet these demands, focusing on key areas for securing MySQL database servers within the NIS2 framework. [...]

MySQL Rockstars 2024 (from The Oracle MySQL Blog)

These are the MySQL Rockstars 2024 winners ! [...]

Wednesday, 19. February 2025

Unleashing 50x Performance: In-Depth Analysis of TiDB DDL Framework Optimizations (from PingCAP Blog)

pManaging schema changes in traditional databases often leads to downtime, blocking, and operational complexity. TiDB has long simplified this process with its online DDL capabilities, allowing developers to evolve their databases without disrupting applications. As user bases and data volumes have surged, however, index creation was increasingly becoming a performance bottleneck. To address this, [...]

A Deep Dive into OpenSSL, FIPS, and MySQL (from The Oracle MySQL Blog)

FIPS compliance is crucial for numerous MySQL deployments, especially within government agencies and organizations subject to regulatory mandates. The alignment of FIPS 140-3 with ISO/IEC 19790 broadens the applicability of these requirements. This blog clarifies the relationship between FIPS, OpenSSL, and MySQL. [...]

Amazon RDS for MySQL supports new minor versions 8.0.41 and 8.4.4 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor versions 8.0.41 and 8.4.4. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MySQL, and to benefit from the bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more about the enhancements in RDS for MySQL 8 [...]

My database communities (from Small Datum)

pI have been working on databases since 1996. In some cases I just worked on the product (Oracle & Informix), in others I consider myself a member of the community (MySQL, Postgres & RocksDB). And for MongoDB I used to be in the community./ppI worked on Informix XPS in 1996. I chose Informix because I could live in Portland OR and walk to work. I was fresh out of school, didn't know much ab [...]

Highlights from preFOSDEM MySQL Belgian Days 2025 (from The Oracle MySQL Blog)

This is a recap of the preFOSDEM MySQL Belgian Days 2025 [...]

Percona Monitoring and Management 3 and rootless containers (from Percona Community Blog)

In today’s landscape, where security breaches are a constant concern, reducing potential attack vectors is a top priority for any organization. Percona Monitoring and Management (PMM) has established itself as a reliable solution for database performance monitoring. With the release of PMM version 3, Percona has significantly strengthened its security posture, notably by introducing support f [...]

Tuesday, 18. February 2025

Decoding MySQL's GTID_TAGGED_LOG_EVENT (from Daniël's Database Blog)

table { margin: 1em 0; border-collapse: collapse; width: 100%; overflow-x: auto; display: block; font-variant-numeric: lining-nums tabular-nums; } table caption { margin-bottom: 0.75em; } tbody { margin-top: 0.5em; border-top: 1px solid #1a1a1a; border-bottom: 1px solid #1a1a1a; } th { border-top: 1px solid #1a1a1a; padding: 0.25em 0.5em 0.25em 0.5em; } td { padding: 0.125em 0.5em 0.25em 0.5em; } [...]

Codership is pleased to announce that we have been selected to join the European Innovation Council Pavilion at MWC 2025 in Barcelona (from Galera Blog)

Codership is pleased to announce that we have been selected to join the European Innovation Council Pavilion at MWC 2025 in Barcelona, taking place from 3 to 6 March! This international trade fair is the largest and most influential connectivity event in the world, where industry leaders, startups, and investors come together to shape the […] [...]

Learning About RAG (from DoltHub Blog)

Dolt recently added support for vector indexes, which are a type of index used commonly in RAG (Retrieval-Augmented Generation) applications… [...]

Monday, 17. February 2025

On Data Migration. Q&A with Eric Hanson (from ODBMS.org)

Q1. What are the typical challenges when performing data migration?  Performing data migration requires you to decide what to migrate, build tables in the target system with the right schema, do initial movement of... [...]

MariaDB 11.7.2 and MariaDB 11.8.1 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.8.1, the Release Candidate (RC) in the long-term MariaDB 11.8 release, and MariaDB 11.7.2, the latest Generally Available (GA) rolling release. … /p pContinue reading \"MariaDB 11.7.2 and MariaDB 11.8.1 now available\"/p pThe post MariaDB 11.7.2 and MariaDB 11.8.1 now available appeared first on MariaDB.org./p [...]

The Potential of Query Attributes in MySQL (from Daniël's Database Blog)

Introduction pQuery Attributes are a relatively new feature of the MySQL Protocol. This is availble since MySQL 8.0.23./p pBefore Query Attributes were introduced there already was already another similar feature: Connetion Attributes, which provides per-connection metadata in the form of key/value pairs./p pThis is what connection attributes look like:/p precodemysql> SELECT ATTR_NAME, ATTR_VAL [...]

Exploiting the Powerful Filtering Capabilities of Tungsten Replicator (from Continuent Blog)

In this blog we take a look at how you can use Tungsten Replicator to replicate data from multiple sources, and merge into a single target using 3 simple yet effective filters.Tags: MySQLMariaDBreplication filtersfiltering [...]

More MariaDB releases, right before the webinar! (from Galera Blog)

So we initially planned to use MariaDB Server 11.7 for the upcoming webinar on 19 February, but we decided that it would be wise to upgrade to 11.8 RC which just became a release candidate. 11.7 is a short term release, and it comes with the all important Vector support, which we are pleased to […] [...]

How to Use IAM Roles for Service Accounts (IRSA) with Percona Operator for MongoDB on AWS (from Percona Community Blog)

Introduction Percona Operator for MongoDB is an open-source solution designed to streamline and automate database operations within Kubernetes. It allows users to effortlessly deploy and manage highly available, enterprise-grade MongoDB clusters. The operator simplifies both initial deployment and setup, as well as ongoing management tasks like backups, restores, scaling, and upgrades, ensuring sea [...]

Sunday, 16. February 2025

Vector indexes, MariaDB & pgvector, large server, dbpedia-openai dataset (from Small Datum)

pThis post has results from ann-benchmarks to compare MariaDB and Postgres with a larger dataset, dbpedia-openai at 100k, 500k and 1M rows. It has 1536 dimensions and uses angular (cosine) as the distance metric. By larger I mean by the standards of what is in ann-benchmarks. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation./pptl;dr/pulliIndex creat [...]

Saturday, 15. February 2025

Vector indexes, large server, dbpedia-openai dataset: MariaDB, Qdrant and pgvector (from Small Datum)

pMy previous post has results for MariaDB and pgvector on the dbpedia-openai dataset. This post adds results from Qdrant. This uses ann-benchmarks to compare MariaDB, Qdrant and Postgres (pgvector) with a larger dataset, dbpedia-openai at 500k rows. The dataset has 1536 dimensions and uses angular (cosine) as the distance metric. This work was done by Small Datum LLC and sponsor [...]

Friday, 14. February 2025

Node Groups in TiDB Cloud: The Key to Scaling Workloads with Predictable Performance and Control (from PingCAP Blog)

pAs modern applications scale, ensuring consistent, predictable performance across different workloads becomes increasingly challenging. Transactional queries, real-time analytics, and batch jobs often compete for resources, leading to slowdowns, inefficient resource allocation, and unpredictable database behavior. With Node Groups in TiDB Cloud, organizations can assign dedicated TiDB node compute [...]

Tuning MariaDB timeouts that affect applications (from Vettabase)

MariaDB has many configurable timeouts. Some of them can only be configured by DBAs (database administrators). Others can be adjusted by developers in the application code, though DBAs can configure defaults. MariaDB timeouts can be grouped in these categories: But why would one change the default timeouts? Isn’t it dangerous? Actually the default timeouts are very high, so they are only hit [...]

Orchestrator (for Managing MySQL) High Availability Using Raft (from Percona Database Blog)

♦As we know, Orchestrator is a MySQL high availability and replication management tool that aids in managing farms of MySQL servers. In this blog post, we discuss how to make the Orchestrator (which manages MySQL) itself fault-tolerant and highly available. When considering HA for the Orchestrator one of the popular choices will be using the Raft consensus. […] [...]

Forecast MySQL IOPS (from MinervaDB Blog)

pThis technical guide offers a comprehensive approach to forecasting MySQL Input/Output Operations Per Second (IOPS) using Performance Schema metrics. Since understanding and accurately predicting IOPS is crucial for database performance optimization, capacity planning, and maintaining [...]/p pThe post Forecast MySQL IOPS appeared first on The WebScale Database Infrastructure Operations Experts in [...]

Thursday, 13. February 2025

TiDB Cloud CONNECTED Care: Elevate Your Support with Seamless, Real-Time Connectivity (from PingCAP Blog)

pTiDB Cloud has always delivered a high-performance, distributed SQL solution. However, we’re now taking it a step further with TiDB Cloud CONNECTED Care, our refreshed support service. Whether you’re a new customer exploring TiDB Cloud or an existing user looking to upgrade to Enterprise or Premium tiers, CONNECTED Care offers seamless, real-time connectivity, ensuring you […]/p pThe p [...]

How GaadiBazaar reduced database costs by 40% with Aurora MySQL Serverless (from AWS Database Blog)

GaadiBazaar draws on over 25 years of vehicle finance expertise from Cholamandalam to connect vehicle buyers and sellers. Their mission is to enable hassle-free transactions at fair prices through buyer-seller interactions and end-to-end financial assistance. This post shows you how GaadiBazaar, an online platform for buying and selling vehicles, achieved significant database cost savings by migrat [...]

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

pAmazon Relational Database Service (RDS) for MySQL announces Amazon RDS Extended Support minor version 5.7.44-RDS.20250103. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of MySQL. Learn more about the bug fixes and patches in this version in the Amazon RDS User Guide.br br Amazon RDS Extended Support provides you more time, up to thr [...]

Announcing Yearly LTS Releases for MariaDB Community Server (from MariaDB Corporation Blog)

In order to give MariaDB community users predictability on when long term maintenance (LTS) versions will be available, MariaDB is … Continued [...]

Announcing MariaDB Community Server 11.7 GA with Vector Search and MariaDB Community Server 11.8 RC (from MariaDB Corporation Blog)

MariaDB Community Server 11.7 is now generally available (GA), and 11.8 is available as a release candidate (RC)! Both reinforce … Continued [...]

SingleStore Unveils No-Code Solution Designed to Cut Data Migration from Days to Hours (from ODBMS.org)

By streamlining data transfer and Change Data Capture, SingleStore Flow makes it easier for customers to harness its capabilities to power applications, analytics and AI. February 13, 2025 09:00 AM Eastern Standard Time SAN... [...]

Succeed with HeatWave – Part 3 (from The Oracle MySQL Blog)

This is the third part of our blog series showcasing how customers succeed with HeatWave. [...]

1995-2025: 30 years! (from The Oracle MySQL Blog)

MySQL turns 30 and we will celebrate this milestone all over the globe! [...]

How MySQL Enterprise Edition Supports Government Digital Transformation (from The Oracle MySQL Blog)

This blog post summarizes how MySQL supports government IT priorities, from cybersecurity protection to modernization, cost savings, and workforce transformation. [...]

Wednesday, 12. February 2025

Grupo Ótima Digital Trusts Readyset to Scale Growing MySQL Infrastructure (from Readyset Blog)

Brazil’s leading provider of messaging solutions, Group Ótima Digital, seamlessly integrates Readyset’s database scaling platform to scale their existing MySQL infrastructure with ZERO code changes [...]

5 Ways to Look at a Tungsten Active-Active MySQL Replication Issue (from Continuent Blog)

Replication is one of the most critical components of database management, especially in an Active-Active multi-primary composite cluster. However, with great flexibility comes the occasional hiccup. If you’re grappling with intermittent replication failures for a table in your Tungsten Cluster setup, here are five practical approaches to diagnose and resolve the issue.Tags: active-active repl [...]

New Year Reality Check: Slowing Down to better Move Forward (from The consistent voice)

pFollowing up on my “New Year, New Me” post — let’s be real, that whole idea is kinda bs right ? Change doesn’t just magically happen because the calendar flips to January. The idea we can reinvent ourselves overnight is unrealistic, and words without intents (and therefore actions) just sets us up for failure more than anything. But that doesn’t mean the end of year holidays and the weeks after ar [...]

MariaDB 11.8 is LTS (from MariaDB Foundation Blog)

pConfirming what you probably already expected: MariaDB Server 11.8 will be a long-term support release. br Now a Release Candidate – GA in Maybr With MariaDB Vector as the lead new feature, MariaDB 11.8 succeeds the previous LTS MariaDB 11.4 from a year ago. … /p pContinue reading \"MariaDB 11.8 is LTS\"/p pThe post MariaDB 11.8 is LTS appeared first on MariaDB.org./p [...]

Building generative AI apps locally (from Programming Brain)

Learn how to set up and run AI embedding models locally with MariaDB to store and query vector embeddings efficiently. [...]

Moving documentation in-product with the dolt_help table (from DoltHub Blog)

Dolt is the world's first and only version-controlled SQL database. As the only product in its category, there's a lot for our customers to… [...]

Tuesday, 11. February 2025

MySQL vs MongoDB: Best Choice for You (from ScaleGrid Blog)

pChoosing the right database often comes down to MongoDB vs MySQL. This article will help you understand the core differences in data structure, scalability, and use cases. Whether you need a relational database for complex transactions or a NoSQL database for flexible data storage, we’ve got you covered. Key Takeaways MySQL is a relational database.../p p<p>The post MySQL vs MongoDB: Best Ch [...]

MariaDB C Connector 3.4.4, 3.3.14, and 3.1.27, and Java Connector 3.5.2 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.4.4, 3.3.14, and 3.1.27, and Connector/Java 3.5.2. Download Now … Continued [...]

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM) (from Percona Database Blog)

♦A critical security vulnerability has been identified in the following software that Percona has made available: PMM Open Virtual Appliance (OVA) installations, version 2.38 and above. This vulnerability does not extend to Docker or Amazon Machine Images (AMIs). The Common Vulnerabilities and Exposures (CVE) identifier for this issue is CVE-2025-26701. Immediate actions required UPGRADE IMMEDIATEL [...]

Building an Interactive LLM Chatbot with HeatWave Using Python (from MySQL expert Diary)

pAI-powered applications require robust and scalable database solutions to manage and process large amounts of data efficiently. HeatWave is an excellent choice for such applications, providing high-performance OLTP, analytics, machine learning and generative artificial intelligence capabilities./p pIn this article, we will explore a Python 3 script that connects to an HeatWave instance and enables [...]

Vector indexes, MariaDB & pgvector, large server, large dataset: part 1 (from Small Datum)

pThis post has results from ann-benchmarks to compare MariaDB and Postgres with a larger dataset, gist-960-euclidean.  Previous posts (here and here) used fashion-mnist-784-euclidean which is a small dataset. By larger I mean by the standards of what is in ann-benchmarks. This dataset has 1M rows and 960 dimensions. The fashion-mnist-784-euclidean dataset has 60,000 rows and 784 dimensions. Bo [...]

Monday, 10. February 2025

MySQL Performance Tuning with Releem (from Vlad Mihalcea's Blog)

pIntroduction If your application uses MySQL and you’re interested in getting the best out of it via performance tuning and monitoring, then Releem is a very nice tool that can assist you in your endeavor. I discovered Releem from Roman Agabekov’s posts on social media. Roman is the founder of this tool, and since his posts about MySQL performance tuning are very insightful, I decided t [...]

Google’s generative AI Toolbox for Databases to help connect agents with databases (from InfoWorld)

pGoogle’s cloud computing division, Google Cloud, has added a new generative AI Toolbox for Databases to help enterprise developers connect agent-based generative AI applications to its databases./p pThe new Toolbox, which is currently in public beta, is an open-source server designed to streamline the creation, deployment, and management of AI agents capable of querying d [...]

Dolt for Beginners: Importing MySQL Dumps (from DoltHub Blog)

The Dolt for Beginners series focuses on topics people getting started with Dolt will likely be interested in. Most of our other blog… [...]

Friday, 07. February 2025

Encrypt PostgreSQL Data at Rest on Kubernetes (from Percona Database Blog)

♦The upcoming Percona Operator for PostgreSQL v2.6.0 release introduces support for PostgreSQL 17, which opens exciting possibilities for data security. Since pg_tde comes pre-installed in Percona’s official PostgreSQL 17 images, this release presents an excellent opportunity to implement Transparent Data Encryption in your Kubernetes-deployed databases. Let’s look at how to configure a [...]

MariaDB Day Brussels Aftertaste 2025-02 (from MariaDB Foundation Blog)

pBack from Brussels! With a bit of time to reflect, I’d like to share the aftertaste from our MariaDB Day, our very own FOSDEM Fringe Event. … /p pContinue reading \"MariaDB Day Brussels Aftertaste 2025-02\"/p pThe post MariaDB Day Brussels Aftertaste 2025-02 appeared first on MariaDB.org./p [...]

Thursday, 06. February 2025

Using TLS with MySQL 5.7 in Golang (from Skeema Blog)

pNew versions of the Go programming language are released every six months, and occasionally these releases tighten and modernize the standard library’s defaults for encryption behavior. Although these new defaults improve security, they can be problematic when connecting to older server software, such as MySQL 5.7, which is no longer being updated./p [...]

MySQL Router bootstrap & “conf-set-option” (from MySQL-Med)

How to parameterize your MySQL Router whilst bootstrapping: quick-n-easy with --conf-set-option. Continue reading → [...]

Wednesday, 05. February 2025

HeatWave MySQL: Latest Enhancements in DB System access mode and security (from The Oracle MySQL Blog)

Modern cloud databases need to offer flexibility in workload management, security and cross-region availability. To address these evolving demands, we have introduced new capabilities in HeatWave MySQL that improves operational efficiency and enables even more sophisticated deployment patterns. [...]

7 Amazing Benefits of Tungsten Active-Active Replication for MySQL (from Continuent Blog)

Discover the benefits of Tungsten Active-Active Clustering for MySQL. Learn how this solution ensures high availability, scalability, low-latency data access, and disaster recovery for businesses with global operations.Tags: tungsten clusterreplicationHigh AvailabilityscalabilityDisaster Recoverylow-latencyCloud [...]

MariaDB 11.4.5, 10.11.11, 10.6.21 and 10.5.28 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.4.5, MariaDB 10.11.11, MariaDB 10.6.21 and MariaDB 10.5.28, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates). … /p pContinue reading \"MariaDB 11.4.5, 10.11.11, 10.6.21 and 10.5.28 now available\"/p pThe post MariaDB 11.4.5, 10.11.11, 1 [...]

Dolt sql-server removes user and password arguments (from DoltHub Blog)

In the Dolt 1.49.0 release, we removed the ability to specify a username and an optional password when starting a sql-server. These… [...]

Tuesday, 04. February 2025

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.5, 10.11.11, 10.6.21, and 10.5.28 maintenance releases. See … Continued [...]

Writing User Defined Functions for MariaDB in Go (from MinervaDB Blog)

pThis guide provides a comprehensive walkthrough for creating User Defined Functions (UDFs) in MariaDB using the Go programming language. UDFs allow you to extend MariaDB’s functionality by implementing custom functions that can be called directly [...]/p pThe post Writing User Defined Functions for MariaDB in Go appeared first on The WebScale Database Infrastructure Operations Experts in Pos [...]

Succeed with HeatWave – Part 2 (from The Oracle MySQL Blog)

Ths blog represents the second part of our "Succeed with HeatWave" blog series, outlining how customers use HeatWave GenAI and HeatWave AutoML to accelerate their AI initiatives. [...]

Monday, 03. February 2025

January Product Update (from Readyset Blog)

Discover Readyset's December highlights: MySQL demo launch, product updates, AWS re:Invent recap, and upcoming events to kick off 2025! [...]

16 Best MySQL GUI Clients for macOS (from Devart MySQL Tool Blog)

pTake a look at the most convenient and user-friendly MySQL GUI tools (clients) that help you tackle a variety of database development, management, and administration tasks on macOS./p pThe post 16 Best MySQL GUI Clients for macOS appeared first on Devart Blog./p [...]

Friday, 31. January 2025

Blazing-Fast Cluster Recovery: How TiDB 8.1 Redefines Large-Scale Data Restoration (from PingCAP Blog)

pBackup and restore are critical for ensuring business continuity, with the Recovery Time Objective (RTO) serving as a key metric for assessing restore performance. As TiDB continues to grow in popularity for its scalability, many users have datasets reaching hundreds of terabytes (TBs). That means the challenge of ensuring a fast RTO for such large […]/p pThe post Blazing-Fast Cluster Recove [...]

Dolt database: first impressions (from Vettabase)

You might know that we maintain a list of Awesome Innovative Databases on GitHub. At the time of this writing, the first item in the list of active projects is curious: Dolt. If English isn’t your mother tongue, you might not know that it is a synonymous for idiot or… git. Someone told me that probably Linus chosen the name git because of its assonance with get and didn’t consider [...]

Your MySQL & MariaDB Galera Cluster and Galera Manager Best Practice Resources (from Galera Blog)

Happy 2025, it is a fresh year, and there have been plenty of resources to help you gain the most out of your Galera Cluster (be it on MySQL or MariaDB Server) and Galera Manager deployments, so here is a quick “best practices” guide. Did you know that in under 15 minutes, you can Deploy […] [...]

Why MariaDB Galera Cluster 11.4? (from Galera Blog)

If you read Changes and Improvements in MariaDB 11.4 you might think there are no MariaDB Galera Cluster changes in this long-term series, maintained until May 2029, but this is far from the truth. There are a few things that you can totally benefit from in MariaDB Galera Cluster, and this series continues from Why […] [...]

Changing HeatWave MySQL shape and configuration with minimal downtime (from The Oracle MySQL Blog)

The Oracle HeatWave MySQL service offers users the flexibility to modify DB system shapes and configuration, enabling them to adapt to changing workloads and enhance performance. In this blog post we'll share insights into the latest changes related to DB system shape and configuration changes, mostly focusing on the high availability and read replicas support. [...]

MySQL Partitioning in 8.0 (from Mydbops Blog)

Discover MySQL 8.0 partitioning strategies, including RANGE, HASH, LIST, and KEY partitioning, plus new subpartitioning features. Learn how to optimize database performance with partitioning best practices. [...]

Available now: OCI Database Management and Ops Insights for on-premises MySQL databases (from The Oracle MySQL Blog)

OCI Database Management and OCI Ops Insights services deliver advanced capabilities to simplify the monitoring of External MySQL databases, offer detailed granular insights, and reduce the burden of managing infrastructure resources. Additionally, as a cloud-native, managed solution, these services eliminate the need to maintain the monitoring solution itself. [...]

Percona Operator for MongoDB 1.19: Remote Backups, Auto-Generated Passwords, and More! (from Percona Community Blog)

The latest release of the Percona Operator for MongoDB, version 1.19, is here. It brings a suite of enhancements designed to streamline your MongoDB deployments on Kubernetes. This release introduces a technical preview of remote file server backups, simplifies user management with auto-generated passwords, supports Percona Server for MongoDB 8.0, and includes numerous other improvements and bug fi [...]

Thursday, 30. January 2025

JSON Showdown: Dolt vs MongoDB (from DoltHub Blog)

This is the fourth in a series of tests putting Dolt head-to-head against other database engines to see how they handle large JSON documents… [...]

Wednesday, 29. January 2025

Readyset and PerformanceDB Join Forces to Revolutionize MySQL Database Scaling in Brazil (from Readyset Blog)

We are thrilled to announce a transformative partnership with PerformanceDB, a leading database support and service provider, to better serve our customers across Brazil. [...]

On HeatWave, MySQL database and GenAI. Q&A with Nitin Kunal (from ODBMS.org)

Q1. You are one of the founding engineers of HeatWave. Can you tell us what are you current projects?  I am indeed one of the founding engineers of the HeatWave project, having written its first header file and designed and developed... [...]

Four reasons to visit MariaDB Day in Brussels (from MariaDB Foundation Blog)

pStill unsure about attending the MariaDB Day in Brussels on Saturday? Here are four reasons to turn up at our FOSDEM Fringe event.br 1.⁠ … /p pContinue reading \"Four reasons to visit MariaDB Day in Brussels\"/p pThe post Four reasons to visit MariaDB Day in Brussels appeared first on MariaDB.org./p [...]

Understanding and managing history list length in Azure Database for MySQL (from Azure for MySQL Blog)

pEfficient database management often requires digging deeply into metrics that reflect the internal state of the database server. While Azure Database for MySQL is already tuned for the best performance out of the box, workloads can vary significantly. One common performance issue arises from open transactions, those that stay active unintentionally because of bugs, errors in application logic, or [...]

Building and testing MySQL 8.0.41 / 8.4.4 / 9.2.0 on macOS (from Laurynas Biveinis' blog)

p Previously: 8.0.40 / 8.4.3 / 9.1.0 /p p Oracle released MySQL 8.0.41 / 8.4.4 / 9.2.0, and it's time for me to build and test it under macOS, of all things! /p p But first, a detour to the last set of releases Valgrind results, because its run took a few weeks on 9.1.0, and that's without code--big-test/code. A big part of tests timed out, or failed randomly. There appear no errors that are diag [...]

4 tiny Docker images for lightweight containers (from InfoWorld)

pDocker images can get pretty bulky if you’re not careful. Your typical Docker image includes everything you need to run a particular piece of software (such as the application language’s runtime) and everything those things depend on. Images in the hundreds of megabytes are common, often because they use as their base some variety of Linux distribution. Anything beyond a sta [...]

Percona Monitoring and Management 3.0.0-GA - Tech Preview (from Percona Community Blog)

We’re excited to announce the release of Percona Monitoring and Management (PMM) 3.0.0 GA. The Percona Monitoring and Management (PMM) 3.0.0 release delivers major security and stability enhancements. Notable security improvements include rootless deployments and encryption of sensitive data, along with improved API authentication using Grafana service accounts. Deployment options have expand [...]

Tuesday, 28. January 2025

Vector indexes, MariaDB & pgvector, large server, small dataset: part 2 (from Small Datum)

pThis post has results for vector index support in MariaDB and Postgres. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation. This is part 2 in a series that compares QPS and recall for the fashion-mnist-784-euclidean dataset using from 1 to 48 concurrent sessions on a large server. This is part 2 and part 1 is here. /ppThe purpose of this post is to explai [...]

Vector indexes, MariaDB & pgvector, large server, small dataset: part 1 (from Small Datum)

pThis post has results for vector index support in MariaDB and Postgres. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation. /ppMy previous posts (here and here) used a server with 8 cores and 32G of RAM. While that was OK for one of the smaller datasets from ann-benchmarks it wasn't enough for larger datasets and the problem was the amount of memory used by th [...]

TiProxy in TiDB: Achieve Zero Downtime Upgrades (from Mydbops Blog)

Discover TiProxy in TiDB, a powerful proxy component for load balancing, connection persistence, service discovery, and zero downtime upgrades. [...]

What’s New in TiDB 8.5? (from Mydbops Blog)

Discover the groundbreaking features of TiDB 8.5.0 LTS, including improved performance, scalability, security, and enhanced TiProxy capabilities. [...]

MySQL latest performance review (from TusaCentral - MySQL Blogs)

pThis article is focused on describing the latest performance benchmarking executed on the latest release of MySQL and Percona. ♦/p pIn this set of tests I have used the machine described here.  /p Assumptions pThere are many ways to run tests, and we know that results may vary depending on how you play with many factors, like the environment or the MySQL server settings. However, if [...]

Monday, 27. January 2025

Why MariaDB Galera Cluster 10.11? (from Galera Blog)

Why MariaDB Server with Galera Cluster 10.11, you might ask? Well, there are plenty of Galera Cluster improvements that one might consider, and know that it rolls up with features that we have been contributing in the rolling short-term releases from 10.7/10.8/10.9/10.10. So, MariaDB Server 10.11 is a long-term support release which means you get […] [...]

How can we tune Redo Buffer in InnoDB for optimal performance? (from MinervaDB Blog)

pOptimizing InnoDB’s redo buffer is a critical aspect of MySQL database performance tuning. This technical document explores various strategies and configurations to enhance the efficiency of the redo buffer system, which plays a vital role [...]/p pThe post How can we tune Redo Buffer in InnoDB for optimal performance? appeared first on The WebScale Database Infrastructure Operations Experts [...]

Saturday, 25. January 2025

Evaluating vector indexes in MariaDB and pgvector: part 2 (from Small Datum)

pThis post has results from the ann-benchmarks with the fashion-mnist-784-euclidean dataset for MariaDB and Postgres (pgvector) with concurrent queries (--batch). My previous post has results when not using concurrent queries. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation./ppI compare MariaDB with pgvector because I respect the work that the Postgres commu [...]

Evaluating vector indexes in MariaDB and pgvector: part 1 (from Small Datum)

pThis post has results for vector index support in MariaDB and Postgres. I am new to vector indexes so I will start small and over time add more results.  This work was done by Small Datum LLC and sponsored by the MariaDB Corporation.brbrI compare MariaDB with pgvector because I respect the work that the Postgres community has done to support vector search workloads. And I am happy to report t [...]

Friday, 24. January 2025

Bun 1.2 squashes Node.js compatibility bugs (from InfoWorld)

pBun 1.2, an update to the all-in-one runtime and toolkit for building, running, and testing full-stack JavaScript and TypeScript applications, has arrived, boasting dramatic improvements in Node.js compatibility. The new version also adds a built-in Amazon S3 object storage API and a built-in PostgreSQL client. /p pBun 1.2 was announced on January 22. With version 1.2, th [...]

How does Galera Cluster behave with many nodes? (from Shinguz's Blog)

pRecently I had the opportunity to have a lot of Linux systems (VMs with Rocky Linux 9) from one of our regular Galera Cluster trainings all to myself for a week. And MariaDB 11.4.4 with Galera Cluster was already installed on the machines./p pSince I had long wanted to try out how a Galera Cluster behaves with an increasing number of nodes, now was the opportunity to try it out./p pThe following [...]

Using sqlx in Go to Query Dolt (from DoltHub Blog)

DoltDB is an open-source SQL database that also includes all the features of Git – Git gives you distributed version control for files, Dolt… [...]

Thursday, 23. January 2025

MariaDB Contribution Statistics, January 2025 (from MariaDB Foundation Blog)

pHere comes the Q4 2024 contributions report. The raw data which contains also statistics until today can be found on GitHub, here.br Server contributionsbr Just like last quarter, I’m going to start with a breakdown of all the organisations who have contributed to MariaDB Server during 2024. … /p pContinue reading \"MariaDB Contribution Statistics, January 2025\"/p pThe post MariaDB Co [...]

Methods to Copy Data Using dbForge for MySQL (from Devart MySQL Tool Blog)

pData copying and migration are essential database tasks that arise frequently. Many tools assist database professionals in performing these tasks, with dbForge Studio for MySQL standing out as the most reliable solution. /p pThe post Methods to Copy Data Using dbForge for MySQL appeared first on Devart Blog./p [...]

Succeed with HeatWave – Part 1 (from The Oracle MySQL Blog)

This blog introduces HeatWave, a cloud service that integrates AI, transactions, and analytics in a single solution, with a focus on HeatWave MySQL. It outlines common challenges faced by businesses using MySQL. The blog also highlights use cases across various industries and provides a step-by-step migration program for businesses looking to move to HeatWave MySQL. Overall, it emphasizes HeatWave’ [...]

Dolt for Beginners: Dolt Basics (from DoltHub Blog)

Dolt is like Git and MySQL had a baby. What does that mean in practice? We've been building Dolt for over six years now. We've been writing… [...]

Wednesday, 22. January 2025

Amazon Redshift announces support for History Mode for zero-ETL integrations (from AWS What's New)

pToday, Amazon Redshift announces the launch of history mode for zero-ETL integrations. This new feature enables you to build Type 2 Slowly Changing Dimension (SCD 2) tables on your historical data from databases, out-of-the-box in Amazon Redshift, without writing any code. History mode simplifies the process of tracking and analyzing historical data changes, allowing you to gain valuable insights [...]

Using Blue/Green Deployment For (near) Zero-Downtime Primary Key Updates in RDS MySQL (from Percona Database Blog)

♦Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the table definition. Since RDS replication does not use asynchronous for its replication, the typical switchover procedure is not feasible. However, the Blue/Green feature of RDS utilizes asynchronous replication, which allows us to update the table […] [...]

Analyzing the Similarity of Spatial Trajectories in MySQL (from The Oracle MySQL Blog)

In this blog post, we will explore how to use MySQL's spatial features to analyze the similarity of trajectories. We will focus on key metrics such as Frechet distance, which measures the similarity between two trajectories, and other geometric operations that help quantify how closely different paths align. This functionality is available in MySQL Community and Enterprise Editions and HeatWave My [...]

Transforming GPS data into trajectories using MySQL (from The Oracle MySQL Blog)

Transforming GPS coordinates into trajectories in MySQL involves organizing raw GPS points (as POINT geometries) into ordered paths and converting them into LINESTRING geometries. This process uses MySQL's spatial functions like ST_Collect to aggregate points and requires ensuring proper ordering (e.g., by timestamp or sequence) to construct accurate routes. [...]

Transformations between Spatial Reference Systems in MySQL (from The Oracle MySQL Blog)

This blog post explores how to transform spatial data between different Spatial Reference Systems (SRS) in MySQL using the ST_Transform function. It covers the syntax and usage of ST_Transform, and its practical applications in mapping and spatial analysis by using demonstrative examples. Whether you're visualizing geographic data or integrating datasets from various sources, understanding SRS tran [...]

Introducing the new CREATE_SPATIAL_REFERENCE_SYSTEM privilege in MySQL (from The Oracle MySQL Blog)

MySQL 9.2.0 has introduced a new dynamic privilege: CREATE_SPATIAL_REFERENCE_SYSTEM. This privilege enables users to create, replace, and drop custom spatial reference systems (SRS), allowing for greater spatial data customization across MySQL environments without needing SUPER access. In this post, we’ll explain the use of this privilege and provide an example to demonstrate its application. The n [...]

Tuesday, 21. January 2025

Amazon Aurora now supports R7g and R7i database instances in Asia Pacific (Malaysia) Region (from AWS What's New)

pAWS Graviton3-based R7g database instances as well as R7i database instances are now available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in Asia Pacific (Malaysia) Region. AWS Graviton3 instances provide up to 30% performance improvement and up to 20% price/performance improvement over Graviton2 instances for Amazon Aurora, depending on the database [...]

Introducing Virtual Canary Maintenance: Early access to Azure Database for MySQL updates (from Azure for MySQL Blog)

pWe are thrilled to announce the Public Preview of Virtual Canary Maintenance for Azure Database for MySQL. This innovative feature provides you with early access to maintenance updates, allowing you to validate workload compatibility with upcoming Azure Database for MySQL enhancements and contribute to the continuous improvement of the service./p Why Virtual Canary Maintenance? pAzure Database for [...]

A Review of 2024 in the Database World (from Vettabase)

It’s January 2025, so it’s a good time to look back, and write my thoughts on the most important events and trends of 2024 in the database world. Would you like to share your thoughts? I’d be happy to read your comments. How does MariaDB compare to MySQL? MariaDB Foundation sponsored benchmarks by a well-known, independent consultant, Mark Callaghan. Mark worked for Informix, Orac [...]

Introducing the Connection-Control Component in MySQL 9.2 : A Powerful Tool for Connection Management (from The Oracle MySQL Blog)

The MySQL Connection-Control Component allows database administrators to enforce limits on client connections based on frequency and behavior. It is especially useful in preventing denial-of-service (DoS) attacks, mitigating resource exhaustion, and regulating access during high-load scenarios. [...]

Exporting query results to object storage with HeatWave (from The Oracle MySQL Blog)

We take a look how you can use HeatWave to build your medallion data lake, transform data, create aggregates, perform format conversions, and enrich your data and make it available for use by HeatWave or other applications. HeatWave can write results of queries to object storage in standard formats like CSV or Parquet. This data can then be used by other applications or loaded back into HeatWave as [...]

TOP 10 MySQL GUI Tools for Efficient Database Management on Windows [2025] (from Devart MySQL Tool Blog)

pSelecting the ideal GUI tool for MySQL and MariaDB databases can be challenging. This article provides a summary of the top functional and user-friendly GUI options for these widely-used database systems. It outlines their advantages and disadvantages and offers extra guidance to assist you in making an informed decision./p pThe post TOP 10 MySQL GUI Tools for Efficient Database Management on Wind [...]

Register for MariaDB Day Sessions 1 Feb 2025 (from MariaDB Foundation Blog)

pTime to sign up! The schedule is out for our first 2025 MariaDB Day, in Brussels 1 Feb 2025.br And what a schedule it is, with insightful presentations by top-brass presenters. … /p pContinue reading \"Register for MariaDB Day Sessions 1 Feb 2025\"/p pThe post Register for MariaDB Day Sessions 1 Feb 2025 appeared first on MariaDB.org./p [...]

WeSQL Disaster Recovery across Regions - WeSQL Replication Solution with S3 storage (from WeSQL Blog)

This blog introduces how to build a disaster recovery cluster across AWS Regions using WeSQL Replication. [...]

Monday, 20. January 2025

MariaDB Galera Cluster webinar 19th of February (EMEA and USA timezone) (from Galera Blog)

MariaDB Server comes with MariaDB Galera Cluster built-in, and it has a new release model, and a lot of new Galera Cluster features, since the replication layer within MariaDB Server is also rapidly changing. Come learn how about the new features, and how to use: * vectors with Galera Cluster * mix asynchronous replication with […] [...]

A Tale of Two Swans: The Story Behind Continuent’s Logo (from Continuent Blog)

Discover the story behind Continuent's logo, showcasing two swans that represent the company's Finnish heritage and dedication to lasting customer partnerships. These swans embody both the elegance of seamless operations and the hard work of the Continuent team in delivering top-tier MySQL high availability and disaster recovery solutions. The logo reflects Continuent's unwavering commitment to rel [...]

Friday, 17. January 2025

4 Database Trends Data-Intensive Businesses Need to Watch in 2025 (from PingCAP Blog)

pIt’s that time of year again for a look back at the database industry. 2024 wasn’t so much about groundbreaking database technologies, but rather the explosive growth of AI-plus-data applications. That said, core database tech hasn’t remained idle either, as cloud infrastructure became the de facto standard for deployment.  So, without further adieu, here are […]/p pTh [...]

Json2SQL : a simple RESTful API for MariaDB (from The consistent voice)

Json2SQL : a simple RESTful API for MariaDBpHi everyone!/ppI’m thrilled to share my latest open-source project on GitHub: Simple RESTful API for MariaDB.brThis project is designed to make it easier than ever to interact with your MariaDB databases through a lightweight, efficient, and easy-to-use RESTful API. Whether you’re building web apps, mobile apps, or automations, this tool provides seamless [...]

What’s the Cost of Counting MySQL Table Rows? (from Percona Database Blog)

♦What index will be used when you count all rows in a table? Well, the MySQL documentation provides a straightforward answer to this, quoting: InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. If a secondary index is […] [...]

Thursday, 16. January 2025

MySQL January 2025 GA Releases Now Available (from The Oracle MySQL Blog)

MySQL January 2025 GA Releases Now Available [...]

Introducing MariaDB MaxScale 25.01 GA (from MariaDB Corporation Blog)

As part of the MariaDB Enterprise Platform 2025 launch, we are happy to announce that MariaDB MaxScale 25.01 is also … Continued [...]

Introducing Vector Search With the Latest Version of MariaDB Enterprise Platform (from MariaDB Corporation Blog)

We are excited to announce the launch of a new version of MariaDB Enterprise Server that features native support for … Continued [...]

Announcing New Release of MariaDB Enterprise Platform (from MariaDB Corporation Blog)

Building on our history of delivering enterprise database solutions, we are launching a new iteration of the MariaDB Enterprise Platform. … Continued [...]

Percona Everest: An Open Source Solution for MongoDB Sharding and Backups (from Percona Database Blog)

♦The increase of cloud-native technologies is transforming how we manage databases. Since I stepped into the world of databases and cloud-native technologies, I have encountered several initiatives aimed at developing and optimizing database operations in the cloud, and Kubernetes plays a crucial role in this shift through Operators. While the core concepts and techniques of […] [...]

ProxySQL Performance Tuning: Unlocking Optimal Database Performance (from ProxySQL Blog)

pOptimizing database interactions is critical to maintaining operational efficiency. According to Gartner, the global Database Management Systems (DBMS) market is projected to reach $203 billion by 2027, emphasizing the growing need for efficient database management solutions. A McKinsey report further highlights that organizations effectively managing their data can see 20% to 25% productivity gai [...]

Announcing Vector Indexes (from DoltHub Blog)

Back in September, we announced that we were looking at adding support for Vectors and Vector Indexes to Dolt. It seems like every SQL… [...]

Wednesday, 15. January 2025

2024 Recap: Key Innovations and Enhancements in HeatWave MySQL (from The Oracle MySQL Blog)

2024 was a productive year for HeatWave MySQL product line with many important enhancements in several areas. We achieved critical milestones in areas of availability, disaster recovery, performance, system management, operations and productivity. Let’s take a look some of the key features. [...]

How MySQL Enterprise Edition Can Help Your Organization Achieve DORA Compliance (from The Oracle MySQL Blog)

The financial services industry is facing a new regulation: the Digital Operational Resilience Act (DORA). One of the key requirements of DORA is that financial institutions must have a robust riskmanagement framework in place. This framework must identify, assess, and mitigate ICT risks. MySQL Enterprise Edition can help organizations achieve DORA compliance byproviding a number of features that [...]

Using Azure Automation PowerShell runbooks with MySQL flexible servers (from Azure for MySQL Blog)

pYou can use Azure Automation PowerShell runbooks to automate several operations on Azure Database for MySQL flexible servers, which can help to optimize costs and streamline resource management and data management. By leveraging runbooks, you can schedule these operations to occur during off-peak hours or trigger them based on events. Using automation eliminates the need for manual intervention an [...]

On the results from the replication poll (from MariaDB Foundation Blog)

pHere are the results of a recent poll on LinkedIn and mariadb.org about the popularity of a few of the major replication features (I aggregated the results from the two sites):br What is your favorite MariaDB replication feature? … /p pContinue reading \"On the results from the replication poll\"/p pThe post On the results from the replication poll appeared first on MariaDB.org./p [...]

Tuesday, 14. January 2025

MySQL cloud services cost comparison: who provides the best value? (from The Oracle MySQL Blog)

This blog shows how HeatWave MySQL delivers substantially more value than the MySQL cloud services offered by AWS, Google Cloud, and Azure. Furthermore, not only can you power your OLTP applications using HeatWave MySQL but you also get built-in lakehouse-scale analytics, generative AI, and machine learning at no additional cost [...]

TiDB’s Chat2Query: Instant Business Insights, No SQL Required (from PingCAP Blog)

pWhat if you could interact with your data just like you would with a colleague? No need for complicated SQL queries or advanced data analysis tools—just ask your data a question and get an immediate, clear answer. Sounds like magic, right? Well, it’s not. It’s TiDB’s Chat2Query, and it’s changing the game in how businesses […]/p pThe post TiDB’s Chat2Query: Instant Business Insights, N [...]

It’s all about the attitude (from The consistent voice)

pMy professional journey in an MLM network has been a transformative experience, deepening my understanding of soft skills, personal growth, and leadership. Through this path, I’ve gained valuable insights from figures like Michael Jordan, John Maxwell, Tony Robbins, and Richard Branson. Their teachings on resilience, communication, and intentional leadership have shaped my approach to leadership — [...]

TiDB Garbage Collection (GC): Lifecycle, Configuration, and Best Practices (from Mydbops Blog)

Learn about TiDB's Garbage Collection (GC) lifecycle, configuration options, and tuning best practices. [...]

Automating cherry-picks between OSS and private forks (from PlanetScale Blog)

Learn how PlanetScale keeps its private fork of Vitess up-to-date with OSS [...]

Dissecting an Extreme Sparse MySQL Table Using ibdNinja (from Zhao Song's Blog)

I previously wrote a blog post to introduce the concept of MySQL B+ Tree splits and explained how to deliberately construct a highly sparse table by hacking the current rules. Then in the next post, I introduced ibdNinja, a tool I developed to parse the MySQL data file. In this follow-up post, I demonstrate how to use ibdNinja to analyze and verify this table’s data file. [...]

Monday, 13. January 2025

Using Airbyte to migrate data to Oracle HeatWave on OCI (from The Oracle MySQL Blog)

Explore open source ETL tool, Airbyte to synchronise data from various data sources such as cloud database (AWS, Azure, GCP) or on-premises databases (MySQL, PostgreSQL, etc) to Oracle HeatWave on OCI. [...]

How can you implement Inline view in MariaDB? (from MinervaDB Blog)

pBasic Syntax Key Features Mandatory Alias Unlike Oracle, MariaDB requires explicit aliases for inline views. For example: Algorithm Options MariaDB supports three view algorithms: Limitations MERGE Algorithm Restrictions Inline views cannot use MERGE if they [...]/p pThe post How can you implement Inline view in MariaDB? appeared first on The WebScale Database Infrastructure Operations Experts in [...]

The Power of MySQL: What Makes It the World’s Favorite Database? (from The Oracle MySQL Blog)

The 2024 JetBrains Developer Ecosystem Report reaffirms what millions of developers already know—MySQL is the #1 database. According to the report, "MySQL continues to be the most widely used database, favored by developers across various domains for its reliability and ease of use. [...]

Recap of the MySQL Community Advent Calendar 2024 Posts (from The Oracle MySQL Blog)

Advent Calendar Recap 2024 [...]

Scaling Database Connections (from WeSQL Blog)

Have you ever wonder why do databases limit the maximum number of connections? [...]

Friday, 10. January 2025

Gaining Actionable Insights: Complex Data Analysis Made Simple with TiInsight (from PingCAP Blog)

pIn today’s fast-paced business world, quick, data-driven decisions are crucial. However, for many, data analysis can seem daunting, especially without the technical skills to navigate complex databases. That’s where TiInsight shines: an intuitive and innovative platform built with the Chat2Query OpenAPI, designed to allow you to gain clear, actionable insights from complex data. An open-source [&# [...]

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

pAmazon RDS for MariaDB now supports MariaDB Innovation Release 11.7 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.7 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 [...]

Indexing to optimize Data Ingestion in MongoDB (from MinervaDB Blog)

pWhat are the best indexing strategies for improving data ingestion speed in MongoDB? To improve data ingestion speed in MongoDB, it’s essential to implement carefully considered indexing strategies that balance write performance with query efficiency. [...]/p pThe post Indexing to optimize Data Ingestion in MongoDB appeared first on The WebScale Database Infrastructure Operations Experts in [...]

Sysbench performance over time for InnoDB and MyRocks: part 4 (from Small Datum)

pThis is part 4 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. For previous posts, see part 1, part 2 and part 3. This post covers performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32 using a server with 32 cores and 128G of RAM.brbrI don't claim that th [...]

Kickstart Your Distributed SQL Journey: Setting Up TiDB Locally with TiUP Playground (from PingCAP Blog)

pTiDB is a powerful, open-source distributed SQL database built for handling both transactional and analytical workloads. With its MySQL compatibility, horizontal scalability, and real-time HTAP capabilities, it’s designed for modern, cloud-native architectures. In this distributed SQL tutorial, we’ll walk you through setting up a local TiDB cluster for development and testing in just a few [ [...]

Oracle to PostgreSQL Migration Series – NoValidate and Parallel Constraints in PostgreSQL (from MinervaDB Blog)

pCan you implement NoValidate and Parallel Constraints in PostgreSQL? Oracle to PostgreSQL Migration Blog series PostgreSQL does not have a direct equivalent to Oracle’s NOVALIDATE option for constraints. However, there are some strategies to achieve [...]/p pThe post Oracle to PostgreSQL Migration Series – NoValidate and Parallel Constraints in PostgreSQL appeared first on The WebScale [...]

Sysbench performance over time for InnoDB and MyRocks: part 3 (from Small Datum)

pThis is part 3 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. For previous posts, see part 1 and part 2. This post covers performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32 using a server with 24 cores and 64G of RAM.brbrI don't claim that the MyRocks CPU overhead i [...]

Sysbench performance over time for InnoDB and MyRocks: part 2 (from Small Datum)

pThis is part 2 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. Part 1 of this series is here. Part 1 documents performance regressions from MySQL 5.6 to 8.0. This post and the ones that follow cover performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32./ppI don't claim that [...]

Thursday, 09. January 2025

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

pThe latest addition to the continuous advancements in Azure Database for MySQL is the introduction of Azure Database for MySQL bindings for Azure Functions, now available in Public Preview. These newly released input and output bindings enable seamless integration with Azure Functions, allowing developers and organizations to build at-scale event-driven applications and serverless APIs that integr [...]

Vacasa’s migration to Amazon Aurora for a more efficient Property Management System (from AWS Database Blog)

Vacasa is North America’s leading vacation rental management platform, revolutionizing the rental experience with advanced technology and expert teams. In the competitive short-term vacation property management industry, efficient systems are critical. To maintain its edge and continue providing top-notch service, Vacasa needed to modernize its primary transactional database to improve performance, [...]

PCI DSS 4.0 Compliance and MySQL (from The Oracle MySQL Blog)

PCI DSS 4.0 Compliance and MySQL [...]

Embrace simplicity (from The consistent voice)

pThe evolution of software architecture has seen a significant shift from traditional spaghetti monoliths to more distributed and flexible approaches. Initial tightly-coupled monolithic systems, often characterized by complex interdependencies were rather difficult to maintain and a nightmare to scale. This lack of flexibility and fault isolation prompted the development of Service-Oriented Archite [...]

How To Detect Account Intruders Using AWS CloudTrail (from Continuent Blog)

Securing your cloud environment is now more critical than ever. As organizations increasingly rely on cloud platforms like Amazon Web Services (AWS), the potential for security breaches and unauthorized access becomes a pressing concern. AWS CloudTrail is a powerful tool that can help you monitor and detect suspicious activities in your AWS account. This blog post will guide you through the process [...]

preFOSDEM MySQL Belgian Days 2025 – Agenda (from lefred's blog)

The preFOSDEM MySQL Belgian Days 2025 will occur at the usual place (ICAB Incubator, Belgium, 1040 Bruxelles) on Thursday, January 30th, and Friday, January 31st, just before FOSDEM. Again this year, we will have the chance to have incredible sessions from our Community and the opportunity to meet some MySQL Engineers from Oracle. DimK will […] [...]

preFOSDEM MySQL Belgian Days 2025 - Agenda (from The Oracle MySQL Blog)

This is the agenda of the preFOSDEM MySQL Belgian Days 2025, an Oracle MySQL technical event managed by the MySQL Community Team for customers, partners & community users. [...]

Sysbench performance over time for InnoDB and MyRocks: part 1 (from Small Datum)

pI spent much time in 2024 documenting performance regressions from old to new versions of MySQL with InnoDB and MyRocks. More posts will be published in 2025, including this sequence of posts, but my work on that is winding down. Most of the problems are from many small regressions rather than a few big ones and it is very expensive to find and fix regressions long after they arrive.brbrHopefully [...]