Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
11 blog posts in 12 categories

Using Kubernetes to Deploy PostgreSQL

This blog provides steps on how to run a PostgreSQL database on a Kubernetes cluster using Docker containerization.

Updated: Become a ClusterControl DBA: Managing your Database Configurations

Learn about how to manage, alter and template your database configurations in ClusterControl for MySQL, MongoDB & PostgreSQL.

Become a PostgreSQL DBA: PostgreSQL Server Configuration Parameters

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

Become a PostgreSQL DBA - How to Setup Streaming Replication for High Availability

In this post, we will show you how to set up master-slave replication with Postgres.

Become a PostgreSQL DBA: Provisioning and Deployment

This post is the first in the “Become a PostgreSQL DBA” blog series and will cover provisioning and deployment.

Become a MongoDB DBA: The Basics of MongoDB Configuration

This is our second post in the “Become a MongoDB DBA” blog series. It covers configuration of MongoDB, especially around ReplicaSet, security, authorization, SSL and HTTP / REST api.

Become a MongoDB DBA: MySQL vs MongoDB - Deployment & Provisioning

This post is the first in the “Become a MongoDB DBA” blog series and will cover provisioning and deployment.

ClusterControl Tips & Tricks for MySQL: Max Open Files

You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a backup using xtrabackup. Or, if it is a Galera cluster, you have to recover a galera node using wsrep_sst_method=xtrabackup[-v2].

ClusterControl Tips & Tricks: Updating your MySQL Configuration

Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. From time to time it is necessary to tune and update your configuration. Here we will show you how you can change/update  individual parameters using the ClusterControl UI. Navigate to Manage > Configurations.

Become a MySQL DBA blog series - Configuration Tuning for Performance

In this blog post, we’ll discuss some of the settings that are most often tweaked and which can bring you significant improvement in the performance. We will also cover some of the variables which are frequently modified even though they should not. Performance tuning is not easy, but you can go a surprisingly long way with a few basic guidelines.

Pages