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....
Using Automation to Speed up Release Tests on Galera Cluster With ClusterControl
Release tests are typically one of the steps in the whole deployment process. You write the code, and then you verify how it behaves on a staging environment, and then, finally, you deploy the new...
How to use Encryption to Protect MongoDB data
With many kinds of data stored in the database, sometimes we may be dealing with confidential data, which might include credit card data, financial record, personal information. Those PII (Personal Identifiable Information) data is subject...
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...
How to Get Started With Database Automation
Database automation helps make complex and time consuming tasks simple and fast. The tasks most commonly and easily identified for automation are those that are time-consuming yet repetitive. These often consume productivity, and can affect...
Automating Security Audits for PostgreSQL
Security audits are a must in all companies to protect data and avoid any possible security breaches, but it is also a time-consuming task as you need to check a lot of things periodically. The...
A Guide to Database Automation with Severalnines ClusterControl
Nowadays, database automation is a very hot topic. Database automation, simply speaking, refers to leveraging processes and tools to make administrative tasks for database developers and database administrators simpler. Why Database Automation? Database automation refers...
Enforcing Role-Based Access Controls with ClusterControl
In Severalnines’ recent release of ClusterControl version 1.8.2 we have introduced a lot of sophisticated features and changes. One of the important features is the newly improved User Management System, which covers New User and...