Understanding Indexes in MySQL: Part Three
This blog post is the third part of the series of blogs about indexes in MySQL. In the second part of the blog post series about MySQL indexes, we covered indexes and storage engines and touched upon some...
Understanding Indexes in MySQL: Part Two
This blog post is the second part of the series of blogs about indexes in MySQL. In the first part of the blog post series about MySQL indexes, we have covered quite many things, including what...
Understanding Indexes in MySQL: Part One
Indexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them - we will do that in these series of...
New User and LDAP Management in ClusterControl 1.8.2
After upgrading to ClusterControl 1.8.2, you should get the following notification banner: What's up with that? It is a depreciation notice of the current user management system in favor of the new user management system...
Database Automation Best Practices in FinTech
Automation equals speed - there is no discussion about it. Automation also increases reliability and reduces the error rate. Those feats are important in pretty much every kind of industry, but they are crucial for...
Automated Testing of the Upgrade Process for MySQL/MariaDB/Percona Server
Upgrades are always a hard and time-consuming task. First, you should test your application in a test environment, so, ideally, you will need to clone your current production environment for this. Then, you need to...
Automated Testing of the Upgrade Process for PXC/MariaDB Galera Cluster
Upgrading your database for Galera-based clusters such as Percona XtraDB Cluster (PXC) or MariaDB Galera Cluster can be challenging, especially for a production-based environment. You cannot afford to lose the state of your high availability...
Using Automation to Speed up Release Tests on PostgreSQL
Having a test environment is a must in all companies. It could be necessary for testing changes or new releases of the application, or even for testing your existing application with a new PostgreSQL version....
Securing MySQL Backups: A Guide
If you’ve ever used MySQL, chances are you probably took backups of your database. If you took backups of your database, chances are you have at least once thought of how you could secure them....
Configuring Mutual SSL Authentication in ClusterControl
Establishing trusted communications between systems is essential in enhancing system’s security. The use of Public Key Infrastructure (PKI) is one of the common ways to achieve trusted communication in distributed systems. In particular, Mutual SSL...
Understanding Lock Granularity in MySQL
If you’ve been working with MySQL for some time, you have probably heard the terms “table-level locking” and “row-level locking”. These terms refer to the lock granularity in MySQL - in this blog we will...
Announcing ClusterControl 1.8.2: Enhanced Security, Resource Utilization and Administration
We are pleased to announce the release of version 1.8.2 of Severalnines ClusterControl - the only management system you’ll ever need to deploy, monitor, and manage your open source databases. ClusterControl version 1.8.2 features new...