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
1answer
11 views

Can I setup several mariadb clusters, each for a schema

I'm planning to use MariaDB Cluster, as a way to sync several databases from different peripherals (raspberry pis). The peripherals don't share data, but all data should be shared with the main ...
0
votes
0answers
13 views

How to handle only failover mechanism in load balancing tools? [closed]

I am trying to implement percona XtraDB cluster. My application doesn't have much traffic, so I don't need to implement load balancing for splitting the traffic. I need to implement only failover ...
2
votes
1answer
54 views

Availability Group Clustering - Cluster Group Preferred Owner

We have a three node AG. Two nodes in a local data center, one in a different subnet DR site. Am I correct that the Cluster Name should have two IPs, just like the listener? Also, is there a way to ...
3
votes
1answer
93 views

Availability Groups automatic failover is not so automatic

Behavior when I stop SQL Server Service : The availability group fails (resolving on SECONDARY SQL SERVER and fail state on Cluster management). SQL Server does not connect with the Cluster ip (I'm ...
3
votes
3answers
172 views

Do I need “New SQL Server Failover Cluster installation” to run Availability groups with manual failover?

I'm trying to set up a test environment here to learn more and apply this on our production environment. I've created and installed the Windows Cluster with CLuster manager. Now I'm going to install ...
0
votes
0answers
12 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
27 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
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 ...
0
votes
0answers
16 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
2answers
54 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
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 ...
2
votes
1answer
62 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
60 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
18 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
143 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
66 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
59 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
59 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
44 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
621 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
65 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
270 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
391 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
101 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
91 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
81 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
12 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
461 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
247 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
131 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
38 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
274 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
67 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
133 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
46 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
31 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
49 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
96 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
35 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
38 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
83 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
76 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
83 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
52 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
739 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
147 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
137 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
563 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 ...