Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

Performing a Live Upgrade to MySQL 5.7

Once we’ve tested that our application works with MySQL 5.7, what is the best way to introduce 5.7 in our live environment? How can we minimize risks? What tools can help facilitate the process?

Posted in:

What to test before upgrading to MySQL 5.7

With the behaviour of some existing features changing in MySQL 5.7, how do you ensure an upgrade will not adversely affect your applications? This blog post looks at how to prepare and perform regression tests.

Posted in:

Pages