Infrastructure at your Service

Failover cluster Archives - Blog dbi services

David Barbarin

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

By | Database Administration & Monitoring | No Comments

In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to share disk resources between my cluster nodes as described in the Microsoft documentation. A couple of days ago, I decided to add a fourth node (LINUX04) to my cluster infrastructure and I expected to do this work easily. But no chance, I faced a problem I never had before on this…

 
Read More
David Barbarin

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

By | Database Administration & Monitoring | No Comments

On my first blog about SQL Server on Linux, I introduced the new high availability feature which concerns only SQL Server failover cluster instances so far. During this discovery time, I had the support of Mihaela Blendea (@MihaelaBlendea) at Microsoft to clarify some architecture aspects about this new kind of architecture. Firstly, I would like to thank her. It’s always a big pleasure to get the availability of the Microsoft team in this case. But after…

 
Read More
David Barbarin

Introducing high-availability with SQL Server on Linux

By | Database Administration & Monitoring, Database management | One Comment

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So now it’s time to start the new year by talking about high availability on Linux with SQL Server vNext. Running standalone instances will be suitable for scenarios but I guess introducing high-availability with critical environments still remain mandatory.Currently, the CTP1 supports installing a SQL Server Failover Cluster Instance on the top…

 
Read More
Daniel Westermann

EDB Failover Manager 2.1, (two) new features

By | Database Administration & Monitoring | 3 Comments

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 post: Failover Manager now simplifies cluster startup with the auto.allow.hosts property efm promote now includes a -switchover option; the -switchover option instructs Failover Manager to perform a failover, promoting a Standby to Master, and then, return the Master node to the…

 
Read More
Daniel Westermann

EDB Failover Manager 2.1, upgrading

By | Database Administration & Monitoring | 2 Comments

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 exactly what you want when you are used to operate Oracle DataGuard. Switching back and forward as you like without caring much about the old master. The old master shall just be converted to a standby which follows the new master…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | 2 Comments

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 operations on the master as well as on the standby node in a failover cluster managed by EDB Failober Manager. What is still open is how to perform maintenance operations on the witness node. So, lets go.  

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | 4 Comments

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 you can do maintenance on the primary node (better: the node where the primary instance currently runs on). This requires slightly more work and attention. Lets go.  

 
Read More
David Barbarin

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

By | Database Administration & Monitoring, Database management | No Comments

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 can’t say strongly enough that the AlwaysOn availability group runs on the top of the WSFC and having a good understanding of the internal stuff can help a lot for troubleshooting. First of all, let me introduce the issue…

 
Read More
David Barbarin

Windows failover cluster 2016 : new site awareness feature

By | Database Administration & Monitoring, Operation systems | No Comments

After my first two blogs about cloud witness and domain-less dependencies features shipped with Windows Server 2016, it’s time to talk about another pretty cool feature of the WSFC : site awareness that will also benefit to our SQL Server FCIs and availability groups. But before to talk further about the potential benefits of this new feature, let’s go back to the previous and current version of Windows Server that is 2012 R2. Firstly, let’s…

 
Read More