A message from our CEO about the future of Stack Overflow and Stack Exchange. Read 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
6
votes
2answers
2k views

SQL Server FCI installation with Mount Point permissions issues

Please help me get past this installation issue. I am trying to install a SQL Server 2016 (SP1 slipstreamed) Failover Cluster Instance (FCI) on two Windows Server 2012 R2 VMs. I have 3 cluster disks....
0
votes
0answers
93 views

Expanding Cluster Drive space

I will need to expand my existing cluster drive (sql cluster with 2 node active and passive) which has sys and user database data files. My san admin told he will need to delete all the existing data ...
1
vote
1answer
1k views

SST not starting on a new node on MariaDB Galera Cluster

I have two MariaDB servers I want to use to create a new MariaDB Galera Cluster: Server mysql1, with some data and configured as a donor Server mysql2, with no data and /var/lib/mysql empty, which I ...
2
votes
1answer
1k views

Unable to Force a WSFC Cluster to Start Without a Quorum

I was testing a three node AlwaysOn availability group cluster. SQL Server is on Node 1 and I powered off Node 1 and Node 3 simultaneously. The cluster lost its quorum and appear to be down. I ...
0
votes
1answer
65 views

Log Shipping back up location to a network share instead of clustered file share

Below is my current cluster set up Node 1 - Active Node 2 - Passive While doing Log SHipping can I save the back ups to a network share instead of a clustered file share? The service account ...
2
votes
1answer
924 views

Upgraded to SQL Server 2017 and now see WSFC lease timeouts

I recently upgraded a production DB environment from SQL Server 2016 Standard Edition to 2017 Enterprise Edition (CU3). We used a Basic Availability Group when on Standard Edition and recreated the AG'...
1
vote
1answer
185 views

Cluster Validation on Remote Node

I have a 3 Node always availability group: 2 Nodes are In house – Synchronous Mode. 1 Node is remote - Asynchronous Mode. Every now and then the Remote Node loses connectivity and goes offline ...
0
votes
1answer
103 views

Log Shipping with Clustered Instance- back up

Current Set up- Clustered Instance Active/Passive Node -1 Node -2 Current Back ups goes to Network Drive Cluster Drive E drive Virtual Name ABC Shared Folder - e\Share New instance- for Log ...
0
votes
2answers
686 views

SQL Failover Clustering with Availability Groups: Single or Multiple Databases

Company wants to implement AlwaysOn SQL Failover Clustering with Availability Groups, for server level and data protection. Are arrangements below, only possible if 1 database is on the server, or ...
0
votes
1answer
66 views

SQL Server Failover Cluster Scalable by adding nodes?

In the book Pro SQL Server Always On Availability Groups They write about scalability. Here is what they say Windows Server 2012 (and above), failover clustering supports up to 64 cluster nodes. ...
5
votes
2answers
5k views

AlwaysOn AG versus FCI

Throughout MS documentation for AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) I see the following pattern: FCI is for HA scenarios. An AG synchronous secondary ...
1
vote
1answer
528 views

SQL Always on availability with failover and mixed authentication

I have 2 boxes running SQL Server 2016, and set up using Always On Availability. I have a listener set up to choose which server to talk to in case of a failover, which seems to work fine, except for ...
5
votes
1answer
430 views

SQL Server mirrored backup using cluster shared volumes

I have SQL Server 2014 cluster with 2 nodes and a third server with iSCSI target server configured on it, all of them are virtual Servers with Windows Server 2012 R2. Both nodes of cluster are iSCSI ...
6
votes
3answers
5k views

Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster

SQL Server 2008 R2 multi-instance cluster (on VMware vSphere 5.1) 2 nodes, each running 2 instances (4 instances in total) 16GB RAM per node. The only time the instances are on the same node is when ...
3
votes
1answer
1k views

SQL Server 2016 SP1 CU1 Install Fails

I am trying to install CU1 for SQL Server 2016 SP1 on a clustered node and it fails with an error that I am not able to find information on. In the summary log file it has the following: Instance ...
1
vote
1answer
1k views

Users in SQL Server cluster

I have created a 2012 WFC and SQL Server 2014 is clustered on it. The cluster works as expected but have a question on Users: I added a windows domain group to the cluster as sysadmin. When the ...
2
votes
2answers
3k views

Change port number for SQL 2012 Cluster

I have been trying to change the port number of a SQL 2012 cluster with little success. I had thought that I could just do this the same way as normal through configuration manager however, even with ...
2
votes
3answers
3k views

Preparing a cluster installation fails at Setup Support Rules Step (Not Clustered or the cluster service is up and online)

Today I was trying to install a SQL Server 2008 R2 Cluster environment on Windows Server 2012 R2 servers and after doing all the necessary steps to prepare the cluster (like Creating an iSCSI Virtual ...
0
votes
1answer
218 views

I can't add an extra node to mariadb cluster 10.1

I was installing a test mariadb cluster but I have a problem when I want to add an extra node. Both nodes use Red Hat Enterprise Linux Server release 7.3 (Maipo) These were the following steps: On ...
1
vote
1answer
6k views

SQL Server Licensing & Clustering for Availability Groups

For SQL Server 2014, reading this MSDN link and Microsoft PDF file about licensing, created a couple of questions. For Availability Groups do we need WSFC or FCI? How are WSFC and FCI different? If ...
4
votes
1answer
754 views

How to determine high availability configuration is working correctly

I am in the process of setting up always on high availability clusters for the first time. Can anyone explain to me from the networking perspective after configuring the group and testing to make sure ...
5
votes
2answers
425 views

Cluster node upgrade of SQL Server 2008 R2 to SP3 fails when moving resource

I'm trying to update a cluster to SQL Server 2008 R2 SP3. I've installed SP3 on the passive node but when I failover the cluster it errors when running through it's upgrade scripts. The messages &...
2
votes
2answers
710 views

MongoDB Cluster - Can't access member of shard with credentials

I have a Sharded Cluster and I am trying to access a specific member of a replica set within a shard. When connecting to the mongos it is fine, but when using the same credentials on a member of the ...
1
vote
1answer
1k views

AlwaysOn AG: Current Host Server - Owner Node - Primary Instance

I'm building up a SQL Server AlwaysOn AG and I'm on the step "failover", manual and automatic: I noticed that in the Windows Server Failover Cluster a "Current Host Server" exists. My knowledge says ...
3
votes
1answer
746 views

File share witness vs 3rd Node for WSFC + AG with only 2 nodes?

I am migrating from Mirroring to AGs on SQL Server 2014 / Windows 2012 R2. I will have a 2 node cluster. I need this cluster to be online at all times for a production environment. I am reading ...
2
votes
2answers
651 views

In 2-node cluster using failover with Dynamic Quorum, is Witness needed?

I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum. There is one thing that made me confused: do we really need a Witness in this case? Since ...
1
vote
1answer
1k views

Use Windows 2016 Storage Replica for SQL Server failover cluster instance

We have two standalone servers with local storage. Based on our needs we have determined that we need to use AlwaysOn failover cluster instances. Can we use the "Storage Replica overview" feature of ...
0
votes
0answers
134 views

Just use WSFC without Always On Failover Cluster Instance? [duplicate]

There was some unanswered questions about the difference between "Windows Server Failover Clustering" and "Always On Failover Cluster Instance". From MS document: A Windows Server Failover ...
0
votes
0answers
2k views

Availability Group Lease Timeout: what is causing 100% CPU utilization and lease time outs on PRIMARY replica?

We have an availability group Replica-01 (Sync on-premise) PRIMARY Replica-02 (Sync on-premise) SECONDARY Replica-03 (Async Azure VM) SECONDARY Replica-01 is sometimes having lease time out and ...
0
votes
1answer
952 views

SQL Server Standard Edition Failover Cluster Installing Windows Updates

i have a question concerning the installation of sql server updates on a sql server 2012 standard edition failover cluster. For example a service pack installation. Is it possible to install the ...
1
vote
0answers
107 views

PostgreSQL partitioning vs. using multiple DBs

I'm building a DB that will have several tables partitioned into 64 partitions. Although I'm using PG 10, I'm using the inheritance method as I need greater control over each table than what is ...
1
vote
1answer
628 views

Remove a SQL Server Patch only visible in View Installed Update List

Kindly help me regarding our issue with a Clustered Environment's applied patch. The situation is: We removed a SQL Patch: GDR 6248 for SQL Server 2012 (KB3194721) (64 bit). When we successfully ...
0
votes
2answers
2k views

Always on Failback

Does always on supports automatic failback like sql cluster? Since the preferred owners and possible owners are controlled by the AG how can a particular node be set as preferred primary when failback ...
0
votes
1answer
929 views

Replication on a clustered Instance

Can I set up Replication on a clustered Instance of 2 Nodes. If yes then is it mandatory to have a 3 separate Instances for Distributor, Publisher and lastly Subscriber . If there is a fail over then ...
0
votes
1answer
67 views

Questions for 'Tips on Converting to Galera' on MariaDB KB [closed]

Some questions about the excellent writing Tips on Converting to Galera. Is "cross-colo writing" cross connect datacenters write? Also, you should use "START TRANSACTION READONLY" wherever ...
0
votes
1answer
448 views

adding node to existing availability group

Currently have a 2 node availability group, trying to add a 3rd. Added Node3 to the Windows Cluster. Node3 appears as UP in "Nodes" on the Failover Cluster Manager console. However I have the ...
0
votes
1answer
587 views

login failed for user 'domain\localMachineName$'

login failed for user 'domain\localMachineName$'. Reason: Could not find a login matching the name provided. [CLIENT: ] This appeared on my new SQL Server right after I added it to an existing ...
1
vote
1answer
1k views

SQL Server failover cluster installation fails on primary node

I'm trying to install SQL Server 2014 fail-over cluster, but the installation fails with following log i have tried a lot of things but without any success.. The installation failed with following ...
1
vote
1answer
216 views

Cannot install SQL Server on a local disk

I'm installing a new instance of SQL Server, and I got this error: instance directory (or command line option /instancedir) value for a cluster installation cannot be a directory on shared drive It ...
0
votes
1answer
1k views

SQL Clustering Preferred Owners

I noticed that in the sql failover clustering under the possible owners none of the nodes has been checked, I have a two node cluster does that mean in the event of failover it will failover to any of ...
0
votes
1answer
155 views

Sql clustering sql server account

Does both the sql cluster nodes needs to use the same service account ? In my environment I saw one one was using a service account and another was using a local account although the sql agent was ...
0
votes
1answer
270 views

Single Domain Controller for SQL Server Always On Availability Group

I was wondering if SQL Server Always On Availability Group supports a single Domain Controller server as opposed to 2 Domain Controllers in every example I've seen. I ask because I suspect that this ...
0
votes
1answer
52 views

HA and DR Solution

Based on the discussions that we had internally we initially decided to move with a SQL FCI for our non critical databases so that we would have hardware level redundancy. However, now the issue ...
1
vote
1answer
529 views

Always on Failover Cluster

This is the error message I get on my replica when there is a connection timeout for few seconds with the Primary. Can anyone tell me whats going on and why are the available storage being moved as ...
2
votes
1answer
2k views

Difference between Session Timeout and Heartbeat in always on

What is the difference between Session Timeout and Heartbeat in always on... My Network is laggy and i get frequent connection timeout error on error logs and also at the I see missed heartbeat errors ...
0
votes
1answer
636 views

Connectivity timeout between cluster nodes

I lose communication between my clusters almost 1 am to 1.30 am and it shows errors like 35206 on primary, 976 on clusters, sometimes the cluster is removed due to lost heartbeat leading to 1135 error ...
0
votes
0answers
659 views

Adding Azure VM as 3rd node to the 2-node On-Premise Windows Server Failover Cluster - Problem

We have 2-node WSFC, which is hosted on-premise in our datacenter This WSFC is running one clustered role which is SQL Server Availability Group Node-1: Windows Server 2016 - two subnets - 192.168.7....
5
votes
4answers
886 views

SSIS in Clustered Enterprise

We have a 2-node clustered SQL Server 2014, Enterprise, environment for our data warehouse. Storage, network, and servers are all high performing (1tb mem, 32 cores CPU per node, all SSD) We are ...
3
votes
1answer
4k views

Is it bad to assign specific processors to SQL Server 2008 R2 cluster instances?

I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
0
votes
2answers
1k views

Recommendations to prevent failover (scheduled)

I have a two node SQL Server failover cluster with availability group. This is used for SharePoint. SharePoint rebuilds the indexes where necessary every night. This routinely causes failover. I can't ...