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.

Wednesday, 13. November 2024

Some InnoDB Cluster troubleshooting commands (from MySQL-Med)

A quick overview of some commands to ensure you can handle your InnoDB Cluster when things get difficult. Continue reading → [...]

Enhancements to MariaDB Logical Dump and Import Tools in Release Series 11.5/11.6 (from MariaDB Corporation Blog)

In this post, we’ll explore the enhancements made to MariaDB’s backup and restore tools, mariadb-dump and mariadb-import, implemented in MDEV-33635 … Continued [...]

BSE (Bombay Stock Exchange) Processes Billions of Transactions Daily with MySQL Enterprise Edition (from The Oracle MySQL Blog)

BSE leverages MySQL Enterprise Edition for processing 150 million trades and 5 billion orders per day. [...]

Tuesday, 12. November 2024

MariaDB C Connector 3.4.3, 3.3.13, and 3.1.26 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.4.3, 3.3.13, and 3.1.26. Download Now Release Notes and … Continued [...]

Jemalloc install & config for MySQL (from MySQL-Med)

Have a look into how to deploy jemalloc and install, configure & test for your MySQL Server. Continue reading → [...]

Difference Between WAL Files and Transaction Logs in PostgreSQL (from MinervaDB Blog)

pUnderstanding the Difference Between WAL Files and Transaction Logs in PostgreSQL In PostgreSQL, two key components that are frequently discussed in relation to database management and performance are the transaction log and the WAL (Write-Ahead [...]/p pThe post Difference Between WAL Files and Transaction Logs in PostgreSQL appeared first on The WebScale Database Infrastructure Operations Expert [...]

Boosting Profitability in Financial Services with MySQL (from The Oracle MySQL Blog)

MySQL not only helps financial institutions bolster their profitability but also equips them to thrive in a rapidly changing market. Embracing MySQL is a strategic move for any financial services organization looking to secure its future in a digital-first world. Read the full blog. [...]

Grouping and Aggregations on Vitess (from Vitess)

I love my job. One of the best feelings is when I find an interesting paper and use it to solve a real problem. It feels like I found a cheat code. Instead of having to do a lot of hard thinking, I can just stand on the shoulders of really big people and take a shortcut. Here, I want to share a recent project that I could solve using a public paper. [...]

Monday, 11. November 2024

Long and Silent / Stressful MySQL Startup with Many Tables (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 two posts on the subject, the links are below.  So far, I did not share what brought my attention to this, and it is the subject of this post.  Also, and because it is related, I come back to the optimization / contribution I already made on [...]

Faster MySQL Startup with Many Tables (1M+) (from J-F Gagné's MySQL Blog)

I have been scratching my head about MySQL startup for some time.  There is much to say about this, and many other posts will probably follow.  For now, it is enough to know that with many tables (millions) the startup of MySQL 8.0+ (including 8.0, 8.4 and 9.0) is suboptimal (to say the least).  With very little changes, I was able to speed it up, from 2:39 to 1:09 (1 minute and 9 [...]

7-point checklist to conquer MySQL 5.7 to 8.0 upgrade challenges (from Azure for MySQL Blog)

pWith the ever-increasing pace of technology, it’s easy to miss out on database end-of-life (EOL) dates, especially in complex multi-database environments. This is especially the case with MySQL 5.7, which reached end-of-life status in October 2023./p pDatabases based on the older versions like MySQL 5.7, after they stop receiving security updates, can have bugs and security vulnerabilities that pu [...]

Evolution of Histograms in MySQL 8.4: From Manual to Automated Performance Optimization (from Mydbops Blog)

Explore the evolution of histograms in MySQL and how MySQL 8.4's automated updates improve query optimization and performance. [...]

Release and version management is hard (from Daniël's Database Blog)

pIn this post I will talk about release management with MySQL as example. Release management has to do with what to put in a release, how often to do a release, how to long to support a release and how to number or name the releases./p The early years pToday software is almost exclusively delivered over the internet, but this didn’t use to be the case. Software used to be delivered in a box that yo [...]

Saturday, 09. November 2024

Managing SQL Drift: Ensuring Stability in Database Transitions (from Ronald Bradford Blog)

SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity. Such challenges extend beyond simple […] [...]

Fixing some of the InnoDB scan perf regressions in a MySQL fork (from Small Datum)

pI recently learned of Advanced MySQL, a MySQL fork, and ran my sysbench benchmarks for it. It fixed some, but not all, of the regressions for write heavy workloads that landed in InnoDB after MySQL 8.0.28.brbrIn response to my results, the project lead filed a bug for performance regressions and then quickly came up with a diff. The bug in this case is for regressions that are most obvious during [...]

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

pI recently shared benchmark results for RocksDB a few weeks ago for both leveled and universal compaction on a small server. This post has results from a large server with leveled compaction. /pptl;dr/pp/pullithere are a few regressions from bug 12038/liliQPS for overwrite is ~1.5X to ~2X better in 9.x than 6.0 (ignoring bug 12038)/liliotherwise QPS in 9.x is similar to 6.x/li/ulp/ppHardware/ [...]

Efficient MySQL Performance In 10 Sentences (from Hack MySQL)

pDon’t have time to read Efficient MySQL Performance? Here’s the book (10 chapters) in one-liners./p ol liPerformance is query response time./li liProper left-most indexing is required for performance./li liThe less data, the better./li liAccess patterns (part of the workload) help or hinder performance./li liSharding is how to scale writes when single-node performance is truly reached. [...]

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

Friday, 08. November 2024

Storing the MySQL Data Dictionary in a 3rd-Party Storage Engine (from Laurynas Biveinis' blog)

pMySQL 8.0 replaced legacy codeFRM/code files with a transactional data dictionary, stored in InnoDB. Here I'll describe how any other storage engine could become the DDSE, that is, serve as the backend for the data dictionary, replacing InnoDB. This is purely an internals post, and will not look into user-facing motivations and implications of the change (which can be found here), now will it disc [...]

How to Connect PHP With MySQL (from Devart MySQL Tool Blog)

pRead on to learn about how to connect PHP with a MySQL database using different methods, including mysqli, PDO, and dbForge for MySQL. /p pThe post How to Connect PHP With MySQL appeared first on Devart Blog./p [...]

Implementing a Tamper-Proof Ledger in PostgreSQL (from MinervaDB Blog)

pImplementing a Tamper-Proof Ledger in PostgreSQL for Auditable and Secure Data Storage In PostgreSQL, a ledger refers to a specialized database structure or extension designed to provide immutable, auditable, and secure data storage. This structure [...]/p pThe post Implementing a Tamper-Proof Ledger in PostgreSQL appeared first on The WebScale Database Infrastructure Operations Experts in Postgre [...]

Thursday, 07. November 2024

Enforcing strong passwords for MariaDB users (from Vettabase)

MariaDB users normally connect using a password. Weak passwords are a common security problem, especially when passwords are generated by humans. However, MariaDB comes with plugins that help validating passwords to make sure they are strong enough. This article is a practical overview of MariaDB password validation plugins. Managing password validation plugins Password validation plugins are just [...]

Introducing sharding on PlanetScale with workflows (from PlanetScale Blog)

Run Vitess workflows right from within PlanetScale. Migrate data from unsharded to sharded keyspaces, manage traffic cutover, and easily revert when problems arise. [...]

Wednesday, 06. November 2024

Isolation level violation testing and debugging in MariaDB (from MariaDB Corporation Blog)

Isolation is one of key transaction properties in database systems (the I in ACID), and its violation is a serious … Continued [...]

An Elephant in the Cluster: Making PostgreSQL Feel at Home on Kubernetes (from Percona Database Blog)

♦TL;DR Kubernetes was built for stateless apps, but as more stateful applications (like databases) run on it, operators include quite heavy implementations to Kubernetes workload management API (such as StatefulSets) deficits. While creating custom methods allows flexibility and faster time to market, it also leads to inconsistency and complexity. In this blog, I want to […] [...]

MySQL Podcast – Practical Learning & Training (from Kedar MySQL Blog)

pHello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…/p The post MySQL Podcast – Practical Learning & Training first appeared on Change Is Inevitable. [...]

Top MySQL Hosting Providers in 2024 for Reliable Database Management (from Devart MySQL Tool Blog)

pCloud-based database hosting seems to be an extremely viable solution for modern apps. After all, the entire management-and-maintenance thing is relegated to the hosting provider, scalability is not an issue, and you are free to focus on product development as you see fit./p pThe post Top MySQL Hosting Providers in 2024 for Reliable Database Management appeared first on Devart Blog./p [...]

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

pThis has benchmark results for RocksDB using a big (48-core) server. I ran tests to document the impact of the the block cache type (LRU vs hyperclock) and a few other configuration choices for a CPU-bound workload. A previous post with great results for the hyperclock block cache is here./pptl;dr/pulliread QPS is up to ~3X better with auto_hyper_clock_cache vs LRU/liliread QPS is up to ~1.3X bett [...]

Tuesday, 05. November 2024

Get Some REST With The Tungsten API (from Continuent Blog)

Standards allow modern systems to advance, and the REST specification is one very important example. Since this post is about the Tungsten API in specific, let me simply say this - a RESTful API adheres to six principles: Client-server, stateless, cacheable, uniform interface, layered system and optionally code on demand. As part of the watchability/monitoring goal, our software as of version 7.0.0 [...]

MMQ : MariaDB (as a) Messsage Queue (from The consistent voice)

MMQ : MariaDB (as a) Messsage Queuesee Addendum/erratum at the end of the storypLet’s practice a theoritical architectural exercise here./ppWhen faced with the challenge of building an internal asynchronous message queue system without introducing new dependencies, leveraging MariaDB can be an effective solution. Thanks to its robust set of features and rich history, MariaDB is well-suited for this [...]

Multi-Source Replication From Dolt to MySQL (from DoltHub Blog)

One of MySQL's greatest features is its robust replication support. MySQL replication provides scalability, reliability, and high… [...]

Optimizing query planning in Vitess: a step-by-step approach (from Vitess)

Introduction # In this blog post, we will discuss an example of a change to the Vitess query planner and how it enhances the optimization process. The new model focuses on making every step in the optimization pipeline a runnable plan. This approach offers several benefits, including simpler understanding and reasoning, ease of testing, and the ability to use arbitrary expressions in ordering, grou [...]

Monday, 04. November 2024

Adding an Invisible Primary Key to an Existing Table in MySQL (from Another Boring Tech Blog)

pWith MySQL 8.0.23, the concept of invisible columns was introduced. Columns marked as invisible do not appear in standard [crayon-67294d8c25372202799568-i/]  queries and don’t require changes to existing application code. Later, in MySQL 8.0.30, support for automatically generated invisible primary keys (GIPKs) was added for InnoDB tables created without an explicit primary key. This enhancement, [...]

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

pI shared benchmark results for RocksDB a few weeks ago using leveled compaction and a small server. Here I have results for universal compaction and the same small server./ptl;drulliin general the there are some improvements and some small regressions with one exception (see  bug 12038)/lilifor a cached database/liulliFrom RocksDB 6.0.2 to 9.x QPS drops by ~10% for fillseq and [...]

Let’s go physical(ly separated) (from The consistent voice)

♦pIn my previous article , we discussed best practices for securing and monitoring admin access, such as role-based access controls (RBAC). It’s a good time to have a quick reminder about AAA aka “ Authentication, Authorization and Accounting” , which is a framework designed to manage access to networked resources and ensure secure, controlled interactions :/polliAuthentication : Verifies the ident [...]

MySQL Change Buffer – What When and FAQ (from Kedar MySQL Blog)

pIn the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…/p The post MySQL Change Buffer – What When and FAQ first appeared on Change Is Inevitable. [...]

WePay's Journey to Enhanced Database Performance with MySQL Enterprise Edition (from The Oracle MySQL Blog)

WePay, the integrated payments arm of JPMorgan Chase, has taken significant strides to enhance its database infrastructure by upgrading to MySQL Enterprise Edition. For businesses looking to optimize their payment infrastructure, the journey of WePay serves as an insightful case study on leveraging advanced database solutions for maximum uptime and security. [...]

Exposing PostgreSQL with NGINX Ingress Controller (from Percona Database Blog)

♦I wrote a blog post in the past about a generic approach on how to expose databases in Kubernetes with Ingress controllers. Today, we will dive deeper into PostgreSQL with ingress and also review two different ways that can be taken to expose the TCP service. The goal is to expose multiple PostgreSQL clusters through […] [...]

MariaDB 11.4.4, 11.2.6, 10.11.10, 10.6.20 and 10.5.27 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.4.4, MariaDB 10.11.10, MariaDB 10.6.20 and MariaDB 10.5.27, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.6 the latest and final scheduled release in the 11.2 short-term series (maintained for one year)br See the r [...]

Embracing Distributed SQL to Drive AI-Readiness in Banking: A Q&A from SACCC 2024 (from PingCAP Blog)

pFinancial services are rapidly transforming to adopt AI, digitize operations, and enhance customer experiences, yet many banks struggle with outdated legacy data systems that limit AI adoption.  At the Silverlake Axis Customer Connect Conference (SACCC), held from October 17 to 20, 2024, in Da Nang, Vietnam, industry leaders focused on modernizing banking infrastructure. C-suite executives, [ [...]

An Ooey GUI Guide to Using Dolt (from DoltHub Blog)

Dolt is inspired by Git and MySQL, two deeply command-line oriented software programs. Thus, Dolt started as a command line utility… [...]

Sunday, 03. November 2024

GenAI chatbot with Laravel, Redis, OpenAI, and LLPhant (from MORTENSI)

pGenAI chatbots help improve the user experience of the visitors to your website. Using natural language, you can connect users with your products, services, documentation, and FAQs and simulate the interactivity of a human operator (kind of). Either choose a third-party service or develop your own; nowadays, you are a few clicks away from offering […]/p pThe post GenAI chatbot with Laravel, [...]

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Recap from MySQL Day Brazil, Oct 5, 2024 [...]

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

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

Sunday, 06. October 2024

MySQL Clone Plugin Speed Test (from Mydbops Blog)

Discover the fastest MySQL backup and recovery methods! This blog compares the MySQL Clone Plugin, Xtrabackup, mysqldump, mydumper & mysqlpump. [...]

Scale Your Database Traffic with Read/Write Splitting using MySQL Router: A Mydbops Webinar Recap (from Mydbops Blog)

MySQL Router for Database Traffic Optimization! Mydbops' webinar explores how it boosts performance & scalability. Learn benefits, features & see how it compares. [...]

MySQL Release Cycle Revolution: Unleashing a New Era of Innovation and Stability (from Mydbops Blog)

Discover the exciting changes in the MySQL release cycle! Oracle introduces MySQL LTS and Innovation releases, focusing on stability, flexibility, and continuous improvement. [...]

Mysqldump​ vs Mysqlpump vs Mydumper (from Mydbops Blog)

Unveiling the strengths and weaknesses of mysqldump, mysqlpump, and mydumper for crafting a robust logical backup strategy. [...]

Thank you for attending the 6th edition of Mydbops MyWebinar (from Mydbops Blog)

Learn how to effectively rebuild MySQL databases using logical backups! Recap key insights from our MyWebinar on tools, techniques, and best practices. [...]

Using RDS for MySQL? Have you upgraded it, yet? (from Mydbops Blog)

Don't wait for AWS to force your MySQL 5.6 upgrade! Avoid data loss & performance issues with a proactive strategy. [...]

Master MySQL Indexing & Explain Plan in Mydbops MyWebinar Edition 32 (from Mydbops Blog)

Struggling with slow MySQL queries? Unleash performance gains with Mydbops MyWebinar! Learn efficient indexing techniques and master the new MySQL Explain Plan features to optimize your database. [...]

Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31 (from Mydbops Blog)

Discover how to leverage the enhanced parallel index rebuild feature in MySQL 8.0.31 to significantly reduce index creation time and optimize database performance. [...]

MySQL Replication Options: Native vs. InnoDB Cluster (from Mydbops Blog)

Explore the differences between Native Replication and InnoDB Cluster for MySQL high availability and replication. Learn which solution suits your specific needs for data integrity and scalability. [...]

Ensure better defaults with InnoDB Dedicated server. (from Mydbops Blog)

Is your MySQL database on a dedicated server but not delivering peak performance? Discover how enabling innodb_dedicated_server in MySQL 8.0 automatically optimizes key variables. [...]

Presentation : Customer Experience on InnoDB Cluster (from Mydbops Blog)

Witness a real-world success story! Mydbops, your MySQL authority, presents a case study of a leading North American retailer's migration from an enterprise database to InnoDB Cluster. [...]

MySQL Clone Plugin in Group Replication and fine-tuning clone plugin (from Mydbops Blog)

Explore the MySQL clone plugin in group replication and optimize your database management and replication processes. [...]

Implementing MySQL Group Replication on Amazon RDS 8.0.35 (from Mydbops Blog)

Unlock the power of MySQL Group Replication on Amazon RDS 8.0.35 for seamless data replication, consistency, and high availability. Follow our guide for essential steps and expert insights. [...]

10 New Functions for JSON Columns in MySQL 8. (from Mydbops Blog)

MySQL has come a long way, and keeps on bringing in new improvements and new collections of JSON functions. Here are a few techniques to store data in JSON columns. MySQL Vs MariaDB JSON Implementati [...]

MySQL 8.0 Clone Plugin and its internal process. (from Mydbops Blog)

MySQL 8 has recently released clone plugin which makes DBA’s task of rebuilding the DB servers more easy. Cloning is a process of creating an exact copy of the original. In technical terms cloning ali [...]

Saturday, 05. October 2024

Histogram​ in MySQL 8.0 (from Mydbops Blog)

MySQL 8.0 introduces many new features. We will have a look at the exciting histogram feature in MySQL 8.0 Histogram: What is Histogram? In General, a histogram is an accurate representation of the d [...]

Common Table Expression (CTE) MySQL 8.0. (from Mydbops Blog)

1.0. Introduction: MySQL 8.0 was released with awesome features. One of its most prominent features is CTE (Common Table Expression). The Common Table Expression can be used to construct complex queri [...]

Mydbops Delighted to be part of Open Source India -2018 (from Mydbops Blog)

Mydbops has partnered with OSI days for the second consecutive year. OSI days is one of the Asia’s leading open source conference. Presentations on MySQL Topic : Evolution of DBA’s in Cloud P [...]

ProxySQL Series: Seamless Replication Switchover Using MHA (from Mydbops Blog)

This is our second blog in the ProxySQL Series ( Blog I MySQL Replication Read-write Split up ). Will cover how to integrate ProxySQL with MHA to handle failover of Database servers. We already have M [...]

Investigating a MySQL dead lock (from Mydbops Blog)

I was involved in one of the development support for MySQL. Here is an interesting case The application needs a Sequence generator as it was not present inbuilt with MySQL ( MariaDB will have it in 10 [...]

Ulimit conflict with PAM and Systemd​​​ (from Mydbops Blog)

As a part of the MySQL Support, we had a support request from a client.The issue is DB server runs out of open files limit, though it is configured. It causes the DB hang and crash at times. Sometimes [...]

Summary – Mydbops Database meetup 2 (from Mydbops Blog)

Mydbops database meetup was held on 26-01-2019 and 48 members from open source database community has attended this event. We had talks on MySQL and MongoDB databases. Open source database enthusiasti [...]

Troubleshooting MySQL Write Stalls and High Active Threads (from Mydbops Blog)

Discover how to resolve MySQL write stalls and reduce active threads by increasing the redo log size. Learn the step-by-step solution implemented by Mydbops and optimize your managed MySQL service. [...]

Security Enhancement in MySQL 5.7 (from Mydbops Blog)

SECURITY ENHANCEMENT IN MYSQL 5.7 MySQL 5.7 has more security enhancements. Some features were removed and some features are added. A temporary password will be generated at time of installation. It c [...]

ONLINE REPLICATION FILTER IN MySQL 5.7 (from Mydbops Blog)

An Unique feature in MySQL is Replication. In MySQL replication the changes are recorded in Binary log of master irrespective of the Engines. The Binlogs are then applied on the slave. What is Replica [...]

Faster Logical backup using MyDUMPER (Presentation). (from Mydbops Blog)

Backups are crucial for any organization. At MyDBOPS our clients need both logical and hot backup. We use mydumper for faster logical backups. We have made a blog on mysqlpump ( 5.7) to make faster lo [...]

Multi-Source Replication in MySQL 5.7 (from Mydbops Blog)

One of the prime feature that makes MySQL popular as an open source database from early days was Replication. MySQL Replication has under gone various improvements in MySQL 5.7. The prominent replicat [...]

An Overview to MySQL SYS Schema (from Mydbops Blog)

Presentation on MySQL Sys Schema in MySQL 5.7. Sys Schema views can help in better monitoring and understanding the MySQL resource consumption at various levels. [...]

MySQL Enterprise Backup ( MEB) (from Mydbops Blog)

MySQL Enterprise Backup (MEB) is a high performance hot backup tool. It is a stable tool and evolved with changes in IT industry. The recent versions has support to direct cloud backup in S3. It is an [...]

Exploring MySQL Group Replication Communication Stack: XCom vs MySQL (from Mydbops Blog)

Explore the intricacies of XCom and MySQL communication stacks in MySQL Group Replication. Learn their strengths, weaknesses, and switching methods. [...]

Estimating records in index range and CPU Spike (MariaDB) (from Mydbops Blog)

Recently we got paged by CPU spikes on one of our clients slave MySQL ( MariaDB ) server under MyDBOPS Remote DBA Team Support. Our MySQL Engineers started analysing the root cause of the issues and r [...]