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

Difference between AlwaysOn with 'WSFC' as the Cluster Type and 'AlwaysOn Failover Clustering'?

Per what I understood: Clustering is used for HA, where you can failover automatically, and it should be fast since the DB files are in a shared disk, so it would just be “reconnecting” the disk to ...
1
vote
1answer
17 views

Move\ Assign Failover Cluster Sql to new domain

What are best practices steps when the Windows Server machine hosting SQL Server 2016 R2 and failover cluster (2 node and shared folder witness) on windows server 2016 is moved to another domain? What ...
1
vote
1answer
52 views

SQL Server restarts, unable to find the reason

One of our SQL Server instances restarts itself in a clustered environment, but it is not fail-overed. When I checked the error logs, event viewer and cluster log I'm unable to find any particular ...
4
votes
6answers
999 views

Why is there automatic failover for HA and manual failover for DR?

I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter: And it specifies: hot → automatic failover → used for high availability (HA) warm → manual failover → used ...
2
votes
2answers
23 views

Can 'clustering' and 'alwayson failover clustering' be used interchangeably?

I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter. In 'hot', when citing the examples the author writes 'Clustering'. But when each technology is explained it ...
0
votes
1answer
14 views

Can we configure local and azure servers in a WSFC for Always On Availability Group? [closed]

Can we configure a local server and an azure server as a two node cluster for Always on Availability Group? Thanks!
0
votes
1answer
22 views

Config enable sharding collection in MongoDB cluster

I'm a new in MongoDB cluster. I have a question about config enable shading collection in MongoDB: I have a cluster : Shard1: replical01/node1:27017, node2:27017 Shard2: replical02/node3:27017, ...
0
votes
1answer
21 views

Repmgr : It automatically promotes to new master but other standby stopped

I'm trying to setup postgre with repmgr and here is the rsult The scenario is, i tried to spinup 1 primary and 2 standby. then i stop the primary so the postgres-2 got promoted. Unfortunately the ...
0
votes
1answer
13 views

What is difference between Lease Timeout and HealthCheck Timeout in AlwaysON?

this question was asked twice here but still there is no satisfied answer. Could someone explain the main difference between these two timeouts?
1
vote
1answer
33 views

Database distribution in AlwaysOn

Good morning all, I have an on Always On SQL server configuration where transactional replication is configured If I open SSMS I find that the distribution database is set to AlwaysOn on then I cannot ...
0
votes
0answers
15 views

Domain Independent Cluster Error “Cluster network name resource…”

Windows Server 2019 SQL Server Standard 2019 3 Basic AG with listeners Setup: I have a domain-independent two-node cluster with a file share witness. Our nodes are not joined to a domain. I ...
0
votes
0answers
16 views

SQL AOAG QUORUM clarification

Setup: SQL AOAG(SQL ALways On Availability Group) PDC(Primary Data Center) has 2 Nodes(PDCDB01 and PDCDB02) DRC(Disaster and Recover Center) has 1 Node(DRDB01) FSW(File Share Witness) Quorum ...
7
votes
3answers
3k views

Cluster design: if I expect to insert data into several tables every week, is it a bad idea to cluster them?

I have some tables that I join that I think would be perfect for putting in a cluster. But I also expect to insert data into them every week. Not a huge amount of data- something like 5 - 20 records a ...
0
votes
1answer
26 views

MS SQL Server 2016 - Always On Node-2 Stuck In Resolving State

For testing the Always On structure; we suddenly shut down the machine on which Node-1 was running. So we wanted to see that Node-2 turns primary. However, Node-2 was stuck in resolving mode. 3 ...
0
votes
0answers
34 views

find out why table insert is slow in postgres cluster

Recently i did create a PostgresQL-HA 11, cluster using bitnami helm charts. There is 1 master and 1 replica, pg_pool and metrics. I am using NFS as file storage for the cluster and it is connected to ...
0
votes
0answers
15 views

Is it possible to convert Postgresql server to master-master cluster on the fly?

There is an Postgresql server that should never be stopped. I want to upgrade it. Is it possible to: configure new empty server, convert existing server to the first node of master-master cluster (...
0
votes
1answer
20 views

How to do failover between AG setup for FCI-FCI servers

Hope I can portrait my question well because i really get confused with AG's :) We have the setup like below- Windows cluster WKCLU01 with 4 nodes (Node1,2,3,4) and a file share witness in DC3, total ...
0
votes
1answer
40 views

MongoDB multi-datacenter deployment and shard keys

I am trying to check my understanding after reading docs and some older questions, so my question is quite loaded: In a sharded cluster, each shard should (and as of 3.6 must?) reside on its own ...
0
votes
1answer
31 views

SQL server Log Shipping

I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can ...
0
votes
1answer
56 views

How to stop all nodes on FCI SQL server?

My Setup: We have two nodes SQL setup with Active/Passive Windows Failover Cluster instance. My Goal: To stop the running SQL Server service on the active node and prevent failover from happening for ...
0
votes
0answers
25 views

Removing a Windows Server Cluster Node and Then Adding Back - Do I need to remove the Availability Group replica?

We had a secondary server bite the dust... we were remarkably able to resurrect it. Everything is great and intact... except for the windows server cluster configuration. We basically need to evict it ...
2
votes
1answer
53 views

SQL Server Assembly on Failover cluster after Framework update

We have database that relies on a CLR assembly. The assembly references other assemblies. After a Windows Framework update we need to drop and reinstall the assembly to have it work. Now the issue is ...
0
votes
0answers
18 views

SQL DR Availability Group cluster validation failure

I'm new to DBA out of necessity at work so please explain or point me in the right resources if you see anything I ask below is wrong: I'm trying to setup a test environment for Disaster Recovery ...
0
votes
1answer
28 views

Why do we still need VIP when using SCAN?

When we are using Single Client Access Name (SCAN), the clients connect to the database through the SCAN name in DNS or GNS like in the example below: stackdb = (DESCRIPTION = (ADDRESS = (...
0
votes
1answer
44 views

Increase TempDB Files, Shrink VLF's with FCI

I am planning to resize and increase the number of tempDB files and shrink the VLF's on an FCI. In this case, the tempdb files are stored on the network drive, rather than the local disk. I couldn't ...
0
votes
2answers
32 views

Multi-instance 2-node SQL Cluster - do instances need their own disks?

I currently have a single default instance of SQL2017 Standard on a 2-node cluster. Against my preference, I need to setup a second instance on the cluster (the new database requires some users to ...
0
votes
0answers
15 views

How to restart an installation of Oracle grid 19c

I would like to know how to perform an installation after trying a previous installation that gave an error. During the installation of the grid in a RAC 19c I was given an error almost finishing it ...
1
vote
1answer
11 views

Can PostgresSQL cluster have synchronus and asyncronus standbys at the same time for the same dbs?

In this question, Write concern in PostgreSQL Laurenz Albe explained how to control the set of standby servers when data is committed to PostgresSQL, and that gave birth to another question. What if I ...
0
votes
1answer
34 views

Multi-Subnet Always On with Availability Group for DR [closed]

I researched a lot of mutli-geographical DR - Disaster Recoververy solution architectures for MSSQL and most of the proposed solutions I came across recommends HA using 2 nodes Failover clustering in ...
0
votes
0answers
24 views

Why won't node-1 restart successfully on my 4-node MariaDB Galera cluster, but the others will?

I setup a 4-node Galera cluster on the following platform: CentOS 8.1.1911, with MariaDB 10.3.17 and Galera 3.26. Galera config: wsrep_cluster_address="gcomm://192.168.10.47,192.168.10.48,192.168.11....
1
vote
1answer
30 views

64 Availability groups max on SQL STD : Failure when attempting to create a new NetBIOS interface while bringing a resource online

I was patching our DB Servers this morning and encountered a really strange error when failing over some Availability Groups : In our environment, we are running a somewhat unconventional setup, but ...
2
votes
1answer
51 views

Can you create a clustered DB in Azure using Windows 2003 and SQL Server 2005?

We need to replicate an environment in Azure, running a clustered DB. The current physical environment is running on Windows 2003 and MS SQL Server 2005 R2. We know that there's no OS/DB support but ...
0
votes
0answers
11 views

Mongo DB Cluster activesessions skyrocketing

I have a forked instance of mongod running with the NUMACTL options right now. It is handling 40k - 50k updates per second without issue. I tried migrating this to a sharded cluster and started ...
0
votes
0answers
24 views

How does sql server FCI respond to failure?

Taking windows role default settings - (n-1) failovers ok within 6 hrs , where n=# of nodes, if nodes = 2, 1 failover within 6 hrs is allowed. Taking resource default settings - Within 15mins period, ...
1
vote
1answer
50 views

How not to have SQL Server to restart on the same node but failover on 1st failure in a cluster

By default SQL Server tries to restart on the same node in case of a failure, next it does failover. Personally I am good with the default behavior , but I am being asked a interesting question - is ...
0
votes
1answer
18 views

Removing AG and clustering - make nodes stand-alone

I am wanting to make a 2-node Always On cluster no longer a cluster (make them (2) stand-alone machines). I am trying to upgrade Sql and the wizard keeps getting stopped before it does it checks ...
0
votes
0answers
29 views

Sql server error message “the database is read only” in a remotely server - availability database

I have a failover cluster with a high availability sql server service, the problem is that I cannot create a table, update, delete remotely even if I already give specific permissions and i had ...
1
vote
0answers
132 views

SQL server availability group cannot access database after disabling sql service

I've completed this setup: OS: Windows server 2016 Database: SQL Server 2017 2 node availability group configured with automatic failover on both nodes. Fileshare witness configured, both nodes ...
0
votes
0answers
45 views

Preferred owner failover change in FCI

I've inherited a few Windows servers with SQL Server installed. Some of them are in failover cluster which is perfect in case of outages. However I do not have much experience with SQL Server ...
0
votes
1answer
61 views

My availability group doesn't work correctly

I recently created an "availability group" on sql server, I created my Listener, all is well the high availability group appears well in the roles of my cluster. However I encounter a small problem, ...
0
votes
1answer
2k views

Windows Cluster can't update DNS record

Setup: Windows server 2016 standard edition. SQL server 2016 standard edition. 2 nodes configured in a cluster without witness quorum. all member of the same Active Directory domain. 1 Availability ...
0
votes
0answers
31 views

Why is the Page Life Expectancy (PLE) not increasing?

We have monitored the PLE performance counter for several SQL Server 2016 instances for over a year, and have had alerts which triggered when this value persistently dropped to zero or froze. ...
0
votes
1answer
52 views

Why distributed AG is preferred to normal AG for cross datacenter failover scenario?

I have two node WSFC and currently I'm working on DR solution with availability group.I already read microsoft doc about distributed AG.So my question is what are benefits of using distributed AG ...
0
votes
2answers
25 views

CLUSTER using sequential scan followed by sorting

I'm tring to understand the meaning of the following clause from PostgreSQL 12 docs CLUSTER can re-sort the table using either an index scan on the specified index, or (if the index is a b-tree) ...
2
votes
1answer
56 views

What are the main principles of SQL Server AGs depending on WSFC?

We have WSFC with 4 nodes + a file share witness. Only nodes 1-3 have SQL server on it with Availability Groups (AGs), and node 4 is shut down gracefully. Node 1 has the primary AAG server. Now,...
0
votes
0answers
210 views

Destroy cluster windows server 2012 r2

I want know how to delete a Windows Server Failover Cluster. My case is a bit special. I encountered some problems while creating a failover cluster, and I stopped the cluster services then I did "...
0
votes
1answer
84 views

Why do I need witness in WSFC with two nodes?

I have Windows Server 2019 and SQL Server 2019 running in both nodes of my cluster. In my case everything is working fine without witness. I need Windows Server Failover Clustering (WSFC) for ...
0
votes
1answer
26 views

Weird case , how do I delete a cluster under these circumstances [closed]

I would like to know how to delete a cluster with this type of case. To explain, I created a cluster for two nodes and there was a bug so I had to stop the service on the first node. However after ...
-2
votes
1answer
51 views

Can't create availability group , big error message

hello I am setting up my "high availability group" and I have a little problem, I have this error message . maybe I have to validate my cluster first? I already tried to validate but I also receive ...
0
votes
0answers
102 views

CreatingDC not updating after Domain controller Migration

Recently we have switched our domain controller and during the migration I have noticed on the cluster manager the below error     Cluster network name resource 'Cluster Name' encountered an error ...

1
2 3 4 5
13