How to Automate Database Workload Analysis With ClusterControl Performance Advisors
ClusterControl Community Edition gives us the opportunity to install database clusters and get a real-time representation of database status and queries for free. A big chunk of ops management consists of tracking your monitoring systems....
Deploy MySQL Replication and ProxySQL With Automatic Failover
MySQL replication is a very popular choice to build highly available setups. It is fairly predictable, robust and efficient. It is also quite easy to setup - install MySQL software, create replication users and configure...
Webinar Replay: An Introduction to Performance Monitoring for PostgreSQL
The replay of our webinar on monitoring PostgreSQL for performance is now available to watch online If you’re asking yourself some of the following questions, then these 60 minutes are for you: PostgreSQL offers many...
Database Security Monitoring for MySQL and MariaDB
Data protection is one of the most significant aspects of administering a database. Depending on the organizational structure, whether you are a developer, sysadmin or DBA, if you are managing the production database, you must...
How to Monitor Your Database Servers Using ClusterControl CLI
How would you like to merge "top" process for all your 5 database nodes and sort by CPU usage with just a one-liner command? Yeah, you read it right! How about interactive graphs display in...
An Overview of Database Operational Reporting in ClusterControl
Operational Reporting provides support to the day-to-day enterprise activity monitoring and control. The purpose of this blog article is to get you more familiar with the operational reports available in ClusterControl. ClusterControl operational reports arm...
Database Monitoring with ClusterControl
Data observability is a critical piece of the database operations puzzle – Data allows you visibility into the state and health of your critical systems. Ideally, this data should be available in one single location....
Introduction to Failover for MySQL Replication – the 101 Blog
Dealing with MySQL replication? Chances are that you chose that setup to achieve high availability. After all, it is the most popular HA solution for MySQL. But guess what absolutely does not qualify as ‘being...
Failover for PostgreSQL Replication 101
Failover might sound like a buzzword for anyone within the IT industry, but what’s behind it? What is a failover? What can I use it for? Is it important to have it? How can I...
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...