Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
How are you currently backing up your data?
Submit
Custom backup scripts scheduled with CRON
ClusterControl
On-prem DB backup tool
Storage snapshot backup
Online backup service
Other
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 32):
  • Custom backup scripts scheduled with CRON (44%, 14 Votes)

  • ClusterControl (0%, 0 Votes)

  • On-prem DB backup tool (16%, 5 Votes)

  • Storage snapshot backup (19%, 6 Votes)

  • Online backup service (9%, 3 Votes)

  • Other (13%, 4 Votes)

22 blog posts in 1 category

ClusterControl Tips and Tricks: Running ClusterControl on PHP 7

PHP 5 is deprecated since early this year, which may cause some concerns when running ClusterControl. This blog post shows you how to run ClusterControl on PHP 7.

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.

Pages