MySQL

The idea behind ClusterControl operational reporting is to put all of the most relevant data into a single document which can be quickly analyzed in order to get a clear understanding of the status of the databases and its processes. This blog post shows how to leverage the ops report functionality to understand the state of your MySQL, MariaDB, MongoDB and PostgreSQL infrastructure.

In this blog post, we’ll show you how to use ClusterControl to monitor multiple MySQL instances running on one host.

This blog post will show you how to add custom graphs to ClusterControl to monitor specific MySQL, MariaDB, MongoDB or PostgreSQL metrics.

This blog post shows how to leverage ClusterControl performance monitoring and advisors functionality to keep your MySQL, MongoDB and/or PostgreSQL databases and clusters healthy.

ClusterControl can be used to deploy open-source database clusters that are configured in complex topologies. The full high availability stack includes both database and proxy layers.

In this blog, we are going to show you how to deploy a production-grade Galera Cluster, complete with load balancers, for a high availability setup.

Agentless monitoring is the collection of performance metrics from databases without installing any agent software on the servers being monitored. This approach is easy to manage and gets you up and running within minutes.

This blog post describes how ClusterControl uses the agentless approach to monitor databases.

The purpose of database security monitoring is twofold. One, to identify security breaches or any unauthorized or undesirable activity on the database. And two, to ensure that  databases comply with policies and security standards set by the organisation.

In this blog post, we will show you how you can monitoring your database clusters using your terminal and the s9s Command Line Interface.

Prometheus is an open-source software for monitoring and alerting, it depends on exporters to ‘scrape’ information from e.g., MySQL running on Docker. In this blog, we’ll see how to deploy the database as well as the monitoring stack with Prometheus and its components. We’ll do this for both MySQL running on standalone Docker containers as well as a Galera Cluster running on Docker Swarm.

It is difficult to measure and report on all database infrastructure components manually. In this article, we discuss the different operational reports available in ClusterControl. ClusterControl operational reports will help you to automate your daily cluster auditings tasks like database backups, operating system workload or instance and schema security.

Observability is critical piece of the operations puzzle - you have to be able to tell the state of your systems based on trending data presented in the form of graphs and alerts. Ideally, this data will be available from one single location. This blog explains how ClusterControl can work as a monitoring hub for all your database systems.

With this blog post we aim to give you an introduction to failover handling in MySQL & MariaDB by discussing what failover is, why it is unavoidable and what the difference is between failover and switchover. We also discuss the failover process in its most generic form and touch a bit on different issues that you will have to deal with in relation to the failover process.

Asynchronous replication places no low latency demands on the network, so it is possible to keep Galera Clusters in sync even when they are thousands of miles apart and utilise low-cost connections. We effectively can achieve a global system of loosely-coupled clusters. However, managing the global state translates into managing failover and failback operations at both node and cluster level.

Database failures can happen at different levels, from schema corruption on an individual server to hardware or even an entire datacenter going down. So how do we troubleshoot and fix these? In this blogpost, we will walk through 6 different failure scenarios and see how we recovery from them.

This blog provides an overview of the new Backup Management and Security & Compliance features for MySQL & PostgreSQL in the ClusterControl 1.6.2 release.

Automated failover is a critical functionality in a MySQL or MariaDB replication setup, involving master-promotion and reslaving. Now, not all slaves are good master candidates, so how do you control which node gets picked? This blog introduces whitelists and blacklists.

This blog describes best practices to make your database schema changes in MySQL and MariaDB flawless. We will walk you through the different test and rollback scenarios and recommend some help approaches for each.

Galera automatic node provisioning and membership control simplifies database cluster operation and improves the reliability of its replication technology. In this blog post, we are diving into the Galera recovery process in events where network partitioning happens.

What do you do if you lose your Galera Cluster? A simple solution is to failover to an asynchronous slave. The slave would immediately serve up-to-date data to applications, with minimal downtime. But then, with the slave being the new source of truth, how do you recover your Galera Cluster?

Wondering about disaster recovery (DR) planning for MySQL and MariaDB? Unsure about RTO and RPO? Should you have a secondary datacenter? How about DR in the cloud? Well, this is the resource for you. In this white paper, we’ll explore DR concepts and discuss the different options available from the MySQL & MariaDB ecosystem for meeting different levels of DR requirements.

Tuning a database and the underlying OS is one of the key tasks when managing a database. The goal is to avoid overutilization or underutilization of the available resources. In this webinar replay, we give you a crash course in performance tuning for MySQL & MariaDB databases.