Tag: postgres

Replication

Failover for MySQL Replication (and others) – Should it be Automated?

Automatic failover for MySQL Replication has been subject to debate for many years. Is it a good thing or a bad thing? For those with long memory in the MySQL world, they might remember the GitHub outage in 2012 which was mainly caused by software taking the wrong decisions. GitHub had then just migrated to …

Miscellaneous

How to Decode the PostgreSQL Error Logs

PostgreSQL error reporting follows a style guide aimed at providing the database administrator with the information required to efficiently troubleshoot issues. Error messages normally contain a short description, followed by some detailed information, and a hint, if applicable, suggesting the solution. There are other fine details, explained in the guide, such as the use of …

Miscellaneous

Collect PostgreSQL Metrics with Percona Monitoring and Management (PMM)

In this article, we’ll describe how to collect PostgreSQL metrics with Percona Monitoring and Management (PMM). We designed Percona Monitoring and Management (PMM) to be the best tool for MySQL and MongoDB performance investigation. At the same time, it’s built on mature opensource components: Prometheus’ time series database and Grafana. Starting from PMM 1.4.0. it’s possible to …

Clustering

Updated: Become a ClusterControl DBA – Deploying your Databases and Clusters

We get some nice feedback with regards to our product ClusterControl, especially how easy it is to install and get going. Installing new software is one thing, but using it properly is another. It is not uncommon to be impatient to test new software and one would rather toy around with a new exciting application …