MySQL

In this blog, we will help you to set database KPI for the Mysql 8.0 monitoring, and things that may cause harm to it. Knowledge of how to use limited resources is essential for anybody managing a production database.

The audit plugin is one of the less known features of the innovative MySQL load balancer ProxySQL. We gave it a try and we want to share how useful it is and what kind of logs it provides.

The new MySQL Clone Plugin can be used to rebuild a replication slave. Currently the go-to tool for that, as well as for backups, is Xtrabackup. In this blog we will compare these two tools and look at how they work and behave.

Installing a standalone MySQL server is a simple straightforward task, but this can be problematic if you have multiple database servers, versions, platforms and environments to support. Thus, having a configuration management tool is the way to go to improve efficiency, remove repetitiveness and reduce human errors. In this blog post, we are going to go walk you through the basics of Ansible's automation for MySQL, as well as configuration management with examples and explanations.

MySQL 8.0 has important performance and security improvements and there are several things to take into account before taking it into production. In this blog, we’ll look at the new MySQL 8.0 features, some deprecations, and what you need to keep in mind before migrating.

MySQL 8.0.17 introduced a new way of provisioning MySQL data - clone plugin. This blog explores this new feature and how you can use it in your database environment.

ClusterControl 1.7.5 introduces a new feature, MySQL Freeze Frame, which can be very helpful for DBA's when troubleshooting database crashes. Freeze Frame takes a snapshot of your database right before a failure, providing you with valuable insight.. This blog will show you how to use this feature.

In this article, we will explain how you can analyze the MySQL database queries workload using pt-query-digest, processlist and more. You will learn how to track database queries and how to find long-running ones.

The internet can be a dangerous place for data that isn’t protected. Using a VPN connection is one way to protect your data in transit by encrypting the traffic over the internet. In this blog, you’ll show how to configure an OpenVPN server in a database node running in the cloud, and how to access it using a VPN client.

In this article, we will explain how you can analyze the workload of your MySQL production systems. Then we’ll evaluate a list of fundamental configuration parameters that can help you improve performance. Performance tuning is not trivial, but you can go a long way with a few basic guidelines.

Inefficient queries are always ubiquitous yet are an inevitable problem among DBAs. In part two of this blog will continue to provide tips that can help you maximize your MySQL database queries efficiently.

Inefficient queries are always ubiquitous yet are an inevitable problem among DBAs. This blog will provide a refresher course that can help you maximize your MySQL database queries efficiently.

How do you build a database management layer that spans across all your data centers, synchronized and fault-tolerant? This is the second part of the blog covering highly available ClusterControl installation. This time we discuss how to ensure that the UI can be accessed in a highly available manner

As database infrastructure is distributed across multiple clouds and data centers, the management of these databases also require distribution. But how do you build a management layer that spans across all your data centers, synchronized and fault-tolerant? This blog post describes the process of setting up a highly available ClusterControl installation using CMON HA Raft-based cluster.

With this blog post, we are going to show you how to automate backup maintenance so you can be sure your database backups are executed successfully and are reliable.

This blog explains how to encrypt and backup a MySQL database using Percona Server for MySQL 8.0 including tips for performing both full and incremental backups.

In this blog post, we look deeper into one of the most advanced features offered by ClusterControl called automatic database recovery and failover. ClusterControl is able to recover clusters, nodes and database-related processes to ensure you achieve the best database uptime possible.

This article gives an overview of the two most popular backup utilities available for MySQL, namely MySQL Enterprise Backup and Percona XtraBackup. We will discuss some best practices that can be applied to high availability topologies in order to make our backups reliable, secure and consistent.

In this second part of the series, we cover a complete walk-through with examples on how to monitor, manage, and scale the MySQL InnoDB Cluster as part of ongoing cluster maintenance operations.

This blog offers you the springboard to leverage the new Galera Cluster 4.0 and move away from MySQL Replication to take advantage of the High Availability that Galera has to offer. We showcase the most up-to-date tips for migration that you'll have to prepare before utilizing Galera Cluster 4.0.

In the first part of this walkthrough, we are going to deploy a MySQL InnoDB Cluster. There are a number of hands-on tutorial available online but this walkthrough covers all the necessary steps/commands to install and run the cluster in one place. The second part will cover monitoring, management and scaling operations as well as some gotchas when dealing with MySQL InnoDB Cluster.