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;...
How to Backup Google Cloud SQL for MySQL and Restore on Your Own Server
Google Cloud SQL is a managed database service for MySQL, PostgreSQL, and SQL Server. Even if you are new to managed database services, it just takes a few minutes to set up Google Cloud SQL...
How to Secure MySQL: Part One
Whenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing...
Monitoring Percona Server for MySQL – Key Metrics
In this blog post, we are going to look into some key metrics and status when monitoring a Percona Server for MySQL to help us fine-tune the MySQL server configuration for a long run. Just...
Full-Text Searches in MySQL: The Good, the Bad and the Ugly
Sometimes when searching in a MySQL database you might want to run full-text search queries against character-based data. Today we’re discussing the advantages and disadvantages of such search methods. What are Full-Text Searches in MySQL?...
How to Deploy Percona Server for MySQL for High Availability
Percona Server for MySQL 8.0 offers a number of clustering solutions for high availability out-of-the-box: Single-master: Asynchronous replication Semi synchronous replication Multi-master: Group replication InnoDB Cluster (a combination of MySQL Router, MySQL Shell and Percona...
Asynchronous Replication Automatic Failover in MySQL 8.0.22
Oracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case...
An Overview of the Percona XtraDB Cluster Kubernetes Operator
If you have been around in the container world, you would know that it is pretty challenging to adopt a full Kubernetes automation for a clustered database system, which commonly adds a level of complexity...