Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Backup and Restore ClusterControl

Migrating ClusterControl to new hardware used to be a pain - you had to reinstall it on the new server, restore configuration/metadata from the old one and redo database grants so the new server can access your managed databases. Not any more! Starting with 1.7.1, it is possible to backup the ClusterControl server in one command and restore it on a new server, with data, grants and all.  This blog shows you how to do this using the s9s CLI.

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.

Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1

A few days ago was the release of a new version of ClusterControl, the 1.7.1, with several new features, including for PostgreSQL. In this blog, we will see how to deploy PostgreSQL 11 version using ClusterControl. We’ll also check out the new backup verification feature that you can use to automatically test your backups.

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.

What is MariaDB TX? How to Manage the New MariaDB MySQL Fork!

MariaDB TX is a subscription in which MariaDB combines multiple offerings building a fully-featured, transactional database. The database used in MariaDB TX is MariaDB Server 10.3, which also includes Galera Cluster for synchronous multi-master replication. For the proxy layer MariaDB TX uses MaxScale.

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.

The New Way to Manage Open Source Databases

The database industry has completely changed in the past two decades - from closed source to open source first, single instances to distributed clusters, polyglot environments and increasingly automated operational systems that are slowly but surely taking over the common core tasks of the DBA.

This blog discusses this industry shift.

2019 Open Source Database Trends & Predictions

2018 saw a rise in PostgreSQL, a boom in containizeration and increased adoption of DevOps in the enterprise. What will 2019 hold? This blog details some industry predictions as well as ones from the Severalnines team.