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

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

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

MySQL Meetups & celebration events [...]

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

Percona Monitoring and Management 3.0.0 (GA) (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 [...]

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

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

Database Sharding (from PlanetScale Blog)

Learn about the database sharding scaling pattern in this interactive blog. [...]

Wednesday, 08. January 2025

Attaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification (from Percona Database Blog)

♦This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it is nice to capture the image of the graph when you receive the alert. We will see how to capture and attach the image of the graph when receiving the alert notification (email, telegram, Slack, […] [...]

Best 7 DBVisualizer Alternatives (from Devart MySQL Tool Blog)

pDiscover why dbForge Edge is the top DBVisualizer or DBeaver alternative for database management. Learn how dbForge Edge surpasses DBVisualizer and DBeaver in functionality and efficiency./p pThe post Best 7 DBVisualizer Alternatives appeared first on Devart Blog./p [...]

Tuesday, 07. January 2025

Tracking MySQL Query Plans Part I and Rebooting This Blog (from PHP With MySQL)

pDid you ever need to determine the performance of a query over time? One of the problems with database query optimizations is that the underlying data is always churning. Add in an increase in the number of users, expanding server demand use, and other items that impact your query. What was optimized is no longer performing as expected./ppMySQL added a JSON format option to the output of the EXPLA [...]

Easier Oracle to MariaDB Migrations with sql_mode and DBeaver (from MariaDB Corporation Blog)

If you’re considering migrating from Oracle to MariaDB, you need to know the sql_mode configuration property in MariaDB as well … Continued [...]

MySQL with Diagrams Part Two: How KILL Works (from Percona Database Blog)

♦Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication Architecture). We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and provide sample demonstrations to help you better understand. Many people think they know […] [...]

Monday, 06. January 2025

How To Import and Export Databases in MySQL or MariaDB (from RoseHosting Blog)

pThis blog post is about importing and exporting databases in MySQL or MariaDB. Importing and Exporting are fundamental processes that ... /p pRead More/p pThe post How To Import and Export Databases in MySQL or MariaDB appeared first on RoseHosting./p [...]

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

MySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed (from Percona Database Blog)

♦At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. In particular, the performance deterioration in the MySQL 8.4.x and 9.y versions caught our attention, as highlighted in Marco Tusa’s insightful blog post, Sakila, Where Are You Going? We’re pleased to report that the latest […] [...]

MySQL 8.4 Support in Percona Toolkit 3.7.0 (from Percona Community Blog)

Percona Toolkit 3.7.0 has been released on Dec 23, 2024. The main feature of this release is MySQL 8.4 support. In this blog, I will explain what has been changed. A full list of improvements and bug fixes can be found in the release notes. TLDR; Replication statements in 8.4 are fully supported by the Percona Toolkit pt-slave-delay has been deprecated. pt-slave-find has been renamed to pt-replica- [...]

ibdNinja: A powerful tool for parsing and analyzing MySQL 8.0 (.ibd) data files (from Zhao Song's Blog)

MySQL 8.0 introduced instant add column and instant drop column operations, allowing multiple data formats to exist within the same table. This added complexity makes developing external tools for record-level parsing and analysis of MySQL .ibd files more complex compared to versions 5.6 and 5.7. Additionally, MySQL Server lacks robust mechanisms for detailed table usage statistics, such as accurat [...]

Friday, 03. January 2025

Mastering Transaction Management in InnoDB: Optimizing COMMIT, ROLLBACK, and SAVEPOINT for Performance and Integrity (from MinervaDB Blog)

pImplementing COMMIT, ROLLBACK, and SAVEPOINT in InnoDB for Optimal Performance Transaction management is a fundamental aspect of relational database systems, and InnoDB provides robust support for transactions. Effective use of COMMIT, ROLLBACK, and SAVEPOINT can significantly improve data integrity [...]/p pThe post Mastering Transaction Management in InnoDB: Optimizing COMMIT [...]

Thursday, 02. January 2025

Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects (from AWS Database Blog)

In this post, we focus on working with the features of mysql_fdw PostgreSQL extension on Amazon RDS for PostgreSQL to help manage a large set of data that on an external database scenarios. It enables you to interact with your MySQL database for importing individual/large/selectively number of objects at the schema level and simplifying how we get information about the MySQL/MariaDB schema, to make [...]

Reflections on a year of biking for 2024 (from Jeremy Cole)

Since shortly after moving to Seattle in July 2022, I have not driven a car. I’ve gotten around by bike and public transit. During 2023, I stayed mostly in the Seattle region, with the exception of a trip to Victoria BC for Tour de Victoria and back to Seattle by bike. In the fall of […] [...]

Dolt MySQL Differences (from DoltHub Blog)

Here at DoltHub, we tell users "Dolt is a drop in replacement for MySQL". We're also quick to remind users that "There is no MySQL code in… [...]

Tuesday, 31. December 2024

TiDB Sync-Diff Inspector (from Mydbops Blog)

Discover how to maintain data integrity during migrations with TiDB Sync-Diff Inspector [...]

MariaDB highlights in 2024: Vectors, K1, and contributions (from MariaDB Foundation Blog)

pNew Year’s Eve is when everyone takes stock of the year that has passed. At MariaDB Foundation, we’re no different.br The technical highlight: MariaDB Vectorbr It’s not hard to pick the technical MariaDB highlight of the year: It’s MariaDB Vector. … /p pContinue reading \"MariaDB highlights in 2024: Vectors, K1, and contributions\"/p pThe post MariaDB highlights in 20 [...]

What we’ve developed in 2024 (from MariaDB Foundation Blog)

pAs Chief Development Officer of the MariaDB Foundation, I’ve worked to ensure that our development efforts focus where they matter most. On this final day of 2024, I want to reflect on the significant technical achievements we’ve accomplished and the collaborative processes that made them possible. … /p pContinue reading \"What we’ve developed in 2024\"/p pThe post What we’ve dev [...]

Monday, 30. December 2024

A Beginner’s Guide to Database Sharding: How to Scale Your Database Effectively (from ProxySQL Blog)

pAs businesses grow, so do their data needs. A small application that once handled a few users can quickly evolve into a system that supports thousands—or even millions—of transactions daily.  According to IDC, the global volume of data is predicted to reach 175 zettabytes by 2025, putting immense pressure on database systems to manage [...]/p pThe post A Beginner’s Guide to Database Sharding: How [...]

Multitenant data management with TiDB (from InfoWorld)

pIn a previous article, we explored various approaches to managing data for multitenant applications. We examined the benefits, compromises and limitations of different deployment models, including share-nothing, share-everything, and hybrid. We discussed the needs and challenges of each approach, from ensuring data isolation and scalability to managing customized tenant requ [...]

MySQLTuner for Windows: Common Issues and Better Alternatives (from Releem Blog)

In this article, we'll cover the specific hurdles you might encounter with MySQLTuner on Windows, explore some viable alternatives for optimizing your database performance with ease. [...]

Dolt Wrapped 2024: A Year in Review (from DoltHub Blog)

Spotify Wrapped popularized a version of the "year in review" format. Now everything is "wrapped". Why can't Dolt be wrapped too? Turns out… [...]

Sunday, 29. December 2024

Speedb vs RocksDB on a large server (from Small Datum)

pI am happy to read about storage engines that claim to be faster than RocksDB. Sometimes the claims are true and might lead to ideas for making RocksDB better. I am wary about evaluating such claims because that takes a lot of time and when the claim is bogus I am reluctant to blog about that because I don't want to punch down on a startup.brbrHere I share results from the RocksDB benchmark script [...]

Monitoring Multi-threaded Replication Lag With Performance Schema (from Hack MySQL)

pUsed to be that replication lag was as simple as codeSeconds_Behind_Master/code (renamed to codeSeconds_Behind_Source/code). But with multi-threaded replication (MTR) this is no longer the case. It’s time to relearn replication lag monitoring using Performance Schema tables./p [...]

Saturday, 28. December 2024

Preventing MySQL Binary Log Sequence Number Exhaustion (from Mydbops Blog)

Manage MySQL binary log sequence numbers to prevent outages. This blog discusses the importance of binary logs, risks of sequence number exhaustion, and monitoring strategies to keep your database running. [...]

What do you expect from vector storage in databases? (from MariaDB Foundation Blog)

pWe’re no mind readers, so from time to time, we like to do polls. Polls are quantitative in nature, so coming up with the right question is not enough – … /p pContinue reading \"What do you expect from vector storage in databases?\"/p pThe post What do you expect from vector storage in databases? appeared first on MariaDB.org./p [...]

Friday, 27. December 2024

IBM upgrading Gold to Platinum (from MariaDB Foundation Blog)

pGood news: IBM is upgrading their Gold sponsorship to Platinum!br Our trinity: Adoption, Openness, Continuitybr The three pillars of MariaDB Foundation are Adoption, Openness, and Continuity. … /p pContinue reading \"IBM upgrading Gold to Platinum\"/p pThe post IBM upgrading Gold to Platinum appeared first on MariaDB.org./p [...]

Dolphie Works with Dolt (from DoltHub Blog)

Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Dolphie, a real-time… [...]

Thursday, 26. December 2024

Thoughts on ScyllaDB License Change (from Peter Zaitsev)

pAs you may have heard, ScyllaDB is moving to a Source Available License. Seeing this move from so many companies from MongoDB to Redis should not surprise everyone. This is what happens to “corporate-owned” Open Source Software these days. Yet it is interesting to explore ScyllaDB’s situation in more detail. First, I think ScyllaDB’s license […]/p pThe post Thoughts on ScyllaDB License Chang [...]

Host Database Serverlessly On AWS Fargate - Just Like Your Applications (from WeSQL Blog)

Running a database in the cloud often means paying for idle capacity and dealing with persistent storage overhead. AWS ECS + Fargate changes that equation by letting you pay only for actual compute time and seamlessly integrate with S3 for storage, effectively separating compute from data. This guide shows you how to host a MySQL-compatible database (WeSQL) using Fargate’s pay-as-you-go model while [...]

Tuesday, 24. December 2024

A Message From the Community Team (from The Oracle MySQL Blog)

For the final day of our Advent Calendar of Content, we bring you a message from the Community Team. [...]

Monday, 23. December 2024

MySQL enters a new decade! (from The Oracle MySQL Blog)

For this penultimate article before Christmas, let's announce the 30th anniversary of MySQL! [...]

Resolving MySQL Binlog Errors and Reclaiming Disk Space (from Mydbops Blog)

Learn how to troubleshoot and resolve MySQL binlog errors like 'Target log not found in binlog index' to free up valuable disk space. [...]

10% Slower Than MySQL (from DoltHub Blog)

Four years ago DoltDB was about 15x slower than MySQL. At the time, we faced skepticism regarding Prolly-tree performance and scalability… [...]

Sunday, 22. December 2024

Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB (from MinervaDB Blog)

pTroubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB Troubleshooting AUTO_INCREMENT Max Value Problems in MySQL and MariaDB involves addressing issues related to hitting the maximum value of an AUTO_INCREMENT column. This can [...]/p pThe post Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB appeared first on The WebScale Database Inf [...]

Resource Semaphore Mechanisms in InnoDB (from MinervaDB Blog)

pInnoDB Synchronization Mechanisms: Understanding Semaphore-Like Constructs for Concurrency Management InnoDB employs various synchronization mechanisms to manage concurrency and resource allocation, which function similarly to resource semaphores. While the term "resource semaphore" is not explicitly used [...]/p pThe post Resource Semaphore Mechanisms in InnoDB appeared first on The WebScale Data [...]

MySQL Blog Revisited - OCI TypeScript SDK (from The Oracle MySQL Blog)

For the 22nd day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that demonstrate using the OCI TypeScript SDK [...]

Saturday, 21. December 2024

MySQL Shorts Revisited - DBA Goodies (from The Oracle MySQL Blog)

For the 21st day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on topics that would interest DBAs. [...]

Friday, 20. December 2024

Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels (from MinervaDB Blog)

pResolving MySQL Error 1412 and Understanding Transaction Isolation Levels Understanding MySQL Transaction Error 1412 and Isolation Levels Error 1412: "Table definition has changed, please retry transaction" MySQL Error 1412 occurs when a transaction attempts to [...]/p pThe post Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels appeared first on The WebScale Database Infras [...]

Amazon RDS for MariaDB supports minors 11.4.4, 10.11.10, 10.6.20, 10.5.27 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 11.4.4, 10.11.10, 10.6.20, and 10.5.27. 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 [...]

MariaDB Day Sat 1 Feb 2025 in Brussels (from MariaDB Foundation Blog)

pWe have the date, we have the place , we have the theme! So we ask you to save the date.br Date: Saturday 1 Feb 2025 (10:00-17:00)br Place: Brussels, SQ Lily-Rose, Avenue Arnaud Fraiteur 15-23, close to FOSDEMbr Theme: Vectors, RAG and all things new in MariaDB Serverbr Registration: Please register here with Meetupbr With the Open Source community convening for FOSDEM, we have noted Brussels duri [...]

MySQL Transaction ERROR 1412 and Isolation Levels (from Percona Database Blog)

♦This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific Isolation level settings. Background As per the MySQL documentation, this error should occur for “operations that make a temporary copy of the original table and delete the original table when the temporary copy is built.” […] [...]

Revolutionizing Loyalty Programs: Rakuten’s Journey to Distributed SQL (from PingCAP Blog)

pAchieving a balance between scalability and operational efficiency has become a defining challenge for data-driven businesses. At HTAP Summit 2024, Alex Bai, Engineering Manager at Rakuten, and Tim Liu, Engineering Lead, shared their journey of overcoming the limitations of traditional databases like Apache Cassandra and MySQL to meet the demands of high-traffic platforms and critical […]/p [...]

MySQL Retrospective - ISAM & MySAM Log (from The Oracle MySQL Blog)

Let's stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. [...]

MySQL Retrospective – ISAM & MyISAM Log (from lefred's blog)

Let’s stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. The idea of this article was suggested to me by Daniël van Eeden. Did you know that in the early days, and therefore still in MySQL 3.20, MySQL used the ISAM storage format? IBM introduced the […] [...]

Thursday, 19. December 2024

Transition from AWS DMS to zero-ETL to simplify real-time data integration with Amazon Redshift (from AWS Database Blog)

The zero-ETL integrations for Amazon Redshift are designed to automate data movement into Amazon Redshift, eliminating the need for traditional ETL pipelines. With zero-ETL integrations, you can reduce operational overhead, lower costs, and accelerate your data-driven initiatives. This enables organizations to focus more on deriving actionable insights and less on managing the complexities of data [...]

RDS Performance Insights Alternative for MySQL Monitoring (from Releem Blog)

Looking for RDS Performance Insights alternative? Compare Releem and RDS Performance Insights for monitoring and tuning MySQL [...]

Amazon RDS Proxy announces caching_sha2_password authentication support for MySQL on Aurora and RDS (from AWS What's New)

pAmazon RDS Proxy announces caching_sha2_password authentication plugin support for client to proxy connections on MySQL on Aurora and RDS.br br Customers need to use plugins to perform authentication between databases and clients while using RDS Proxy. Starting with MySQL 8.4, community MySQL uses caching_sha2_password plugin as the default, which is more secure than the previous default plugins. [...]

Percona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress? (from Percona Database Blog)

♦This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying to production is essential. Let’s dive into the story: […] [...]

Building for Scale: The Blueprint for Distributed SQL Databases That Meet Modern Demands (from PingCAP Blog)

pWelcome to the Distributed SQL Era: What AWS’s Entry Means for You Modern applications are pushing the boundaries of what databases can handle. As businesses expand, they face unprecedented demands—hyper-scaling applications, global deployments, and real-time responsiveness—that traditional databases simply weren’t designed to meet. Distributed SQL databases have emerged as a blueprint for success [...]