Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

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.

How to Configure Drupal with MongoDB Replica Set

Drupal’s modular setup allows for different datastores to be integrated as modules, this allows sites to store different types of Drupal data into MongoDB. You can choose to store Drupal’s cache, session, watchdog, block information, queue and field storage data in either a standalone MongoDB instance or in a MongoDB Replica Set in conjunction with MySQL as the default datastore. If you’re looking at clustering your entire Drupal setup, then see this blog on how to cluster MySQL and the file system.

Posted in: