Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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

RESTORE VERIFYONLY FROM DISK is failing

We are having WSFC(Windows Server Failover Cluster) configuration for one of database server and from last few days, backup of one of the database is failing. Sometime backup itself fails whereas on ...
1
vote
1answer
52 views

I would like to understand better the difference between “sql server stand alone” and “sql server failover instance”

AS these question asks: Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing? Shouldn't Windows Server Failover Clustering already ...
0
votes
1answer
26 views

AlwaysOn database not synchronizing/recovery pending due to cluster loss quorum

I have this error in cluster event 'Cluster node 'MMPDB1NEW' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to ...
0
votes
1answer
216 views

Cannot start MySQL Cluster Management Service

Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid= on command line. This is what EventViewer is saying
2
votes
1answer
422 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
0
votes
1answer
202 views

Automatic MYSQL failover

We have a wordpress environment however this is not a wordpress question. Our scenario is that front Ends connect to a MYSQL backend (MYSQL VM1) which is replicated to a backup vm (MYSQL VM2). The ...
0
votes
1answer
318 views

HA PostgreSQL installation using patroni and pgbouncer

I'm not having a problem yet, just searching for advise I want to build installation of PostgreSQL on 3 nodes using patroni: master and 2 standbys (for failover only). There are PostgreSQL and ...
1
vote
1answer
344 views

Why configuring automatic failover for SQL availibility group feature on sql failover cluster instance not allowed

I have set up an availability group where a primary is standalone server and replica is SQL failover cluster. This setup allows me only manual failover and when ever I try to set it automatic in FCI ...
0
votes
2answers
48 views

SQL Server AlwaysOn and FailoverCluster

We have one project which has Failover Cluster with two nodes and one standalone server in AlwaysON. For example: Project 1 Node1 (ip:192.168.100.101) Node2 (ip:192.168.100.102) in Failover ...
0
votes
1answer
352 views

Log Shipping failover when Primary is not accessible

Log Shipping Failover I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible. My Steps for failover will be 1) Copy ...
2
votes
0answers
106 views

SQL Server 2016 SP2 CU9 - WFC Failover failing

I have updated my SQL Server 2016 on one of my Windows Failover Cluster nodes successfully. When I attempted to failover one of my SQL instances onto the newly patched node, SQL Server service fails ...
3
votes
0answers
38 views

Availability group/Failover cluster failing without signs of errors

So this is the second time it happens. Specs: SQL Server 2014 Enterprise Failover Cluster with 2 nodes No Quorum ( I Think ) Event Viwer has some events as follow: The information one always ...
0
votes
1answer
379 views

Postgres-XL adding GTM Proxy seems to do nothing

I've set up a Postgres-XL cluster using this recipe: GTM: hostname=host1 nodename=gtm Coordinator: hostname=host2 nodename=coord1 Datanode1: hostname=host3 nodename=datanode1 Datanode2: hostname=...
1
vote
2answers
68 views

SQL Server Always-On Availability Groups LeaseTimeout

One of my AG environments encountered the error The lease between availability group XXXXXXX and the Windows Server Failover Cluster has expired. A connectivity issue occurred between the ...
1
vote
2answers
1k views

delete WSFC 2012 cluster role/group fails

PS C:\Windows\system32> get-cluster Name ---- sql2012poc_cl1 PS C:\Windows\system32> get-clustergroup Name OwnerNode State ----...
2
votes
3answers
2k views

SQL Server Cluster: There is no SQL Server failover cluster available to join

I have set up a SQL Server 2016 Standard cluster (Cluster-SQL) on node 1 (Cluster-Node-1) which is appearing in Windows Failover Cluster manager without issue. When I attempt to add a second node (...
0
votes
1answer
12 views

Can I setup several mariadb clusters, each for a schema

I'm planning to use MariaDB Cluster, as a way to sync several databases from different peripherals (raspberry pis). The peripherals don't share data, but all data should be shared with the main ...
0
votes
1answer
500 views

Migrate from SQL Server 2016 Failover Cluster to Availability Groups

We have a 16 node SQL Server 2016 failover cluster with around 20 SQL Server instances and total number of databases around 600. Since we are upgrading our hardware to Hyper-Converged infrastructure ...
0
votes
2answers
582 views

Is MySQL Cluster just for in-memory databases?

In MySQL website I see below definition for MySQL Cluster. MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. I want to use Clustering for a ...
2
votes
1answer
58 views

Availability Group Clustering - Cluster Group Preferred Owner

We have a three node AG. Two nodes in a local data center, one in a different subnet DR site. Am I correct that the Cluster Name should have two IPs, just like the listener? Also, is there a way to ...
1
vote
1answer
4k views

SQL Server Cluster Service Online Pending Status

I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > ...
3
votes
1answer
7k views

Always On Failover Clustering vs Always On Availability Groups

I have some concerns over my understanding of SQL Server Always On. Kindly can you correct me (conceptually) where needed: Always On Clustering and Always On Availability Groups are 2 separate ...
5
votes
2answers
2k views

Failover Cluster Diagnostic Logs

I know there must be a simple answer to this question, but I cannot find it anywhere. Our SQL 2012 FCI have SQLDIAG .XEL files in their MSSQL\LOG folder. In some instances, these files are often ...
3
votes
1answer
103 views

Availability Groups automatic failover is not so automatic

Behavior when I stop SQL Server Service : The availability group fails (resolving on SECONDARY SQL SERVER and fail state on Cluster management). SQL Server does not connect with the Cluster ip (I'm ...
3
votes
3answers
201 views

Do I need “New SQL Server Failover Cluster installation” to run Availability groups with manual failover?

I'm trying to set up a test environment here to learn more and apply this on our production environment. I've created and installed the Windows Cluster with CLuster manager. Now I'm going to install ...
1
vote
2answers
981 views

SQL Server 2016 - Configuration Manager WMI Problem

Background: Windows Server 2016 Core SQL Server 2016 Enterprise (obviously 64-bit) Windows Failover Cluster SQL Failover Cluster I am attempting to connect to SQL Server Configuration Manager via my ...
5
votes
1answer
586 views

How to Achieve Concurrent Write Transactions to MySQL Group Replication in Multi-Primary Mode

I've set up a MySQL "cluster" (four CentOS 7 servers running MySQL 5.7.19) using Group Replication in multi-primary mode, but I can't get it to accept writes from more than one thread at a time. This ...
2
votes
1answer
16k views

Cluster network name resource 'Cluster Name' failed registration

I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
0
votes
0answers
14 views

Neo4j cluster - kubernetes, helm - no load to replicas

I have neo4j in kubernetes cluster deployed via official helm chart, core stateful set works fine, but when readonly replicas are deployed, there is no load to them. Anyone was already solving this ...
1
vote
1answer
33 views

remove Analysis service from a SQL 2014 cluster

Is it possible to uninstall Analysis service from a SQL 2014 cluster. I’ve seen that it cannot be done in 2008/12. I’m hoping that this maybe fixed now
4
votes
1answer
440 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
2
votes
1answer
3k views

Lease Timeout VS HealthCheck Timeout - AlwaysON

After all the reading this is what I understood. Is it correct? LeaseTimeout is a simple heartbeat between SQL Server resource DLL and the SQL Server instance. HealthCheck Timeout is related to ...
0
votes
1answer
92 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
0
votes
0answers
10 views

Cassandara ec2 Number of Nodes and autoscale for increasing 70Gb of Data

I am beginner in Cassandra, I currently have 72 GBs of Data that is growing and i will have approximately 1gbs inserted into database daily. How can i decide number of nodes in the cluster and how ...
4
votes
3answers
2k views

Cannot create login on cluster

I have a SQL Server 2008 R2 cluster on Win2008 R2. I am unable to add a login for the service account. Any other login I add to this instance works fine and I have been able to add the same ...
10
votes
2answers
21k views

What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?

What are the main differences between Mirroring and Failover Clustering? What kind of problem each one solves and in what kind of scenarios is each one recommended over the other?
0
votes
0answers
25 views

Not able to add a node into windows failover cluster

I had two node cluster but due to disk corruption one node was removed. After maintenance when second node came back we tried to add it into the cluster but getting exception. I checked the even log ...
0
votes
3answers
98 views

Need to configure Availability Groups between three different SQL failover instance

We have total 6 Nodes and 3 failover cluster (Each with two node). Cluster1.TestAD.com(Node1,Node2) - SQL Failover Instance (SQL1) - 1 TB Shared storage Cluster2.TestAD.com(Node3,Node4) - SQL ...
0
votes
2answers
57 views

Error in WSFC Role while applying SQL 2016 CU7 in Multiple SQL instance environment

Kindly advise on following error: Cluster resource 'AG1_NAME' of type 'SQL Server Availability Group' in clustered role 'AG1_NAME' failed Based on the failure policies for the resource and ...
0
votes
2answers
254 views

Need to maintain transactional consistency of the data across both servers, need to achieve these goals without manual intervention

I got this question about MS SQL Server 2012 administration, two production servers in the same data center. You need to ensure that database remains available if a catastrophic server failure or a ...
1
vote
1answer
199 views

SQL Server 2016 Cluster - mail works in alerts; sp_send_dbmail dosen't send in jobs

I upgraded from 2008 R2 to a 2016 cluster [Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)]. We have some scheduled emails that happen from the agent that are reporting success as the ...
0
votes
1answer
35 views

SQLDIAG File in the SQL log folder

There were few inconsistency issues in our database and this happened because of unsuccessful fail-over of DB server(WSFC), same was asked in this question and is resolved last night after dropping ...
1
vote
1answer
1k views

MongoDB replica has no primary

I have an existing MongoDB setup (part of a Graylog installation) where I'm attempting to configure a replica set with a primary, secondary and arbiter. I had the primary and arbiter configured ...
2
votes
1answer
63 views

SQL Server takes an hour to fail over to secondary node

I am at a new job, we have a 2008 R2 (SP1) WSFC which hosts SQL Server 2008 FCI. Each node has it's own storage, nodes are 32 core with 32 GB memory (don't ask me why it is configured this way). ...
2
votes
1answer
68 views

Checkdb issue - Consistency error on two tables at critical database

There was a network activity last night and they were upgrading server switch. Whole network was down and we as a DBA had prepared by disabling all the jobs at DB server for replication and backup ...
1
vote
0answers
24 views

When does the quarantinethreshold counter reset in WSFC cluster?

An outage that occurred on our SQL availability group this morning caused us to look into the quarantine settings on WSFC - something we never needed to configure. Now there seems to only be two ...
0
votes
1answer
187 views

MySQL Cluster - Data Node Restarting when database corrupt

I initially Have MySQL cluster with 2 Management and 2 Datanode. I added 2 Data node online and redistribute its data. So my current cluster setup is 4 Management Node + SQL and 4 Data node. There ...
0
votes
1answer
209 views

Selective synchronization between distributed clusters

What's the best practice for the following scenario: I've an embeded device with a single, lightweight database; a powerful server with a cluster; a cluster in the cloud. I'd like to synchronize the ...
1
vote
1answer
450 views

How to monitor a file share witness for accessibility

In the context of a SQL Server Availability Group, what's the best way to monitor a file share witness for accessibility? I want to make sure the witness can be accessed by the Availability Group ...
0
votes
1answer
188 views

MySQL replication with DRBD - Can we use Old master as slave after failover?

I have configured MySQL replication with DRBD, and now its working fine, Incase if something happens to my master then Slave will promote as Master. My question is after the failover(lets assume ...