Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Upgrade PostgreSQL10 to PostgreSQL11 with Zero Downtime

The old way to accomplish upgrades on PostgreSQL used to be using pg_upgrade, dumping and restoring, or using some third party tools, all of them with their own caveats. Nowadays, PostgreSQL allows us to use logical replication which, in contrast to physical replication, you can replicate between different major versions of PostgreSQL. In this blog, we're going to see how we can upgrade our PostgreSQL 10 to PostgreSQL 11 with zero downtime using logical replication.

What's New in PostgreSQL 11

This blog provides an overview of the new features and functions that can be found in PostgreSQL 11 including stored functions, partitioning, and much more!

Migrating from MSSQL to PostgreSQL - What You Should Know

If you are considering moving from a MSSQL environment to PostgreSQL, this blog provides a high level overview of what you should know to migrate between the two.

Failover for PostgreSQL Replication 101

Failover is a procedure that we hope we won’t have to use, but we must know how it works. In this blog, we will be cover the basic definitions of failover in PostgreSQL replication, and some example scenarios where failover can be useful.

How to perform Schema Changes in MySQL & MariaDB in a Safe Way

This blog describes best practices to make your database schema changes in MySQL and MariaDB flawless. We will walk you through different scenarios and recomment some approaches for each.

Custom Trigger Based Upgrades for PostgreSQL

This blog provides an overview of custom trigger based upgrades for PostgreSQL; and some insight into how computer game strategies can be lessons for database administration life.

Upgrading Your Database to PostgreSQL Version 10 - What You Should Know

This blog offers a short summary of how you can perform a PostgreSQL 10 upgrade, including what method to chose, how to prepare and what to check for after the upgrade is complete.

Upgrading to the ClusterControl Enterprise Edition

This blog details how to upgrade from the ClusterControl Community Edition to the Enterprise Edition and the value it brings to your database infrastructure.

Online Schema Upgrade in MySQL Galera Cluster using RSU Method

Performing RSU - Rolling Schema Upgrade - in a safe way is much more complex than just running a couple of commands. This blog post explains the RSU method for schema changes in Galera Cluster for MySQL, MariaDB Galera Cluster or Percona XtraDB Cluster.

Database Security - MySQL Upgrade Instructions for Zero-day Exploit

This blog shows you how to upgrade your MySQL and MariaDB databases, in order to address CVE-2016-6662 - a publicly disclosed vulnerability in MySQL.

Pages