Skip to main content

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
-1 votes
0 answers
8 views

Assistance Needed: SQL Server 2019 Log Shipping for SharePoint SQL FCI Database

I hope this message finds you well. I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) ...
usamawahab khan's user avatar
0 votes
0 answers
28 views

Process to remove High availability and Break the cluster

We have a 4 node High availability group. We now will have to make the primary a standalone server and remove all the replicas and break the cluster. Before we attempt this on production below is what ...
SQL_NoExpert's user avatar
  • 1,061
-1 votes
0 answers
16 views

In a 3 node AG setup, when the third node is in a different data center, how to ensure it doesn't participate in cluster voting?

In a 3 node AG, where 2 nodes are in data center one, and 3rd node is in a data center in another region, how to ensure that the 3rd node doesn't participate in failover voting? That is - how to zero ...
variable's user avatar
  • 3,476
0 votes
0 answers
20 views

SQL server is already part of a cluster error; cannot re-add after removing offline SQL node

I'm new here but I've run out of options for my search on this issue my team is having. To give a relatively short backstory; I know almost nothing about SQL beside what I've learned from a short time ...
Anthony Schwab's user avatar
0 votes
0 answers
18 views

Unsafe_aggressive_sstable_expiration - Procedure to enable unsafe_aggressive_sstable_expiration

I am planning to enable this tag to solve an issue related to some SSTables that are fully expired and are blocking some other expired SSTables from being expired. I have looked for information on ...
Jon Corral's user avatar
-1 votes
1 answer
90 views

What is choice between node drain versus role switching in WSFC FCI patching?

I'm learning about patching OS and SQL FCI. I have a 2 node SQL FCI (active/passive). The SQL service exists on both nodes, but is running only on the active node. This is managed by the WSFC. I also ...
variable's user avatar
  • 3,476
-2 votes
0 answers
28 views

What is the meaning of distributed server in wsfc cluster manager (Azure VM FCI)?

On a SQL server FCI on Azure VM, when I open the wsfc failover cluster manager, then under cluster properties, I cannot see the IP address of the cluster. Also, when I click on the cluster, below the ...
variable's user avatar
  • 3,476
0 votes
1 answer
44 views

Does the fail back only apply when failover happens to a non preferred node?

I'm trying to understand the failback setting. Suppose I have 3 nodes in cluster (FCI): Node 1 and 2 are preferred owners. Node 1, 2 and 3 are possible owners. Failover preference will be between ...
variable's user avatar
  • 3,476
0 votes
0 answers
19 views

Galera Cluster: All Nodes Slowed Down After Update Query and Too Many Connections Error

I met a disability while using galeracluser and I have a question. It is an active-active 3-node structure and maintains replication through log_slave_updates=ON. I'm using MariaDB 10.5.13 version ...
samsamsamsmasma's user avatar
0 votes
1 answer
103 views

Will a 2-node windows server failover cluster go down if the disk witness owner crashes?

In a 2 node WSFC where Node 1 owns the disk witness, would Node 1 crashing result in the entire cluster going down (loss of quorum because only 1/3 votes remain)? Or does disk witness ownership ...
Marcus's user avatar
  • 69
0 votes
0 answers
299 views

Patroni failed to get list of machines from etcd

I am running a patroni cluster (3.4) on linux with an etcd cluster. Normally the cluster runs perfectly fine but sometimes I get some errors saying Request to etcd server failed (ReadtmeoutError, ...
mymarcelsql's user avatar
1 vote
0 answers
94 views

Configuring 3:1 Failover Cluster for SQL Developer Edition on Windows Server with AWS AMI

We are in the process of configuring a 3:1 failover cluster mechanism for SQL Developer Edition hosted on Windows Server, deployed using an AWS AMI. Our objective is to ensure that if any of the three ...
Rahul's user avatar
  • 11
-2 votes
1 answer
37 views

Alternative Connection Methods to PolarDB Cluster without Activated DMS

I've set up a high-privilege account for my PolarDB cluster and successfully whitelisted the necessary host IP addresses for access. However, the Database Management Service (DMS) isn't currently ...
user24266786's user avatar
0 votes
1 answer
35 views

Sharded Cluster - Why does my data not splitted among nodes?

I created a cluster with two shards. Or so I thought. In my design, first server has mongos_router shard1 (3 nodes) and config servers. Second server only has shard 2 nodes. After I configured shards ...
Furkan YIlmaZ's user avatar
0 votes
1 answer
50 views

How to handle primary site cluster if there is a network issue due to which I invoke a forced failover to DR site?

Assuming I have AG in a 4 node cluster, with 2 nodes on primary site and 2 nodes on DR site, 1 cloud witness. Failover mode is manual. Now for some reason, suppose primary site network goes down, ...
variable's user avatar
  • 3,476
0 votes
1 answer
39 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
348 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
98 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
82 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,476
0 votes
1 answer
163 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. I'm referring to both OS patching and SQL patching. Say node1 is the current active node. When I execute the KB patch on node2, how do I ensure that there won'...
variable's user avatar
  • 3,476
0 votes
0 answers
105 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
19 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
70 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
60 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
14 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
235 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
54 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
  • 66
0 votes
0 answers
40 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
94 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
102 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
144 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
827 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
  • 69
0 votes
2 answers
133 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
261 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
698 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
1k 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
286 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
  • 10k
0 votes
1 answer
20 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
1 answer
149 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
45 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
556 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
204 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
1 answer
85 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
  • 69
0 votes
1 answer
45 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
1 answer
36 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
1 vote
2 answers
533 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
3 votes
1 answer
269 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
185 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
2 3 4 5
16