Failover is the concept of moving services from one host or node to another in order to provide high availability in a computing system.

learn more… | top users | synonyms

2
votes
1answer
30 views

Can I get pg_rewind to show me lost data after a Postgres failover?

Say I have Postgres setup with a warm standby using the build in replication features. Now, imagine a scenario where the data centre the master loses power and the slave is in another data centre and ...
1
vote
2answers
48 views

Remove a node from Failover Cluster

We had 5 SQL Server 2012 servers configured with AlwaysOn. A few days ago we dismissed 2 of them, we removed them from the availability group and then stopped SQL services. We need to reuse these ...
0
votes
1answer
31 views

Mixing Clustered Instance and Non-Clustered Instance

I'm currently managing a 2 node SQL Server Failover Cluster in Active/Passive setup. I plan on adding a new SQL Server instance which doesn't have to be on the Failover Cluster. The only documentation ...
3
votes
1answer
34 views

Force a Member to Become Primary when Primary fails in mobgodb

I have mongodb 2.6.11 cluster of two members: nms02 and nms01m. I know how to force secondary to become primary when primary is avail. But now my primary nms02 failed..and nms01m is secondary...How I ...
6
votes
2answers
45 views

Force a Member to Become Primary in mongodb

I looked into answers but nothing works for me in mongo 2.6.11 cluster 'nms' (members nms01m and nms02) below. I want my current secondary nms01m to become primary, and now nms02 is primary instead of ...
3
votes
1answer
45 views

Can SQL Server 2012 FCI have multiple names?

Is it possible to have multiple names for the same SQL Server Failover Cluster Instance (virtual server)? IT has a naming convention they like, but it hard codes the Windows cluster name into the SQL ...
1
vote
0answers
25 views

Is is possible to convert SQL Server from single instance to failover clustered node?

If SQL Server 2014 Enterprise has already been installed, can it still be converted/added to a failover cluster? Specific scenario - Amazon EC2 instance of Windows 2012 + SQL Server 2014 (license ...
2
votes
1answer
41 views

Change port number for SQL 2012 Cluster

I have been trying to change the port number of a SQL 2012 cluster with little success. I had thought that I could just do this the same way as normal through configuration manager however, even with ...
0
votes
1answer
42 views

SQL Server - How does Always On in a shared nothing config maintain transaction durability during a failover?

I've been reading up on Always On, and I was wondering how transactional durability is maintained during a failover when using a shared nothing configuration. The only things I can find on google ...
1
vote
2answers
74 views

Would SQL Server in a Cluster failover if it is running out of RAM

I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running out of RAM (both physical and pagefile). In the instance level settings there is not Max RAM set (set to the ...
1
vote
1answer
180 views

SQL Server failover cluster installation fails on primary node

I'm trying to install SQL Server 2014 fail-over cluster, but the installation fails with following log i have tried a lot of things but without any success.. The installation failed with following ...
0
votes
0answers
25 views

PGBouncer pausing hanging from ltm monitor

Currently I have the following setup: F5LTM --> PGBx2 --> DBx3 The PGBouncers are set up with priority groups on the F5 so in the event one fails or hangs traffic will still be sent to the database ...
-1
votes
1answer
30 views

What are the typical errors that cause sql server to failover in a cluster [closed]

I have a two-nodes cluster with active-passive applied for a single instance of SQL Server 2008 R2. What would be the typical reasons the instance will fail over to the passive node?
2
votes
1answer
46 views

Availability Groups - Can async replica delay failover of sync replica?

Availability Groups SQL Server 2012. Node 1 and Node 2 in primary data centre - sync mode for HA Node 3 in dr data centre - async mode for DR If a manual failover is performed between node 1 and ...
0
votes
1answer
69 views

SQL Server does not failback to the primary node

We are running SQL Server 2008 R2 on a Windows Server 2008 R2 two-node cluster. My choice of machine is primary, and the secondary is just a low-end machine for contingency planing. We had a ...
2
votes
1answer
146 views

SQL Server 2012 Always On Setup with two nodes

I have AlwaysOn setup with two data nodes and one witness. I faced an issue where my PRIMARY Server restarted abruptly. Here're some issues I faced during this timeframe. Due to abrupt restart of ...
5
votes
2answers
152 views

MySQL InnoDB over a Raw Device in an Active/Passive topology

We have an Active/Passive topology where there are two x86 complexes with a shared raw storage, where only one of the nodes in a given moment has an access to the shared storage (AKA the active node). ...
2
votes
1answer
391 views

How do I configure AWS Aurora to separate write/read operations

I want to migrate my database instance from AWS RDS MySQL to Aurora, but I have a doubt about replication and how Aurora management the write/read operations. I have my application and I want to ...
2
votes
1answer
73 views

SQL Server (2014) Failover Cluster Performance with many databases

We are considering implementing SQL failover clustering and I have a question about how SQL Failover clustering works with regards to performance. Specifically, we would have about 1000 dbs mounted ...
3
votes
1answer
60 views

SQL Server - Company wants HA for single instance with 1 userDB - sanity check and questions

I am new to SQL Server (2 months) and learning at a gov company (europe). The job is to make a HA solution for this 1 productive instance (1 database). Following is given SQL Server 2012 Windows ...
1
vote
0answers
37 views

Queries running slower on production (failover cluster) than on homologation env [duplicate]

I have a Windows Server 2012 cluster with two nodes running SQL Server 2012 for production and a Windows 2012 single server with SQL Server 2012 for homologation. I just restored the production ...
0
votes
0answers
19 views

Create db2 alert for automatic failover

We have two servers in automated failover HADR (TSA installed and haicu configured). How can we create an alert that fires when a failover happens i.e. when the primary server goes down and the ...
3
votes
1answer
53 views

SQL Server 2014 Availability Group failed

I have 3 servers on VMware workstation: Win 2012 R2 as ADDC -Cluster service. Win 2012 R2 as SQL server primary replica . Win 2012 R2 as SQL server secondary replica (auto fail-over). My ...
1
vote
0answers
138 views

Redis Cluster monitoring

In some limited testing with Redis Cluster I've identified the following conditions where a failed master would be unable to failover: The obvious, all the slaves have failed All of a master's slaves ...
1
vote
1answer
56 views

Manual sql failover machine with replication

I hope this is the correct place to ask this question. We recently experienced one of our virtual machines being offline for 3 days due to issues in the data center hosting it. This quickly brought us ...
3
votes
0answers
50 views

PostgreSQL Streaming Replication Tools - Windows

Is there any clusterware available for PostgreSQL clusters running on Windows OS? I'm specifically interested in automatic failover and STONITH functionality. I've done a fairly extensive Google ...
1
vote
0answers
57 views

Mirroring DB failover, and found Schema different

I set two database mirroring with Safety OFF. Once I do failover to mirroring DB, I found there are some Stored Procedure Schema different. Does anyone have same problem before ? What is the root ...
1
vote
0answers
29 views

Test Failover SQL Server 2012 [closed]

I have created simple FAILOVER cluster in SQL Server 2014 on Windows Server 2012 R2. This is my development lab and never worked on have a fail over cluster with SAN. As this is my development lab ...
1
vote
2answers
140 views

Error creating database on new storage in SQL Server 2008 R2 Failover Cluster

Via the Failover Cluster Manager, I recently added a new disk to an existing SQL Server 2008 R2 Cluster, running on Windows Server 2012 R2. When attempting to create a database on this new storage, I ...
7
votes
1answer
53 views

Failover timeout problem

I'm looking for an additional bit of help with regard to some problems I'm looking at for one of my company's clients. Basically I have two related problems with regard to a 2-node active/active ...
1
vote
0answers
33 views

Quorum disk conundrum

I'm working on a problem for one of my company's clients where they are having a problem with their 2-node active-active cluster and which has been failing over lately but not bringing resources back ...
0
votes
0answers
48 views

VIP to VIP Failover

I have a VIP named sqlserver01 under it are physical servers nodes: node01 and node03 I have another VIP named sqlserver02 under it are nodes: node02 and node04 Is there a possible way that I can ...
3
votes
1answer
766 views

Postgres 9.4, replication slots, doesn't work failover master

I've installed postgres master and slave nodes by this manual: At the master (10.0.0.1): sudo -u postgres initdb -D /data/postgres/main Change postgresql.conf: listen_addresses = '*' wal_level = ...
1
vote
1answer
85 views

SQL Server Failover Cluster Instance compatible with VMware HA?

Imaginary Setup: Microsoft SQL Server Failover Cluster Instance on virtual machine in an ESX-Cluster. Question: In case of a hardware failure, what will happen with both high availability ...
0
votes
1answer
137 views

SQL Server Mirroring (with Witness) and Client Timeouts

Can you explain what happens in this situation. Imagine I have a Sql Server Mirroring set-up with 2 databases and 1 witness. Database clients have in their ConnectionStrings the Principal= and ...
0
votes
1answer
120 views

Restart the active node services without failover [closed]

On a 2 node cluster configuration, How to restart the SQL services on the Active node without failing over on to another node?
0
votes
0answers
93 views

Converting MySQL master-master replication to master-standby

I set up two mysql servers in a master-master configuration. This was working fine until recently when I encountered a duplicate-key problem. After doing some research and evaluating my needs, I ...
3
votes
0answers
495 views

Postgres Streaming Replication: How to re-sync data in master (with standby) after failover

I am absolutely new to postgres 9.1 replication mechanisms. I have managed to set up streaming replication between a master and standby postgres (Both have x number of records). At one point when ...
0
votes
1answer
37 views

Failover Cluster Instance work without quorum

I have a environment with three nodes with installed SQL Server on them. All three nodes are parts of FCI and quorum setting is Node Majority. In start, first node is role owner, and all three nodes ...
1
vote
0answers
51 views

MySQL ODBC Mirror/Failover

I am wondering if it is possible with the Windows MySQL ODBC driver to mirror the data writing on a local (Access) database or, at least, to write on the local database if the writing on the remote ...
0
votes
0answers
77 views

Filestream on a SQL Cluster during failover sits at 'Pending Recovery'

We have an application using FILESTREAM storage which is also hosted on a SQL cluster. Unfortunately, when we fail the SQL cluster over between say, node 1 and node 2, it works on one node, but when ...
0
votes
2answers
45 views

High Availability using SQL Server 2012 requires how many licenses [closed]

For on premise solution, is it possible to implement high availability for SQL Server 2012 using a single license, or, one needs to buy extra licenses? Also, for high availability with SQL Server, ...
1
vote
1answer
144 views

Replication throw an error after failover mirror partner is down in SQL Server

Received an error mentioned below after failover when mirror partner is down. Error : to fail over to a database which is not configured for database mirroring. code: 22037, text: 'Invalid ...
1
vote
1answer
55 views

MongoDB failover reasons

I have a replica set on MongoDB with 3 members - primary, secondary and arbiter. One day I came and saw that primary and secondary have switched. I'd like to find a reason for the failover that caused ...
2
votes
1answer
76 views

Agent service account shows as not clustered

One of the SQL Server 2008 R2 instances I administer is running on a two node Windows Cluster (Windows Server 2008 R2 Enterprise) When I run the DMV sys.dm_server_services, SQL Server Service Account ...
0
votes
0answers
203 views

ComputerNamePhysicalNetBIOS and “Current Host Server” shows different machines

I have a SQL Server 2008 R2 instance on a two node (say names X and Y) windows server cluster (Windows Server 2008 R2 Enterprise). Server Manager on both nodes shows 'X' as the 'Current Host ...
1
vote
2answers
380 views

Best DR strategy for MS SQL Failover Cluster [closed]

I have... 2 database servers 1 shared SAN storage 2 MSSQL 2012R2 (Standard) server instances (2 SQL Failover Cluster) Server A is the primary node for SQL Instance A Server B is the primary node for ...
1
vote
0answers
56 views

Can I revert to local logging in IIS 7.5 if ODBC fails? [closed]

Environment I have 3 Servers running instances of IIS 7.5 hosting different websites. 1 Server is on Domain A, 2 Servers are on Domain B. I have a one way trust setup from Domain A to Domain B. SQL ...
1
vote
1answer
187 views

Error while duplicating Oracle database after failover, using 11.2.0.4

I've recently updated oracle from version 11.2.0.1 to 11.2.0.4 and my redundant system is no longer able to recover from failover. I'm using scripts both on primary and standby node to get back to a ...
0
votes
1answer
170 views

Postgresql - Streaming replication - STONITH

Current situation: PostgreSQL, streaming replication Master failed, I created the trigger file. Slave is promoted to new master After the old master restarted successfully, I have to create base ...