by Jaime Sicam | Aug 20, 2024 | Cloud, MySQL, Percona Software
Percona Operator for MySQL, based on Percona XtraDB Cluster (PXC), provides configuration to expose the ProxySQL, HAProxy, and the PXC instances themselves so that you can use Percona Toolkit to connect to MySQL from these endpoints externally. However, you can also...
by Kedar Vaijanapurkar | Jul 22, 2024 | Insight for DBAs, MySQL
pt-online-schema-change is an amazing tool for assisting in table modifications in cases where ONLINE ALTER is not an option. But if you have foreign keys, this could be an interesting and important read for you. Tables with foreign keys are always complicated, and...
by Sveta Smirnova | Jun 19, 2024 | Insight for DBAs, Percona Software
pt-pmp is a profiler tool that creates and summarizes full stack traces of processes on Linux. It was inspired by http://poormansprofiler.org and helped Percona Support resolve many performance issues. In this blog post, I will present an improved pt-pmp that can...
by Sveta Smirnova | Jun 18, 2024 | MySQL, Percona Software
Starting from Percona Toolkit 3.6.0, pt-online-schema-change supports the option –where, so you can not only alter your table definition live but copy only rows that satisfy certain criteria. It may happen that you may not need to copy all the data when changing...
by Sveta Smirnova | Jun 14, 2024 | MySQL, Percona Software
Starting from Percona Toolkit 3.6.0, you can resume pt-online-schema-change if it was interrupted. This blog describes the prerequisites and usage of the new –resume option. To restart the job, you need to know where it failed. This is why the first option you...
by Sveta Smirnova | Jun 12, 2024 | MongoDB, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and...
by Arunjith Aravindan | May 13, 2024 | Insight for DBAs, MySQL, Percona Software
Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted...
by Sveta Smirnova | Dec 22, 2023 | Insight for DBAs, Insight for Developers, Percona Software
Percona Toolkit 3.5.6 was released on December 21, 2023. This blog post covers the main changes in this release. New tool: pt-galera-log-explainer We continue adding more instruments for the Support teams. pt-galera-log-explainer was written by my Percona Support...
by Larry Xia | Dec 12, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s...
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 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 David Stokes | Oct 2, 2023 | Insight for DBAs, Percona Software
Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex...
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 Anil Joshi | May 2, 2023 | Insight for DBAs, MySQL, Percona Software, Security
Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns. The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other...
by Arunjith Aravindan | Dec 12, 2022 | Insight for DBAs, MySQL, Percona Software
Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in a controlled manner that does not disrupt application users or cause application downtime. One of the tools in Percona Toolkit is...
by Arunjith Aravindan | Aug 29, 2022 | Insight for DBAs, MySQL, Percona Software
by Michael Patrick | Apr 20, 2022 | Insight for DBAs, MySQL, Percona Software
When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through Production, it is often useful to ensure that configurations in test environments are comparable to the final production...
by Sveta Smirnova | Oct 4, 2021 | Insight for DBAs, MySQL, Percona Software
It is a common use case to synchronize data in two tables inside MySQL servers. This blog post describes one specific case: how to synchronize data between two different tables on the same MySQL server. This could be useful, for example, if you test DML query...
by Przemysław Malkowski | Oct 8, 2020 | Insight for DBAs, MySQL, Percona Software
Recently I was dealing with an unexpected issue raised by our Support customer, in which data became inconsistent after a schema change was applied. After some investigation, it turned out that affected tables had a special word in the comments of some columns, which...
by Dmitriy Kostiuk | Sep 13, 2019 | MariaDB, MongoDB, MySQL, Percona Software
Percona announces the release of from the website or install PT-1696: the new pt-pg-summary tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces: Shell ##### --- Database...
