Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Tuesday, 23. April 2024

Reduce Amazon Aurora MySQL backup costs using MySQL Shell and Amazon S3 (from AWS Database Blog)

Amazon Aurora backs up cluster volumes automatically and retains restore data for the length of the backup retention period. Aurora automated backups are continuous and incremental, so you can restore to any point within the backup retention period from 1–35 days. If you need to retain backups for more than 35 days, you can take manual snapshots […] [...]

Upgrade to Azure Database for MySQL – Flexible Server for better performance with easy migration (from Azure for MySQL Blog)

pWith the retirement of Azure Database for MySQL – Single Server scheduled for this September, it’s time to move to Azure Database for MySQL – Flexible Server. The move improves performance, offers better value, and is supported by an easy migration process for your high-performance online transaction processing (OLTP) applications according to a recent study by Principled Technologies. Overall, Fl [...]

Short note re Progress and NuSphere (from SQL And Its Sequels (Ocelot Blog))

Progress Software on April 19 said more about “considering” an offer for MariaDB plc (the company not the foundation). They own NuSphere which had a dispute with MySQL AB which was settled in 2002. My happy history as a MySQL employee biases me but I thought that NuSphere was not acting angelically. I think it… Continue Reading Short note re Progress and NuSphere [...]

Why MariaDB Is “Better” Than MySQL (from Percona Database Blog)

♦Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […] [...]

From Standalone to High Availability: Convert Your PostgreSQL Database to a Patroni Cluster (from Mydbops Blog)

In Database Management, achieving High Availability(HA) is very important, particularly for systems handling critical data and applications. In a Production Environment, any downtime can translate int [...]

Monday, 22. April 2024

Database Testing – Unveiling the Latest Best Practices and Innovations in 2024 (from Devart MySQL Tool Blog)

pDatabases are invaluable for any application that relies on them. Thus, database testing is a critical aspect of ensuring optimal database performance. This article will delve into various types of database testing, methodologies, and practical applications. /p pThe post Database Testing – Unveiling the Latest Best Practices and Innovations in 2024 appeared first on Devart Blog./p [...]

Sunday, 21. April 2024

The Insert Benchmark: MariaDB, MySQL, small server, cached workload, some concurrency (from Small Datum)

pThis post has results for the Insert Benchmark on a small server with a cached workload. The goal is to compare MariaDB and MySQL./ppThis work was done by Small Datum LLC and sponsored by the MariaDB Foundation./ppThe workload here has some concurrency (4 clients) and the database is cached. The results might be different when the workload is IO-bound or has more concurrency. R [...]

The Insert Benchmark: MariaDB, MySQL, small server, cached workload (from Small Datum)

pThis post has results for the Insert Benchmark on a small server with a cached workload. The goal is to compare MariaDB and MySQL./ppThis work was done by Small Datum LLC and sponsored by the MariaDB Foundation./ppThe workload here has low concurrency and the database is cached. The results might be different when the workload is IO-bound or has more concurrency.brbrtl;dr/pp/pulliModern [...]

Friday, 19. April 2024

Deploying Percona Everest on GCP with Kubectl for Windows 11 Users (from Percona Community Blog)

Welcome to this blog post! Today, our primary goal is to guide you through deploying Percona Everest on GCP using Kubectl, specifically for users on Windows 11. It’s been some time since I last used Windows, so this will be an excellent opportunity to do it from scratch. Let me tell you a little bit about Percona Everest. You may have already heard it recently. It is the new open source tool [...]

Thursday, 18. April 2024

Explain Hypothetical Scenario: The Application Rolls Back the Transaction in MySQL (from MinervaDB Blog)

pIn a hypothetical scenario where an application rolls back a transaction in MySQL, especially when using the InnoDB storage engine, several key processes and implications come into play. This scenario can serve as an instructive [...]/p pThe post Explain Hypothetical Scenario: The Application Rolls Back the Transaction in MySQL appeared first on The WebScale Database Infrastructure Operations Expe [...]

Handle tables without primary keys while creating Amazon Aurora MySQL or Amazon RDS for MySQL zero-ETL integrations with Amazon Redshift (from AWS Database Blog)

At AWS, we have been making steady progress towards bringing our zero-ETL vision to life. With Amazon Aurora zero-ETL integration to Amazon Redshift, you can bring together the transactional data of Amazon Aurora with the analytics capabilities of Amazon Redshift. The integration helps you derive holistic insights across many applications, break data silos in your […] [...]

Handle tables without primary keys while creating Amazon Aurora PostgreSQL zero-ETL integrations with Amazon Redshift (from AWS Database Blog)

At Amazon Web Services (AWS), we have been making steady progress towards bringing our zero-extract, transform, and load (ETL) vision to life. With Amazon Aurora zero-ETL integration to Amazon Redshift, you can bring together the transactional data of Amazon Aurora with the analytics capabilities of Amazon Redshift. The integration helps you derive holistic insights across […] [...]

Should You Deploy Your Databases on Kubernetes? And What Makes StatefulSet Worthwhile? (from Percona Database Blog)

♦Why do cloud-native databases matter?Kubernetes makes it easier to run applications. It’s like having a magic wand for managing everything from small tasks to significant operations. However, despite the popularity of Kubernetes, there are many cases when it might not be the best solution for your database needs.Kubernetes wasn’t built with the needs of databases […] [...]

MySQL NDB Cluster replication: Single-channel replication (from The Oracle MySQL Blog)

This is the second article in our blog series about MySQL NDB Cluster replication, it describes the basic concept and functional parts of a single-channel replication which is used for replicating data between clusters. [...]

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

pWe're pleased to share a summary of the Azure Database for MySQL - Flexible Server feature updates and announcements from last month, as well as the latest roadmap of upcoming features!/p p /p April 2024 Live webinar p /p pThese 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 [...]

How to Add, Show, and Drop MySQL Foreign Keys (from Devart MySQL Tool Blog)

pA key is typically defined as a column or a group of columns that are used to uniquely locate table records in relational databases (including MySQL, of course). And now that we've covered MySQL primary keys on our blog, it's time to give you a similarly handy guide on foreign keys./p pThe post How to Add, Show, and Drop MySQL Foreign Keys appeared first on Devart Blog./p [...]

Creating a MySQL HeatWave Configuration with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a MySQL HeatWave configuration that can be specified when creating a new instance. [...]

Wednesday, 17. April 2024

Programmatic approach to optimize the cost of Amazon RDS snapshots (from AWS Database Blog)

One of the key benefits of Amazon Relational Database Service (Amazon RDS) is that it creates an automated storage volume snapshot of the database instance, backing up the database host at the instance. Amazon RDS saves the automated backups of databases according to the specified backup retention period. The flexibility of creating manual snapshots helps […] [...]

When COMMIT Is the Slowest Query (from Hack MySQL)

pWhen codeCOMMIT/code is the slowest query, it means your storage is slow. Let’s look at an example./p [...]

How MariaDB and MySQL performance changed over releases (from MariaDB Foundation Blog)

pIs performance important for you, along with the latest features and long-term support? Go with MariaDB 11.4. But don’t take our word for it. We asked well known benchmarking expert Mark Callaghan to check out a number of MariaDB and MySQL releases, hit them hard with a tool of his choice, and share his findings. … /p pContinue reading \"How MariaDB and MySQL performance changed over r [...]

Online migration from Single Server to Flexible Server using MySQL Import and Data-In Replication (from Azure for MySQL Blog)

pAzure Database for MySQL – Flexible Server is the flagship Platform as a Service running on Linux, offering of the popular open-source software relational database management system MySQL. It is a go-to platform for web applications such as WordPress, Magento, Moodle in the LAMP stack, e-commerce, OLTP, and gaming on the Microsoft Azure Cloud./p p /p pSince the announcement of deprecation of [...]

Introducing global replica credentials (from PlanetScale Blog)

With global replica credentials, you can now automatically route reads to the closest replica. [...]

Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts (from Percona Database Blog)

♦This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how to set up this distribution on Kubernetes clusters in AWS, Google Cloud, and locally with k3d. You’ll also learn how to switch between these setups to test them effectively.In Kubernetes, a context is a profile […] [...]

Intel, RedHat, and others join hands for Open Platform for Enterprise AI (from InfoWorld)

pIn a move that could redefine how generative AI can be used by enterprises sans the present ambiguity over its ability to scale and interoperable across business systems, the LF AI & Data Foundation has announced the launch of the Open Platform for Enterprise AI (OPEA) in collaboration with several technology companies./ppThe objective is to spearhead the development of open, robust, multi- [...]

Tungsten Dashboard Via Docker: Now Available! (from Continuent Blog)

In this blog post, we explore the new support for running Tungsten Dashboard via Docker containers. This method allows for a rapid configuration of the GUI. We describe the docker method of installing the Tungsten Dashboard using a pre-defined Docker container provided by Continuent containing Apache, PHP, HAProxy and the Dashboard.Tags: tungsten dashboardDashboard via DockerTungsten Dashboard [...]

Tuesday, 16. April 2024

MariaDB Completes Nutanix Ready Certification for AI and Data-Driven Hybrid and Multicloud Applications (from MariaDB Corporation Blog)

In the fast-paced world of enterprise databases, reliability, scalability, and performance are paramount. Cloud deployment flexibility is critically important to … Continued [...]

MySQL Shorts - Episode #60 is Released (from The Oracle MySQL Blog)

Episode #60 of MySQL Shorts in now available! [...]

A Guide to Better Understanding MySQL Charset Levels (from Percona Database Blog)

♦We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova.Some of the questions […] [...]

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

pWith the first quarter of 2024 out of the way, we can take a look at the contribution statistics for the last three months. For the Foundation, this has been a very busy quarter, we have had a few big events to prepare for and attend. … /p pContinue reading \"MariaDB Contribution Statistics, April 2024\"/p pThe post MariaDB Contribution Statistics, April 2024 appeared first on MariaDB.org./p [...]

EMEA MySQL Meetups in April & May 2024! - UPDATED! (from The Oracle MySQL Blog)

MySQL Meetups EMEA in April [...]

A short tale about troubleshooting improbable bug – part deux (from Szymon Skorupinski Blog)

Last month I hoped that we have valid workaround for the bug described in A short tale about troubleshooting improbable bug. Unfortunately, it appeared that it is not working for all cases. As the fix for the bug was still missing, I tried to find something more reliable. Knowing the contents of the stack trace reported … Continue reading "A short tale about troubleshooting improbable bug  [...]

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

Ever struggle with managing high database traffic? Mydbops, a leading database management and consultancy provider, recently hosted a webinar to shed light on how MySQL Router can help. Presented by V [...]

Creating a MySQL HeatWave Read Replica with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a read replica of a MySQL HeatWave instance. [...]

Monday, 15. April 2024

Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB (from Percona Database Blog)

♦If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally.Recently, I had a chance to investigate some of these cases closer, and it stunned me what huge differences there can be depending on the circumstance given the very […] [...]

Friday, 12. April 2024

How to query a REST API with MariaDB CONNECT engine (from Vettabase)

Querying a remote REST API directly from the database: does it sound like pure madness? Some people will surely answer that yes, it does. So, first of all, let me spend a paragraph to show some great benefits of doing so. Then I’ll show you how to query a REST API with MariaDB CONNECT storage engine. I will explore a practical use case with Hashicorp Releases API. The benefits of querying a R [...]

Microsoft Defender for Cloud support for Azure Database for MySQL - Flexible Server - GA (from Azure for MySQL Blog)

pWe’re excited to announce general availability of Microsoft Defender for Cloud support for Azure Database for MySQL - Flexible Server. Defender for Cloud provides Advanced Threat Protection (ATP) as part of the Microsoft Defender for open-source relational databases plan and simplifies security management of your MySQL flexible server by enabling effortless threat prevention, detection, and mitiga [...]

Access Amazon RDS across AWS accounts using AWS PrivateLink, Network Load Balancer, and Amazon RDS Proxy (from AWS Database Blog)

Amazon RDS Proxy is a fully managed, highly available database proxy for Amazon Relational Database Service (Amazon RDS) and Amazon Aurora that makes applications more scalable, secure, and resilient to database failures. With RDS Proxy, you can handle unpredictable surges in database traffic that might otherwise cause issues due to using all available connections or creating new connections at a f [...]

Partially Rolling Back a Transaction in MySQL or PostgreSQL (from Percona Database Blog)

♦This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this feature in databases.DescriptionEvery ACID-compliant RDBMS follows the “All or None” […] [...]

Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a backup of a MySQl HeatWave instance and then restore that back up to a new HeatWave instance. [...]

Sysbench on a small server: MariaDB and MySQL (from Small Datum)

pThis has results from the sysbench benchmark for MariaDB and MySQL on a small server with a cached and low-concurrency workload. For MariaDB I tested LTS releases from 10.2 through 11.4. For MySQL I tested 5.6, 5.7 and 8.0. The results from MySQL here are a good reason to use changepoint detection to spot regressions early, like that provided by Nyrkiö./ppThis work was done by Small Datu [...]

Sysbench on a (less) small server: MariaDB and MySQL (from Small Datum)

pThis has results from the sysbench benchmark for MariaDB and MySQL on a (less) small server with a cached and low-concurrency workload. For MariaDB I tested LTS releases from 10.2 through 11.4. For MySQL I tested 5.6, 5.7 and 8.0. The results from MySQL here are a good reason to use changepoint detection to spot regressions early, like that provided by Nyrkiö./ppThis work was done by&nbs [...]

Thursday, 11. April 2024

How to Replicate and Rename a Database in MariaDB (from Percona Database Blog)

♦MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not dynamic, and you should be aware of that.The use case here is to replicate one database from […] [...]

MySQL at OSC (Open Source Conference) Japan 2023 - Recap. (from The Oracle MySQL Blog)

OSC Japan 2023 recap [...]

Improving Database Performance with ReadySet: A MySQL Caching Solution (from Another Boring Tech Blog)

pMany developers face the challenge of achieving performance without compromising on real-time application functionality in database management. This brings us to today’s spotlight technology: ReadySet. What is ReadySet? According to its GitHub repository, ReadySet is designed to enhance the performance of real-time applications by providing a powerful SQL caching engine that requires no chan [...]

Profiling memory usage in MySQL (from PlanetScale Blog)

Learn how to visualize the memory usage of a MySQL connection [...]

Wednesday, 10. April 2024

Load Test Emulation for Azure Database for MySQL - Flexible Server using mysqlslap (from Azure for MySQL Blog)

pGuidance for using mysqlslap to simulate client load and measure performance/p p /p Introduction pMysqlslap is a diagnostic program included with the MySQL server binary that you can use to emulate client load for a MySQL server and report the timing of each stage. Mysqlslap works as if multiple clients are accessing the server simultaneously./p p /p pIn this post, I’ll show you how to u [...]

GitHub Availability Report: March 2024 (from The GitHub Blog)

pIn March, we experienced two incidents that resulted in degraded performance across GitHub services. /p pThe post GitHub Availability Report: March 2024 appeared first on The GitHub Blog./p [...]

Generally available: Defender for Cloud supports Azure Database for MySQL - Flexible Server (from Azure Updates)

You can now protect Azure Database for MySQL - Flexible Server with Microsoft Defender for Cloud. [...]

17 Years of Insecure MySQL Client ! (from J-F Gagné's MySQL Blog)

Yes, this is a catchy title, but it is true, and it got you reading this post :-).  Another title could have been “Please load this mysql-dump: what could go wrong ?”.  As you guessed, loading a dump is not a risk-free operation.  In this post, I explain how the insecure MySQL client makes this operation risky and how to protect against it. And if you think this post is not [...]

Percona Monitoring and Management Setup on Kubernetes with NGINX Ingress for External Databases (from Percona Database Blog)

♦It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K8s. It acts as a reverse proxy and load […] [...]

Install Tungsten Clustering Version 7 Securely in 10 Easy Steps (from Continuent Blog)

In this blog post, we explore the 10 basic steps for doing a secure Tungsten Clustering deployment. A fresh Tungsten version 7 installation is secure by default. We also cover the various tungsten.ini options that impact an install.Tags: tungsten clustersecuritysslhow to [...]

Listing and Updating MySQL HeatWave Instances with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve a list of MySQL HeatWave instances, retrieve more detailed information for a specific instance, and update properties of that instance. [...]

Top 5 Reasons To Attend MySQL and HeatWave Summit 2024 (from The Oracle MySQL Blog)

Join us at MySQL and HeatWave Summit 2024, on May 1, 2024 in Redwood Shores, California. Free, unperson event, open to all. Learn about Generative AI and Machine Learning. Get One-on-One Help and Feature Demos. Hear from Leading Companies like NVIDIA, Meta, LY Corp, CERN, Panasonic Avionics. And Network with the MySQL Community. [...]

Tuesday, 09. April 2024

Amazon RDS for MySQL supports rds_superuser_role for easier implementation of role based privileges (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports rds_superuser_role to simplify implementation of role-based privileges on MySQL 8.0. The rds_superuser_role is granted by default to the primary administrative user, and has privileges including, CREATE ROLE, CREATE USER, and DROP ROLE, for all database objects. For a complete list of rds_superuser_role privileges, refer to the [...]

Ask Me Anything About MySQL 5.7 to 8.0 Post EOL (from Percona Database Blog)

♦We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In the previous interview with Vinicius, we discussed the upcoming End of Life (EOL) for MySQL 5.7. Now that MySQL 5.7 has reached EOL, MySQL 8 […] [...]

Why Top Spanish Business School Esade Migrated from MySQL to MariaDB Enterprise Server (from MariaDB Corporation Blog)

Esade Ramon Llull University is a top business school located in Barcelona, Spain. They are committed to nurturing the next … Continued [...]

Accelerate database development in Amazon RDS and Amazon Aurora with Amazon CodeWhisperer (from AWS Database Blog)

As organizations continue to scale applications, the need for database developers to quickly pick up new skills becomes increasingly important. Amazon CodeWhisperer is an AI-powered productivity tool for the integrated development environment (IDE) and command line that helps improve developer productivity by generating code recommendations based on your comments in natural language and code in […] [...]

MariaDB Joins Forces with Google Cloud to Enhance Support Operations on Google Distributed Cloud (from MariaDB Corporation Blog)

In an era where the cloud is omnipresent, yet the needs for data sovereignty, security, and localized performance are paramount, … Continued [...]

Google adds Gemini to databases to aid faster code development, migration (from InfoWorld)

pGoogle Cloud is adding capabilities driven by its proprietary large language model, Gemini to its database offerings, which include Bigtable, Spanner, Memorystore for Redis, Firestore, CloudSQL for MySQL, and AlloyDB for PostgreSQL, the company announced at its annual Next conference./ppThe Gemini-driven capabilities, which are currently in public preview, include SQL generation, and AI assista [...]

MariaDB's parallel replication to catch up (from Shinguz's Blog)

pDue to an application error, our replication stopped for 5 days (over Easter). After the problem was solved, the replication was supposed to catch up, which turned out to be very slow. All the usual tricks (codeinnodb_flush_log_at_trx_commit/code, codesync_binlog/code, etc.) had already been exhausted. So we tried our hand at parallel replication of the MariaDB server./p pParallel replication is [...]

Leverage TiDB's Automated TTL Feature for Efficient Data Management (from Mydbops Blog)

Modern applications generate a tidal wave of data. But what happens to all that information as it accumulates? Just like a cluttered attic, a database overflowing with old data can lead to sluggish pe [...]

Summer 2023: Fuzzing Vitess at PlanetScale (from PlanetScale Blog)

My experience working as an intern in the Vitess query serving team for PlanetScale. [...]

Monday, 08. April 2024

Creating a MySQL HeatWave Instance With the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve reference data and create a new MySQL HeatWave instance. [...]

Summer 2023: Fuzzing Vitess at PlanetScale (from Vitess)

My name is Arvind Murty, and from May to July of 2023, I worked on Vitess via an internship with PlanetScale. I was first introduced to Vitess when I was in high school as a potential open-source project for me to work on. I had been interested in working on one because they’re a relatively easy way to get some real-world experience in large-scale software development. Vitess seemed like an good pl [...]

Saturday, 06. April 2024

Calling All Open-Source Database Experts: Share Your Knowledge at Mydbops Meetup 16! (from Mydbops Blog)

Mark your calendars, database enthusiasts! The Mydbops Open Source Database Meetup 16 is happening on June 8th, 2024, and we're seeking passionate experts like YOU to share your insights with the comm [...]

Friday, 05. April 2024

Querying Percona Operator for MongoDB Logs Using LogCLI (from Percona Database Blog)

♦With all the convenience Kubernetes operators provide in managing resources, it can still be a challenge to conveniently store, query, manage, and download the database logs from the pods. Since the pod logs are rotated after a certain period or size depending on the configuration and workload, it’s necessary to collect them to analyze for […] [...]

Japan: Special MySQL Meetup on April 11! (from The Oracle MySQL Blog)

HWJP meetup Apr 2024 [...]

Building MariaDB Server from the sources (from Shinguz's Blog)

pRecently I had to test a new MariaDB feature that was developed at our request (MDEV-33782). To test this feature I had to build the MariaDB server myself from source, which I have not done for a long time. So a new challenge, especially with codeCMake/code.../p pI followed the MariaDB documentation Get, Build and Test Latest MariaDB the Lazy Way to build the server./p pOn Ubuntu 22.04 it did no [...]

dbdeployer Tutorial on Mac (from J-F Gagné's MySQL Blog)

Not very long ago (well, maybe a little longer, this post is in draft for more than a year), in the spawn of less than 5 days, I suggested many colleagues to reproduce a problem they had with MySQL in a "more simple environment".  Such more simple environment can be created with dbdeployer.  dbdeployer is a tool to create "MySQL Sandboxes" on a Mac (laptop or desktop) or on Linux (vm, [...]

Thursday, 04. April 2024

Perf regressions in MySQL from 5.6.21 to 8.0.36 using sysbench and a small server (from Small Datum)

pThis has results for sysbench vs upstream MySQL on a small server. I have results for some 5.6, 5.7 and 8.0 releases up to 8.0.36. My last report stopped at 8.0.34. The goal is to document where things get faster or slower over time for a low-concurrency and CPU-bound workload. The focus is on CPU regressions. /ppMy results here aren't universal. /pp/pulliThe microbenchmarks here mostly [...]

Amazon RDS now supports M6gd database instances in six additional AWS regions (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton2-based M6gd database instances in Asia Pacific (Hong Kong, Melbourne, Seoul), Canada (Central), Europe (Milan), and Middle East (Bahrain) regions./p [...]

Automatic MySQL Query Cache with Readyset and ProxySQL (from Readyset Blog)

Learn how to use a dedicated scheduler for integrating Readyset with ProxySQL to automatic inspect your workload and cache problematic queries. [...]

MySQL NDB Cluster replication: Introduction (from The Oracle MySQL Blog)

Learn more about basic single-channel replication setup as well as the high-end active-active circular or merge replication setups. In this series we will describe how it works both on high level as well as the detailed technical level. [...]

ClusterControl Terraform provider now available (from Severalnines Blog)

pWe’re pleased to announce that ClusterControl (CC) now integrates with the widely-used Infrastructure as Code (IaC) tool – Terraform. With our Terraform Provider, users can build provisioning workflows into the deployment sequences of their ClusterControl-managed databases. For DevOps teams using ClusterControl and Terraform, this will further reduce the daily operational load and comp [...]

How PlanetScale makes schema changes (from PlanetScale Blog)

Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application. [...]

MaxScale configuration synchronisation (from Shinguz's Blog)

Table of contents ul liOverview/li liPreparations/li liActivate MaxScale configuration synchronisation/li liChange MaxScale parameters/li liAdd new slave and make MaxScale known/li liRemove old slave and make MaxScale known/li liHow is the configuration synchronised?/li liWhat happens in the event of a conflict?/li liTests/li liDeactivating MaxScale configuration synchronisatio [...]

Introducing Tungsten Cluster & Tungsten Replicator v7.1.2 (from Continuent Blog)

Discover the latest enhancements, new features, and critical bug fixes in Tungsten Cluster and Tungsten Replicator version 7.1.2. Explore behavior changes affecting installation and deployment, learn about the introduction of the tungsten_mysql_ssl_setup command-line tool and critical bug fixes addressing issues such as data source monitoring and cluster switch failures.Tags: tungsten clusteri [...]

Using the Oracle Cloud TypeScript SDK Part 7 - Retrieving Reference Lists (from The Oracle MySQL Blog)

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to retrieve reference data that can be used to configure MySQL HeatWave instances. [...]

Wednesday, 03. April 2024

MySQL 101: How to Find and Tune a Slow MySQL Query (from Percona Database Blog)

♦This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.  While this can be caused by a multitude of factors, it is more often than not caused by a bad or slow MySQL […] [...]

Azure Database for MariaDB retirement - Key updates and migration information (from Azure for MySQL Blog)

pAzure Database for MariaDB is scheduled for retirement by September 19, 2025/p p /p pIn alignment with the Azure Database for MariaDB retirement announcement, we stopped support for creating MariaDB instances via the Azure portal or CLI as of March 19, 2024. If you still need to create MariaDB instances to address business continuity requirements, please raise an Azure support ticket./p [...]

Tuesday, 02. April 2024

PostgreSQL for MySQL DBAs Second Edition Is Now Available (from Percona Database Blog)

♦Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified PostgreSQL DBA. Years later, that same sentiment is still […] [...]

Amazon Aurora zero-ETL integration with Amazon Redshift now in additional regions (from AWS What's New)

pAmazon Aurora MySQL zero-ETL integration with Amazon Redshift is now supported in 11 additional regions, enabling near real-time analytics and machine learning (ML) using Amazon Redshift. Based on your analytics needs, you can include or exclude specific databases and tables from an existing or a new zero-ETL integration and selectively bring data into Amazon Redshift./p [...]

Releasing ProxySQL v2.6.2! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.6.2 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and [...]/p pThe post Releasing ProxySQL v2.6.2! appeared [...]

Achieve faster switchover for Amazon RDS Blue/Green Deployments with large number of connections (from AWS Database Blog)

In this post, we show you a recent improvement for Amazon RDS Blue/Green Deployment switchovers to reduce your overall downtime when you have a large number of connections to your database. Blue/Green Deployments enforce safety measures to make sure that the switchover from your blue environment to the green environment maintains data consistency. For reference, […] [...]

Integrating Readyset with ProxySQL for MySQL workloads (from Readyset Blog)

Learn the step-by-step process of configuring ProxySQL with Readyset for optimized MySQL performance today, including advanced connection management techniques. [...]

How to Find Duplicate, Unused, and Invisible Indexes in MySQL (from Percona Database Blog)

♦This blog was originally published in January 2023 and was updated in April 2024.MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It is used to quickly locate data without having to […] [...]

MariaDB Community Server 11.4 LTS: What This Means For Customers (from MariaDB Corporation Blog)

MariaDB Community Server 11.4 will be a long-term maintenance (LTS) release. Version 11.4 is currently in RC and will be … Continued [...]

MariaDB Server 11.4 will be LTS (from MariaDB Foundation Blog)

pMariaDB Server 11.4 will be a long-term support release, on top of our current plan.br Early February, we announced that we were adjusting the MariaDB Server release model. … /p pContinue reading \"MariaDB Server 11.4 will be LTS\"/p pThe post MariaDB Server 11.4 will be LTS appeared first on MariaDB.org./p [...]

Using the Oracle Cloud TypeScript SDK Part 6 - Updating a MySQL HeatWave Backup (from The Oracle MySQL Blog)

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to update some propertied of a backup of a MySQL HeatWave instance. [...]

Monday, 01. April 2024

March Product Updates (from Readyset Blog)

Check out Readyset's product updates for March 2024, including added support for new MySQL commands, the ability to cache multiple queries, and more. [...]

Database Management Now Monitors MySQL HeatWave Clusters and Lakehouse (from The Oracle MySQL Blog)

The initial release focused on MySQL OLTP observability. Building upon the existing foundation, we are pleased to announce an extension of its monitoring capabilities encompassing MySQL HeatWave clusters and Lakehouse-enabled DB Systems. With this enhancement, the Database Management service empowers data professionals with deeper insights and provides proactive monitoring opportunities, ensuring r [...]

caching_sha2_password Support for ProxySQL Is Finally Available! (from Percona Database Blog)

♦ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following:Added support for caching_sha2_password!This is great news for the community! The caching_sha2_password authentication method for frontend connections is now available. This has been a long-awaited feature …Why?Because in MySQL 8, caching_sha2_password has been the default authentication [...]

Public preview: Azure Backup supports long term retention for backup of Azure Database for MySQL– Flexible Server (from Azure Updates)

Now you can retain backups for up to 10 years by defining your own backup and retention policy for MySQL- Flexible server. [...]

Unleash Peak Database Performance with TiDB's Smart Engine Selection (from Mydbops Blog)

TiDB, the distributed SQL database, is renowned for its horizontal scalability, strong consistency, and compatibility with MySQL. One of the standout features that enhance its performance and flexibil [...]

Learning SQL Exercise (from MacLochlainns Weblog)

I’ve been using Alan Beaulieu’s Learning SQL to teach my SQL Development class with MySQL 8. It’s a great book overall but Chapter 12 lacks a complete exercise. Here’s all that the author provides to the reader. This is inadequate for most readers to work with to solve the concept of a transaction. Exercise 12-1 […] [...]

Sunday, 31. March 2024

TOP 10 IDEs for SQL Database Management & Administration [2024] (from Devart MySQL Tool Blog)

pIDEs are comprehensive software products equipped with specialized tools for software development. This article explores the most popular and powerful database-related IDEs, their functionality, advantages, pricing models, and other crucial factors./p pThe post TOP 10 IDEs for SQL Database Management & Administration [2024] appeared first on Devart Blog./p [...]

Friday, 29. March 2024

Web3Bench: A New HTAP Benchmark for Web3 Workloads (from TiDB and TiKV Blog)

pThis blog introduces Web3Bench, a hybrid transaction/analytical processing (HTAP) benchmark that addresses earlier limitations. Web3Bench is based on real-world Web3 use cases that utilize HTAP. Our data model is a simplified version of the decentralized blockchain Ethereum. We leverage a sample data set from Ethereum to build a scale factor-based data generator. The workload in […]/p pThe p [...]

A MyLoader Error You Might Face When Restoring Databases (from Percona Database Blog)

♦At Percona Managed Services, we manage Percona for MySQL, MySQL Community, MariaDB, and other software. Sometimes we might need to use mydumper/myloader to restore one or more databases from the production environment to the lower environment for testing. The automated restore process ran well until one day, we got the error below.0. The error we face […] [...]

MySQL HeatWave Faster Point-in-time Recovery (from The Oracle MySQL Blog)

MySQL HeatWave Faster Point-in-time Recovery [...]

Identifying and profiling problematic MySQL queries (from PlanetScale Blog)

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems. [...]