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...
How to Recover MySQL Galera Cluster From an Asynchronous Slave
Introduction When running Galera Cluster, it is a common practice to add one or more asynchronous slaves in the same or in a different datacenter. This provides us with a contingency plan with low RTO,...
Disaster Recovery Planning for MySQL & MariaDB
We’re happy to announce that our new whitepaper Disaster Recovery Planning for MySQL & MariaDB is now available to download for free! Database outages are almost inevitable and understanding the timeline of an outage can...
Managing MySQL, MongoDB & PostgreSQL with ChatOps from Slack
What is ChatOps? Nowadays, we make use of multiple communication channels to manage or receive information from our systems, such as email, chat and applications among others. If we could centralize this in one...
MariaDB Backup & PostgreSQL in the Cloud – ClusterControl Release 1.6.1
We are excited to announce the 1.6.1 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 or...
PostgreSQL Management and Automation with ClusterControl
We’re happy to announce that our new whitepaper PostgreSQL Management and Automation with ClusterControl is now available to download for free! This whitepaper provides an overview of what it takes to configure and manage a...
Setting up HTTPS on the ClusterControl Server
As a platform that manages all of your databases, ClusterControl maintains the communication with the backend servers, it sends commands and collect metrics. In order to avoid unauthorized access, it is critical that the communication...
Safeguarding your Data with ClusterControl
In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in...
Deploying Cloud Databases with ClusterControl 1.6
ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. In...
Getting the Most Out of ClusterControl Community Edition
ClusterControl is an agentless management and monitoring system that helps to deploy, manage, monitor and scale our databases from a friendly interface. It allows us to perform, in a few seconds, database management tasks that...
How to do Point-in-Time Recovery of MySQL & MariaDB Data Using ClusterControl
Backups are crucial when it comes to safety of data. They are the ultimate disaster recovery solution - you have no database nodes reachable and your datacenter could literally have gone up in smoke, but...
Visualizing Your Cluster Topology in ClusterControl
Distributed databases or clusters typically consist of multiple node and nodes types, and it is not always easy to understand how all these hang together. For instance, one could have a replication setup with intermediate...