Operational Reports for MySQL, MariaDB, PostgreSQL & MongoDB
The majority of DBA’s perform health checks on their databases every now and then. Usually, it would happen on a daily or weekly basis. We previously discussed why such checks are important and what they...
How to Monitor Multiple MySQL Instances Running on the Same Machine – ClusterControl Tips & Tricks
Requires ClusterControl 1.6 or later. Applies to MySQL based instances/clusters. On some occasions, you might want to run multiple instances of MySQL on a single machine. You might want to give different users access to...
Custom Graphs to Monitor Your MySQL, MariaDB, MongoDB and PostgreSQL Systems – ClusterControl Tips & Tricks
Graphs are important, as they are your window onto your monitored systems. ClusterControl comes with a predefined set of graphs for you to analyze, these are built on top of the metric sampling done by...
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....