May 05, 2020 |
Insight for DBAs, MySQL, Percona Software
In this day and age, large enterprise companies make use of Ansible, Puppet, or Chef to provision MySQL servers, be it replica sets or clusters. This eases the burden of deployment and workflow management. However, for some smaller companies, the learning curve hampers the immediate adoption of automation software. This is where the MySQL Shell […]
Sep 24, 2018 |
MySQL, Percona Software, Security
To use Percona XtraBackup with keyring_vault plugin enabled you need to take some special measures to secure a working backup. This post addresses how to backup Percona Server for MySQL with keyring_vault plugin enabled. We also run through the steps needed to restore the backup from the master to a slave. This is the second […]
Sep 17, 2018 |
MySQL, Percona Software, Security
This is the first of a two-part series on using the keyring_vault plugin with Percona Server for MySQL 5.7. The second part, Backing up Percona Server for MySQL with keyring_vault plugin enabled, walks through how to use Percona Xtrabackup to backup from this instance and restore to another server and set it up as a slave with […]
May 24, 2018 |
Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, I will show you how easy it is to set up a Percona Monitoring and Management server on Google Compute Engine from the command line. First off you will need to have a Google account and install the Cloud SDK tool. You need to create a GCP (Google Cloud Platform) project […]
Apr 11, 2018 |
Insight for DBAs, MySQL, ProxySQL
In this blog post, we demonstrate a new feature in ProxySQL Admin: support for multiple clusters. In a previous blog post, Ramesh and Roel introduced a new tool that helps configured Percona XtraDB Cluster nodes into ProxySQL. However, at that time it only worked for a single cluster per ProxySQL Admin configuration. Starting from ProxySQL […]
Mar 06, 2018 |
MySQL, Security
Security is one of the hottest topics lately, and in this blog post, I will walk you through what needs to be configured to have a working three-node Percona XtraDB Cluster running with InnoDB Tablespace Encryption enabled. This article will not cover the basics of setting up a cluster nor will it cover how to […]
Jun 20, 2014 |
Cloud, Insight for DBAs, MySQL, Percona Software
In my Percona ClusterControl and add the existing Patrick Galbraith’s blog series about Docker.
May 26, 2014 |
Cloud, Insight for DBAs, MySQL, Percona Software
In my previous post, I blogged about using Percona Server with Docker and have shown you how fast and easy it was to create a virtual environment with just a few commands. This time I will be showing you how to setup a three-node Percona XtraDB Cluster (PXC) 5.6 on the Docker open-source engine. Just […]
May 13, 2014 |
MySQL, Percona Software
There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things. In this post, however, I will show you how to use Docker with […]
Feb 03, 2014 |
Insight for DBAs, MySQL, Percona Software
This is the first in a series of posts highlighting a few of the seldom-used but still handy Percona Toolkit tools. Have you ever had a problem understanding the EXPLAIN statement output? And are you the type of person who would rather use the command line than a GUI application? Then I would recommend that […]