Monitoring Percona Server for MongoDB – Key Metrics
When running critical database services in production, we need to know and monitor the database. You need to understand the key metrics in the database that you are using. For example, when you run MongoDB...
Monitoring Percona XtraDB Cluster – Key Metrics
Percona XtraDB Cluster is a very well known high availability solution in MySQL world. It is based on Galera Cluster and it does provide virtually synchronous replication across multiple nodes. As with every database, it...
How to Deploy a Highly Available Canvas LMS with a PostgreSQL Database Cluster
In these pandemic times, Learning Management System (LMS) platforms are getting more and more important to allow you to continue learning remotely when the traditional education system just isn’t available anymore. Having an LMS platform...
Comparing the Features of Percona Monitoring & Management (PMM) to ClusterControl Database Monitoring
You may have heard about Percona Monitoring and Management (PMM), a solution from Percona that is focused on the monitoring of open source databases. It is a quite popular and free solution that provides access...
Monitoring Percona Server for MySQL – Key Metrics
In this blog post, we are going to look into some key metrics and status when monitoring a Percona Server for MySQL to help us fine-tune the MySQL server configuration for a long run. Just...
How to Deploy Percona XtraDB Cluster
Percona XtraDB Cluster is a cluster solution based on the synchronous replication handled by Galera library. It is one of the most common high availability solutions for MySQL. It supports multiple writers and the conflict...
How to Deploy Percona Server for MySQL for High Availability
Percona Server for MySQL 8.0 offers a number of clustering solutions for high availability out-of-the-box: Single-master: Asynchronous replication Semi synchronous replication Multi-master: Group replication InnoDB Cluster (a combination of MySQL Router, MySQL Shell and Percona...
How to Deploy Percona Distribution for PostgreSQL for High Availability
High Availability is a requirement for many systems, no matter what technology you are using. This is especially important for databases, as they store data that applications rely upon. Depending on the requirements, there are...
Asynchronous Replication Automatic Failover in MySQL 8.0.22
Oracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case...
How to Deploy Percona Server for MongoDB for High Availability
High availability can be achieved by eliminating all single points of failures, including the database tier. So you can imagine our surprise every time we bump into setups with multiple web servers/applications all hitting one...
Monitoring Percona Distribution for PostgreSQL – Key Metrics
Monitoring is the base to know if your systems are working properly, and it allows you to fix or prevent any issue before affecting your business. Even in a robust technology like PostgreSQL, monitoring is...
Tips for Migrating from HAProxy to ProxySQL
ProxySQL is a dedicated load balancer for MySQL which comes with a variety of features including, but not limited to query redirecting, query caching or traffic shaping. It can be used to easily set up...