MySQL

MySQL Shell is one of the most advanced client tools for MySQL servers. In this blog we shall take a look at the speed of the backup and restoration process.

MySQL Shell is a one of the most advanced client tools for MySQL servers. In this blog we explain how to use the MySQL shell utilities to take a logical backup.

The MySQL ALTER TABLE statement is used to add, delete, or modify columns in an existing table as well as to add and drop various constraints on an existing table. In this blog post we discuss the advantages and disadvantages of using the ALTER TABLE in MySQL.

Percona XtraDB Cluster 8.0 is based on Percona Server for MySQL 8.0 embedded with Galera write set replication API and Galera replication library, to form a highly available multi-master replication for MySQL-based database server. In this blog post, we are going to look into how to deploy a Percona XtraDB Cluster 8.0 for high availability using the manual and automated way.

ProxySQL clustering allows you to keep the configuration of multiple ProxySQL instances in sync. The recent version of the ClusterControl comes with support for deploying ProxySQL nodes as part of a cluster. We are going to show you how you can do that.

In part two of our mini-series on MySQL Security we take a look at several security features like user management as well as the plugins that are available to help keep your data safe.

Percona XtraDB Cluster comes with multiple metrics that are strictly related to this particular cluster (and Galera clusters in general). Let’s take a look at them and see what are the most important bits to watch for.

Protecting the data stored in your database is essential. In this blog post, we discuss what we can do to make MySQL more secure. Part one focuses on general security settings and managing user privileges.

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.

MySQL provides support for full-text indexing and searching. In this blog post, we discuss the advantages and disadvantages of utilizing the full-text search in MySQL.

The most popular, battle-tested, and highly scalable database solutions are achieved with asynchronous replication. In this blog post, we are going to deploy a Percona Server for MySQL replication setup specifically for high availability.

Oracle recently released MySQL 8.0.22, it included a new asynchronous connection failover mechanism which allows a replica to automatically establish an asynchronous replication connection to a new source, in case its existing one fails. 

This blog post will test out the deployment of Percona XtraDB Cluster 8.0 in a containerized environment, orchestrated by the Percona XtraDB Cluster Kubernetes Operator on Google Cloud Platform (GCP).

This blog will showcase not just the importance of auditing your database, but also how to use the Percona Audit Log Plugin to achieve these goals.

Data migration is a challenging task, but with the right setup, architecture, and tools it can be achieved. This blog will deal with the challenges and limitations when migrating your Azure Database for MySQL or MariaDB to an on-prem server.

This blog post will walk you through how to perform online migration from Google Cloud SQL to an on-premises server. There are differences between Google Cloud SQL and standard MySQL functionality like limited control, restricted resources, data locality, budget and security, which may influence your final decision to move out from the Google Cloud SQL instances and host the database service in the on-premises infrastructure

ProxySQL is a dedicated loadbalancer for MySQL database backends. If you run a HAProxy as your loadbalancer for MySQL, you may want to migrate to ProxySQL to benefit from all the features it comes with. This blog shares some tips regarding the migration process.

Migrating off Amazon RDS to an on-prem server can be tedious work,  especially if you need to determine how accurate the copy of your on-prem node is against the AWS RDS data. This blog will show you how to take care of this problem by sharing procedures to handle this situation.

Database migrations can be a hefty job to handle. This blog looks at tools which are freely available either to be used or to be extended in order to achieve your desired data migration activities.

Percona XtraDB Cluster comes with some changes from PXC 5.7. This blog is an attempt to highlight those, and which may have an impact on the upgrade process