Failover cluster

Prepare Failover Cluster for AG configuration

In this blog I will show you some important powershell commands to prepare a Failover Cluster for AG configuration. Please keep in mind, this is a test environment and I will not talk about firewall rules. Our objective(…)

SQL Server Failover Cluster on Linux and synchronizing uids/gids across nodes

In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to(…)

Introducing high-availability and multi-subnet scenarios with SQL Server on Linux

On my first blog about SQL Server on Linux, I introduced the new high availability feature which concerns only SQL Server failover(…)

Introducing high-availability with SQL Server on Linux

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So(…)

EDB Failover Manager 2.1, (two) new features

In the last post we upgraded EDB EFM from version 2.0 to 2.1. In this post we'll look at the new features. Actually we'll look only at two of the new features in this(…)

EDB Failover Manager 2.1, upgrading

Some days ago EnterpriseDB released a new version of its EDB Failover Manager which brings one feature that really sounds great: "Controlled switchover and switchback for easier maintenance and disaster recovery tests". This is(…)

Maintenance scenarios with EDB Failover Manager (3) – Witness node

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance(…)

Maintenance scenarios with EDB Failover Manager (2) – Primary node

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I'll look on how(…)

Maintenance scenarios with EDB Failover Manager (1) – Standby node

Recently at a customer we again implemented a PostgreSQL architecture as described some time ago. When we delivered the first draft of the documentation the question popped up how to handle maintenance tasks in a failover cluster(…)

SQL Server AlwaysOn : the registry is also important for availability groups

A couple of months ago, we experienced with my colleague Nathan Courtine a weird issue at one of our customers. This issue concerned an AlwaysOn availability group and more precisely to the WSFC cluster layout. I(…)