Taking Physical Backups for MySQL
If you've ever had any sort of issue with MySQL, you have probably needed to restore a MySQL database. In that scenario, you have probably used mysqldump or Percona XtraBackup to accomplish the task -...
Improving MySQL Performance with Advanced InnoDB Settings
We have discussed how to configure InnoDB for high performance a while ago, however, we have not yet discussed how we can improve MySQL performance while making use of advanced InnoDB settings. This blog post...
Monitoring MySQL Performance with ClusterControl
Monitoring the performance of MySQL databases is a daily task of almost every MySQL DBA. In this blog post we will try to demonstrate how to monitor the performance of your MySQL databases - with...
Database Design 101: Partitions in MySQL
In this blog post we are going to be discussing one of the most widely used features of MySQL - partitions. What is Partitioning? In MySQL, partitioning is a database design technique in which a...
How to Verify Your MySQL Backups with ClusterControl
Backups are a basic point in all Disaster Recovery Plans, but only having a backup is not enough to guarantee correct data recovery. You must need to make sure that the backup is usable, and...
What is a Query Outlier and How to Fix It
The MySQL database workload is determined by the number of queries that it processes. There are several situations in which MySQL slowness can originate. The first possibility is if there are any queries that are...
Performance Testing Using MySQLdump and the MySQL Shell Utility
In my previous post I explained how to take a logical backup using the mysql shell utilities. In this post, we shall compare the speed of the backup and restoration process. MySQL Shell Speed Test ...
Logical Database Backups Using MySQL Shell
Mysqldump is a popular logical backup tool for MySQL which was originally written by Igor Romanenko. Mysqldump performs logical backups (set of SQL statements). By default, mysqldump does not dump information_schema tables and it never...
ALTER TABLE in MySQL: Friend or Foe?
The ALTER TABLE statement is one of the most frequently used statements in the MySQL world - the statement allows you to add, delete or modify columns in a table. In this blog post we...
How to Deploy Percona XtraDB Cluster 8 for High Availability
Percona XtraDB Cluster 8.0 is based on Percona Server for MySQL 8.0 embedded with Galera writeset replication API and Galera replication library, to form a highly available multi-master replication for MySQL-based database server. Percona XtraDB...
An Overview of ProxySQL Clustering in ClusterControl
ProxySQL is a well known load balancer in MySQL world - it comes with a great set of features that allow you to take control over your traffic and shape it however you see it...
How to Secure MySQL: Part Two
In the previous post about MySQL security, we have covered a range of options that can be used to make your MySQL instance(s) more secure. They included: General MySQL security measures; Controlling access in MySQL;...