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
5
votes
1answer
533 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
12k 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
11 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
24 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
429 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
89 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 ...
1
vote
1answer
5k 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 ...
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
13 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
95 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
50 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
247 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
2answers
938 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 ...
1
vote
1answer
179 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
30 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
818 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
59 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
56 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
14 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
177 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
191 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
186 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
176 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 ...
1
vote
2answers
579 views

Manual failover of AAG in SQL Server 2012

Just a question regarding manual failovers. Does it matter if we use SSMS to perform the failover vs going to the Failover Cluster Manager and move the role to the secondary node? Is there a ...
0
votes
1answer
158 views

EventID 1196 | SQL Cluster & FailoverClustering

I have Pre-Staged the SQLCluster objects, since login had no Domain admin rights. Later SQL Cluster installation completed successfully.(Also tested with failover and failback).It is working fine till ...
2
votes
1answer
447 views

Why am I unable to create this Availability Group? (error 35220)

I was attempting to create an Availability Group on a SQL Server 2017 instance and was running into error 35220: Could not process the operation. Always On Availability Groups replica manager is ...
5
votes
2answers
2k views

Restart the active node services without failover

On a 2 node Windows Server Failover cluster configuration, how do I restart the SQL Server services without failing over to the other node?
0
votes
1answer
204 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
0
votes
1answer
194 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
204 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 ...
2
votes
1answer
337 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 ...
2
votes
2answers
380 views

Clustering SSAS

We are using both SQL Server 2012 and 2014 always on. Here is my issue: we have an application that I have set up to use Availability groups(2014), however the issue I am having is that it uses ...
4
votes
1answer
39k views

SQL Server Clustering - Active/Active or Active/Passive?

What is the logic of the Active/Active cluster vs Active/Passive cluster? I have searched a lot and read lots of documents but have not found the answer. In active active cluster can I have 1 ...
1
vote
1answer
304 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
3answers
699 views

SQL SERVER 2014 FCI Cluster taking too long to failover

I support a multi-instance, two node failover cluster (active-active). Both instances are running SQL 2014, on Windows Server 2008R2. The nodes each have 3/4 TB of memory and 32 cores (64 with HT). ...
1
vote
0answers
107 views

SQL alwayson manual Failover Cluster failed because a duplicate IP address detected

When I manually tried to make a failover I got the following errors: "SQL always on Cluster IP address resource listener cannot be brought online because a duplicate IP address was detected on the ...
5
votes
1answer
230 views

Powershell Missing Cluster Name for FCI

I'm running the following simple Powershell command. $Server = New-Object ('Microsoft.SqlServer.Management.Smo.Server') 'SerName' $Server | SELECT * For FCI clusters the ClusterName value is always ...
0
votes
0answers
43 views

mysql 8 innodb clustering - adding instance fails with error “Unknown database 'mysql_innodb_cluster_metadata'”

I'm setting up my first mysql innodb cluster, following the instructions here: https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html I've configured the instances ...
0
votes
1answer
321 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 ...
6
votes
3answers
1k views

SQL Server Always On Node and File Share Majority

I am looking for some guidance on architecting our SQL Server 2016 SP1 Always On Availability Groups HADR solution on Windows Server 2012 R2. We have a primary site A with a primary replica and a ...
1
vote
1answer
46 views

Automatic Failover on SQL Server Always On Availability Groups is not triggered when primary replica becomes offline

I have set up a 2-node Always On Availability Group. Both replicas are in synchronous mode with automatic failover. If I perform a manual failover, everything works as expected: Primary and Secondary ...
0
votes
1answer
340 views

GFS2 as shared storage for MySQL cluster with active active setting

I am using MySQL 5.7 on RHEL 7.1. For cluster management I am using Pacemaker and corosync. For shared storage, I am using GFS2 file system with iSCSI server I am trying to implement MySQL active-...
1
vote
1answer
49 views

Dynamic quorum and Dynamic witness in Always On AG 2016

I have a Always On AG 2016, configured on Windows Server 2012 R2 – 2 node cluster. Quorum configured as 2 nodes + Fileshare witness, totally 3 votes. Scenario 1: Now, either 1 node fails – remaining ...
0
votes
1answer
354 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=...
0
votes
1answer
278 views

Add Secondary Node to existing WSFC Cluster

I need to add new server in my existing WSFC cluster server setup. I need few details on following : 1. I have Windows Server Failover Cluster setup on 2012 R2 with SQL Server 2012, Can I have my new ...
0
votes
1answer
40 views

How to setup a SQL Cluster between 2 sites in active passive mode without shared storage

we need to install SQL at 2 sites, 1 primary and 1 DR. We don't to pay for license for the DR and need to know how will we setup a SQL cluster/replication/alwayson/bag or any other method that will ...
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 ----...