Rebuilding a MySQL 8.0 Replication Slave Using a Clone Plugin
With MySQL 8.0 Oracle adopted a new approach to development. Instead of pushing features with major versions, almost every minor MySQL 8.0 version comes with new features or improvements. One of these new features is...
Why Did My MySQL Database Crash? Get Insights with the New MySQL Freeze Frame
In case you haven't seen it, we just released ClusterControl 1.7.5 with major improvements and new useful features. Some of the features include Cluster Wide Maintenance, support for version CentOS 8 and Debian 10, PostgreSQL...
Announcing ClusterControl 1.7.5: Advanced Cluster Maintenance & Support for PostgreSQL 12 and MongoDB 4.2
We’re excited to announce the 1.7.5 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. This new version features support for the latest...
Tips for Delivering MySQL Database Performance – Part Two
The management of database performance is an area that businesses when administrators often find themselves contributing more time to than they expected. Monitoring and reacting to the production database performance issues is one of the...
Using OpenVPN to Secure Access to Your Database Cluster in the Cloud
The internet is a dangerous place, especially if you’re leaving your data unencrypted or without proper security. There are several ways to secure your data; all at different levels. You should always have a strong...
Tips for Delivering MySQL Database Performance – Part One
The database backend affects the application, which can then impact organizational performance. When this happens, those in charge tend to want a quick fix. There are many different roads to improve performance in MySQL. As...
Maximizing Database Query Efficiency for MySQL – Part Two
This is the second part of a two-part series blog for Maximizing Database Query Efficiency In MySQL. You can read part one here. Using Single-Column, Composite, Prefix, and Covering Index Tables that are frequently receiving...
Maximizing Database Query Efficiency for MySQL – Part One
Slow queries, inefficient queries, or long running queries are problems that regularly plague DBA's. They are always ubiquitous, yet are an inevitable part of life for anyone responsible for managing a database. Poor database design...
How ClusterControl Performs Automatic Database Recovery and Failover
ClusterControl is programmed with a number of recovery algorithms to automatically respond to different types of common failures affecting your database systems. It understands different types of database topologies and database-related process management to help...
MySQL InnoDB Cluster 8.0 – A Complete Operation Walk-through: Part Two
In the first part of this blog, we covered a deployment walkthrough of MySQL InnoDB Cluster with an example on how the applications can connect to the cluster via a dedicated read/write port. In this...
Database Load Balancing in the Cloud – MySQL Master Failover with ProxySQL 2.0: Part Two (Seamless Failover)
In the previous blog we showed you how to set up an environment in Amazon AWS EC2 that consists of a Percona Server 8.0 Replication Cluster (in Master - Slave topology). We deployed ProxySQL and...
MySQL InnoDB Cluster 8.0 – A Complete Deployment Walk-Through: Part One
MySQL InnoDB Cluster consists of 3 components: MySQL Group Replication (a group of database server which replicates to each other with fault tolerance). MySQL Router (query router to the healthy database nodes) MySQL Shell (helper,...