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.
770
questions
0
votes
1
answer
35
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 ...
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 ...
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 ...
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 ...
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 )....
-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 ...
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 ...
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 ...
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" ...
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 ...
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-...
0
votes
1
answer
96
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
0
votes
2
answers
435
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 + ...
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 ...
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 ...
0
votes
1
answer
340
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 ...
0
votes
2
answers
474
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
0
votes
1
answer
347
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)
...
0
votes
1
answer
169
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
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 ...
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 ...
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
...
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': ...
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)....
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 ...
1
vote
2
answers
359
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 ...
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.
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 ...
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 ...
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 ...
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 ...
2
votes
1
answer
203
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 ...
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....
-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 ...
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 ...
-3
votes
2
answers
886
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 ...
-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 ...
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 ...
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 ...
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 ...