Questions tagged [failover]

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

Filter by
Sorted by
Tagged with
1 vote
0 answers
112 views

Losing records during transitioning to a failover cluster

Recently we had an outage in our primary SQL Server cluster and traffic was directed to the fail-over cluster. This process has taken a few seconds. The funny thing is that application logs show we ...
Mori's user avatar
  • 163
0 votes
1 answer
363 views

Can I seed Percona XtraDB cluster from the existing backup?

I have a running setup of Percona MySQL 5.7. I would like to try out Percona XtraDB cluster. The current data size is ~500GB. From what I've observed (seen in a couple of YouTube videos: https://www....
sameergautam's user avatar
0 votes
1 answer
1k views

Is it possible to have one Sql-Server cluster node in multiple Sql-Server clusters?

Is it possible to create FAILOVER CLUSTER A with Node01 (active) and Node02 (passive) and FAILOVER CLUSTER B with the same Node02 (passive) and Node03 (active)? I realized that SQL Server instances ...
Magier's user avatar
  • 4,757
0 votes
1 answer
81 views

AC with Oracle 12c

I'm thinking of configuring Application Continuity for my 2 node RAC (12c) database where my application is running on Weblogic server. Before I proceed with the setup of AC, I need to clarify/confirm ...
tesla747's user avatar
  • 1,876
1 vote
1 answer
158 views

SQL Network Name owned by Available Storage OwnerGroup in Server 2012 FCI

I did a simple get-clusterresource and noticed the 'owner group' is 'available storage'. Not SQL Server (instance)for the SQL Server Network Name (instance). I want to fix this ASAP but I'm having a ...
Ali Razeghi - AWS's user avatar
0 votes
1 answer
829 views

Load Balancing SSRS inside an AlwaysOn Availability Group

We have 3 nodes in an Availability Group in SQL 2014: Primary Site: Server1 (synchronous primary) Server2 (synchronous, readable secondary) DR: Server3 (async, nonreadable secondary) We use ...
Greg's user avatar
  • 3,222
0 votes
1 answer
1k views

Can an SQL Server Failover Cluster support a named instance?

If I currently have someName\instanceName on a standalone SQL Server and I want to migrate to a failover cluster, http://itknowledgeexchange.techtarget.com/sql-server/moving-a-standalone-instance-to-a-...
Chris Nelson's user avatar
5 votes
2 answers
969 views

Improve AlwaysOn failover time

I have set up an AlwaysOn with a primary and secondary replica on different subnets but I have been forced to use Registerallprovidersip set to 1. This causes the listener to only have 0 IP address ...
totalfreakingnoob's user avatar
1 vote
2 answers
1k views

High Availability Options For SQL Server

I'm looking to upgrade my single server SQL Server 2008 environment to a platform with much greater redundancy. The current system was put in 5 years ago when the company started and so was built down ...
Bob Sampson's user avatar
6 votes
1 answer
5k views

The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database

We have two SQL 2012 database servers configured in a mirror with a witness for automatic fail-over. Yesterday the primary server suffered a HDD degradation which triggered the fail-over, however ...
QFDev's user avatar
  • 789
1 vote
3 answers
27 views

Replicating a database that uses Fail Over

We are trying to setup replication for data coming in from an outside vendor. The issue that we are having is they say that because our vendor is using SQL Fail Over Clustering so they claim that the ...
logixologist's user avatar
1 vote
0 answers
544 views

Connect to a SQL Server Mirror from Oracle Database

I know we can create a database link to connect to a Microsoft SQL Server from Oracle database. But the problem which I faced with is the SQL database which I want to connect to has a mirror fail-over ...
Reza Aghaei's user avatar
1 vote
0 answers
394 views

Oracle Database Gateway for SQL Server - Connect to a SQL Server Mirroring Session

An Oracle Database server is using Oracle Database Gateway for SQL Server to define a Link Server to a Microsoft SQL Server. For the database on Microsoft SQL Server, Mirroring has been configured. So ...
Reza Aghaei's user avatar
0 votes
2 answers
1k views

AlwaysOn AG between 2 sql server failover clusters

I have 2 windows failover cluster and each of them consist of 2 nodes (virtual machines). And on each cluster has its own ms sql role which uses seperate shared discs : 1. wincluster1 (wsfcnode1 and ...
Ulvi Babashov's user avatar
0 votes
1 answer
34 views

Quorum Configuration [closed]

I have watched many sample videos in youtube.com and discovered that in this videos in windows failover cluster dashboard configuration looks like this : Quorum Configuration: Node and Disk Majority (...
Ulvi Babashov's user avatar
1 vote
0 answers
58 views

Failover stragtegy for replicant db via 3rd party

We use a Multi-tenant SaaS product hosted in the providers network. They provide us a 3 replicate db for our data, updated approximately every 30 min. We used this replicant database for our read ...
Justin Homes's user avatar
3 votes
1 answer
621 views

Is an automatic failover to the primary replica of a readonly replica in an availability group possible?

I want to set up an availability group with two nodes. One node will be the primary replica and the second one will be set up as a read-only replica. In my application I do all active stuff with a ...
Azrael's user avatar
  • 63
1 vote
1 answer
335 views

Two active + one passive node for failover clustering

I'd like to know if it is possible to have a single passive node for two SQL Servers in a failover clustering deployment. For example, both active servers A and B will use server C as their contingent ...
Stackoverflowuser's user avatar
5 votes
1 answer
6k views

Always On AG is Down when service is stopped

I have SQL Server 2014 running on Windows Server 2012 R2. There are three nodes, one is remote DataCenter. So two nodes have voting. Failover Cluster is using file share witness on remote server. If ...
Yavuz Selim's user avatar
1 vote
2 answers
514 views

Shared LUN for SQL Server Backup files

I have a SQL Server 2012 instance running on a 2 Node Failover Cluster Instance. Both nodes are VMs running Windows 2012 Server R2. The FCI has four shared LUNs: 1 for data files, 1 for log files, 1 ...
Schmallen's user avatar
  • 129
7 votes
2 answers
5k views

Does a replica set with only two machines make sense?

A lot of MongoDB tutorials, when they talk about replica sets, give examples of two machines: one originally initialized as primary, and another one originally created as secondary. As I understand ...
Arseni Mourzenko's user avatar
0 votes
1 answer
363 views

IP address of WSFC

Kindly asking you to help me to figure out how can I find virtual IP address of my Windows Server Failover Cluster. Search on the net doesn`t give any useful information. I need this IP in order to be ...
Nizami Khalilbayli's user avatar
0 votes
3 answers
140 views

Need to configure Availability Groups between three different SQL failover instance

We have total 6 Nodes and 3 failover cluster (Each with two node). Cluster1.TestAD.com(Node1,Node2) - SQL Failover Instance (SQL1) - 1 TB Shared storage Cluster2.TestAD.com(Node3,Node4) - SQL ...
adkalavadia's user avatar
0 votes
3 answers
75 views

Problem installing SQL Failover cluster

Let me first tell you my current environment in which there is one windows cluster on which there is sql cluster with two nodes, i.e, A and B in it. Of which, one A is active and B is passive. So, ...
palmon's user avatar
  • 31
0 votes
1 answer
855 views

Automatic recovery on a 3 node AlwaysOn Multisite Cluster?

We are looking to build a 3-node AlwaysOn Windows 2012 R2 failover cluster with 2 nodes in our primary datacenter for HA, and a 3rd node replica in our DR datacenter for reporting. Given this is a ...
floyd's user avatar
  • 111
3 votes
1 answer
4k views

SQL Server 2012 failover cluster node won't start cluster services

We have 2 node SQL server failover cluster setup in our environment. Node2 SQL server machine got shut down. I turned it back on and connect back to the failover cluster. It successfuly ...
Keith Rivera's user avatar
2 votes
1 answer
5k views

Failed to create, join or add replica to availability group in SQL Server 2014

I have a 2 node FCI and a standalone SQL Server installation on a non FCI node. I have been automating the configuration/installation of FCIs, AGs, and DB Replicas which has worked fine up to now in ...
Ali Razeghi - AWS's user avatar
1 vote
1 answer
297 views

SQL Server mirroring / failover alternative [closed]

I am looking at building at reliable database with Microsoft SQL Server, with mirroring and automatic failover. The SQL Server here is standard version, not enterprise one so High Availability ...
ydoow's user avatar
  • 162
5 votes
1 answer
4k views

Understanding of SQL Server active/active cluster

I have a vague understanding of SQL Server's active/active cluster. Can anyone help to confirm if my understanding is correct? As I understand, active/active cluster use two or more Windows servers. ...
Just a learner's user avatar
1 vote
1 answer
912 views

Scenario to automate the promotion of a read replica when the master db is not responding

I would like to set a scenario like the following: Set an RDS event subscription [that the MySQL is unresponsive] that will publish to an SNS topic that will trigger a Lambda function which will ...
Kostas Demiris's user avatar
2 votes
1 answer
2k views

Linked server to Availability Group Listener - is anyone successfully using one?

I edited the question hoping to check the basic stuff first. Does anyone have linked servers that successfully work with Availability Group listener? Have anyone heard of problems with linked servers?...
benik9's user avatar
  • 351
0 votes
1 answer
2k views

SQL Server 2012 on a Windows 2008 R2 cluster, would like to upgrade Windows to 2012 R2

I need someone to help validate a strategy. I have a pair of Windows 2008 R2 server in a active/passive failover cluster with SQL Server 2012 installed. I would like to upgrade the Windows OS to ...
Aaron's user avatar
  • 1
2 votes
2 answers
2k views

Slave DB promoted as Master DB when Master DB is down. New data added on the new master while old master is down

I am currently setting up a call center system (Vicidial) having a Master DB and a Slave DB. When the Master would go down, I have made a script on the SlaveDB that would execute "stop slave" on the ...
efren al anora's user avatar
4 votes
4 answers
4k views

patching SQL Server with Availability Group and Secondary Replica

Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary ...
Razvan Zoitanu's user avatar
1 vote
0 answers
612 views

Firewall Rules, IP address failover cluster

We are having issues with some applications running and connecting to a failover cluster through a firewall (not Windows firewall). In the firewall settings we configure the IP addresses from the ...
Martijn1989's user avatar
0 votes
2 answers
1k views

SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over

I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database. When I fail-over the AG, the Availability ...
Kalin's user avatar
  • 1
0 votes
1 answer
50 views

Should a Sql Server be accessible through the service's virtual network name?

In a working SQL-Server failover cluster environment I can open a SQL-Server connection using the configured service's IP address independantly of the current node it is on. I wonder if the assigned ...
Magier's user avatar
  • 4,757
2 votes
1 answer
2k views

Sql Server Cluster with multiple nodes

Does it make sense to think about a failover cluster configuration where less than 50% of all included nodes are standby? For example instead of setting up 4 two-node clusters where one is active and ...
Magier's user avatar
  • 4,757
2 votes
1 answer
2k views

Windows cluster failed over, but SQL instances didn't move

I recently inherited a SQL Cluster (2008R2) which for the most part behaves itself impeccably. The windows cluster is made up of two nodes running Active/Passive, Node1 and Node2 are dedicated ...
Molenpad's user avatar
  • 1,774
1 vote
1 answer
759 views

Manually specifying candidate masters in Maxscale

Looking over the documentation, I haven't quite been able to find if its possible to manually set the candidate master status of a server in Maxscale. The reason I am looking for this is because some ...
Bif Stone's user avatar
2 votes
1 answer
2k views

SQL Server 2012 Cluster Service pack 3 fail to failover node

Roughly a year ago, i had this problem with an 2008R2 cluster. I asked about it here, but i didn't grab enough logs in the process. And now i have the same problem on my 2012 failover cluster. So i'm ...
Trones's user avatar
  • 163
1 vote
1 answer
323 views

MaxScale not correctly recognizing new topology when we failover to a new master

So I currently have an architecture where we have one master and one slave and read/write splitting in Maxscale. When we fail the slave, Maxscale correctly recognizes it and displays the information ...
Bif Stone's user avatar
2 votes
1 answer
721 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 ...
Frankie Robertson's user avatar
2 votes
2 answers
4k 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 ...
maurice's user avatar
  • 41
0 votes
0 answers
30 views

Debian Server failover setup [duplicate]

I need to set up two servers with failover capability (Active - Passive model) sharing a common DB (Postgres)running over NAS. Could you please suggest me some workaround for the same ?
user avatar
0 votes
1 answer
231 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 ...
faulty's user avatar
  • 153
4 votes
1 answer
1k 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 ...
irom's user avatar
  • 203
6 votes
2 answers
4k 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 ...
irom's user avatar
  • 203
3 votes
1 answer
614 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 ...
Rebeccah's user avatar
  • 141
2 votes
0 answers
1k 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 ...
孔夫子's user avatar
  • 4,310

1
4
5
6 7 8