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
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
660 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
55 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
504 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 ...
0
votes
1answer
340 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 ...
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
818 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
80 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
235 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
345 views

SQL server standard 2016 fail over cluster Amazon AWS

I am in the process of migrating to Amazon AWS and need a SQL server high availability solution. The current licence that I have is SQL standard 2016. At this time Amazon does not support shared ...
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 ...
1
vote
1answer
437 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 ...
0
votes
1answer
544 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
555 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
721 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 ...
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
407 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 ...
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, ...
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
0answers
628 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 ...
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
1answer
178 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
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, ...
1
vote
1answer
243 views

Failover Cluster Role Properties dialog

Can someone please explain diff between different 'Priority' options viz. High, Medium, Low and No Auto Start ?
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/...
5
votes
1answer
539 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 ...
0
votes
1answer
190 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 ...
0
votes
1answer
57 views

Can't run pcs -f cluster1.xml stonith create with PostgreSQL 9.6 on CentOS 7.3

Follow this guide to do PostgreSQL Automatic Failover: https://dalibo.github.io/PAF/Quick_Start-CentOS-7.html At this step: pcs -f cluster1.xml stonith create fence_vm_srv1 fence_virsh ...
3
votes
3answers
356 views

SQL Server FCI won't start after OS Upgrade

I have a two node sql server 2008 r2 cluster that we just did an OS upgrade from windows 2008 r2 to windows 2012 r2, the OS upgrade was done in place so the SQL Server Installation stayed in tack. ...
3
votes
1answer
217 views

SQL Server 2014 EE not using all available processors

First of all let me apologize for not being clear on my requirements in my original question. I am now updating my question with my current scenario: I have few existing SQL 2014 Enterprise Edition ...
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 > ...
1
vote
1answer
248 views

SQL Server AlwaysOn FCI vs AG Doubts

I have a big confusion between Always On FCI/AG. I know that for FCI you need to have shared disks and in-case of Hardware failure or OS failure or System reboot the instance with db, logins etc will ...
1
vote
1answer
930 views

SQL Server Multi-Site HA/DR Solution

I want to deploy Multi Site SQL Server HA/DR Solution. I am not sure if I use FCI/AG. In my case whenever the wan link is down at Site1 my ISP is redirecting my wan traffic to Site2. I was thinking ...
0
votes
1answer
355 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
0answers
109 views

Could not find subkey System\CurrentControlSet\Services\MSSQLFDLauncher$INSTANCE_NAME

I am getting the following error when attempting to add a node to an existing SQL Server 2016 Clustered instance on a Windows 2012 R2 Server TITLE: SQL Server Setup failure. SQL Server Setup ...
1
vote
0answers
2k views

MultiSubnetFailover option not supported on one server?

I have a SQL Server Cluster with Availability Groups. I connect to that server from a Windows 2012 R2 server with PHP 7.0.18 and Apache using ODBC and PHP ODBC Drivers. I have two Windows 2012 R2 ...
1
vote
0answers
538 views

Could not fail over Always on AG to DR ones Prod was down - Help!

Set-up: Prod-HA-DR - SQL 2012 SP2 Prod-HA Synch, DR Asynch Databases are distributed on Prod and HA equally like Active-Active Instances. PROD-HA in Datacenter A DR - In Datacenter B Scenario: This ...
0
votes
1answer
644 views

Windows Server 2016 Active Directory-Detached Cluster - Cannot add a Client Access Point

I am setting up a Windows Server 2016 cluster detached from an active directory (so called Workgroup Cluster, i.e. nodes are not added to an active directory). I cannot add a Client Access Point to ...
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
1answer
1k views

Postgres-XL cluster

I'm trying to create a Postgres-XL cluster on 4 servers. I've followed the recipe on https://ruihaijiang.wordpress.com/2015/09/17/postgres-xl-installation-example-on-linux/ (Note: update to pgxc_ctl....
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 ...
2
votes
0answers
499 views

Cluster using docker

We are creating a new application using microservices, and for that we would like to be able to raise database instances just like we raise new instances for the application's microservices. We do not ...
2
votes
2answers
680 views

Alternative to CLUSTER without table lock

I'm facing performance degradation and increasing storage usage as a result of frequent new and updated records causing index and storage fragmentation. VACUUM doesn't help much. Unfortunetely ...
0
votes
1answer
195 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
2k views

How to Get WSFC Name Using T-SQL

I know how to get the name of the current node, but is there a simple T-SQL query to use to get the Windows Server Failover Cluster name that the clustered instance is part of? The SQL Server version ...
2
votes
1answer
180 views

SQL Cluster IP should this be the same as the WFC cluster IP?

Been building my first SQL Server cluster. One question I have: Should the SQL Cluster IP address be the same as the WFC cluster IP address? Thanks!
3
votes
1answer
349 views

Reporting services existing in SQL Cluster instance but unable to see on SSMS? [closed]

This is first time I am working on SQL Failover Cluster environment and I installed Reporting services on SQL server Failover Cluster Instance both Active Nodes(Node1 & Node2) and configured ...
2
votes
0answers
319 views

Startup Parameters missing on passive SQL Server node in cluster?

I built a failover cluster on windows 2016 for sql 2016 using SMB fileshare as shared storage. This is just for learning, not production (I'm a SharePoint guy btw) On the passive node, once installed,...