Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Creating New Modules using PostgreSQL Create Extension

The PostgreSQL Create Extension allows you to extend the functionality of PostgreSQL to meet the needs of your specific application. This blog details how to use this functionality.

A Guide to Partitioning Data In PostgreSQL

For databases with extremely large tables, partitioning is a wonderful and crafty trick for database designers to improve database performance and make maintenance much easier.  This blog provides an overview of partitioning data for PostgreSQL.

Understanding System Columns in PostgreSQL

A system column is a a table with OIDs. OID is auto-incrementing integer value, unique within a PostgreSQL database (not just a table) that can be automatically assigned to each row of a table created WITH OIDS option.

PostgreSQL Triggers and Stored Function Basics

By building DML code into PostgreSQL, we can avoid duplicate implementation of data-related code in multiple separate applications that interface with the database. This ensures consistent execution of DML for data validation, data cleansing, or other functionality such as data auditing (i.e., logging changes) or maintaining a summary table independently of any calling application. In this blog, we’ll look at the basics of triggers and stored functions in PostgreSQL.

More of My Favorite PostgreSQL Queries - and Why They Also Matter

This is the follow up to the popular blog ‘My favourite PostgreSQL queries and why they matter’. This new blog focusses on a particular query, multi-row UPDATE with a single CASE expression, and makes comparisons between that particular query, and one involving multiple single UPDATE statements.

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.