How to Perform Schema Changes in MySQL & MariaDB in a Safe Way
Before you attempt to perform any schema changes on your production databases, you should make sure that you have a rock solid rollback plan; and that your change procedure has been successfully tested and validated...
Custom Trigger Based Upgrades for PostgreSQL
1st RULE: You do not upgrade PostgreSQL with trigger-based replication 2nd RULE: You DO NOT upgrade PostgreSQL with trigger-based replication 3rd RULE: If you upgrade PostgreSQL with trigger-based replication, prepare to suffer. And prepare well....
Upgrading Your Database to PostgreSQL Version 10 – What You Should Know
As more and more posts on PostgreSQL 11 appear on the web, the more outdated you may feel when using Postgres 9. Although the PostgreSQL 10 version release only happened just months ago, people are...
Featuring Backup Encryption for MySQL, MongoDB & PostgreSQL – ClusterControl 1.5.1
What better way to start a new year than with a new product release? Today we are excited to announce the 1.5.1 release of ClusterControl - the all-inclusive database management system that lets you easily...
Upgrading to the ClusterControl Enterprise Edition
The ClusterControl Enterprise Edition provides you will a full suite of management and scaling features in addition to the deployment and monitoring functions offered as part of the free Community Edition. You also have the...
What's New with ProxySQL in ClusterControl v1.4.2
ClusterControl v1.4.2 comes with a number of improvements around ProxySQL. The previous version, also known as “The ProxySQL Edition”, introduced a full integration of ProxySQL with MySQL Replication and Galera Cluster. With ClusterControl v1.4.2, we...
Online Schema Upgrade in MySQL Galera Cluster Using RSU Method
This post is a continuation of our previous post on Online Schema Upgrade in Galera using TOI method. We will now show you how to perform a schema upgrade using the Rolling Schema Upgrade (RSU)...
What’s New in ClusterControl 1.4 – Backup Management
ClusterControl 1.4 introduces some major improvements in the area of backup management, with a revamped interface and simplified options to create backups. In this blog post, we’ll have a look at the new backup features...
ClusterControl 1.4 – the MySQL Replication & MongoDB Edition
Today we are pleased to announce the 1.4 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases in any environment; on-premise...
MySQL Database Security Upgrade Instructions for Zero-day Exploit
You must have heard about the CVE-2016-6662, the recent zero-day exploit exposed in most of MySQL and its variants. The vulnerability flaw can be exploited by a remote attacker to inject malicious settings into your...
MongoDB Features – Sharded Deployments, Cluster-Consistent Backups, Advisors in ClusterControl 1.3.2 Release
The Severalnines team is pleased to announce the release of ClusterControl 1.3.2. This release contains new features, such as deploying MongoDB sharded clusters and scheduling cluster-consistent backups, MongoDB Advisors, a new alarm viewer and new...
What's New in ClusterControl 1.3.1 Documentation
If you haven’t upgraded to ClusterControl 1.3.1, you should! It’s full of great new features and enhancements. We have lots of documentation to help you get started. Documentation on older versions is also available in...