Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
Does your company/department have a disaster recovery plan?
Submit
Yes
No
I don’t know
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 7):
  • Yes (43%, 3 Votes)

  • No (57%, 4 Votes)

  • I don’t know (0%, 0 Votes)

54 blog posts in 1 category

Integrating Tools to Manage PostgreSQL in Production

As a follow up to the popular blog “Ten Tips for Going into Production with PostgreSQL”, this blog explores the different types of tools you would need to effectively run a PostgreSQL instance in a production environment.

Schema Management Tips for MySQL & MariaDB

Schema changes are not popular among database ops folks. They can be quite cumbersome in MySQL and MariaDB, and there are risks to the data as well as the availability of the database.

This blog describes the different types of schema change operations you can perform on MySQL and MariaDB, and presents some best practices to minimize disruptions to your operations.

How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome

Split brain syndrome is a state where a cluster of nodes is partitioned into smaller clusters of equal numbers of nodes, and each cluster believes it is the active cluster. This is a harmful state, as data is changed on a partition, without being replicated to the other. This blog post describes how to prevent a split brain from happening, and what can be done if it does happen.

Optimizing Your Linux Environment for MongoDB

This blog details the steps you should take to setup your environment to optimally run a MongoDB setup.

An Overview of the Serial Pseudo-Datatype for PostgreSQL

Introduction to the special implementation of PostgreSQL serial data types typically used for creation of synthetic primary keys.

Visualizing your Cluster Topology in ClusterControl

Topology View provides a visual representation of your database nodes and load balancers in real time, in a simple and friendly interface and without the need to install any additional tools.

An Overview of Database Indexing for MongoDB

This blog provides an overview of MongoDB NoSQL Database Indexing, how to create them and measure performance.

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore, study, learn, or otherwise manipulate data sets.

Capacity Planning for MySQL and MariaDB - Dimensioning Storage Size

How much storage should we allocate to the database depends on how fast the database is expected to grow. It sounds like a simple question to answer, but there are a number of factors to consider before we can come up with an accurate answer. This blog post gives you some tips on how to plan and dimension storage size for your MySQL and MariaDB servers in production.

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.

Pages