Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Monitor PostgreSQL Running Inside a Docker Container: Part Two

This is part II of the blog How to Monitor PostgreSQL Running Inside a Docker Container.

How to Monitor PostgreSQL Running Inside a Docker Container: Part One

In this article we will be introduced to Docker, describing some ways of configuration and comparing them. Furthermore PostgreSQL comes to play, and we will deploy it inside a Docker container in a smart way, and finally we will see the benefits that ClusterControl can provide, to monitor key metrics about PostgreSQL and the OS outside of it.

Deploying & Configuring MongoDB Shards with Ansible

This blog provides an overview of how to deploy and configure a sharded MongoDB setup using the automation platform Ansible.

MySQL Replication with ProxySQL on WHM/cPanel Servers - Part 2

In this second part of how to run MySQL Replication with ProxySQL on WHM cPanel servers, we cover the post-deployment operations for maintenance, management, failover as well as advantages over the standalone setup.

MySQL Replication with ProxySQL on WHM/cPanel Servers - Part 1

In this two-part blog series, we are going to give a complete walkthrough on how to run MySQL Replication with ProxySQL on WHM cPanel servers. This first part covers the deployment of MySQL Replication and ProxySQL, as well as ProxySQL integration with cPanel via standardized hooks integration. The second part will cover management and ongoing maintenance of the setup.

PostgreSQL Deployment and Maintenance with Ansible

Deployment and Maintenance of PostgreSQL are common and frequently performed operational tasks. No engineers should spend time doing these tasks manually, so in this blog, we will see how we can use Ansible for automating PostgreSQL deployment and maintenance.

MariaDB MaxScale Load Balancing on Docker: Management - Part 2

In the previous blog, we looked at how to deploy MaxScale on Docker, and how to use Swarm service to run multiple replicas. This part focuses more on management operations with advanced use cases like service control, configuration management, query processing, security and cluster reconciliation.

An Overview of MongoDB Schema Validation

Schema validation allows you to define the specific structure of documents in each MongoDB collection. If anyone tries to insert some documents which don't match with the defined schema, MongoDB can reject this kind of operation or give warnings according to the type of validation action.

Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster

This post walks you through deployment of MySQL/MariaDB Galera Cluster using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

How to Optimize PostgreSQL Logical Replication

Logical Replication or pglogical is a method of replicating specific data objects (tables) and their changes to the replica in real-time which is similar to streaming replication. The term logical is in contrast to physical replication, which uses exact block addresses and byte-by-byte replication. This blog provides tips on how to optimize logical replication system.

Pages