Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

HAProxy Connections vs MySQL Connections - What You Should Know

Max connections determines the maximum number of connections to the database server. This can be set on both the database server, or the proxy in front of it. In this blog post, we’ll dive into HAProxy and MySQL maximum connections variables, and see how to get the best of both worlds.

Posted in:

Become a PostgreSQL DBA: Adding Additional Nodes To a Replication Setup

Master-slave replication setups can be very useful, as they provide multiple copies of the data for high availability or for scale out purposes. Master slave replication setups can be ver useful as they provide multiple copies of the data from a redundancy perspective., We will show you how to add nodes to an existing PostgreSQL replication setup using ClusterControl.

How to Stop or Throttle SST Operation on a Galera Cluster

A full node resync, or SST, can be a heavy, long-running operation that impacts the performance and stability of a Galera Cluster. This blog post explains a trick on how to stop an ongoing SST operation in a clean manner.

Posted in:

View the replay: how to manage MongoDB & Percona Server for MongoDB

For this webinar we’d teamed up with Percona’s Tyler Duzan, Product Manager, who talked to us about some of the key features and aspects of Percona Server for MongoDB.

Posted in:

New ClusterControl Template for Zabbix

This blog post describes our new ClusterControl Template for Zabbix v2, which comes with a number of improvements if compared to the previous version.

Posted in:

Automating and Managing MongoDB in the Cloud

This blog provides an overview of setting up ClusterControl for MongoDB on Amazon Web Services, including deploying a MongoDB replica set, and demonstrating several key features of ClusterControl relevant to MongoDB.

How to Automate Galera Cluster Using the ClusterControl CLI

As sysadmins and developers, we spend a lot our time in a terminal. So we brought ClusterControl to the terminal with our command line interface tool called s9s. This blog post shows how to use s9s to automate management of a Galera Cluster and a master-slave replication setup.

Posted in:

[Updated] Monitoring Galera Cluster for MySQL or MariaDB - Understanding metrics and their meaning

Read this blog to find out how ClusterControl combines the two most popular types of monitoring, and see how it presents needed information on Galera Cluster and how we should interpret it.

Posted in:

Become a PostgreSQL DBA: Best Community Tools for PostgreSQL

This blog features some of the most widely used PostgreSQL tools to help you get up-and-running.

Become a PostgreSQL DBA: PostgreSQL Server Configuration Parameters

In this blog, we focus on connection, logging and memory parameters important to PostgreSQL Server Configuration.