by Kedar Vaijanapurkar | Dec 11, 2023 | Cloud, Insight for DBAs, MySQL
A quick configuration change may do the trick in improving the performance of your AWS RDS for MySQL instance. Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. While this...
by Totel | Dec 8, 2023 | Insight for DBAs, MySQL, Percona Software
In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. Let us...
by Mohit Joshi | Dec 7, 2023 | Insight for DBAs, MySQL, Percona Software
Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of...
by Kedar Vaijanapurkar | Dec 6, 2023 | Insight for DBAs, MySQL
During an interview or while having general discussions, I have found some funny responses that can be easily classified as “Wrong Answers,” but at times, they’re thought-provoking or involve a deep meaning within. This blog is regarding some of the...
by Patrick Birch | Nov 8, 2023 | MySQL, Percona Software
With the release of Percona XtraBackup 8.0.34-39, Percona XtraBackup (PXB) allows a backup on server version 8.0.35 and higher. We have removed the server version check because the MySQL 8.0 series has transitioned to bug fixes. A feature change in the MySQL 8.0...
by David Stokes | Nov 6, 2023 | Insight for DBAs, Insight for Developers, MySQL
Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at the release notes to see what these new versions bring to the community. You’ll want to keep an eye on the deprecations in particular because some...
by Przemysław Malkowski | Nov 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes, there is a need to update the table and index statistics manually using the ANALYZE TABLE command. Without going further into the reasons for such a need, I wanted to refresh this subject in terms of overhead related to running the command on production...
by Fernando Mattera | Oct 31, 2023 | Insight for DBAs, MySQL, Percona Services
Hello friends, In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time. This time, I’m going to tell you about a particular case: a client with a...
by Sveta Smirnova | Oct 17, 2023 | Insight for DBAs, MySQL
This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. In my previous blog post on the CLONE INSTANCE command, The MySQL Clone Plugin Is Not Your Backup, I...
by Jinyou Ma | Oct 13, 2023 | Insight for DBAs, MySQL
Visual Studio Code (VS) supports memory dump debugging via C/C++ extension: https://code.visualstudio.com/docs/cpp/cpp-debug#_memory-dump-debugging. When MySQL generates a core file, the VS code simplifies the process of debugging. This blog will discuss how to debug...
by Gaurav Pareek | Oct 13, 2023 | Insight for DBAs, MySQL
by Juan Arruti | Oct 12, 2023 | Cloud, Monitoring, MySQL
In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes environments. Flame graphs are a graphical representation of function calls. It shows which code paths are more busy on the CPU in given samples. They...
by Uday Rajarapu | Oct 11, 2023 | Insight for DBAs, MySQL
This blog post discusses roles in MySQL 8.0, which are named collections of privileges. Like user accounts, roles can have privileges granted and revoked as required. Typically, we have multiple users with the same set of privileges. Previously, the only way to grant...
by Ananias Tsalouchidis | Oct 10, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Performing an operation is always challenging when dealing with K8s. When on-prem or DBaaS like RDS or Cloud SQL, it is relatively straightforward to apply a change. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async...
by Sveta Smirnova | Oct 4, 2023 | Insight for Developers, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.5.5 was released on October 3, 2023. This blog post covers the main changes in this release. pt-online-schema-change improvements After nibble hook This was contributed by Marcelo HP Ferreira at https://github.com/percona/percona-toolkit/pull/645....
by Brian Sumpter | Oct 3, 2023 | Insight for DBAs, Insight for Developers, MySQL
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we...
by Bhuvanes Waran | Sep 29, 2023 | Insight for DBAs, MySQL
As a DBA, one of the very frequent tasks is to stop/start MySQL service for batching or some other activities. Before stopping MySQL, we may need to check if there are any active connections; if there are, we may need to kill all those. Generally, we use pt-kill to...
by Denis Subbota | Sep 28, 2023 | Insight for DBAs, MySQL
Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features –...
by Sveta Smirnova | Sep 26, 2023 | Insight for DBAs, MySQL, Percona Software
This blog post discusses the limitations of the MySQL Clone plugin. The MySQL clone plugin significantly simplifies the process of replica provisioning. All you need to do is: Ensure that the source server has binary logs enabled Grant appropriate permissions Execute...
by Mani Paluru | Sep 26, 2023 | Insight for DBAs, MySQL
As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Throughout our careers, most of us have encountered situations where the absence of a primary key has led to operational challenges. Primary keys play...
