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.

Tuesday, 22. October 2024

MySQL Enterprise Edition for Financial Services (from The Oracle MySQL Blog)

MySQL Enterprise Edition enables financial services organizations to thrive in a complex and ever-changing environment. By harnessing its capabilities, these institutions can modernize their operations, protect their data, and unlock new opportunities for growth. Modernize your applications and embrace the future of financial services with MySQL Enterprise Edition. [...]
Published Tuesday, 22. October 2024 19:22 • 2 hours ago

Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster (from Continuent Blog)

Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime. These same steps may be used to upgrade the MySQL server or patch the OS.Tags: MySQLMariaDBzero downtimeMaintenanceupdateHigh Availability [...]
Published Tuesday, 22. October 2024 18:11 • 3 hours ago

A MySQL 9.1.0 branch with patches (from Laurynas Biveinis' blog)

p Following-up on the previous MySQL 9.0.0 branch with patches, I have rebased them on 9.1.0: patched-mysql-9.1.0. /p p The set of the patches is the same as for 9.0.0: it improves AddressSanitizer support and fixes/improves clone plugin to support a second transactional storage engine: /p ol liFix for Bug 115120: Provide memory debugging macro implementations for AddressSanitizer./li liFix for Bu [...]
Published Tuesday, 22. October 2024 13:18 • 8 hours ago | Updated Tuesday, 22. October 2024 13:18 • 8 hours ago

TLS in MySQL NDB Cluster 8.4 with MCM 8.4 (from The Oracle MySQL Blog)

Learn how to enable TLS in MySQL NDB Cluster 8.4 with MySQL NDB Cluster Manager 8.4 [...]
Published Tuesday, 22. October 2024 08:00 • 13 hours ago

OpenID Connect (Oauth2 - JWT) Authentication Support in MySQL (from The Oracle MySQL Blog)

With MySQL 9.1 we introduce support for OpenID Connect, making secure authentication easier for developers and enterprises alike. [...]
Published Tuesday, 22. October 2024 05:02 • 16 hours ago

Monday, 21. October 2024

The impact of PGO, LTO and more for MySQL on a small CPU: insert benchmark (from Small Datum)

pThis post has results for the impact of PGO, LTO and other compiler options for MySQL using the Insert Benchmark. I previously shared results like this for sysbench. The PGO builds here were created from profiles captured during sysbench and I am curious to understand whether the benefit from those builds extends to other workloads. /pptl;dr/pp/pulliPGO builds created using sysbench also help [...]
Published Monday, 21. October 2024 21:37 • 23 hours ago | Updated Monday, 21. October 2024 21:37 • 23 hours ago

MySQL 8.0.40 does not fix the regressions I hoped it would fix (from Small Datum)

pPerformance regressions arrived in InnoDB with MySQL 8.0.30. Eventually multiple bugs were filed. The worst regressions were from changes to the hash function (perhaps fixed in 8.0.36) and from changes to how functions are inlined for InnoDB (bug 111538). The problems are obvious if you run CPU-bound workloads, and my CPU-bound workload is sysbench with a cached database./ppBug 111538 is now close [...]
Published Monday, 21. October 2024 18:50 • a day ago | Updated Monday, 21. October 2024 19:11 • a day ago

Announcing the PlanetScale vectors public beta (from PlanetScale Blog)

You can now use the vector data type for vector search and storage in your PlanetScale MySQL database. [...]
Published Monday, 21. October 2024 10:00 • a day ago

How to Migrate From SQL Server to MySQL (from Devart MySQL Tool Blog)

pOne of the standout features of dbForge Studio is its ability to import data from various sources, including ODBC data. This significantly expands your capabilities, both for direct conversion of data stored on different platforms and for the convenient development of database-related objects such as ETL procedures, reports, and more./p pThe post How to Migrate From SQL Server to MySQL appeared fi [...]
Published Monday, 21. October 2024 09:36 • a day ago

Group Commit and Transaction Dependency Tracking (from Hack MySQL)

MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuratio [...]
Published Monday, 21. October 2024 02:35 • 2 days ago

Sunday, 20. October 2024

SQL Statement Management (from MacLochlainns Weblog)

It’s very difficult explaining to students new to relational databases how SQL works. There are many parts that seem intuitive and then there are others that confuse and confound. For beginners, the idea that a SQL statement is simply a text string that you must dispatch to a SQL statement processing engine is new. That’s […] [...]
Published Sunday, 20. October 2024 19:38 • 2 days ago

Installing Example Databases on HeatWave Using Cloud Shell and MySQL Shell (from The Oracle MySQL Blog)

Installing Example Databases on HeatWave Using Cloud Shell and MySQL Shell [...]
Published Sunday, 20. October 2024 00:04 • 3 days ago

Friday, 18. October 2024

Effective Methods for Tracking PostgreSQL Parameter Changes (from MinervaDB Blog)

pEffective Methods for Tracking PostgreSQL Parameter Changes: A Comprehensive Guide Tracking PostgreSQL parameter changes can be essential for understanding the impact of configuration adjustments on the performance and behavior of your database. PostgreSQL provides various [...]/p pThe post Effective Methods for Tracking PostgreSQL Parameter Changes appeared first on The WebScale Database Infrastr [...]
Published Friday, 18. October 2024 19:42 • 4 days ago

Building and testing MySQL 8.0.40 / 8.4.3 / 9.1.0 on macOS (from Laurynas Biveinis' blog)

p Congrats to Oracle friends with MySQL 8.0.40 / 8.4.3 / 9.1.0 releases! Let's continue my blog post series on builds and tests on macOS (the previous post for MySQL 8.0.38 / 8.4.1 / 9.0.0 is here. I skipped the emergency hotfixes 8.0.39 / 8.4.2 / 9.0.1). /p Build p Mostly good news here. XCode 16 works (8.4.3 & 9.10 need code-Wno-unused-const-variable/code), and so does LLVM 18. The very re [...]
Published Friday, 18. October 2024 14:03 • 4 days ago | Updated Friday, 18. October 2024 14:03 • 4 days ago

Building Generative AI Applications with TiDB and Amazon Bedrock (from PingCAP Blog)

pIn the rapidly evolving field of artificial intelligence, generative AI (GAI) stands out as one of the most fascinating and groundbreaking advancements. GAI represents a major leap forward, enabling machines to generate original and creative content across various domains, including conversations, stories, images, videos, and music. As companies seek to harness the potential of GAI, […]/p pT [...]
Published Friday, 18. October 2024 02:23 • 5 days ago

Thursday, 17. October 2024

Essential PostgreSQL Performance Troubleshooting Tools (from MinervaDB Blog)

pEssential PostgreSQL Performance Troubleshooting Tools: A Comprehensive Guide Performance optimization is crucial in PostgreSQL database management. As databases grow in size and complexity, a robust toolkit for identifying and addressing performance bottlenecks becomes essential. Efficiently [...]/p pThe post Essential PostgreSQL Performance Troubleshooting Tools appeared first on The WebScale Da [...]
Published Thursday, 17. October 2024 19:53 • 5 days ago

The impact of PGO, LTO and more for MySQL on a small CPU (from Small Datum)

pThis has results for MySQL 8.0.28 vs sysbench on a laptop-class CPU (AMD 4700u) to understand the impact of various compile-time optimizations including LTO and PGO. I will have results from a server-class CPU next weeok. I previously published results on this but then retracted some of them as they appeared bogus./pptl;dr/pp/pulliclang and gcc have similar performance with a few exceptions/liulli [...]
Published Thursday, 17. October 2024 19:25 • 5 days ago | Updated Thursday, 17. October 2024 19:25 • 5 days ago

MySQL NDB Cluster replication: Filter replica updates (from The Oracle MySQL Blog)

A new feature to MySQL NDB Cluster replication allows the NDB data nodes to skip sending unnecessary updates to subscribing MySQL Server nodes. These updates reflect changes that occurred in the NDB cluster, and some subscribing MySQL Servers are configured to discard changes applied by a replica or that are not to be written to binary log at all. Instead of having MySQL Servers discarding changes, [...]
Published Thursday, 17. October 2024 12:32 • 5 days ago

A MySQL backup and recovery tutorial on K8s using the MySQL Operator for Kubernetes (from Severalnines Blog)

pSupported by the growing maturity of operators, many organizations have graduated from using Kubernetes to deploy and manage stateless applications to adopting it for all kinds of stateful workload deployment in the last 4 years. But, running databases on Kubernetes is much more than deployment and can include Day 2 operations like backup and recovery, […]/p pThe post A MySQL backup and reco [...]
Published Thursday, 17. October 2024 11:33 • 5 days ago

How to Connect to a MySQL Database (from Devart MySQL Tool Blog)

pYou can connect to MySQL Server using MySQL Client (the command-line utility) and GUI tools. This article will review each method in detail./p pThe post How to Connect to a MySQL Database appeared first on Devart Blog./p [...]
Published Thursday, 17. October 2024 10:00 • 5 days ago

Wednesday, 16. October 2024

Sysbench vs c-state on an AMD 4700u (from Small Datum)

pI repeated CPU-bound sysbench on my smallest server while using cpupower idle-set to disable some of the c-states to understand the impact on performance. brbrWith a lower-concurrency (1 thread) workload there was up to a 13% performance improvement when some of the c-states were disabled. /ppWith a higher-concurrency (6 threads) workload there is up to a 14% performance improvement for one o [...]
Published Wednesday, 16. October 2024 20:58 • 6 days ago | Updated Wednesday, 16. October 2024 21:04 • 6 days ago

Azure Database for MySQL - September 2024 updates and latest feature roadmap (from Azure for MySQL Blog)

pWe're thrilled to present the latest roadmap for upcoming features in Azure Database for MySQL - Flexible Server!/p p /p October 2024 Live webinar pThe latest roadmap and other feature updates are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every month, at 7:30 AM Pacific time. Below is a link to [...]
Published Wednesday, 16. October 2024 19:58 • 6 days ago

Work around a MariaDB behaviour change (from SQL And Its Sequels (Ocelot Blog))

CREATE PROCEDURE p() BEGIN DECLARE v CHAR CHARACTER SET utf8 DEFAULT ''; SELECT * FROM information_schema.routines WHERE routine_name > v; END; CALL p(); Result: with current MariaDB 11.4 or MySQL 8.3: a result set.Result: with new or future MariaDB: an error message mentioning collations. The error appears with MariaDB 11.5.1 and later, except for Debian-based… Continue Reading Work arou [...]
Published Wednesday, 16. October 2024 18:47 • 6 days ago

Securing Your MaxScale Environment: Best Practices & Configuration Guide (from MariaDB Corporation Blog)

In today’s data-driven landscape, ensuring the security of your database infrastructure is paramount. MariaDB MaxScale, a powerful database proxy for … Continued [...]
Published Wednesday, 16. October 2024 16:30 • 6 days ago

Code bloat vs memory system bloat : why is something getting slower (from Small Datum)

pAs I document performance regressions over time in MySQL it helps to assign names for common problems that I see. While there are many problems in general including mutex contention and poor usage of IO, my current focus is on the following:/pp/pullicode bloat - the system uses more instructions per unit of work/lilimemory system bloat - the instructions don't get executed as fast because there is [...]
Published Wednesday, 16. October 2024 15:40 • 6 days ago | Updated Wednesday, 16. October 2024 16:11 • 6 days ago

Coroutines in RonDB, (from Mikael Ronstrom)

p A while ago C++ standard added a new feature to C++ 20 called coroutines. I thought it was an interesting thing to try out for RonDB and used some time this summer to read more about it. My findings was that C++ coroutines can only be used for special tasks that require no stacks. The problem is that a coroutine cannot save the stack./ppMy hope was to find that I could have a single thread t [...]
Published Wednesday, 16. October 2024 15:56 • 6 days ago | Updated Wednesday, 16. October 2024 16:00 • 6 days ago

How to Migrate MySQL Database to Amazon RDS or Aurora (from Devart MySQL Tool Blog)

pIn this guide, we are going to walk you through the process of transferring a database from a local machine or a traditional server to AWS with the help of the command line as well as with a convenient GUI - dbForge Studio for MySQL./p pThe post How to Migrate MySQL Database to Amazon RDS or Aurora appeared first on Devart Blog./p [...]
Published Wednesday, 16. October 2024 10:06 • 6 days ago

Tuesday, 15. October 2024

Amazon Aurora PostgreSQL zero-ETL integration with Amazon Redshift is generally available (from AWS Database Blog)

In this post, we discuss the challenges with traditional data analytics mechanisms, our approach to solve them, and how you can use Amazon Aurora PostgreSQL-Compatible Edition zero-ETL integration with Amazon Redshift, which is generally available as of October 15th, 2024. [...]
Published Tuesday, 15. October 2024 21:00 • 7 days ago

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

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now support AWS Graviton3-based M7g database instances in Europe (Paris), and R7g database instances in Asia Pacific (Hong Kong) and Europe (Milan).br br With this regional expansion, Graviton3 database instances are now available for Amazon RDS in 21 regions: US East (N. Virginia, Ohio), US West (N. California, Ore [...]
Published Tuesday, 15. October 2024 17:00 • 7 days ago

Amazon RDS for MariaDB now supports MariaDB 11.4 with new password validation options (from AWS What's New)

pAmazon RDS for MariaDB now supports MariaDB major version 11.4, the latest long-term maintenance release from the MariaDB community. Amazon RDS for MariaDB 11.4 now supports the Simple Password Check Plugin, and Cracklib Password Check Plugin for password validation. You can use these plugins together, or individually to enforce the security policies appropriate for your organization. MariaDB 11.4 [...]
Published Tuesday, 15. October 2024 17:00 • 7 days ago

MariaDB – the Foundation, the Company, and the Future of the Sea Lion (from MariaDB Foundation Blog)

pDid you read the TechCrunch article on MariaDB? “How do you solve a problem like MariaDB? Cozy up to the community, says new CEO“. … /p pContinue reading \"MariaDB – the Foundation, the Company, and the Future of the Sea Lion\"/p pThe post MariaDB – the Foundation, the Company, and the Future of the Sea Lion appeared first on MariaDB.org./p [...]
Published Tuesday, 15. October 2024 10:23 • 7 days ago

InnoDB data_locks: a happy ending/new beginning in MySQL 8.0.40 ! (?) (from Marc Reilly)

p /pEarlier today lefred tweeted that the new MySQL releases were rolling out today! As per the usual release process, the yum repositories typically have the release rpms available first, followed by github (release tags here) and then the release notes.brblockquotepHey hey! It's that time again! #MySQL 🐬 9️⃣ .1️⃣ being released! Stay tuned for release notes tomorrow at 9.00AM PDT p [...]
Published Tuesday, 15. October 2024 06:05 • 8 days ago | Updated Tuesday, 15. October 2024 06:05 • 8 days ago

(from Small Datum)

pI recently published results with a summary of HW performance counters for sysbench with MySQL on four CPU types. The performance reports were published over several weeks and to make it easier to see the impact of performance regressions over time, this blog post has the relative QPS for all of the microbenchmarks. Having all of the numbers in one place makes it easier for me to spot things to in [...]
Published Tuesday, 15. October 2024 00:09 • 8 days ago | Updated Tuesday, 15. October 2024 00:31 • 8 days ago

Monday, 14. October 2024

Let the fun begins !!! (from The consistent voice)

Let the fun begins !!!pNo we have defined our facts, their attributes and the relations that unites all those facts. So we’re good aren’t we ?/ppNot really. The complete guide to build a good schema can be summarized as :/pp“Normalize until it breaks, denormalize until it works”. Let the fun begin !!!/ppSo what is denormalization ? What is it for ? Sounds like undoing what we did in the first place [...]
Published Monday, 14. October 2024 21:31 • 8 days ago

How do you implement row-level security in MariaDB? (from MinervaDB Blog)

pHow do you implement row-level security in MariaDB for fine-grained data access control? This guide outlines the implementation of Row-Level Security (RLS) in MariaDB, an open-source relational database management system. RLS enables database administrators to [...]/p pThe post How do you implement row-level security in MariaDB? appeared first on The WebScale Database Infrastructure Operations Exp [...]
Published Monday, 14. October 2024 19:50 • 8 days ago

Transition from VNET integration to public access or Private Link using the Azure CLI (from Azure for MySQL Blog)

pYou can transition an Azure Database for MySQL flexible server from using VNET integration (Private Access) to using Public Access or Private Link seamlessly, without the need to alter the server name or migrate data, which simplifies the process for customers. However, after you make the transition, you cannot reverse it. The transition involves approximately 5-10 minutes of downtime fo [...]
Published Monday, 14. October 2024 17:07 • 8 days ago

How to distinguish facts, attributes and relations from bullshit ? (from The consistent voice)

How to distinguish facts, attributes and relations from bullshit ?pWe’ve seen in my previous article ( who said rant ? ) how to easily normalize database items, but how do we know what’s what ? It is crucial to clearly define and differentiate between facts, attributes, and relationships to create an efficient and evolutive design . Here’s how you can identify each component and filter out unnecess [...]
Published Monday, 14. October 2024 14:15 • 8 days ago

Galera : often overlooked, still powerful (from The consistent voice)

Galera : often overlooked, still powerfulpGalera Cluster, while often overlooked, is a sophisticated and robust database solution whose full potential is frequently misunderstood. While many IT professionals are aware of its existence, they usually fail to grasp the depth of its capabilities. Understanding Galera’s true strengths can unlock significant improvements in database operations, making it [...]
Published Monday, 14. October 2024 14:09 • 8 days ago

Simplify MySQL Clustering with Galera Cluster Helm Chart on Kubernetes Webinar (from Galera Blog)

Join us for an in-depth webinar where we introduce the new Helm Chart for Galera Cluster for MySQL, now available from Codership (read the blog). In this session, we’ll guide you through the process of deploying a high-availability MySQL cluster using Galera Cluster on Kubernetes (live demo!). You’ll learn how Helm Charts can simplify Kubernetes […] [...]
Published Monday, 14. October 2024 13:33 • 8 days ago

Understanding Return Codes of pt-upgrade: A quick guide (from Kedar MySQL Blog)

pInterpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…/p The post Understanding Return Codes of pt-upgrade: A quick guide first appeared on Change Is Inevitable. [...]
Published Monday, 14. October 2024 06:47 • 9 days ago

Managing CPU frequency for AMD on Ubuntu 22.04 (from Small Datum)

pI need stable performance from the servers I use for benchmarks. I also need servers that don't run too hot because too-hot servers cause HW to fail and introduce variance when CPU speeds are throttled. This post is about my latest adventures managing CPU speed. My previous post is here./ppAt a high level my solution is:/pp/pullidisable turbo boost/lili(optional) cap the max frequency the CPU can [...]
Published Sunday, 13. October 2024 17:51 • 9 days ago | Updated Monday, 14. October 2024 01:25 • 9 days ago

Is MySQL Dying? (from DoltHub Blog)

Here at DoltHub, like MariaDB and Oracle, we're in the MySQL business. We built a MySQL-compatible database, Dolt, that has all the version… [...]
Published Monday, 14. October 2024 00:00 • 9 days ago

Saturday, 12. October 2024

How do you solve a problem like MariaDB? Cozy up to the community, says new CEO (from TechCrunch)

pThe new CEO of MariaDB (Plc) says he wants closer-knit collaboration with the foundation behind the eponymous open source database project. He cites the corporation’s newfound stability from its recent acquisition by a private equity firm as to why it should now be able to get on a firmer footing. It has been a turbulent […]/p p© 2024 TechCrunch. All rights reserved. For personal use o [...]
Published Saturday, 12. October 2024 13:00 • 10 days ago

Friday, 11. October 2024

MyDumper + ZFS – Merely Faster Than mysqldump is not Enough (from Shattered Silicon OSDB Blog)

pOptimizing MyDumper's logical backup throughput using ZFS./p pThe post MyDumper + ZFS – Merely Faster Than mysqldump is not Enough appeared first on Shattered Silicon./p [...]
Published Friday, 11. October 2024 21:35 • 11 days ago

HeatWave MySQL - Quick guide: Enabling Automatic storage expansion (from The Oracle MySQL Blog)

HeatWave MySQL now supports Automatic Storage Expansion. HeatWave Automatic Storage Expansion dynamically adjusts storage capacity to accommodate increasing database workloads, ensuring continuous operation without any downtime. [...]
Published Friday, 11. October 2024 20:00 • 11 days ago

Implementing “Always Encrypted” Functionality in PostgreSQL (from MinervaDB Blog)

pImplementing “Always Encrypted” Functionality in PostgreSQL: Techniques and Best Practices for Secure Data Encryption PostgreSQL doesn't natively have a feature exactly equivalent to SQL Server's Always Encrypted option. Always Encrypted is a feature in SQL [...]/p pThe post Implementing “Always Encrypted” Functionality in PostgreSQL appeared first on The WebScale Database Infrastructure Operation [...]
Published Friday, 11. October 2024 19:03 • 11 days ago

Optimizing Inner Joins for High-Performance MySQL Queries (from MinervaDB Blog)

pOptimizing Inner Joins for High-Performance MySQL Queries Inner JOINs in MySQL can have a substantial impact on query performance, potentially leading to increased memory and CPU utilization. This effect is particularly pronounced when dealing with [...]/p pThe post Optimizing Inner Joins for High-Performance MySQL Queries appeared first on The WebScale Database Infrastructure Operations Experts i [...]
Published Friday, 11. October 2024 18:45 • 11 days ago

What does "perf stat" tell us about MySQL performance regressions on an AMD Threadripper CPU (from Small Datum)

pI used perf stat to collect a variety of HW performance counter and will share the results over several posts. I used 4 different servers with 4 different CPUs and there will be a post per CPU. This is the third post with results from a server class CPU. Previous posts that used laptop class CPUs (but mini PCs, not laptops) are here and here and a result from a server class CPU [...]
Published Friday, 11. October 2024 18:19 • 11 days ago | Updated Friday, 11. October 2024 18:19 • 11 days ago

What does "perf stat" tell us about MySQL performance regressions on an Intel Xeon CPU (from Small Datum)

pI used perf stat to collect a variety of HW performance counter and will share the results over several posts. I used 4 different servers with 4 different CPUs and there will be a post per CPU. This is the third post with results from a server class CPU. Previous posts that used laptop class CPUs (but mini PCs, not laptops) are here and here.brtl;dr/pp/pulliMySQL (InnoDB and MyRocks) gets slower o [...]
Published Friday, 11. October 2024 01:28 • 12 days ago | Updated Friday, 11. October 2024 18:07 • 11 days ago

What does "perf stat" tell us about MySQL performance regressions on a Ryzen 7 7735HS CPU (from Small Datum)

pI used perf stat to collect a variety of HW performance counter and will share the results over several posts. I used 4 different servers with 4 different CPUs and there will be a post per CPU. This is my second post and my first post is here. The previous post and this one use a small server. Results here are similar to results on my other small server./pptl;dr/pp/pulliMySQL (InnoDB and MyRocks) [...]
Published Wednesday, 09. October 2024 02:08 • 14 days ago | Updated Friday, 11. October 2024 18:06 • 11 days ago

What does "perf stat" tell us about MySQL performance regressions on a Ryzen 7 4700u CPU (from Small Datum)

pI used perf stat to collect a variety of HW performance counter and will share the results over several posts. I used 4 different servers with 4 different CPUs and there will be a post per CPU. First up is a result from my smallest server that uses a AMD Ryzen 7 4700u CPU./pptl;dr/pp/pulliMySQL (InnoDB and MyRocks) gets slower over time from both memory system bloat (TLB and cache activity) and co [...]
Published Monday, 07. October 2024 23:46 • 15 days ago | Updated Friday, 11. October 2024 18:04 • 11 days ago

MySQL October 2024 GA Releases Now Available (from The Oracle MySQL Blog)

This October release is the third LTS release and second Innovation release since MySQL announced our move to a new LTS/Innovation release model. For more details see MySQL Releases: Innovation and LTS. During the innovation cycle, MySQL 9.x quarterly releases will include new features, deprecations and removals, and bug fixes. The 9.x releases also include Shell, Router, Connectors and Client [...]
Published Friday, 11. October 2024 17:57 • 11 days ago

Advanced ProxySQL Features and How to Leverage Them (from ProxySQL Blog)

pAre you facing challenges managing your MySQL database as user traffic increases? As more users and applications connect, performance can slow down, leading to delays that impact the user experience. Ensuring high availability and quick response times is essential for smooth operations.   ProxySQL acts as an effective intermediary between your applications and your MySQL [...]/p pThe post Advanced [...]
Published Friday, 11. October 2024 09:32 • 11 days ago

Using Dolt with JDBC (from DoltHub Blog)

Dolt is the world's first version-controlled SQL database – you can branch, merge, diff, fork, revert, rebase, and clone your relational… [...]
Published Friday, 11. October 2024 00:00 • 12 days ago

Thursday, 10. October 2024

MySQL Rockstar 2023: Q&A with Alkin Tezuysal (from ODBMS.org)

Q1. You were awarded the MySQL Rockstar 2023. Congratulations! What do you think are your most important contributions in the area of open-source relational databases? My most significant contributions to the open-source relational database community... [...]
Published Thursday, 10. October 2024 13:57 • 12 days ago

Emacs Projectile Tweaks for MySQL Development (from Laurynas Biveinis' blog)

p I am using Emacs with Projectile (besides other packages) for MySQL development. Here's a couple of little tweaks to save a few keystrokes here and there: /p ul liVisit (which in Emacs parlance means open) the MTR test file, by its MTR name instead of file path:/li /ul pre;; This is a not a MySQL-specific implementation of `projectile-find-test-file'. ;; That function is meant for jumping from [...]
Published Thursday, 10. October 2024 13:06 • 12 days ago | Updated Thursday, 10. October 2024 13:06 • 12 days ago

MariaDB Contribution Statistics, October 2024 (from MariaDB Foundation Blog)

pAnother quarter year has gone by, and in the world of MariaDB, it is time for another contributions report. The raw data for this report can be found on GitHub, here. … /p pContinue reading \"MariaDB Contribution Statistics, October 2024\"/p pThe post MariaDB Contribution Statistics, October 2024 appeared first on MariaDB.org./p [...]
Published Thursday, 10. October 2024 08:06 • 13 days ago

Anatomy of a Throttler, part 2 (from PlanetScale Blog)

Design consideration for implementing a database throttler with a comparison of singular vs distributed throttler deployments. [...]
Published Thursday, 10. October 2024 00:00 • 13 days ago

Wednesday, 09. October 2024

How to run MySQL with text in huge pages (from Small Datum)

pI have been documenting why MySQL gets slower (in some cases) from version 5.6 to 8.0. One of the causes is more cache and TLB activity, especially misses. I have tried huge pages for data and it helps a bit, but doesn't solve the problem - see here and here. But it comes at cost in usability.brbrHere I explain how to use huge pages for text (the code of mysqld). I have work in progress to share m [...]
Published Sunday, 06. October 2024 20:03 • 16 days ago | Updated Wednesday, 09. October 2024 16:08 • 13 days ago

The Easiest Way to Try MaxScale with your Java, Python, and Node.js Apps (from MariaDB Corporation Blog)

Here’s the simplest method to integrate MariaDB MaxScale into your Java, Python, and Node.js projects using Canonical Multipass. This guide … Continued [...]
Published Wednesday, 09. October 2024 16:00 • 13 days ago

Three simple rules to not fail (too much) the foundations of your data design (from The consistent voice)

pDesigning a robust and efficient relational database is crucial for the smooth operation and management of data in any application. It will asloa llow for easier evolution over time. In this article we will outline three simple rules that will help you abide by the fundamental principles of database design./ppDatabase normalization is the process of structuring a relational database in accordance [...]
Published Wednesday, 09. October 2024 12:37 • 13 days ago

Validating rows with CHECK constraints in MariaDB (from Vettabase)

Relational databases provide several ways to validate data. CHECK constraints are a powerful tool for in-database data validation. Their impact on performance is minimal, if any. In this article we’ll discuss MariaDB support for CHECK constraints. Note that the CHECK syntax and semantics are the same for most relational databases. The most relevant difference between MariaDB and other product [...]
Published Wednesday, 09. October 2024 11:41 • 13 days ago

MariaDB: so much more than just a MySQL fork (from The consistent voice)

♦pIn the course of conversations, I realise that MariaDB is still often perceived as a simple fork of MySQL maintained by a few enthusiasts. But it’s an independent product maintained by teams with a name. Let’s talk about why MariaDB deserves to be recognised as a standalone database./pOrigins and developmentpMariaDB was created in 2009 by the original MySQL developers, led by Michael ‘Monty’ Wide [...]
Published Wednesday, 09. October 2024 08:37 • 14 days ago

Tuesday, 08. October 2024

Introducing scaling up to 256 ACUs with Amazon Aurora Serverless v2 (from AWS Database Blog)

AWS announced that Amazon Aurora Serverless v2 supports database capacity of up to 256 Aurora Capacity Units (ACUs). Aurora Serverless v2 is an on-demand, auto scaling configuration for Amazon Aurora. It adjusts capacity in fine-grained increments to provide the right amount of database resources that the application needs. There is no database capacity for you […] [...]
Published Tuesday, 08. October 2024 17:56 • 14 days ago

Unlocking the Power of Cloud Snapshots: Backup and Restore Your MongoDB Clusters on Kubernetes (from Percona Database Blog)

♦There are various ways to backup and restore Percona Server for MongoDB clusters when you run them on Kubernetes. Percona Operator for MongoDB utilizes Percona Backup for MongoDB (PBM) to take physical and logical backups, continuously upload oplogs to object storage, and maintain the backup lifecycle.  Cloud providers and various storage solutions provide the capability […] [...]
Published Tuesday, 08. October 2024 15:10 • 14 days ago

MySQL Brazil Meetup - Recap. (from The Oracle MySQL Blog)

Recap from MySQL Day Brazil, Oct 5, 2024 [...]
Published Tuesday, 08. October 2024 10:20 • 14 days ago

Monday, 07. October 2024

How to Check MySQL Version (from Devart MySQL Tool Blog)

pMySQL is an extremely popular open-source RDMS, and it is widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary./p pThe post How to Check MySQL Version appeared first on Devart Blog./p [...]
Published Monday, 07. October 2024 10:56 • 15 days ago

Migrating in-place from PostgreSQL to MySQL (from Yelp Engineering Blog)

The Yelp Reservations service (yelp_res) is the service that powers reservations on Yelp. It was acquired along with Seatme in 2013, and is a Django service and webapp. It powers the reservation backend and logic for Yelp Guest Manager, our iPad app for restaurants, and handles diner and partner flows that create reservations. Along with that, it serves a web UI and backend API for our Yelp Reserva [...]
Published Monday, 07. October 2024 00:00 • 16 days ago

Saturday, 05. October 2024

Open Source is in Our DNA: Reaffirming TiDB’s Commitment (from PingCAP Blog)

pWhen we first set out to build TiDB, we didn’t just want to create another database—we wanted to build a community-driven, open-source project that developers worldwide could trust and contribute to. From day one, TiDB has been an open-source project under the Apache 2.0 license, and it remains so today. Open source isn’t just a […]/p pThe post Open Source is in Our DNA: Reaffirming TiDB’s C [...]
Published Saturday, 05. October 2024 04:07 • 18 days ago

Friday, 04. October 2024

How to tune Linux Threads for MongoDB IOPS Performance? (from MinervaDB Blog)

pHow to tune Linux Threads for MongoDB IOPS Performance? To optimize Linux threads for enhanced MongoDB IOPS performance, it is crucial to implement a comprehensive and meticulously crafted tuning strategy. This approach encompasses a series [...]/p pThe post How to tune Linux Threads for MongoDB IOPS Performance? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreS [...]
Published Friday, 04. October 2024 20:08 • 18 days ago

Quick guide: Setting up HeatWave MySQL alarms and notifications in minutes (from The Oracle MySQL Blog)

The alarm definitions feature eases the process of creating and managing alarms to monitor HeatWave MySQL DB Systems. It enables you to create Oracle-recommended alarms by making use of the standardized set of rules and thresholds, across multiple databases. [...]
Published Friday, 04. October 2024 15:31 • 18 days ago

Early design choices for RonDB and InnoDB (from Mikael Ronstrom)

p I have had many interesting discussions with Zhao Song about RonDB and its internals. Since both Zhao and myself also worked on MySQL/InnoDB features as well, it becomes natural that we sometimes compare the features of RonDB  with the features in InnoDB./ppIn this blog I will discuss what is the basis for the very different solutions that we have in RonDB compared to what we find in In [...]
Published Thursday, 03. October 2024 22:34 • 19 days ago | Updated Friday, 04. October 2024 15:23 • 18 days ago

Galera Cluster for MySQL Helm Chart for Kubernetes (from Galera Blog)

Codership, the makers of Galera Cluster, are pleased to announce the availability of Helm charts for Galera Cluster for MySQL 8.0.39. It is available on our GitHub releases page, for convenience. You are encouraged to send feature requests at our GitHub issues. Helm charts help you manage your Kubernetes applications, to install and upgrade any […] [...]
Published Friday, 04. October 2024 07:38 • 19 days ago

Hack MySQL: Create an Extremely Sparse InnoDB Table (B+Tree) (from Zhao Song's Blog)

1. Experiment By running this script, you can generate an extremely sparse B+Tree in an InnoDB table with just simple INSERT statements: ``` #!/bin/bash Define the MySQL command path MYSQL_CMD=”/PATH/TO/mysql -h127.0.0.1 -P3306 -uroot” [...]
Published Friday, 04. October 2024 00:00 • 19 days ago

Thursday, 03. October 2024

Using MariaDB MaxScale for Schema Sharding With Galera (from MariaDB Corporation Blog)

Schema Sharding is a useful means of distributing the load over multiple MariaDB Enterprise Server instances when you have multiple … Continued [...]
Published Thursday, 03. October 2024 22:06 • 19 days ago

Awards and Endorsements Recap: Discover the Best dbForge Products of Q2 and Q3 2024 (from Devart MySQL Tool Blog)

pThroughout the second and third quarters of 2024, the Devart team achieved multiple awards for the dbForge product line, winning gold and silver for the DBTA Readers’ Choice Awards 2024 nominations, as well as getting badges from Crozdesk, Sourceforge, G2, and SoftwareSuggest listings.  Let's check them out./p pThe post Awards and Endorsements Recap: Discover the Best dbForge Products of Q2 and Q3 [...]
Published Thursday, 03. October 2024 08:43 • 20 days ago

Wednesday, 02. October 2024

Announcing Tungsten Cluster & Tungsten Replicator v7.1.4 (from Continuent Blog)

Explore the latest release of Tungsten Clustering & Tungsten Replicator! This new version v7.1.4 brings critical improvements, new features, and bug fixes, ensuring enhanced performance, stability, and functionality for your database management.Tags: tungsten clusteringtungsten replicatorMySQLMariaDBreleases [...]
Published Wednesday, 02. October 2024 14:02 • 20 days ago

MySQL Upcoming Meetups Worldwide (from The Oracle MySQL Blog)

MySQL Metups, Sep-Nov 2024 [...]
Published Wednesday, 02. October 2024 09:17 • 20 days ago

Tuesday, 01. October 2024

Optimizing PostgreSQL Failover in AWS Using Elastic IPs and DNS Route Failover (from MinervaDB Blog)

pOptimizing PostgreSQL Failover in AWS Using Elastic IPs and DNS Route Failover Utilizing Elastic IPs and DNS Route Failover for PostgreSQL in AWS When deploying PostgreSQL in AWS, one effective approach to ensure high availability [...]/p pThe post Optimizing PostgreSQL Failover in AWS Using Elastic IPs and DNS Route Failover appeared first on The WebScale Database Infrastructure Operations Expert [...]
Published Tuesday, 01. October 2024 20:19 • 21 days ago

Dumpling – Logical backup tool for TiDB (from Mydbops Blog)

TiDB, developed by PingCAP, stands out as a distributed SQL database known for its exceptional scalability and strong consistency. To harness its full potential, effective data export tools are essent [...]
Published Tuesday, 01. October 2024 04:40 • 22 days ago

Monday, 30. September 2024

Amazon Aurora MySQL now supports RDS Data API (from AWS What's New)

pAmazon Aurora MySQL-Compatible Edition now supports a redesigned RDS Data API for Aurora Serverless v2 and Aurora provisioned database instances. You can now access these Aurora clusters via a secure HTTP endpoint and run SQL statements without the use of database drivers and without managing connections. This follows the launch of Data API for Amazon Aurora PostgreSQL-Compatible Edition for Auror [...]
Published Monday, 30. September 2024 17:00 • 22 days ago

ProxySQL Expands Database Support to PostgreSQL in Version 3.0.0-Alpha (from ProxySQL Blog)

pThe reigning champion of MySQL proxies, ProxySQL, has set its sights to conquer new territory. Today marks the dawn of a new era as ProxySQL unveils its 3.0.0-Alpha release, bringing PostgreSQL - the darling of developers, and the titan of open source databases - under its formidable umbrella. A Game Changing Expansion Long respected [...]/p pThe post ProxySQL Expands Database Support to PostgreSQ [...]
Published Monday, 30. September 2024 12:35 • 22 days ago

Announcing the first MariaDB Hackathon – in India! (from MariaDB Foundation Blog)

pUpdate 2024-10-15: The event has been cancelled in favour of something better. Please see the end of this post.br On the 24th – 25th October 2024 we will be hosting our first-ever Hackathon as part of our larger MariaDB Foundation presence around Open Source India. … /p pContinue reading \"Announcing the first MariaDB Hackathon – in India!\"/p pThe post Announcing the first Maria [...]
Published Monday, 30. September 2024 09:56 • 22 days ago

Crescendo makes AI boring—and profitable (from InfoWorld)

pThere’s money in AI, but not where you think. Sure, Nvidia and the clouds are cleaning up, but they’re primarily selling to enterprises that are mostly kicking tires, not running mission-critical AI applications. Some, like the Financial Times, suggest that AI startups are cleaning up but, again, this could simply be a matter of reselling GPUs, as Chris Gaun points out./p [...]
Published Monday, 30. September 2024 08:45 • 23 days ago

Friday, 27. September 2024

Troubleshoot Amazon RDS for MySQL and Amazon RDS for MariaDB Errors (from AWS Database Blog)

In this post, we discuss MySQL or MariaDB errors seen in error logs and application logs related to database, their possible root cause and how to effectively troubleshoot them on Amazon Relational Database Service(Amazon RDS) for MySQL or Amazon Relational Database Service(Amazon RDS) for MariaDB. [...]
Published Friday, 27. September 2024 19:08 • 25 days ago

InnoDB code bloat in MySQL 8.0 makes me sad (from Small Datum)

pInnoDB uses a lot more CPU per query in MySQL 8.0 which makes it a lot slower for low-concurrency workloads that are CPU-bound. That is offset by improvements which reduce mutex contention which means it might not be slower for high-concurrency workloads?brbrIt would be great to get the reduction in mutex contention without the increase in CPU overhead. Alas, I don't think that is ever going to ha [...]
Published Thursday, 26. September 2024 22:18 • 26 days ago | Updated Friday, 27. September 2024 16:21 • 25 days ago

MariaDB Replication – slave_parallel_mode Difference (from Shattered Silicon OSDB Blog)

pMariaDB's optimistic parallel replication doesn't often make a significant difference over conservative, but in some cases the improvement can be huge./p pThe post MariaDB Replication – slave_parallel_mode Difference appeared first on Shattered Silicon./p [...]
Published Friday, 27. September 2024 10:06 • 25 days ago

Celebrating the TiDB Future App Hackathon 2024 (from PingCAP Blog)

pDuring the recent HTAP Summit, I had the honor of celebrating another successful TiDB Future App Hackathon and announcing our winners. This year, we had close to 2,100 participants–about 40% increase from 2023–joining us from 80+ countries. If you visit the Hackathon project gallery, you will be able to see the winners and all other […]/p pThe post Celebrating the TiDB Future App Hackathon 2 [...]
Published Friday, 27. September 2024 08:57 • 26 days ago

How to Restore a MySQL Database with Command Line or Restore Tools (from Devart MySQL Tool Blog)

pThe article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin./p pThe post How to Restore a MySQL Database with Command Line or Restore Tools appeared first on Devart Blog./p [...]
Published Friday, 27. September 2024 08:34 • 26 days ago

Thursday, 26. September 2024

MariaDB ColumnStore SQL limitations (from Vettabase)

MariaDB ColumnStore is an extremely fast and scalable solution for analytics built on MariaDB, which Vettabase supports. MariaDB ColumnStore inherits the MariaDB SQL dialect, and many MariaDB features. However, numerous MariaDB features are not available for the ColumnStore storage engine. In some cases the reason is that they don’t apply to a columnar storage. Some features were not yet impl [...]
Published Thursday, 26. September 2024 10:26 • 26 days ago

Clustercontrol adds Valkey in latest release (from Severalnines Blog)

pClustercontrol (CC) v2.2.0 is now live, offering a new Redis alternative in response to recent licensing changes, along with improved support for MariaDB 11.4 and Ubuntu 24.04. Let’s explore the key updates and see what’s new in Clustercontrol v2.2.0! Redis shifts to source-available licensing Beginning with v7.4, Redis will adopt a dual-licensing model under the […]/p pThe post Clustercontr [...]
Published Thursday, 26. September 2024 09:57 • 26 days ago

How to Enable, Configure, and Use MySQL Query Logging (from Devart MySQL Tool Blog)

pIn this article, we will address questions such as the purpose of query logging in MySQL, why it is important, how to enable and configure it, and more. You’ll find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage./p pThe post How to Enable, Configure, and Use MySQL Query Logg [...]
Published Thursday, 26. September 2024 09:34 • 26 days ago

On Neurelo Database Abstraction Platform. Q&A with Chirag Shah (from ODBMS.org)

Q1. You have founded Neurelo. What is it? Neurelo is an API-first database abstraction platform that provides a comprehensive data access layer designed to streamline database programming and management for developers. Neurelo instantly transforms... [...]
Published Thursday, 26. September 2024 09:27 • 26 days ago

Wednesday, 25. September 2024

How Network Splits/Partitions Impact Group Replication in MySQL (from Percona Database Blog)

♦In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for some insight. Topology: [crayon-6717f76e012fe155565676/] Scenario 1: One of the GR nodes […] [...]
Published Wednesday, 25. September 2024 13:25 • 27 days ago

Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 (from Devart MySQL Tool Blog)

pThere's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports./p pThe post Time to Empower Yourself With the Newly [...]
Published Wednesday, 25. September 2024 10:39 • 27 days ago

MySQL Upcoming Meetups Worldwide (from ODBMS.org)

By Lenka Kasparova, MySQL Community Manager and MySQL Community Manager & Events Coordinator @ Oracle/MySQL October 2024: [...]
Published Wednesday, 25. September 2024 10:07 • 27 days ago

HeatWave MySQL – New Capabilities for OLTP Workloads (from ODBMS.org)

by Mark Matthews, Architect, HeatWave Service on OCI HeatWave MySQL is a robust and time-tested ACID compliant database which is ideal for transactional processing, mixed workloads, real-time analytics, and machine learning where the data... [...]
Published Wednesday, 25. September 2024 10:05 • 27 days ago

Creating and Connecting to A HeatWave MySQL Always Free Instance (from ODBMS.org)

By Scott Stroz, MySQL Developer Advocate Oracle Cloud Infrastructure (OCI) has a very robust always-free tier. Oracle recently announced that HeatWave MySQL will now be part of that offering. As part of the always-free tier, we can... [...]
Published Wednesday, 25. September 2024 10:02 • 27 days ago

Intro to Node’s built-in SQLite module (from InfoWorld)

pNode 22.5.0 now bundles SQLite, a lightweight, in-process relational database that requires no additional infrastructure but packs considerable capability. Let’s get to know this handy new built-in feature in Node.js./p What is SQLite? pRelational databases are a key component of the software landscape. SQLite is a simple but versatile implementation with a variety of [...]
Published Wednesday, 25. September 2024 09:00 • 28 days ago

The Impact of Using UUIDs as Primary Keys in MySQL, MariaDB and Percona – Part 2 (from DBPEDIABLOGS)

Introduction Primary keys (PKs) are crucial for database indexing and performance. In MySQL, particularly with the InnoDB storage engine, primary keys are clustered indexes, meaning the table data is stored physically on disk in the order of the primary key values. This clustered nature makes the choice of primary key critical for database performance, especially […] [...]
Published Wednesday, 25. September 2024 07:15 • 28 days ago