MySQL

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.

Vendor lock-in, or proprietary lock-in, occurs when a customer becomes dependent on a vendor for products and services. In this blog, we will see how to avoid it using open source tools.

Replicating your database cluster to a remote datacenter is key in achieving Disaster Recovery with minimal RTO and RPO, but there are other reasons like datacenter migration or geo distribution. However, if managing a cluster was not hard enough, setting up and managing replicated clusters takes complexity to another level. In this blog, we will have a peek at a new ClusterControl 1.7.4 feature that allows you to set up replication between clusters.

Migrating from proprietary to open source databases poses challenges. In this blog we share some tips on what you should keep in mind while planning the transition.

A hot standby is a common term in computing, especially on highly distributed systems. It's a method for redundancy in which one system runs simultaneously with an identical primary system. In this blog how you can create a Hot Standby Node on Amazon AWS for Galera Cluster 4.0 using MariaDB.

Master switches are very common operations in replication setups. They are part of every migration - from one environment to another, from older version of MySQL to more recent one. In a live production environment, you may want to reduce the impact they have on the application. If you wonder how to do it, we are here to help. In this first part we will go over the initial setup of the environment. In the upcoming next part we will explain the process of transparent master switch with ProxySQL.

In this blog post, we are going to deploy a high-available setup for our private "Dropbox" infrastructure using Nextcloud, GlusterFS, Percona XtraDB Cluster (Galera Cluster), ProxySQL with ClusterControl as the automation tool to manage and monitor the database and load balancer tiers.

New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the second part we will show you how to enable Streaming Replication and what the results could look like when you use it.

New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the first part of this blog we will tell you about this new feature and how you can use it.

Amazon EC2 is a very popular environment to deploy your infrastructure on and MySQL Galera is a very popular high availability solution for MySQL. How do they work together? In this blog post we will show how one can deploy the latest version of Galera Cluster on Amazon EC2.

Hosting your database with a cloud provider, such as Microsoft Azure, still requires you to prepare and define your disaster recovery policy. In this blog, we will cover all of the backup and restore methods Azure offers for MySQL.

This is the second part of a two-part series. Here we look into designing a geo-distributed MySQL Galera Cluster and explain how it can be easily deployed using ClusterControl