Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
72 blog posts in 1 category

How to Optimize Performance of ClusterControl and Its Components

This blog post explains a number of ways to improve performance of ClusterControl and its components.

Monitoring HAProxy Metrics And How They Change With Time

There is a lot information on the traffic that is routed through HAProxy, as well as the state of the backends. This blog post discusses different HAProxy metrics, which ClusterControl collects and presents in the agent-based monitoring mode with Prometheus.

Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

MySQL Performance Cheat Sheet

You would be surprised by the number of MySQL installations running default configurations, regardless of the workload. However, what works well for a read-intensive workload might not work as well for a write-intensive one. Configuration parameters also need to take into account the underlying hardware. This cheat sheet provides some quick tips on how to tune some of the key MySQL variables in order to improve performance.

Severalnines 2018 Momentum: Raising the Bar on MySQL, MariaDB, PostgreSQL & MongoDB Management

Read about 2018 at Severalnines: from our top achievements of the year via our year-end video all the way through to our most read and watched content for MySQL, MariaDB, PostgreSQL & MongoDB users.

MySQL in 2018: What’s in 8.0 and Other Observations

This blog details MySQL’s accomplishments in 2018, including the release of MySQL 8.0 which includes changes to roles and the integration of NoSQL.

Database High Availability Comparison - MySQL / MariaDB Replication vs Oracle Data Guard

This blog compares MySQL replication vs Oracle Data Guard solution for High Availability.

Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL

Watch the replay of this webinar for a detailed overview of what failover processes may look like in MySQL, MariaDB and PostgreSQL replication setups. We’ll cover the dangers related to the failover process and look at how ClusterControl manages it as well as how it can be configured for both assisted and automated failover.

MySQL & MariaDB Query Caching with ProxySQL & ClusterControl

A query cache can greatly improve database performance, and there are various types of mechanisms available - from the inbuilt MySQL query cache to external key value stores like memcached or Redis. In this blog, we’ll show you how to cache your queries via ProxySQL, and avoid the overhead of an additional dedicated caching layer.

MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.