ClusterControl Performance and Health Monitoring
In the previous two blog posts we covered both deploying the four types of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL) and managing/monitoring your existing databases and clusters. So, after reading these two first blog...
How to Deploy PostgreSQL for High Availability
Introduction Nowadays, high availability is a requirement for many systems, no matter what technology you’re using. This is especially important for databases, as they store data that critical applications and systems rely on. The most...
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...