A Look at the Percona Toolkit
The Percona Toolkit (PT Toolkit) was initially designed as a swiss army knife for MySQL/MariaDB/Percona Server and its underlying operating system to perform advanced database and system administration tasks that are hard to perform especially...
Using the pt-pg-summary Percona Toolkit for PostgreSQL
The Percona Toolkit is a powerful, free, and open-source product developed by Percona. It is a collection of command-line tools that allow you to perform different MySQL, MongoDB, PostgreSQL, and system tasks that, in general,...
MySQL Workbench Alternatives – ClusterControl’s Point-and-Click GUI
Many would agree that having a graphical user interface is more efficient and less prone to human error when managing or administering a system. Graphical user interface (GUI) greatly helps reduce the steep learning curve...
How to Fail or Crash Your MySQL Instances for Testing
You can take down a MySQL database in multiple ways. Some obvious ways are to shut down the host, pull out the power cable, or hard kill the mysqld process with SIGKILL to simulate an...
MySQL High Availability Tools – Comparing MHA, MRM and ClusterControl
We previously compared two high availability solutions for MySQL - MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we’ll see how ClusterControl stacks up against these solutions....
Webinar Replay: MySQL Query Tuning – Process & Tools
Many thanks to everyone who participated in this week’s first part of our webinar trilogy on MySQL Query Tuning. This time we looked at the process and tools to consider when tuning MySQL queries. It...