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
2
votes
3answers
2k 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
182 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
413 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
614 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 ...
2
votes
1answer
617 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
592 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
968 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
123 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
1k 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
910 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
99 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
566 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
708 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
57 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
364 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
516 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
204 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
854 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
86 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
238 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
444 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
1k 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
562 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
572 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
745 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 ...
1
vote
1answer
417 views

Periodic connection failure on SQL Server 2012 AlwaysOn cluster

Since last wednesday (so a we're dealing with this for a week now) we're getting periodic connection problems on our production database cluster. (An alwayson cluster running on windows 2012, three ...
7
votes
1answer
4k views

SQL Cluster Resources Disappear After Removing Disk Resource

In the process of removing an usused disk resource from cluster, I would follow these steps: 1) remove dependencies on the disks by the SQL Server resource, 2) take the disk resource offline, 3) ...
1
vote
1answer
75 views

SQL Server 2014 FCI Add Port

Scenario: Windows Server 2012R2 & SQL Server 2014 SP2, no CUs FCI adding a non-default port and keeping the default port I made the change on both nodes via SQL Configuration Manager, however, ...
2
votes
1answer
2k views

Postgres 9.6 Physical and Logical replication

I am working with Postgres9.6 with a Master/Slave cluster replication using Streaming replication (physical). I would like to add a new Slave server database but this database with logical ...
0
votes
0answers
650 views

Primary Server is “Resolving state” & Quorum node is in “failed” state

I would like to say that in my environment I have a 2 node in WSFC with the nodes SQLServer-01 (Primary Server) SQLServer-02 (Secondary Server) And for third vote in cluster also One (File share ...
47
votes
4answers
33k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
1
vote
2answers
1k views

Postgresql Replication - Pacemaker vs DRBD

I need to setup a Highly available Postgresql Cluster. So I found Pacemaker and DRBD with pgpool load balancer are the best options. So the architecture will look like this. As of my knowledge, ...
2
votes
1answer
432 views

WSFC File Share Witness

I've got a multi-site 2008 R2 WSFC with a file share witness. I noticed that the possible owners for the FSW is every node in the cluster. I thought the concept of a FSW was that no node of the ...
0
votes
0answers
54 views

Issues with SQL Quorum Configuration

I am having some of the below mentioned issues in a SQL Cluster. I just joined the company and don't know who built it. When I see the status of quorum, it seems to be online, what could be wrong? I ...
1
vote
1answer
251 views

Failover Cluster Role Properties dialog

Can someone please explain diff between different 'Priority' options viz. High, Medium, Low and No Auto Start ?
3
votes
0answers
285 views

Error: “Computer X is Joined to a cluster” when creating a new cluster

I am trying to create a New Cluster for Always On Availability Groups. On Failover Cluster Manager when I try to add the cluster nodes I get the following error: Computer X is joined to a cluster. ...
0
votes
2answers
52 views

MySQL/MariaDB: Scaling 10 millions database in cluster

This is for SaaS app (currently in MySQL-InnoDB). Each app contains about 150 tables. The database size is not big, but the number is high. For each database, InnoDB create directory in /var/lib/...
1
vote
1answer
5k views

What is the difference between Oracle clusterware and Real Application Clusters?

What is the difference between Oracle clusterware and Real Application Clusters? If we have 2 servers and want to join them into a cluster why there are two separate software products?
0
votes
1answer
192 views

SQL Server 2014 SP2 upgrade on Alwayson + FCI

I want to upgrade my SQL Server 2014 to SP2 which is involved in SQL Server FCI and Alwayson. Below is my environment details: Nodes: SERVER-A, SERVER-B, SERVER-C, SERVER-D SQL Server ...
0
votes
2answers
2k views

Stopping SQL Services on Active Node [closed]

I have an active passive SQL Cluster. When I stop the SQL services on active node from SQL Server Configuration Manager, the SQL cluster doesn't failover instead shows as Partially online. If SQL ...
1
vote
2answers
903 views

Experience with Scalearc sharding?

Does anyone have experience with Scalearc sharding and it's ability to scale ? Does Scalearc needs to have the whole data in memory or does it behave well with disk storage ? I'm thinking to big ...
2
votes
2answers
1k views

Experience using ScaleArc in test or production?

Has anyone had any experience using ScaleArc? My CTO has asked my thoughts on it, and I have seen no information out there regarding real-world experiences.