by Walter Garcia | Nov 1, 2023 | Insight for DBAs, MySQL, Open Source, Percona Software
This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. In this age of digital...
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...
by Balchandar Reddy Voodem | Sep 25, 2023 | Insight for DBAs, MySQL, ProxySQL
ProxySQL is a high-performance SQL proxy, which runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime. The daemon accepts incoming traffic from MySQL clients and forwards it to backend...
by Kedar Vaijanapurkar | Sep 20, 2023 | Insight for DBAs, MySQL
As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for monitoring the replication status on your MySQL replicas. However, its output can be overwhelming for beginners, especially regarding...
by Mauricio Cacho | Sep 20, 2023 | Insight for DBAs, MySQL, Percona Software
If you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that could lead to unwanted scenarios if you modify some dynamic parameters at some point in your instance. Here’s a brief story of how this could happen, to make...
by Larry Xia | Sep 15, 2023 | Insight for DBAs, MariaDB, MySQL
At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring and managing MariaDB GTID replication. In this blog, we’ll show you how to convert MariaDB binary log file and position-based...
by Sri Sakthivel | Sep 14, 2023 | Insight for DBAs, MySQL
MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. However, modern business is very much dependent on analytical data. ClickHouse is a columnar database that handles analytical...
by Michael Villegas | Sep 12, 2023 | Insight for DBAs, MySQL
Schema changes are required to add new features or to fix bugs in an application. However, there is no standard procedure to make the changes in a quick and safe manner. If the changes are not made considering the necessary precautions, you may face unwanted outages...
