Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
725 blog posts in 13 categories

How to Manage Your PostgreSQL Databases from the ClusterControl CLI

What if you could deploy a 3-node streaming replication setup in one command? Or orchestrate a master failover with reslaving of nodes in one command? Welcome to ClusterControl’s command line interface to manage your PostgreSQL setups. This blog post shows you how to manage your PostgreSQL streaming replication cluster using s9s, the ClusterControl CLI.

Webinar Replay: How to Automate & Manage PostgreSQL with ClusterControl

Watch the replay of our webinar on how to automate and manage PostgreSQL with ClusterControl. Sebastian Insausti, Support Engineer at Severalnines, will introduce us to the world of PostgreSQL ops automation: from the ‘old ways’ to the modern way of managing PostgreSQL; including a look at ClusterControl’s integrated approach to deployment, monitoring, performance management, scaling, upgrades and backup, delivered as an integrated suite that plugs into your favourite tools.

Monitoring & Ops Management of MongoDB 4.0 with ClusterControl

MongoDB 4.0 added support for multi-document ACID transactions, which brings it closer to the relational world. But how can you manage it, along with other relational open source databases like MySQL, MariaDB and PostgreSQL? In this blog post, we look at the challenges of operating a MongoDB database, and see how important tasks like monitoring, alerting, backups and failover can be handled with ClusterControl.

Analytics with MariaDB AX - the Open Source Columnar Datastore

What is a columnar datastore? When is it a better fit over a relational datastore? In this blog post, we will take a look at MariaDB AX and how it fits in this landscape.

An Overview of JSON Capabilities Within PostgreSQL

This blog provides an overview of the JSON capabilities within PostgreSQL which were released in version 9.2.

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.

Database Security - How to Use Encryption to Protect Your MongoDB Data

Database security is an important part of management. This blog shows you how to use different types of encryption to ensure your MongoDB data is secure.

One Security System for Application, Connection Pooling and PostgreSQL - The Case for LDAP

This blog describes how you can use LDAP for both authentication and connection pooling with your PostgreSQL database.

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.