Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

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

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

Friday, 26. April 2024

Creating a MySQL HeatWave Replication Channel 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 inbound replication channel. [...]
Published Friday, 26. April 2024 04:00 • 7 hours ago

Thursday, 25. April 2024

Amazon RDS now supports M6gd database instances in four 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 (Hyderabad), Europe (Spain, Zurich), and Middle East (UAE) regions./p [...]
Published Thursday, 25. April 2024 17:03 • 18 hours ago

Understanding Flashback in TiDB (from Mydbops Blog)

Author: Kabilesh PR What would be your reaction when your junior comes and says that i have dropped the wrong table or accidentally dropped the entire DB in prod instead of doing it in a test environ [...]
Published Thursday, 25. April 2024 03:49 • a day ago

Wednesday, 24. April 2024

MariaDB Enterprise Server 10.6.17-13 maintenance release (from MariaDB Corporation Blog)

We are pleased to inform you that a new maintenance release of MariaDB Enterprise Server 10.6 is available. This is … Continued [...]
Published Wednesday, 24. April 2024 20:24 • a day ago

Bringing Percona Experts to a City Near You (from Percona Database Blog)

♦Percona.connect, a series of free events hosted by Percona database performance experts, is coming to a city near you!  This amazing learning opportunity spans six cities — across two continents — and includes educational sessions, customer testimonials, networking activities, and more. Don’t miss your chance to talk with technical evangelists, MySQL, PostgreSQL, and Mo [...]
Published Wednesday, 24. April 2024 13:14 • 2 days ago

Tungsten Replicator: Understanding Latency Calculations (from Continuent Blog)

This blog post discusses the Tungsten Replicator and how latency is calculated when extracting events on a Primary, and when applying events to the Replicas. We also examine what latency is, and the two different types of latency that we track - how to interpret them and how they differ.Tags: tungsten replicatorLatencyApplied LatencyRelative Latency [...]
Published Wednesday, 24. April 2024 09:50 • 2 days ago

The MySQL adaptive hash index (from PlanetScale Blog)

The adaptive hash index help to improve performance of the already-fast B-tree lookups [...]
Published Wednesday, 24. April 2024 00:00 • 2 days ago

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 […] [...]
Published Tuesday, 23. April 2024 19:38 • 3 days ago

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 [...]
Published Tuesday, 23. April 2024 18:53 • 3 days ago

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

Progress Software on 2024-04-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 won’t… Continue Reading Short note re Progress and NuSphere [...]
Published Tuesday, 23. April 2024 17:45 • 3 days ago

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 […] [...]
Published Tuesday, 23. April 2024 15:36 • 3 days ago

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 [...]
Published Tuesday, 23. April 2024 10:52 • 3 days ago

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 [...]
Published Monday, 22. April 2024 09:15 • 4 days ago

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 [...]
Published Sunday, 21. April 2024 22:43 • 5 days ago | Updated Sunday, 21. April 2024 22:43 • 5 days ago

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 [...]
Published Saturday, 13. April 2024 18:18 • 13 days ago | Updated Sunday, 21. April 2024 22:43 • 5 days ago

MySQL: Latency and IOPS (from Die wunderbare Welt von Isotopp)

pWhen talking about storage performance, we often hear three terms that are important in describing storage performance. They are/p ul libandwidth/li lilatency/li liI/O operations per second (IOPS)/li /ul pWhen you talk to storage vendors and cloud providers, they will gladly provide you with numbers on bandwidth and IOPS, but latency numbers will be hard to come by. To evaluate storage, especially [...]
Published Sunday, 21. April 2024 05:06 • 5 days ago

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 [...]
Published Friday, 19. April 2024 00:00 • 7 days ago

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 [...]
Published Thursday, 18. April 2024 19:45 • 8 days ago

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 […] [...]
Published Thursday, 18. April 2024 15:59 • 8 days ago

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 […] [...]
Published Thursday, 18. April 2024 15:59 • 8 days ago

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 […] [...]
Published Thursday, 18. April 2024 15:21 • 8 days ago

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. [...]
Published Thursday, 18. April 2024 14:39 • 8 days ago

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 [...]
Published Thursday, 18. April 2024 08:58 • 8 days ago

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 [...]
Published Thursday, 18. April 2024 07:26 • 8 days ago

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. [...]
Published Thursday, 18. April 2024 04:00 • 8 days ago

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 […] [...]
Published Wednesday, 17. April 2024 20:27 • 9 days ago

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 [...]
Published Wednesday, 17. April 2024 20:06 • 9 days ago

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 [...]
Published Wednesday, 17. April 2024 17:02 • 9 days ago

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 [...]
Published Wednesday, 17. April 2024 16:58 • 9 days ago

Introducing global replica credentials (from PlanetScale Blog)

With global replica credentials, you can now automatically route reads to the closest replica. [...]
Published Wednesday, 17. April 2024 16:01 • 9 days ago

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 […] [...]
Published Wednesday, 17. April 2024 13:25 • 9 days ago

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- [...]
Published Wednesday, 17. April 2024 12:31 • 9 days ago

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 [...]
Published Wednesday, 17. April 2024 07:57 • 9 days ago

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 [...]
Published Tuesday, 16. April 2024 16:30 • 10 days ago

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

Episode #60 of MySQL Shorts in now available! [...]
Published Tuesday, 16. April 2024 15:04 • 10 days ago

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 […] [...]
Published Tuesday, 16. April 2024 13:24 • 10 days ago

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 [...]
Published Tuesday, 16. April 2024 09:04 • 10 days ago

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

MySQL Meetups EMEA in April [...]
Published Tuesday, 16. April 2024 08:56 • 10 days ago

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  [...]
Published Tuesday, 16. April 2024 08:54 • 10 days ago

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 [...]
Published Tuesday, 16. April 2024 04:07 • 10 days ago

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. [...]
Published Tuesday, 16. April 2024 04:00 • 10 days ago

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 […] [...]
Published Monday, 15. April 2024 13:02 • 11 days ago

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 [...]
Published Friday, 12. April 2024 23:52 • 13 days ago

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 [...]
Published Friday, 12. April 2024 20:45 • 14 days ago

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 [...]
Published Friday, 12. April 2024 15:43 • 14 days ago

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” […] [...]
Published Friday, 12. April 2024 13:36 • 14 days ago

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. [...]
Published Friday, 12. April 2024 04:00 • 14 days ago

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 [...]
Published Thursday, 04. April 2024 20:58 • 22 days ago | Updated Friday, 12. April 2024 00:51 • 14 days ago

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 [...]
Published Friday, 12. April 2024 00:40 • 14 days ago | Updated Friday, 12. April 2024 00:40 • 14 days ago

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 […] [...]
Published Thursday, 11. April 2024 13:14 • 15 days ago

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

OSC Japan 2023 recap [...]
Published Thursday, 11. April 2024 11:12 • 15 days ago

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 [...]
Published Thursday, 11. April 2024 01:52 • 15 days ago

Profiling memory usage in MySQL (from PlanetScale Blog)

Learn how to visualize the memory usage of a MySQL connection [...]
Published Thursday, 11. April 2024 00:00 • 15 days ago

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 [...]
Published Wednesday, 10. April 2024 22:09 • 16 days ago

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 [...]
Published Wednesday, 10. April 2024 20:15 • 16 days ago

The Ultimate Guide to Integrations with SQLDM for MySQL (from Webyog Blog)

pWelcome to your comprehensive guide on maximizing efficiency with SQLDM for MySQL through its extensive integration capabilities. This guide is tailored to help database professionals, IT teams, and organizations leverage […]/p pThe post The Ultimate Guide to Integrations with SQLDM for MySQL appeared first on Webyog./p [...]
Published Wednesday, 10. April 2024 16:25 • 16 days ago

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. [...]
Published Wednesday, 10. April 2024 16:00 • 16 days ago

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 [...]
Published Wednesday, 10. April 2024 14:42 • 16 days ago | Updated Wednesday, 10. April 2024 14:42 • 16 days ago

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 […] [...]
Published Wednesday, 10. April 2024 12:49 • 16 days ago

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 [...]
Published Wednesday, 10. April 2024 10:30 • 16 days ago

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. [...]
Published Wednesday, 10. April 2024 04:00 • 16 days ago

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. [...]
Published Wednesday, 10. April 2024 03:44 • 16 days ago

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 [...]
Published Tuesday, 09. April 2024 17:02 • 17 days ago

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 […] [...]
Published Tuesday, 09. April 2024 16:02 • 17 days ago

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 [...]
Published Tuesday, 09. April 2024 16:00 • 17 days ago

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 […] [...]
Published Tuesday, 09. April 2024 15:48 • 17 days ago

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 [...]
Published Tuesday, 09. April 2024 12:00 • 17 days ago

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 [...]
Published Tuesday, 09. April 2024 12:00 • 17 days ago

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 [...]
Published Tuesday, 09. April 2024 08:53 • 17 days ago

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 [...]
Published Tuesday, 09. April 2024 04:49 • 17 days ago

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

My experience working as an intern in the Vitess query serving team for PlanetScale. [...]
Published Tuesday, 09. April 2024 00:00 • 17 days ago

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. [...]
Published Monday, 08. April 2024 04:00 • 18 days ago

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 [...]
Published Monday, 08. April 2024 00:00 • 18 days ago

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 [...]
Published Saturday, 06. April 2024 12:33 • 20 days ago

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 […] [...]
Published Friday, 05. April 2024 15:08 • 21 days ago

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

HWJP meetup Apr 2024 [...]
Published Friday, 05. April 2024 11:08 • 21 days ago

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 [...]
Published Friday, 05. April 2024 06:47 • 21 days ago

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, [...]
Published Friday, 05. April 2024 00:55 • 21 days ago | Updated Friday, 05. April 2024 02:08 • 21 days ago

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 [...]
Published Saturday, 17. February 2024 03:52 • 2 months ago | Updated Thursday, 04. April 2024 20:00 • 22 days ago

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 [...]
Published Thursday, 04. April 2024 17:01 • 22 days ago

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. [...]
Published Thursday, 04. April 2024 15:38 • 22 days ago

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. [...]
Published Thursday, 04. April 2024 14:39 • 22 days ago

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 [...]
Published Thursday, 04. April 2024 09:45 • 22 days ago

How PlanetScale makes schema changes (from PlanetScale Blog)

Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application. [...]
Published Thursday, 04. April 2024 09:00 • 22 days ago

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 [...]
Published Thursday, 04. April 2024 07:53 • 22 days ago

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 [...]
Published Thursday, 04. April 2024 07:39 • 22 days ago

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. [...]
Published Thursday, 04. April 2024 04:00 • 22 days ago

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 […] [...]
Published Wednesday, 03. April 2024 12:02 • 23 days ago

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 [...]
Published Wednesday, 03. April 2024 00:41 • 23 days ago

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 […] [...]
Published Tuesday, 02. April 2024 17:24 • 24 days ago

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 [...]
Published Tuesday, 02. April 2024 17:04 • 24 days ago

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 [...]
Published Tuesday, 02. April 2024 16:49 • 24 days ago

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, […] [...]
Published Tuesday, 02. April 2024 15:45 • 24 days ago

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. [...]
Published Tuesday, 02. April 2024 14:13 • 24 days ago

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 […] [...]
Published Tuesday, 02. April 2024 13:55 • 24 days ago

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 [...]
Published Tuesday, 02. April 2024 12:00 • 24 days ago

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 [...]
Published Tuesday, 02. April 2024 09:33 • 24 days ago

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. [...]
Published Tuesday, 02. April 2024 04:00 • 24 days ago

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. [...]
Published Monday, 01. April 2024 22:40 • 25 days ago

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 [...]
Published Monday, 01. April 2024 17:46 • 25 days ago