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.
778 questions
0
votes
0
answers
35
views
SQL AG with Windows Server 2025 Fail-over cluster
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 ...
- 1
0
votes
1
answer
58
views
If an Availability Group contains two FCIs, how many quorums do I have?
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 ...
- 1,362
0
votes
1
answer
49
views
cluster vs replica in mariadb or mysql
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.
- 115
0
votes
1
answer
48
views
Resource allocation strategy for Cassandra on a single server
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 ...
- 155
0
votes
1
answer
435
views
Cluster Error 1069 and 1205
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 ...
- 1,117
0
votes
1
answer
344
views
Failover Cluster DNS error, event 1207 every hour The specified network password is not correct
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 ...
- 1,106
1
vote
1
answer
176
views
SQL Server Always On Availability Group on Multi-Subnet Cluster
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 ...
- 1,117
0
votes
1
answer
266
views
Is there any practice to align file system block size with database block size?
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 ...
- 700
1
vote
1
answer
69
views
Cassandra Backups questions
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 ...
- 11
0
votes
1
answer
100
views
Is it possible to add a PostgreSQL hot standby using pg_createcluster to a primary created with initdb?
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 ...
- 3
0
votes
1
answer
211
views
MariaDB Galera and Geo redundancy
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 ...
- 11
0
votes
0
answers
349
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 ...
- 1,117
0
votes
1
answer
115
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 ...
-1
votes
1
answer
386
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 ...
- 3,610
0
votes
1
answer
67
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 ...
- 3,610