Controlling Replication Failover for MySQL and MariaDB With Pre- or Post-Failover Scripts
In a previous post, we discussed how you can take control of the failover process in ClusterControl by utilizing whitelists and blacklists. In this post, we are going to discuss a similar concept. But this...
New Backup Management and Security Features for MySQL & PostgreSQL: ClusterControl Release 1.6.2
We are excited to announce the 1.6.2 release of ClusterControl - the all-inclusive database management system that lets you easily automate and manage highly available open source databases in any environment: on-premise or in the...
How to Control Replication Failover for MySQL and MariaDB
Automated failover is pretty much a must have for many applications - uptime is taken for granted. It’s quite hard to accept that an application is down for 20 or 30 minutes because someone has...
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...
Backup PostgreSQL Using pg_dump and pg_dumpall
Businesses and services deliver value based on data. Availability, consistent state, and durability are top priorities for keeping customers and end-users satisfied. Lost or inaccessible data could possibly equate to lost customers. Database backups should...
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...