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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
32 views

SQL server 2019 alwayson problem

I've SQL server 2019 STD always on set up with 2 nodes and file share witness (located on third server). yesterday we had an network issue that the main switch was down for 15 minutes. after the ...
Avi's user avatar
  • 71
0 votes
0 answers
59 views

Microsoft SQL Always On failover cluster goes offline when adding a new node

I'm in a process of migrating my windows servers which contains SQL from windows 2012 to windows 2016. At the moment my Always On failover cluster contains 3 2012 servers and i want to replace 2 of ...
Yishai's user avatar
  • 1
1 vote
1 answer
47 views

SQL availability group failover latency experienced is 35 seconds, which is 10 seconds higher than older SQL Mirror failover

Encountered problem: Our use-case has 3 x Server 2022 in a topology of a domain controller with two node cluster. This is a SQL Always On AG architecture. The cluster hosts the SQL availability ...
AllYourBaseAreBelongToUs's user avatar
0 votes
1 answer
42 views

What is recommended response to resource failure for cloud witness in FCI?

I'm looking at an FCI on an Azure VM. This is a test setup. In the failover cluster manager when I right click on cloud witness resource and click on properties, then click on policies, under Response ...
variable's user avatar
  • 3,593
0 votes
0 answers
23 views

What to pay attention when installing SSIS in a cluster?

I'm improving my previous questions with more info here. we have a 2 node cluster environment and one of them died. we created a new node to replace it and added to the cluster ( no sql or ssis yet )....
Racer SQL's user avatar
  • 7,376
-1 votes
1 answer
56 views

When patching SQL FCI, how to ensure there will not be a failover to the node being patched?

This is about patching a 2 node SQL FCI. Say node1 is the current active node. When I am patching the node2, how do I ensure that there won't be a automatic failover to node2 even if node1 crashes ...
variable's user avatar
  • 3,593
0 votes
0 answers
95 views

SQL Connection Timeout Expired

We have a strange issue with our SQL server. We have two SQL nodes (node 1 and node 2) configured in Microsoft Cluster. It's important to note that the issue is only with one of the nodes. When the ...
Dimitar Stoykov's user avatar
0 votes
0 answers
16 views

Does MariaDB-Galera cluster have error tolerance function on sst_user credential?

We have done the testing and confirmed the following system behavior of MariaDB-Galera clustering: The first-time bootstrap always needs to get everything correct, including the sst_user credentials ...
Mike's user avatar
  • 13
0 votes
0 answers
21 views

Repmgr installation and primary register

When I run /usr/pgsql-13/bin/repmgr -f /var/lib/pgsql/repmgr.conf primary register I get an error: NOTICE: attempting to install extension "repmgr" ERROR: unable to create "repmgr" ...
Minja 's user avatar
0 votes
2 answers
28 views

setting up WSFC for AlwaysOn with one node acting as read replica for both instnaces ( AWS EC2)

I am trying to setup WSFC so that I can configure AlwaysOn. I have 3 nodes(A,B,C) and each has one instance (1, 2 and 3). I am trying to setup WSFC between A and C and another WSFC between B and C ...
SqlDBA's user avatar
  • 117
0 votes
0 answers
13 views

Getting this exception in MongoDB Failed to completely discover replica set appdbRS

There is a problem with the address: address=om-3- proud-toad.mdbtraining.net: there is no space after '3-' CAN ANYONE TELL WHERE CAN I CHANGE THE ADDRESS? 2024-01-05T13:13:58.938+0000 [DiagnosticsSvc-...
datascinalyst's user avatar
0 votes
1 answer
95 views

Oracle RAC 19c instance fails to start with ORA-29707: inconsistent value 1 for initialization parameter 1146 with other instances

After having to restart a node in a RAC cluster, we ran into "ORA-29707: inconsistent value 1 for initialization parameter 1146 with other instances" when trying to use srvctl start instance ...
jmichaelwDBA's user avatar
1 vote
0 answers
49 views

Always-On listener not working correctly

I have an Always-On architecture with two nodes and two AG. One of AG working correctly but other AG's listener only directs to the primary node. When I fail it to the secondary node, the application ...
mbielsa's user avatar
  • 56
0 votes
0 answers
22 views

MaySQL InnoDB cluster log fill on one server

in my mysqld.cnf file, I enabled logging via the following general_log = 1 general_log_file = /var/log/mysql/mysql.log It is a three-node cluster. I can see all the queries in the log ...
orddie's user avatar
  • 1
0 votes
0 answers
49 views

Replication between two galera clusters

I currently have two 3 node mariadb (10.5.9) Galera clusters set up in different locations, I'm using standard replication to copy data between the primary and secondary. What I've recently noticed is ...
imbrian21's user avatar
0 votes
1 answer
68 views

Joining SQL 2016 to a one-node cluster that has SQL 2014 installed

I have currently 1-node (it's a lab) Windows 2012R2 cluster with SQL server 2014 installed (patched to the last patch based on sqlserverupdates.com). The goal is to upgrade the cluster to something ...
Sranda's user avatar
  • 360
-2 votes
2 answers
76 views

What port is each instance using in a cluster?

I have two nodes in a Failover Cluster. There are three SQL roles / instances installed. I can connect to any instance with SSMS from a different computer by using RoleServer\InstanceName. One of the ...
RemonsterGrrr's user avatar
0 votes
2 answers
429 views

Adding a Windows Server 2016 computer to a Windows Server 2022 Failover cluster

Is it possible to join a Windows Server 2016 computer to an existing Windows Server 2022 2-node Failover cluster? The cluster is domain-independent. Hypothetical setup: Node 1 (windows server 2022 + ...
Marcus's user avatar
  • 59
0 votes
2 answers
88 views

Where to store DB files for SQL Failover Cluster Instance on Hyper-V

I am upgrading old off-lease hardware to brand new / full warranty enterprise-class host servers and 10gb iSCSI SAN. In the old environment, it was made up of a bunch of old Dell servers with lots of ...
Lando_'s user avatar
  • 3
0 votes
0 answers
167 views

WSFC - Unable to set node weight in Failover cluster

I have a two node Windows failover cluster configured with Always on availability groups which are configured for disaster recovery not for high availability. In this windows failover cluster we are ...
info.sqldba's user avatar
0 votes
1 answer
338 views

Configuring a Failover Cluster Fileshare Witness?

I'm relatively new to high availability groups in SQL Server, and am hoping for a bit of advice on best practices for configuration. I didn't set up this configuration, I inherited it and am trying to ...
fuandon's user avatar
  • 101
0 votes
2 answers
469 views

How to get a list of all postgres clusters built with initdb?

I understand that, to get a list of clusters with pg_lscluster I need to use tools like pg_createcluster. But, I use initdb and pg_ctl to create clusters. I know they are running because I can access ...
Vinn's user avatar
  • 103
0 votes
0 answers
8 views

Moving Primary AG Replia to new location

DBA by accident here so apologies if I'm a little vague!! My current workplace use a three node SQL 2016 cluster, not virtual. One of the nodes is a primary replica and requires moving to a new data ...
Darren's user avatar
  • 1
0 votes
0 answers
197 views

Removing/disabling a single SQL instance on a failover cluster?

I need to retire a single SQL instance on a (classic) failover cluster while leaving other SQL instances running. SQL version is 2012 in case that matters, but this could come up for other versions in ...
BradC's user avatar
  • 9,954
0 votes
1 answer
18 views

On which node must the failover manager for the AG be?

I have an availability group for Windows SQL Server. It is so that instances hosting replicas must be in a Windows failover cluster. However, if the node where the failover manager is on fails, what ...
Hector234's user avatar
0 votes
0 answers
107 views

SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)

We're running SQL Server 2017 Enterprise Edition on a pair of EC2 instances (we'll call them "P1" and "P3" here) in AWS. Each EC2 instance is in its own subnet, and runs two ...
Skip Daly's user avatar
1 vote
0 answers
42 views

MongoDB RBAC limitations

I'm researching if MongoDB is the solution for my problem of storing schema-less data for multiple users. Let me sketch the problem: I've got a lot of users (100k) and want to have some place for ...
Ron Nabuurs's user avatar
0 votes
1 answer
345 views

AlwaysOn failures and failovers

This is the setup: Firstly, it's in Azure 3 SQL Servers: SQL Server 2019 RTM CU18. AlwaysOn configured between these 3 servers. Server 1 & 2 in one region (Synchronous + Manual Failover Mode) ...
Sicilian-Najdorf's user avatar
0 votes
1 answer
168 views

Installing failover cluster after SQL installation

Will there be any issue if WSFC is installed after SQL is already installed for the purpose of configuring Always ON? SQL Server version 2017 Enterprise Windows version 2019 standard
mk SQL's user avatar
  • 5
0 votes
0 answers
126 views

Easiest way to migrate Availability Group databases from one cluster to another?

Consider this scenario: OLDCLUSTER (WSFC, all nodes SQL Server 2016 SP2) OLDSQL01 AG primary node OLDSQL02 AG secondary node OLDSQL03 AG secondary node (for DR) NEWCLUSTER (WSFC, all nodes SQL ...
Saverio Parlato's user avatar
0 votes
1 answer
60 views

Can a domain-independent SQL Server Failover Cluster Instance be created

I know that Always on Availability Groups can be set up on a windows server failover cluster without active directory integration. But can a SQL Server Failover Cluster Instance high availability ...
Marcus's user avatar
  • 59
0 votes
1 answer
38 views

Is putting a column as first in clustered primary key the same as giving its own clustered index?

Perfomance-wise, is it the same to query a table on a non-unique GUID in these two cases? Case 1: Primary key on multiple columns while the significant column is the first item in the primary key ...
Bishoy's user avatar
  • 103
0 votes
0 answers
12 views

I had created CassandraCluster on 3 nodes 1 node the bin/nodetool status and bin/cqlsh is working fine and other 2 nodes I got the errors listed below

nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connection refused (Connection refused)'. Connection error: ('Unable to connect to any servers', {'127.0.0.1:9042': ...
Prasad's user avatar
  • 31
0 votes
1 answer
32 views

Can I fail back from Node2 to Node1 when my SQL Server database is in recovery?

I recently failed over my SQL Server instance from Node1 to Node2 and noticed below informational message: Recovery of database 'huge_database' (22) is 24% complete (approximately 399 seconds remain)....
Fajela Tajkiya's user avatar
0 votes
0 answers
34 views

AGs with async commit or Zerto for DR to a secondary data center?

We have several two node AGs configured across two data centers for DR. They're all async commit due to the lag, and the company is ok with minimal data loss. We're considering replacing the AGs ...
Bobogator's user avatar
1 vote
2 answers
356 views

Failover time after SQL Server patch

We have two node Windows Server cluster with installed SQL Server (2019 Standard Edition) Clustered instances on each node There are 500 active databases There are no any Availability Groups or any ...
Elvin Ahmadov's user avatar
0 votes
1 answer
1k views

How to get the SQL Server version/ patch level from passive node?

I needed to get the SQL Server version/ patch level from 2 node cluster's (active/ passive) passive node. And didn't find any information about that.
Elvin Ahmadov's user avatar
0 votes
0 answers
46 views

Kerberos Authentication and SQL Clusters

We are planning on building several SQL clusters. I want to create an alias and have the alias point to the cluster name. The purpose is so that in the future when we have to migrate application to ...
Cycling DBA 's user avatar
3 votes
1 answer
266 views

Keep smaller databases out of an availability group (and recover via backup) to avoid cluster/AG issues taking the db offline?

We have several availability groups and each one has a mix of large databases and small databases, all critical. They're all asynchronous commit because their secondaries are in a different data ...
Bobogator's user avatar
1 vote
1 answer
139 views

Always On Cluster, Network Problem, make failover or disconnections for nodes

have a nice day, I have a cluster sharing the same quorum resource, this quorum is a server with 2 share folders, one for SQL Always on Cluster, and other for SAP Always On Cluster, I have lot´s of ...
Mantraxyz's user avatar
1 vote
1 answer
65 views

Maintenance on machines that have a SQL Server cluster, both nodes need to be down

There is going to be an update on the virtualization farm from VMWare 6.7 to VMWare 7. I have a SQL Server cluster in that farm, both machines need to be down to perform the upgrade. What is the best ...
Andres Arango's user avatar
2 votes
1 answer
202 views

Can I join multiple nodes to a SQL Server failover cluster simultaneously?

I'm in the process of setting up a three-node SQL Server FCI. I have already created a WSFC and set up a SQL Server failover cluster on node1. Now, I need to add node2 and node3 to the failover ...
Fajela Tajkiya's user avatar
1 vote
1 answer
434 views

Multi-Subnet AlwaysOn Cluster issue - Unable to add 3rd node

We are trying to build a multi-subnet cluster. VM1 - 172.16.0.11 and 172.16.0.12 VM2 - 172.16.0.22 and 172.16.0.23 VM3 - 192.168.0.111 and 192.168.0.112 Windows Failover Cluster - WINCLUSTER - 172.16....
Kris's user avatar
  • 422
-1 votes
1 answer
75 views

Changing NICs from 1Gb to 10Gb in an availability group

We have a two-node Always On Availability Group set up. Both nodes are on SQL Server 2016 SP3. Primary server has two 1Gb NICs. Secondary has two 10Gb NICs. Both primary and secondary have a default ...
Kris's user avatar
  • 422
0 votes
1 answer
44 views

Does dynamic quorum/witness re-adjust the quorum majority figure?

Example: Quorum majority should be floor((5/2)+1) = 3. Meaning 3 must be active for cluster to be remain active. My question is - does dynamic quorum/witness ever result in readjustment of the above ...
variable's user avatar
  • 3,593
-3 votes
2 answers
883 views

Restarting SQL service on primary causes failover of AG to secondary even when the setting says that it must try a reboot prior to failover

In WSFC resource properties there is a config to attempt a restart prior to failover. For testing purpose, on primary node (Node1) I restarted the sql service (from sql configuration manager), and the ...
variable's user avatar
  • 3,593
-1 votes
1 answer
66 views

How does dynamic witness significantly reduce the risk that the cluster will go down because of witness failure?

From the documentation Understanding cluster and pool quorum - Dynamic witness: Dynamic witness significantly reduces the risk that the cluster will go down because of witness failure. Assuming 3 ...
variable's user avatar
  • 3,593
0 votes
1 answer
35 views

AG Replica on anther WSFC

Is it possible that an AG spans two different WSFC failover clusters, i.e. one of the nodes is part of another WSFC failover cluster. So is it possible that one of the replicas is hosted on a node ...
xhr489's user avatar
  • 805
0 votes
1 answer
185 views

Split brain scenario

We have a 4 node availability group with 3 nodes at primary site and 1 node at the DR. Suppose the Primary site entirely goes down and we have to do a forced failover at the DR. Now if there is no ...
SQL_NoExpert's user avatar
  • 1,049
0 votes
1 answer
133 views

More than 3 Subnets with WFC and Availability Groups

I have a system design where I will have a single WFC node using 2 Server 2016 boxes and a SQL Server 2019 Availability Group. I've followed instructions easily found for setting this up, such as ...
DaveJM's user avatar
  • 3

1
2 3 4 5
16