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.

Friday, 01. November 2024

MariaDB Community Server Q4 2024 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.4, 11.2.6, 10.11.10, 10.6.20, and 10.5.27 maintenance releases. … Continued [...]

Too many performance regressions for InnoDB in MySQL 8.0.29 and 8.0.30 (from Small Datum)

There are many changes to InnoDB in MySQL 8.0.29 and 8.0.30. And many changes increases the chance of performance regressions. A recent report on this from me is here. In the worst-case the throughput drops almost in half for the update-index microbenchmark. This blog post identifies the diff that causes the regression.brtl;drullithis diff causes the update-index regression. The diff adds support f [...]

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

Trying out Advanced MySQL (from Small Datum)

pI recently learned of the Advanced MySQL project on github via a tweet. There is a book and a repo for an enhanced version of 8.0.40. I wish I had the time to read some of that book and learn more about the enhancements but for now I just ran my sysbench tests for it on a few large servers. Hopefully I will also run the Insert Benchmark for it on the same servers./pptl;dr/pp/pulliAdvanced MySQL is [...]

How Can MySQL Catch Up with PostgreSQL’s Momentum? (from Percona Database Blog)

♦When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome and still more popular than PostgreSQL (according to DB-Engines methodology at least), but it is losing ground while PostgreSQL’s growth in popularity has been unstoppable?” Can anything be done in the MySQL ecosystem to reverse […] [...]

Use Dolt With MySQL Connector in Python (from DoltHub Blog)

Dolt is a version controlled MySQL compatible database. It means you can commit, diff and merge along with other Git-like version control… [...]

Thursday, 31. October 2024

How Dafiti migrated its most critical database to Amazon Aurora MySQL with minimal downtime and improved operational efficiency (from AWS Database Blog)

In the dynamic world of digital retail, performance, resilience, and availability are not only desirable qualities, they are essential. Recently, Dafiti, a leading fashion and lifestyle ecommerce conglomerate operating in Brazil, Argentina, Chile, and Colombia, undertook a significant transformation of its critical database infrastructure by migrating from self-managed MySQL Server 5.7 on Amazon EC [...]

Celebrating 15 years of innovation (from MariaDB Foundation Blog)

pWe have been in festive mode this week, celebrating fifteen years of MariaDB. You may have seen our very own Ian Gilfillan’s blog MariaDB Server turns fifteen! … /p pContinue reading \"Celebrating 15 years of innovation\"/p pThe post Celebrating 15 years of innovation appeared first on MariaDB.org./p [...]

Amazon Aurora supports rolling upgrades for Operating System upgrades (from AWS What's New)

pAmazon Aurora announced rolling upgrades support for Operating System (OS) upgrades. Aurora now seamlessly upgrades the OS version of Aurora database clusters while maintaining read access to the data when using Aurora cluster or reader endpoint. The feature automatically applies upgrades to a few reader instances at a time so the database can continue serving read traffic for clusters with more t [...]

Tracking Dual Passwords in MySQL (from Percona Database Blog)

♦We already have blog posts about Dual Password in MySQL from Brian Sumpter – Using MySQL 8 Dual Passwords, and from Marco Tusa – MySQL Dual Passwords – How To Manage Them Programmatically Let’s skip the details about dual passwords and focus on tracking password usage. How can we be sure that we are using […] [...]

New JSON format for EXPLAIN (from The Oracle MySQL Blog)

MySQL 8.3 introduced a new JSON format for EXPLAIN reflecting how the execution plan actually is built, allowing for programmatic analysis of plans and executions. [...]

Enhancing MySQL Security: Data-at-Rest Encryption with the Keyring Plugin (from Vettabase)

In this article, we'll explain why encrypting tablespaces and binary logs in MySQL is so important. Do expect step-by-step guidelines and practical examples demonstrating common risks coming with non-encryption. [...]

Support for large transactions in Galera: Taking Streaming Replication for a spin (from Galera Blog)

We have documented streaming replication, and we have also mentioned how you can use streaming replication, and we also once did a webinar with recording on it, and we wrote a very in-depth blog post on how to use streaming replication to manage large transactions with Galera Cluster. However, we had a question recently about […] [...]

Sleuthing resource leaks in Dolt (from DoltHub Blog)

Recently, users running SQL queries against their databases hosted on DoltHub has led us to uncovering some really interesting bugs in Dolt… [...]

Wednesday, 30. October 2024

Celebrating 15 years of MariaDB Server (from MariaDB Corporation Blog)

It is now 15 years since the first MariaDB Server release of MariaDB 5.1.38 on 29’th of October 2009. The … Continued [...]

Celebrating the GitHub Awards 2024 recipients 🎉 (from The GitHub Blog)

pThe GitHub Awards celebrates the outstanding contributions and achievements in the developer community by honoring individuals, projects, and organizations for creating an outsized positive impact on the community./p pThe post Celebrating the GitHub Awards 2024 recipients 🎉 appeared first on The GitHub Blog./p [...]

Using the MySQL “SET ROLE” to Enforce “Least Privilege” Principles (from The Oracle MySQL Blog)

How using SET ROLE can be used to define a “Least Privilege” model for accessing database objects based on a user’s current task. [...]

Tuesday, 29. October 2024

Performance testing MySQL migration environments using query playback and traffic mirroring – Part 3 (from AWS Database Blog)

This is the third post in a series where we dive deep into performance testing of MySQL environments being migrated from on premises. In Part 1, we compared the query playback and traffic mirroring approaches at a high level. In Part 2, we showed how to set up and configure query playback. In this post, we show you how to set up and configure traffic mirroring. [...]

Performance testing MySQL migration environments using query playback and traffic mirroring – Part 2 (from AWS Database Blog)

This is the second post in a series where we dive deep into performance testing MySQL environments being migrated from on premises. In Part 1, we compared the query playback and traffic mirroring approaches at a high level. In this post, we dive into the setup and configuration of query playback. [...]

Performance testing MySQL migration environments using query playback and traffic mirroring – Part 1 (from AWS Database Blog)

In this series of posts, we dive deep into performance testing of MySQL environments being migrated from on-premises to AWS. In this post, we review two different approaches to testing migrated environments with traffic that is representative of real production traffic: capturing and replaying traffic using a playback application, and mirroring traffic as it comes in using a proxy. This means you’r [...]

What’s Next for SQL @ Scale? TiDB’s Vision to Evolve Growing Businesses (from PingCAP Blog)

pScaling database systems remains one of the biggest challenges facing growing companies modernizing IT infrastructure. Max Liu, Co-Founder and CEO of PingCAP, discussed these critical scaling challenges during his opening keynote, “What’s Next for SQL @ Scale,” at HTAP Summit 2024. Drawing from real-world examples and industry insights, Liu explored how TiDB addresses the limitations […]/p p [...]

MariaDB Server turns fifteen! (from MariaDB Foundation Blog)

pFifteen years ago, Internet Explorer made up about two-thirds of all browsers, Firefox the majority of the rest, while a newly-released browser called Chrome was starting to appear in the rankings. … /p pContinue reading \"MariaDB Server turns fifteen!\"/p pThe post MariaDB Server turns fifteen! appeared first on MariaDB.org./p [...]

Use HammerDB to run performance tests on Amazon RDS for Db2 (from AWS Database Blog)

To ensure that you properly size your Amazon RDS for Db2 instances and achieve comparable or better performance than your on-premises systems, you can use HammerDB. By using this tool, you can generate OLTP-type workloads using TPC-C tests, enabling you to compare performance between your on-premises Db2 and Amazon RDS for Db2 systems. This post guides you through running HammerDB tests on RDS for [...]

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

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports M7i and R7i database (DB) instances. M7i and R7i are the latest Intel based offering and are available with a new maximum instance size of 48xlarge, which brings 50% more vCPU and memory than the maximum size of M6i and R6i instance types.br br M7i and R7i DB instances are available for Amazon RDS for P [...]

preFOSDEM MySQL Belgian Days 2025 – save the dates (from lefred's blog)

As announced yesterday, the MySQL Devroom is back at FOSDEM! For people preparing for their travel to Belgium, we want to announce that the MySQL Belgian Days fringe event will be held on the Thursday and Friday before FOSDEM. This event will take place on January 30th and 31st, 2025, in Brussels at the usual […] [...]

preFOSDEM MySQL Belgian Days 2025 - save the dates (from The Oracle MySQL Blog)

For people to prepare for their travel to Belgium, we want to announce that the preFOSDEM fringe event known as the MySQL Belgian Days will take place the Thursday and Friday, January 30 and 31, before FOSDEM. [...]

MariaDB Server Turns 15! Here Are 15 Reasons Why Developers and DBAs Love It (from MariaDB Corporation Blog)

October 29, 2009 was a special day in the database community—it saw the first release of MariaDB Server. Started as … Continued [...]

Announcing Vitess 21 (from PlanetScale Blog)

Vitess 21 is now generally available. [...]

Announcing Vitess 21 (from Vitess)

Announcing Vitess 21 # We're delighted to announce the release of Vitess 21 along with version 2.14.0 of the Vitess Kubernetes Operator. Version 21 focuses on enhancing query compatibility, improving cluster management, and expanding VReplication capabilities, with experimental support for atomic distributed transactions and recursive CTEs. Key features include reference table materialization, mult [...]

Monday, 28. October 2024

FLUSH_PRIVILEGES: A new dynamic privilege to execute FLUSH PRIVILEGES (from The Oracle MySQL Blog)

MySQL 8.4 introduces a new privilege, FLUSH_PRIVILEGES, which allows database users to execute FLUSH PRIVILEGES statement without the need of RELOAD privilege. [...]

How to use passkeys to authenticate to MySQL (from The Oracle MySQL Blog)

MySQL 9.1 adds support for Windows Hello. And this supports passkeys stored on the OS store. Check how to set up and use one of these instead of the hardware based FIDO2 devices [...]

The MySQL Hypergraph Optimizer Now Available in HeatWave MySQL (from The Oracle MySQL Blog)

Starting with MySQL 9.0, users of HeatWave MySQL can now try the new hypergraph optimizer. Read on to learn how to enable the hypergraph optimizer, and to understand what it means for your query plans. [...]

Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible (from J-F Gagné's MySQL Blog)

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote a post about my work (Faster MySQL Startup with Many Tables).  In that post, I link to a bug report (Bug #115988 : Too Much Disk Read on Startup, penalizing deployments with many tables).  In that bug report, I write, without much details, that the [...]

MariaDB for SQL Server DBA (from MinervaDB Blog)

pMariaDB for SQL Server DBA - How do you configure MariaDB for Transaction Log Backup? While MariaDB does not offer a native transaction log backup feature comparable to Microsoft SQL Server, it provides an equivalent [...]/p pThe post MariaDB for SQL Server DBA appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse./p [...]

Abandonware in Popular Open Source Databases (from Percona Database Blog)

♦Inspired by this comment in the Hacker News discussion, I posted polls on my LinkedIn network about the tendency (or perception of tendency) to abandon features without deprecating them in some of the most popular open source databases – MySQL, MariaDB, and PostgreSQL.  First, let’s look at why “Abandoning” features rather than formally depreciating them […] [...]

MySQL NDB Cluster 8.4 - What's new (from The Oracle MySQL Blog)

The MySQL NDB Cluster Development team is quite happy to announce that MySQL NDB Cluster 8.4 (LTS) is available for download. This release includes new features made available before under Innovation Releases - 8.1, 8.2 and 8.3 - and new features made available in 8.4. [...]

MySQL Connector/J Observability with OpenTelemetry (from The Oracle MySQL Blog)

The OpenTelemetry project is an open-source, vendor-neutral observability framework, providing a common observability standard. It enables users to instrument their applications in order to export observability data: traces, metrics, and logs, enabling increased granularity of debugging and testing. MySQL Connector/J now supports producing observability data, baked into the driver code, offering a [...]

FOSDEM 2025 MySQL Devroom - call for participation (from The Oracle MySQL Blog)

This is the call for participation for the FOSDEM 2025 MySQL Devroom [...]

FOSDEM 2025 MySQL Devroom – call for participation (from FOSDEM MySQL & Friends Devroom)

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […] [...]

FOSDEM 2025 MySQL Devroom – call for participation (from lefred's blog)

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […] [...]

MySQL: information_schema.tables performance regression (from Die wunderbare Welt von Isotopp)

pIn IRC codelibera:#mysql/code somebody asked about the performance of codeSHOW TABLES LIKE 'name'/code in MySQL 8.0, which was slow for them, but fast in 5.7. They pointed to a forum article from 2022 that had a similar problem with a codeselect/code-statement on codeI_S.TABLES/code./p pBoth cases had in common a large number of tables in a single schema. The person in IRC had around 40k tables, [...]

MySQL: dual passwords (from Die wunderbare Welt von Isotopp)

pAccount password rotation is often a regulatory requirement. For that very reason, MySQL allows you to have multiple passwords on a single account./p pI have written about this in Rotating Accounts or Passwords? ./p pOf course, if something is a regulatory requirement, you also need to prove that you are meeting it./p pSo Percona has a nice article Tracking Dual Passwords in MySQL which shows h [...]

Galera : understanding Flow Control (from The consistent voice)

Galera : understanding Flow ControlpAs explained in a previous article Galera cluster from Codership is a robust synchronous multi-master replication technology integrated directly into MariaDB Server. This powerful feature enables high availability and data consistency across multiple database nodes without the need for additional software. This tight integration helps MariaDB users can leverage t [...]

Friday, 25. October 2024

Understanding PostgreSQL I/O Details (from MinervaDB Blog)

pUnderstanding PostgreSQL I/O Details: A Deep Dive into Monitoring and Optimization Introduction Input/Output (I/O) operations play a critical role in database performance. In PostgreSQL, these operations are fundamental to the efficiency of data retrieval and [...]/p pThe post Understanding PostgreSQL I/O Details appeared first on The WebScale Database Infrastructure Operations Experts in PostgreS [...]

Achieve a high-speed InnoDB purge on Amazon RDS for MySQL and Amazon Aurora MySQL (from AWS Database Blog)

This post outlines a set of design and tuning strategies for a high-speed purge in an Amazon Relational Database Service (Amazon RDS) for MySQL DB instance and Amazon Aurora MySQL-Compatible Edition DB cluster. Purge is a housekeeping operation in a MySQL database. The InnoDB storage engine relies on it to clean up undo logs and delete-marked table records that are no longer needed for multiversion [...]

Amazon Aurora Global Database support for tagging global clusters (from AWS What's New)

pAmazon Aurora Global Database now supports applying tags to your global clusters, enabling you to associate metadata information with your overall Global Database cluster. For instance, you can apply a tag to organize resource costs for your entire Global Database cluster, making it easier to categorize and track your AWS costs.br br Aurora Global Database allows a single Aurora database to span m [...]

Announcing the MariaDB Vector Bounty Program! (from MariaDB Foundation Blog)

pToday, we are excited to announce a new fund to help give MariaDB Vector a high-quality integration into as many LLM frameworks as possible. … /p pContinue reading \"Announcing the MariaDB Vector Bounty Program!\"/p pThe post Announcing the MariaDB Vector Bounty Program! appeared first on MariaDB.org./p [...]

Thursday, 24. October 2024

Updated MariaDB Java, R2DBC, and Node.js Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/Java 3.5.0, Connector/R2DBC 1.3.0, and Connector/Node.js 3.4.0. Download Now   … Continued [...]

Migrate or upgrade your like-to-like databases using AWS DMS homogeneous migration (from AWS Database Blog)

In this post, we highlight common challenges encountered during homogeneous database migrations and how using AWS DMS homogeneous migration can help address them. [...]

Mastering MySQL Instant DDLs: Enhancing Schema Changes with INSTANT (from MinervaDB Blog)

pMastering MySQL Instant DDLs: Enhancing Schema Changes with INSTANT Algorithm, Monitoring, and Rebuild Strategies In MySQL 8.0.12, a new DDL algorithm called INSTANT was introduced, enabling non-blocking schema changes. Initially, INSTANT DDLs allowed adding a [...]/p pThe post Mastering MySQL Instant DDLs: Enhancing Schema Changes with INSTANT appeared first on The WebScale Database Infrastructur [...]

RocksDB benchmarks: small server, leveled compaction (from Small Datum)

pI shared benchmark results for RocksDB a few weeks ago and there was a suggestion for me to repeat tests using different (older) values for format_version. Then while replacing a failed SSD, I also updated the OS and changed a few kernel-related config options. Thus, I ended up repeating all tests.brbrThis post has results from a small server with leveled compaction. Results from a large server an [...]

Recent InnoDB Enhancements that Boost Performance in MariaDB Server (from MariaDB Corporation Blog)

The performance of MariaDB Server has been improved over the years thanks to many enhancements to the InnoDB storage engine … Continued [...]

Automatic Statistics (from DoltHub Blog)

DoltDB is the first relational database that supports Git-like version control primitives like branch, diff, and merge. All our versioning… [...]

Wednesday, 23. October 2024

Evaluating the right fit for your Amazon Aurora workloads: provisioned or Serverless v2 (from AWS Database Blog)

In this post, we cover important concepts of Aurora provisioned and Aurora Serverless v2 databases including cost, performance, features, and how to determine which to use for your workload type. [...]

InnoDB busy-wait loops changed in MySQL 8.0.30 (from Small Datum)

pThis blog post attempts to explain some of the performance regressions that landed in InnoDB with MySQL 8.0.30. I'd rather not try to debug perf regressions long after they arrived but here we are. I assume that most of the problems landing in MySQL 8.0.28+ are also in 8.4 and 9.X, so these are problems the community will be dealing with for a long time.brbrOne blog post that documents the regress [...]

October MySQL Meetups - Recap. (from The Oracle MySQL Blog)

Oct 2024 Meetups Recap [...]

Optimizing PostgreSQL Capacity Planning and Sizing with Default Value Settings (from MinervaDB Blog)

pOptimizing PostgreSQL Capacity Planning and Sizing Through Effective Default Value Settings Establishing default values in PostgreSQL is a crucial component of effective capacity planning and sizing. This practice significantly enhances the database's capacity to manage [...]/p pThe post Optimizing PostgreSQL Capacity Planning and Sizing with Default Value Settings appeared first on The WebScale D [...]

Tuesday, 22. October 2024

Offline mode error improvement (from The Oracle MySQL Blog)

This blog post describes work that landed in MySQL v9.0 and implements generic mechanism to attach key/value attributes to a global system variable, used to improve error messages related to "offline mode". [...]

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

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

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

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

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

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

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

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

A Comprehensive Guide to TiDB’s Backup and Recovery Technology (from PingCAP Blog)

pData loss can occur while using a database for various reasons, such as operator error, malicious hacker attacks, and server hardware failures. Backup and recovery technology is the final line of defense to ensure data can still be restored and used after such losses.  TiDB, as a native distributed database, fully supports various backup and […]/p pThe post A Comprehensive Guide to TiDB [...]

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

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

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

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

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

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

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

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

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

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

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

From Plan to Execution: Zhihu’s Guide to Petabyte-Scale TiDB Database Migration (from PingCAP Blog)

pAuthor: Xiaolei Dai, Database lead at Zhihu Efficient and reliable data migration is crucial for large-scale online services. Zhihu, one of China’s largest knowledge-sharing platforms, recently undertook the complex task of online migration for dozens of TiDB databases, totaling petabytes (PB) of data. This blog post, based on the expertise of Zhihu’s database lead, Dai […]/p pThe post From [...]

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

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

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

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

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

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

How Kissflow Breaks Down Silos: A Unified Data Strategy (from PingCAP Blog)

pDiscover how Kissflow moved from a traditional SQL-based system to a unified data strategy leveraging Hybrid HTAP./p pThe post How Kissflow Breaks Down Silos: A Unified Data Strategy appeared first on TiDB./p [...]

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

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

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

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

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

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

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

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

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

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

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

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

Deploying Galera Cluster 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 […] [...]

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