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

Are there any challenges with using basic AGs for multiple db in an existing FCI setup?

I'm looking to add DR capability to an existing 2 node FCI, by adding a 3rd server to be located on DR site. Since SQL edition is standard, I can make use of to use of log shipping or Basic ...
variable's user avatar
  • 3,350
0 votes
0 answers
5 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
55 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,784
0 votes
1 answer
17 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
44 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
26 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
63 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
64 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
55 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
36 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 ...
Miranda's user avatar
  • 23
0 votes
1 answer
32 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
10 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
  • 21
0 votes
1 answer
29 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
18 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
223 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
423 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
35 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
259 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
67 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
56 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
132 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
257 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
  • 402
-1 votes
1 answer
65 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
  • 402
0 votes
1 answer
40 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,350
-3 votes
2 answers
477 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,350
-1 votes
1 answer
58 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,350
0 votes
1 answer
30 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
  • 785
0 votes
1 answer
117 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,019
0 votes
1 answer
81 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
0 votes
1 answer
34 views

Distributed Availability group with witness server for quorum

I have experience in setting up availability group and have used witness server when the nodes are even to achieve quorum. One of the vendor provided a layout which will have two availability group ...
SQL_NoExpert's user avatar
  • 1,019
0 votes
1 answer
411 views

problem on replication EFM (WAL LSN not match)

I have a postgres cluster (edb) , when i check the status i have this output : Cluster Status: efm Agent Type Address Agent DB VIP ------------------------------------------------...
Hackim_ft's user avatar
0 votes
1 answer
40 views

What owner node should the quorum drive belong to

Using windows fail over clustering on a two or three node cluster. What owner node should the quorum drive be owned by? During my fail over testing, i can jump from node 1 to 2 and 2 to 1, but the ...
pithhelmet's user avatar
6 votes
1 answer
182 views

AG available from 1st node, but not 2nd node

I am in the process of configuring an Availability Group in SQL Server 2019 on Windows Server 2019. We have two Windows Servers, UT01 and UT02, configured with a single network adapter, using static ...
Hannah Vernon's user avatar
  • 69.5k
1 vote
0 answers
532 views

Unable to initialize a DB cluster and if initialized, pg_ctl does recognize active PostgreSQL services?

I am running [email protected] via wsl2 on Windows 11. I got a few issues. One - I am unable to initialize a PostgreSQL DB cluster Below are my bash configurations that I edited using sudo nano. ~/.bashrc ...
iCantFindaGoodUsername's user avatar
0 votes
0 answers
274 views

Cannot select "Windows Failover Cluster" when creating Always On High Availability Group [closed]

I have created a Windows Failover Cluster on two Windows Server 2019 with a third server acting as filshare witness. The cluster seems to work as it should and it validates OK. Both servers has SQL ...
Magnus Hansson's user avatar
0 votes
2 answers
35 views

To setup 3 2-node FCI's, what is the basis to decide whether to go for 3 2-node WSFC versus 1 6-node WSFC?

I want to setup 3 2-node FCI's To do this I can either setup 3 2-node WSFC Or 1 6-node WSFC Either ways, there will be 1 file share witness in each WSFC. What is the basis to decide between the above ...
variable's user avatar
  • 3,350
0 votes
1 answer
93 views

Is it possible to have a failover sql server with same instance name and same database name?

We have an application that is licensed on MS sql server instance name and database name. It is not possible to add a second instance/database. Is it possible to have active mirroring and let the ...
Sven Dühring's user avatar
2 votes
1 answer
278 views

Should the quorum drive always be at the same node with the SQL Server role in a SQL Server failover cluster environment?

In a SQL Server failover cluster environment, I can move the SQL Server role to node a and the quorum drive at node b. Although it's possible, is this a correct configuration? While I was Googling ...
Fajela Tajkiya's user avatar
0 votes
1 answer
34 views

Transactional integrity across replicated node

I'm taking a training course in DB Admin and this came to my mind during class: how can a database system ensure transactional integrity when it's replicated across multiple nodes. For example, let ...
Data Bae's user avatar
0 votes
1 answer
572 views

Is anyone aware of issues where uninstalling SQL 2012 Native Client has broken Failover Clustering?

We were recently asked to remove unsupported software from our servers and the list included SQL 2012 Native Client. Version 11 was installed, so we removed it from test & dev servers without any ...
Michael F's user avatar
1 vote
2 answers
194 views

what after WAL LSN value of type pg_lsn reach its limit

I am trying to determine the optimal Standby for automated failover based on the highest value of pg_last_wal_receive_lsn() of all slaves. But what if max_wal_size is reached, does pg_lsn values go to ...
Lucky Shofar's user avatar
0 votes
2 answers
77 views

Configuring Always On Availability Groups in SQL Server 2019

Please can I get some help with this - setting up Available Groups in a 2-node WSFC. Questions: 1) I have more than one AG (each with >1 availability databases) in the SQL instance Each AG belongs ...
PTL_SQL's user avatar
  • 295
-1 votes
1 answer
310 views

Help me understand how the FCI cluster quorum works when 2 nodes are remaining of a 2 node + 1 file share cluster?

Link: https://learnsqlserverhadr.com/so-you-think-your-sql-server-availability-group-is-really-highly-available/ The example given is that - there are 2 nodes and 1 file share. The author says file ...
variable's user avatar
  • 3,350
0 votes
1 answer
89 views

What is the use case difference between forced quorum and force cluster to start without quorum?

I'm learning about handling fci issues and stuck at 2 concepts to recover from cluster failure: Forced quorum Force start without quorum What is the factor to decide whether to use which of the ...
variable's user avatar
  • 3,350
0 votes
1 answer
1k views

Exception code: 0xc0000374 constant failover

I have two clusters setup for failover. However, from some time ago, I keep getting error Exception code: 0xc0000374 Then SQL SERVER failover happens. When failover happens, sometimes the secondary ...
vay's user avatar
  • 9
0 votes
2 answers
148 views

Remove MSSQL database out of FCI

I have three database nodes, node 1 & 2 are participating in HA using Failover Cluster Instance. Node 3 is acting as DR using SQL Always On Availability Group similar to the image below: I ...
Fylix's user avatar
  • 202
0 votes
1 answer
57 views

Design options: multi clusters, multi instances or multi availability groups

We have a Microsoft platform, where within it, we have two sets of databases. One set of databases for the platform services etc. and one set of databases of more custom nature with some data that is ...
regularroutine's user avatar
3 votes
0 answers
59 views

More low-level faster replication schemes for PostgreSQL?

From this question: in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?, I was reminded of my experience and disappointment with the hot-...
Gunther Schadow's user avatar
0 votes
1 answer
82 views

Dynamic Quorum behaviour with a witness

I was going through this article and trying to understand the behaviour described in the article. Summary - It is not a common scenario to see cluster nodes go offline until the last node and the FSW ...
DMDM's user avatar
  • 1,738

1
2 3 4 5
16