Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [clustering]

A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.

0
votes
0answers
12 views

Windows server 2008 r2 active passive cluster

I've got few errors in my cluster manager event saying that; Cluster network 'Heart Beat' is down Cluster network interface 'server1-private' for cluster node 'server1' on network 'Heart Beat' ...
0
votes
1answer
22 views

Duplicate Ips for cluster nodes causing backup issues

We have a four node cluster (SQL Server 2014 on Windows 12) and we recently setup heart beat network on the nodes following a best practices source after experiencing some cluster instability issues. ...
-2
votes
0answers
47 views

No matching network interface found for resource 'Cluster IP Address' IP address 'xx.xxx.245.140' (return code was '5035') [on hold]

In a cluster of one node at each site, the cluster is showing this warning and error as Cluster resource 'Cluster IP Address' of type 'IP Address' in clustered role 'Cluster Group' failed. ...
1
vote
1answer
39 views

Cluster IP's under Access Point for Administering the Cluster

When adding the cluster IPs under Access Point for Administering the Cluster, do we only include IPs for the public subnets, or do we also need to include an IP for the private subnet(s)? This ...
0
votes
0answers
34 views

SQL Server error 19456 when adding the listener

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error ...
0
votes
1answer
28 views

Automatic fail over in Always on availability group with 3 Node in synchronous mode and 1 Node in Asynchronous Mode

I am laying out a plan where there will be 3 Node on site with automatic fail over with synchronous mode and 1 remote replica with asynchronous mode. My question is if the primary goes down which node ...
0
votes
1answer
16 views

Difference between Client Access Name in SQL server Fail over Cluster and Always on availability group

We are migrating from SQL Server Fail over Instance to Always On Availability group. The current network name is ABC\ABCTEST where ABC is the SQL server Virtual Name and ABCTEST is the named instance ...
2
votes
0answers
22 views

Percona Xtradb Cluster not accepting options on command line

I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error: CentOS 7: systemctl start mysql --wsrep-sst-donor=srv1 ...
0
votes
0answers
14 views

Optimum partitioning strategy for cassandra

Please bear with me for slightly long problem description. I am a newbie to Cassandra world and I am trying to migrate my current product from oracle based data layer to Cassandra. In order to ...
2
votes
1answer
32 views

How can coupled databases be kept in sync with selective uni-directional syncing and with connections that can be off for days?

I am trying to create a database topology that looks like this: .------------. Bad Connection. Bad Connection. | Central DB | May go offline May go offline '-----...
0
votes
0answers
35 views

PostDock with repmgr: Auto recovery failed in master node

I use Docker service and Docker swarm to deploy the PostDock cluster This is my docker-compose.yml setup: version: "3.3" networks: postdock: external: true services: pgmaster: ...
2
votes
1answer
37 views

Quorum question for SQL Cluster (Always On)

We are looking at setting up an SQL Always On High Availability environment at our organisation. Our organisation has two datacenters of with one much smaller one but this one's being created to ...
1
vote
2answers
62 views

Cluster Configuration

I’m looking at some of the SQL servers in a (new to me) SQL estate. The servers are configured for AOAGs; there are two nodes, both are part of the WSFC. However, if I look at the SQL Server advanced ...
0
votes
1answer
43 views

Redo thread pending work

I've got a real tricky one here, there so much conflicting evidence it's difficult to write up the question! Here goes.. I've got a 2 node AOAG: node 1 is currently the secondary replica (but I ...
1
vote
1answer
40 views

Failover Cluster Owners

In Windows Server Failover Cluster Manager I can see "possible owners" under "Other Resource" and also under "Server Name". I have a 3 node AlwaysOn Availability Group with 2 servers in synchronous ...
1
vote
1answer
45 views

Disabling IPV6 on Always on availability group

In our environment we only have one network adapters for the Replicas and IPV4 is being used. By default the IPV6 is also enabled. My question is will there be any problems if I unchecked IPV6 from ...
0
votes
0answers
15 views

Configuring a MongoDB Cluster

I should configure a mongodb cluster with two nodes. Each node should have all data replicated. If one server die, the other should assume as primary. Before I configure the cluster, I'm doing a ...
0
votes
0answers
13 views

Query performance issue in Mysql

Table is completely normalized its in innodb. Size of data is more than 600 million records. Even after indexing and optimization queries are too slow. Size of records increases rapidly and it would ...
1
vote
1answer
29 views

AG of 2 replicas on 2 nodes in WSFC : is it possible to add 3rd replica to AG and NOT add 3rd machine WSFC?

Please help to to research the possibility of below: We have availability group that consists of two replicas: replica 1: SQL Server 2017 on Windows Server 2016 replica 2: SQL Server 2017 on ...
3
votes
1answer
529 views

Does clustering provide disaster recovery in MS SQL Server?

I mean can the nodes of MS SQL Server failover clustering be geographically separated and besides high availability also provide disaster recovery?
0
votes
0answers
40 views

Edition upgrade on SQL Server failover clustered instance

We did Edition upgrade on our active node for the SQL Server instance SQL01 and that was successful. I have a question/doubt --> Do I need to proceed the same on other node as well since SQL Server ...
8
votes
2answers
650 views

Can one of Windows failover cluster nodes run on Linux?

As SQL Server is available for Linux can I configure Clustering on Linux nodes? I mean mixed with Windows - some nodes are on Linux, others on Windows in the same cluster?
1
vote
1answer
37 views

Quorom Configuration for 3 Node Windows cluster

We have 2 node onsite and the 3rd node on DR and there is no disk witness. Due to maintenance I set the DR site to be primary and the other 2 nodes to be manual in asynchronous mode and after both ...
0
votes
1answer
35 views

IP address to use with FCI, Always On AG and Always On (AG) FCI

My understanding is that HA can be achieved using either of the below and my concern was which IP address should client applications use when connecting to SQL Server: Failover Clustering: For this ...
0
votes
1answer
38 views

Automatic failover (Clustering/Always On AG)

Let's says we have 2 nodes (N1, N2) clustered (say C1) on-site. And an Always On AG is configured between this cluster C1 and a new SQL server instance N3 (N3 is off-site). Now, if there is a problem ...
0
votes
0answers
36 views

Moving tempdb from shared to local drive in a failover cluster

We have an existing failover cluster that I would like to have the tempdb in local drive. I'm not sure how to proceed. My thought process is below: Create two drives on each node one for tempdb and ...
0
votes
0answers
48 views

Cleaning up the environment on old cluster after migrating to newer SQL Server cluster

We migrated many instances of SQL Server 2008/R2 on Windows 2008R2 and 2012 on Windows 2012 to newer Windows 2016 with SQL Server 2014 and 2016 versions. The old clusters were configured with either ...
0
votes
1answer
191 views

Always ON - What is the difference between the virtual cluster name and Listener

In clustering you specify DNS name/IP address of cluster that is then used by all applications. In case of failover, the same DNS name/IP address will point to the appropriate database server. In ...
-1
votes
1answer
285 views

Always On Failover Clustering vs Always On Availability Groups

I have some concerns over my understanding of SQL Server Always On. Kindly can you correct me (conceptually) where needed: Always On Clustering and Always On Availability Groups are 2 separate ...
1
vote
0answers
21 views

Java app crash after shard failover

I am using a Mongo sharded cluster with 4 shards. All shards are a 3 members replica set with a PRIMARY with priority 1, a SECONDARY with priority 0.5 and an arbiter. The Mongo config server is a 3 ...
1
vote
1answer
48 views

Multi-site SQL Server Cluster issue

We have a 12 node SQL Server FCI (6 nodes in our primary datacenter and the other 6 nodes at a DR site) which has been working well until an access control list (ACL) was applied to a network switch. ...
0
votes
2answers
67 views

Install standalone instance on cluster server with SQL Server

I've a cluster instance in 2016 SP1 version on Windows 2016 server. All work fine. I want to install a new instance in standalone mode (version 2008) on one server of this cluster. The data disk of ...
2
votes
1answer
20 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
1
vote
2answers
81 views

AG Group failover and quorum

We have a 4 node AG set up across two data centers using 4 replicas with a file share witness. Nodes 1 and 2 are in data center 1 and Nodes 3 and 4 in data center 2. Node 1 is primary and is set to ...
1
vote
1answer
54 views

Setting up Always On Availability Groups with Windows Server Failover Cluster

I'm trying to setup Availability groups for SQL Server with two nodes. I have two SQL Servers at two different locations. I ran through the failover cluster validation and everything looked good ...
0
votes
0answers
22 views

Possible to skip the virtual host in SQL Server Enterprise?

I want to set up an environment in the cloud supporting multiple tenants. I think that I have all that I need to do this, but I do need to understand the database site a bit more. I will have a web ...
0
votes
0answers
52 views

AttributeError: 'NoneType' object has no attribute 'Queue' - Cassandra Python

this is my code. It runs fine for the first time: cluster=Cluster([cluster_ip]) session=cluster.connect((keyspace)) query_result=session.execute("some_query") query_result.current_rows For the first ...
1
vote
0answers
18 views

Cassandra pool warning displaying continuously

I am using the Cassandra driver for python in Spyder. I am trying to fetch some data from Cassandra table. Here is my code: from cassandra.cluster import Cluster cluster=Cluster(['some_ip']) session=...
2
votes
1answer
21 views

Snapshot Folder Location for Replication with Clustered Instance

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...
0
votes
1answer
28 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
1
vote
1answer
33 views

How to create BAG on non-wsfc nodes (SQL Server 2016 STANDARD Edition) [closed]

Stumbled over this a few times now, while trying to figure out if a consultant is right or not in his claim. I hope you can shed light on it. Is it, or is it not possible to configure a Basic ...
2
votes
1answer
102 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
3
votes
1answer
69 views

Any Reason to have Regular Failover Clustering in Azure Cloud?

Is there a reason to have Regular SQL Failover Clustering when database is in Azure Cloud? I understand the benefits having Availability Groups in Azure Cloud for Database-Level protection. People ...
1
vote
1answer
37 views

Shouldn't Windows Server Failover Clustering already take care of SQLServer Failover Clustering?

After reading this question, Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing? If Windows Server Failover Clustering is installed, ...
1
vote
1answer
46 views

Azure Failover Clustering vs On Premise Failover Clustering

Azure AlwaysOn FCI Failover Clustering IaaS VMs seem to have a different diagram compared to On-Premise Failover Clustering. Azure has two storage for 2 Vms; Traditional On-Premise contains 1 Shared ...
1
vote
1answer
52 views

Is it a common pattern in having two AlwaysOn Availability Groups for DR and Reporting?

We have a primary OLTP server in the cloud. We intend to have Synchronous Alwayson Availability Group for Disaster Recovery, and another Availability Group AAG for Ad-hoc Query Reporting. This way ...
1
vote
1answer
50 views

Any Reason to have AlwaysOn Failover Clustering in Azure Cloud?

Is there a reason to have AlwaysOn Failover Clustering when a database is in Azure Cloud? I understand the benefits having AlwaysOn Availability Groups in Azure Cloud for Database-Level protection. ...
1
vote
1answer
21 views

Mysql cluster configuration help

I am new to mysql cluster I was reading around the web how to set it up. I came up with 2 different set up not sure which one is better fail safe vs cost efficient. Our new site have clients in USA ...
2
votes
1answer
193 views

Install new SQL Server cluster instance on existing cluster without downtime

I get this error when trying to install a new SQL Server instance on the passive node in an existing, classic cluster with shared storage, that has this configuration - Node A: active, Node B: passive....
0
votes
0answers
24 views

full backup after failover cluster stuck for 11 hours

We have 2 nodes in a cluster environment one is a physical node and the other is virtual and both servers are windows 2008R2. the client performed a manual failover at night at about 7:30 pm(to the ...