Skip to main content
Database Administrators

Questions tagged [clustering]

Ask Question

A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.

778 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
36 views

I wonder if anyone is up-to-date with the workings of Fail-over cluster in Windows Server 2025. Since each version has their changes. We are doing a test setup of 3 nodes on 1 location, 3 nodes on the ...
Smee's user avatar
  • 1
0 votes
1 answer
58 views

To have an Availability Group, I must have a Windows Server Failover Cluster. All Windows Server Failover Clusters have the ability to form exactly one quorum. This clearly means that if I have two ...
J. Mini's user avatar
  • 1,362
0 votes
1 answer
49 views

I'm confused between two words of cluster and replica in mariadb. I saw some tutorial and they explain cluster or replica. Is replica same cluster or not? If not , please explain their diffrences.
PersianGulf's user avatar
  • 115
0 votes
1 answer
48 views

I have a single physical server running Cassandra. Given that Cassandra performs poorly with fat nodes, which strategy is better: Running a single large node on the server (allocating all resources ...
Amir reza Riahi's user avatar
  • 155
0 votes
1 answer
438 views

I have just built a SQL Server 2022 Always on Availability group with 3 Nodes at HQ and 1 Node at DR. During our testing phase I have noticed every time I rebooted the primary without failing over or ...
SQL_NoExpert's user avatar
  • 1,117
0 votes
1 answer
344 views

every hour I get event like below. I tried something below. but without success. client access name : CMPDB01 Always ON name : AO Cluster name : cls01 I have multi-IP Addresses in SQL Server Always ...
Cell-o's user avatar
  • 1,106
1 vote
1 answer
176 views

We are building a multi-subnet, always-on availability group. I initially requested the below IPs. For Failover Cluster 192.168.1.129 192.168.2.129 For Listener 192.168.1.130 192.168.2.130 My network ...
SQL_NoExpert's user avatar
  • 1,117
0 votes
1 answer
266 views

This topic has already been discussed here: Understanding block sizes But I have few more things to add for my use case. Generally, most database systems use a default block size of 8 KB, though some ...
goodfella's user avatar
  • 700
1 vote
1 answer
69 views

I am very very new to cassandra. As I slowly wrap my head around it I have questions about backups. (be gentle) I was asked to build a processing machine for scientific application we use which ...
SteveM's user avatar
  • 11
0 votes
1 answer
100 views

Hi we are using PostgreSQL 16 on Ubuntu 22 LTS and have built a cluster using initdb. I'm wondering if it's possible to rebuild a standby using pg_createcluster instead to take advantage of various ...
Di Si's user avatar
  • 3
0 votes
1 answer
211 views

I am trying to simulate 2 clusters in different datacenters/different locations, using VMWare VSXi and 6 VMs: 3 are located on DC1 and other 3 on DC2. All nodes are RHEL 9. Both DCs communicate ...
scharrua's user avatar
  • 11
0 votes
0 answers
355 views

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,117
0 votes
1 answer
115 views

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
-1 votes
1 answer
386 views

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,610
0 votes
1 answer
67 views

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,610
0 votes
1 answer
590 views

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
  • 89
0 votes
0 answers
1k views

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
  • 21
1 vote
0 answers
129 views

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
48 views

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
  • 1
0 votes
1 answer
104 views

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
  • 3
0 votes
1 answer
90 views

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,610
0 votes
1 answer
66 views

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
990 views

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
469 views

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
  • 11
0 votes
1 answer
199 views

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,610
0 votes
1 answer
620 views

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,610
0 votes
0 answers
135 views

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

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
  • 171
0 votes
0 answers
34 views

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
  • 105
1 vote
1 answer
679 views

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
  • 51
1 vote
0 answers
117 views

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
88 views

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
262 views

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
  • 11
0 votes
1 answer
203 views

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
342 views

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

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
  • 89
0 votes
2 answers
287 views

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
556 views

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
  • 327
0 votes
1 answer
2k views

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
7k views

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
1 answer
31 views

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
  • 1
0 votes
1 answer
308 views

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
1 vote
0 answers
55 views

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
  • 121
0 votes
1 answer
1k views

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
  • 381
0 votes
1 answer
283 views

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
183 views

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
  • 89
0 votes
1 answer
73 views

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
68 views

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,239
1 vote
2 answers
865 views

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
  • 240
0 votes
1 answer
2k views

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
  • 240

1
2 3 4 5
…
16