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

Exception while adding node in WFC(Windows failover cluster) [on hold]

Recently one of the cluster node got rebooted(due to some disk corruption) for which we first removed from cluster and after that when we are trying to add it back into cluster we are facing exception(...
0
votes
1answer
33 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
1answer
29 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 ...
2
votes
1answer
54 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 ...
2
votes
1answer
56 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). ...
1
vote
0answers
10 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 ...
1
vote
0answers
78 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 ...
1
vote
1answer
34 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
0answers
31 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 ...
1
vote
1answer
43 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
36 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
0answers
294 views

DATABASE lacks a quorum of nodes for high availability

Just after setting up successfully alwayson - availability group, testing the failover, I get this error message: TITLE: Microsoft SQL Server Management Studio Failed to resume data movement in ...
1
vote
1answer
34 views

SQL Server AlwaysOn Availability Groups Cluster File Share Permissions

Just need to double confirm, when setting up the file share witness to act as a quorum vote in the HA cluster - does each server node within the cluster need access to that file share or is it just ...
3
votes
2answers
180 views

Evict node from SQL Server 2016 Cluster on Windows Core

I have 4 nodes cluster on Windows Core with SQL Server 2016 installed on them (4 instances, 1 instance on each node). I would like to remove 2 nodes from the cluster (2 instances aren't needed). I ...
4
votes
2answers
198 views

SQL Server Always On File Share Witness (Quorum vote) on different subnet to other nodes

I am currently having issues with some of my Availability groups where node 1 and node 2 loose connectivity between each other "A connection timeout has occurred on a previously established connection ...
1
vote
1answer
92 views

Upgrade SQL Server 2014 Failover Cluster to SQL Server 2016 Availability Group on Windows Server 2016

In our current set up we have 2 node SQL failover cluster in data center DC1 with mirroring enabled. And similarly in DC 2 a 2 node SQL failover cluster. DC1 acts as primary via DB mirroring in one ...
2
votes
1answer
73 views

Database Engine and SSISDB architecture advice

I'm seeking some architecture advice involving the database engine and Integration Services components of SQL Server 2017. We have an existing SQL Server environment which is due for an upgrade and ...
1
vote
2answers
63 views

Vertical / Horizontal Scaling Disk Size MySQL or MariaDB

I have been looking into this for a while and cannot find a suitable solution so would like to know if someone here can please help. I am trying to set up database back-end that will assist with ...
0
votes
0answers
8 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
6
votes
0answers
306 views

Alwayson AG lease timeout and healthcheck timeout

We have a physical SQL Server 2016 Enterprise SP2 with two instances and each instance contains one AG. Sometimes it happens that one AG goes to resolving (without failover), the cluster resource is ...
0
votes
1answer
162 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
104 views

An error occurred on the always on dashboard

I have a setup of Windows Server Failover Cluster and i am using SQL Server Service with one DC, One Primary Server and One Secondary Server. During Using SQL Server Management Studio, when i click ...
1
vote
0answers
37 views

Current Host Server for Availability Groups [duplicate]

We have a 4 Node multi Subnet Availability Group. When i go to the Cluster Manager I could see the Current host server is the Node 4 whereas the AG Primary node is Node 1. Will the AG go down if Node ...
1
vote
1answer
128 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
0answers
28 views

Configure Availability Group in SQL Server 2016

Can you tell me how you add the second node as the replica to the AG? I am using this feature on AWS instances, I have followed all the steps as shown in different videos, but when I try to add the ...
0
votes
1answer
45 views

Do you connect an application to the load balancer name or the cluster name?

My DBA delivered a 2 server WSCF for me to connect my sharepoint farm to. I have a load balancer name and a windows cluster name, and 2 server names. I realize I need to connect either to the ...
0
votes
1answer
53 views

Can a query whose execution plan uses parallelization use the cores of a processor on a another server that's part of the same Availability Group?

If I have two servers (server A and server B) that are part of the same Availability Group failover cluster, and a query running on server A has an execution plan that uses parallelization, is it ...
0
votes
0answers
101 views

Sync PostgreSQL with Cloud and multi Local Locations

I need help with a complex (for me) multi server setup with PostgreSQL. I have to setup a Cloud Server and 3 Local Servers for our company. Each Server will have: Linux Ubuntu 16.04 Docker ...
0
votes
1answer
40 views

Can an AlwaysOn Availability Group be used to mitigate downtime when there's replication syncing issues on the primary server?

Once in a while I'll run into syncing issues with my subscriber server in a transactional replication setup. Taking a new snapshot of the publisher causes significant downtime on my subscriber server. ...
1
vote
0answers
27 views

Enabling FileStream in existing clustered servers in SQL Server 2012

I have heard that enabling FileStream in an already existing clustered environment is tough. I'm working on a consolidation project and currently analyzing the impact it will have if we migrated DBs ...
0
votes
1answer
44 views

Availability Group Upgrade 2012 to 2016 Data Move

I'm working with a team to upgrade a four node AlwaysOn Availability Group from SQL Server 2012 to 2016. Two of the nodes are local and two are in Azure. The database holds a large amount of data (2 ...
0
votes
0answers
75 views

TDE Enabled DB Always Going Into “Recovery Pending” on Secondary Node [duplicate]

I have a Windows Failover Cluster set up with SQL 2016 Enterprise SP2. TDE was implemented on a DB, on node1 the DB is able to start without issues. However, when a failover occurs, on node2 the DB ...
0
votes
1answer
32 views

Remove Windows FCI completely

When I built the cluster I forgot to uncheck the storage. It's now giving me all sorts of errors. How can completely remove the cluster so I can rebuild it? This is a 3 node cluster and I evicted two ...
1
vote
2answers
33 views

Upgrade SQL Server 2014 AG to SQL Server 2017 AG

Is it possible to migrate SQL Server 2014 AG (Windows 2012, SQL Server 2014) to SQL Server 2017 AG (Windows 2016, SQL Server 2017) using rolling upgrade method? What I mean is Build 2 SQL Server ...
0
votes
1answer
71 views

File Share Witness with 4 Node Cluster

I am building a cluster of 4 nodes along with a file share witness. Every month due to server updates the server that holds the file share will need to be rebooted. My question is while the file ...
2
votes
2answers
44 views

Making a server with multiple instances a member of two effectively independent clusters

We're in the early stages of planning a new database environment for our ERP and CRM applications (third-party). The goal is to use Always On Availability Groups for HA, rolling patches, read-only ...
0
votes
1answer
68 views

help understanding galera consistency (certification-based replication)

Galera uses a certification-based replication to achieve strong consistency. While doing a transaction after doing a COMMIT the other nodes will certify it and if is ok it will be successfully ...
-2
votes
2answers
43 views

Does each node of SQL traditional cluster have separate master database

In SQL server traditional cluster, does each node of cluster has their our own master database? I am sure physically they don't...but logically might be?? Also as we know that the method of applying ...
2
votes
2answers
566 views

Do we really need a file share witness? [duplicate]

We have an Availability Group configured. Total number of nodes in the cluster is 3 (odd). All are in same subnet. Also we do have file share witness. Everything is working fine for now. My question ...
1
vote
2answers
102 views

SQL Server 2014 Failover cluster - Nodes on different patch levels

As part of trouble shooting a performance issue with a SQL Server cluster I found out that the nodes haven't been patched properly to the same level. It is a 2 node active / passive cluster. SQL ...
2
votes
1answer
123 views

Availability Group cluster memory issue after network issues. How to dump HADR Log Block Msg Pool?

We have a four node Availability Group, two nodes in one site, two nodes off site in another data center. I have noticed after every WAN issue where the WAN connection is flapping, and the off site ...
2
votes
1answer
359 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 ...
0
votes
1answer
24 views

Xtrabackup corrupt incremental backup

I have 3 nodes PXC 5.6 cluster. Xtrabackup 2.3.10. Centos 7.6 Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64 I am using only single Node-1 for both read and write. And I use to take backup ...
1
vote
1answer
682 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 ...
0
votes
1answer
55 views

is vertical scaling good idea for a mysql database server?

I operate a mariadb/mysql database server and i do not want to get into the problems with managing a multi-cluster database server i have access to huge CPU and RAM and STORAGE when needed so my ...
0
votes
1answer
121 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 ...
0
votes
1answer
21 views

Domain Controller on Multi Subnet Always on Availability Group

This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
0
votes
2answers
80 views

Safe backup of PXC / Galera cluster

I have 3 nodes 'master master' cluster and using PXC 5.6 But I am only using a single node for both read and write. Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
0
votes
0answers
18 views

mysql cluster with 1 master 1 node and 2 slave

My Query is I want to set up MySQL cluster with 1 Master 1 Node and 2 Slave with Auto failover. If my master is down node should assign slave as a master. Can anyone suggest me an idea to do that? As ...
0
votes
1answer
24 views

Convert MyISAM to InnoDB in PXC master master

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total MyISAM table = 120 Total MyISAM table size = 80MB I have also read few recommendations where it suggests ...