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
1
vote
1answer
29 views

Mysql cluster configuration help

I am new to mysql cluster I was reading around the web how to set it up. I came up with 2 different set up not sure which one is better fail safe vs cost efficient. Our new site have clients in USA ...
2
votes
1answer
247 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
1
vote
2answers
200 views

AG Group failover and quorum

We have a 4 node AG set up across two data centers using 4 replicas with a file share witness. Nodes 1 and 2 are in data center 1 and Nodes 3 and 4 in data center 2. Node 1 is primary and is set to ...
1
vote
1answer
311 views

Setting up Always On Availability Groups with Windows Server Failover Cluster

I'm trying to setup Availability groups for SQL Server with two nodes. I have two SQL Servers at two different locations. I ran through the failover cluster validation and everything looked good ...
0
votes
1answer
75 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
1
vote
1answer
65 views

How to create BAG on non-wsfc nodes (SQL Server 2016 STANDARD Edition) [closed]

Stumbled over this a few times now, while trying to figure out if a consultant is right or not in his claim. I hope you can shed light on it. Is it, or is it not possible to configure a Basic ...
88
votes
5answers
22k views

Why can't RDBM's cluster the way NoSQL does?

One of the big plusses for nosql DBMS is that they can cluster more easily. Supposedly with NoSQL you can create hundreds of cheap machines that store different pieces of data and query it all at ...
3
votes
1answer
90 views

Any Reason to have Regular Failover Clustering in Azure Cloud?

Is there a reason to have Regular SQL Failover Clustering when database is in Azure Cloud? I understand the benefits having Availability Groups in Azure Cloud for Database-Level protection. People ...
1
vote
1answer
157 views

Shouldn't Windows Server Failover Clustering already take care of SQLServer Failover Clustering?

After reading this question, Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing? If Windows Server Failover Clustering is installed, ...
1
vote
1answer
60 views

Any Reason to have AlwaysOn Failover Clustering in Azure Cloud?

Is there a reason to have AlwaysOn Failover Clustering when a database is in Azure Cloud? I understand the benefits having AlwaysOn Availability Groups in Azure Cloud for Database-Level protection. ...
1
vote
1answer
277 views

Azure Failover Clustering vs On Premise Failover Clustering

Azure AlwaysOn FCI Failover Clustering IaaS VMs seem to have a different diagram compared to On-Premise Failover Clustering. Azure has two storage for 2 Vms; Traditional On-Premise contains 1 Shared ...
1
vote
1answer
124 views

Is it a common pattern in having two AlwaysOn Availability Groups for DR and Reporting?

We have a primary OLTP server in the cloud. We intend to have Synchronous Alwayson Availability Group for Disaster Recovery, and another Availability Group AAG for Ad-hoc Query Reporting. This way ...
2
votes
1answer
852 views

Install new SQL Server cluster instance on existing cluster without downtime

I get this error when trying to install a new SQL Server instance on the passive node in an existing, classic cluster with shared storage, that has this configuration - Node A: active, Node B: passive....
2
votes
0answers
230 views

SQL Server 2017 Failover Cluster on RHEL Linux

I am trying to create Failover Cluster on SQL Server 2017 on RHEL 7.3 Linux, following this document from Microsoft: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-shared-disk-cluster-...
0
votes
1answer
229 views

Enable GTID on one node in Percona/Galera

Im having 3 node percona cluster. (5.6) Server ID is enabled on each node but all are different IDs. Binlog and log slave updates are enabled. Now I want to enable GTID on the third node alone. I ...
4
votes
1answer
11k views

Multiple IPs registered for listener when using AlwaysOn AGs w/ multi-subnet clustering

We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...
1
vote
1answer
445 views

SQL Server 2016 SP2 CU2 Availability Group Online but Cluster Offline

Am I missing something basic here? My AVG is online and working, but the Cluster on which it resides is saying offline. I didn't think this is possible, so I either have a basic misunderstanding of ...
1
vote
0answers
145 views

Domain Independent Cluster on AWS

I am trying to work out whether it's possible to create a Domain Independent Workgroup Cluster in AWS (on Windows Server 2016 for use with SQL 2017 Availability Groups). This environment also has no ...
1
vote
0answers
693 views

VMWare Windows Failover Clustering - Cluster Node Removed

We have a 2012 Windows failover Cluster set up for SQL Server 2014 on VMWare ESXi, 6.0.0, 3620759. A couple weekends ago, our Server Admin made some updates to the the UCS Manager software, which in ...
1
vote
1answer
352 views

Uninstalling 2 instances on 1 node of a 2 node SQL Server 2012 failover cluster instance

I need some pointers to uninstalling 2 instances on SQL Server 2012 cluster We have a SQL Server 2012 Active -Active cluster with instance A on Node 1 and Instance B, Instance C and 3 services on ...
3
votes
1answer
407 views

Apply SQLServer Service Pack to a Single Node Cluster

I have to apply a SQL Server 2008 R2 Service Pack to a Single Node Cluster. The other node died and new hardware has been ordered. Is there anything weird to worry about? Normally we'd apply the ...
2
votes
1answer
988 views

MongoDB cluster setup

I am trying to set up a 3 node MongoDB cluster. 1) Started mongodb in all 3 nodes with the below config file. net: bindIp: 0.0.0.0 port: 10901 setParameter: ...
2
votes
1answer
196 views

SSRS is missing after failover to other node

We have 2 node setup cluster, after a failover I can't see the reporting services, even the service it self is missing. I checked control panel program manager, SSRS is not installed, I open ...
0
votes
4answers
510 views

Clustering MySQL with InnoDB engine

I have a MySQL single server setup with all tables using the InnoDB engine (because I need support for foreign keys). As response times are getting longer, I now believe I need to create a cluster of ...
1
vote
2answers
246 views

SQL Server 2014 Standard FCI Does Not Failover

Have a peculiar case where a previously working FCI, after installing a large backlog of Windows updates, is now failing often and not failing over. On occasion, and this appears to happen around ...
5
votes
2answers
2k views

Is it safe to run a Windows Failover Cluster Public and Heartbeat on a Single NIC?

I have a 2-Node Windows Failover Cluster (Windows Server 2016, SQL Server 2017) with a Quorum Disk Witness on fibre-connected shared storage. How important is it that the heartbeat is on its own ...
4
votes
1answer
3k views

WSREP: failed to report last committed and stop

I have galera cluster and I have 4 nodes. I'm importing some data. however one node gives error. Warning. The warning is; warning WSREP: Failed to report last committed 59102, -q (interrupted system ...
1
vote
1answer
1k 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 ...
5
votes
2answers
12k views

I cannot get SQL Server 2012 to install the database engine

SQL Server 2012 installation on a standard Windows 2008 R2 server. It refuses to install the database engine or sql replication. During the installation I got no errors saying that it wasn't ...
1
vote
1answer
33 views

Can I add 1 primary node in existing cluster?

I have a 2 node windows 2012 cluster and SQL Server 2012 installed on both. In this I have added a database on nodeA as primary and one on nodeB as secondary. I want to add more 2 databases which will ...
1
vote
0answers
528 views

clussvc.exe consuming high cpu

We have a 4 node cluster running 2 SQL Failover Instances. Windows 2012 Standard & SQL 2014 Microsoft Failover Cluster Service has been consitently between 25 - 30 % CPU. This is happening on 2 ...
4
votes
2answers
4k views

“Skipping the default startup of database” SQL notification for AlwaysOn Cluster

So I set up our SQL servers to notify us of alerts at severity 17 or higher (as advised by various SQL Server articles). I've done this to each node of a SQL Server Always On Availability Cluster, ...
2
votes
4answers
3k views

Log Shipping or Always on as DR for SQL Failover CLuster

Which is easier to maintain as Disaster Recovery on a remote site for a 2-node SQL Server Cluster Log Shipping Single Instance of Always on Availability Group Instance. Any suggestion will be ...
2
votes
0answers
3k views

Cassandra - High Number of Dropped Mutations (Specific Table on a specific Node in the cluster)

History Leading to this issue: My Compression strategy in Production was LZ4 Compression. But I modified it to Deflate For compression change, we had to use nodetool Upgradesstables to forcefully ...
4
votes
2answers
8k views

Setting up MySQL Cluster on Two Systems

I am attempting to setup a MySQL Cluster. I have the folllowing setup one management node two data nodes another machine on which two more nodes reside Below is the config.ini file: [ndbd ...
0
votes
1answer
94 views

MySQL clusters - sync a table [closed]

I've been developing a software that runs on hardware and now I need to synchronise DB on them, but only partly - several tables using MySQL Clusters(don't matter which style), each of hardware can ...
0
votes
0answers
109 views

Remove node from failover cluster without access to said cluster or domain

I have a server running Windows Server 2012 and SQL Server 2008 R2. The server used to be part of a SQL cluster but it is now standalone and no longer has access to the cluster. I want to repurpose ...
1
vote
1answer
649 views

MySQL InnoDB cluster pricing

On https://www.mysql.com/products/community/, the InnoDB Cluster is listed as part of the MySQL community edition, but when clicking the "Download MySQL Community Edition" link and further, I end up ...
1
vote
0answers
565 views

MySQL InnoDb Cluster Replication Issue

I am trying to setup MySQL InnoDB Cluster. I am using version 5.7.20 of the MySQL server. I am able to create a cluster. When I try to add the first slave is when I run into my issue. It complains ...
0
votes
2answers
82 views

Growing MySQL NDB Database. How to get High Availability?

Since last 2 year, we were using NDB Cluster for live database of our app, which is now have size of 7-10 GB, running on 6 Dedicated servers (6 data node, 2 api node, 1 mgm node) to have get maximun ...
2
votes
2answers
875 views

ComputerNamePhysicalNetBIOS and “Current Host Server” shows different machines

I have a SQL Server 2008 R2 instance on a two node (say names X and Y) Windows server cluster (Windows Server 2008 R2 Enterprise). Server Manager on both nodes shows 'X' as the 'Current Host Server'...
2
votes
1answer
59 views

Log Shipping with Failover Cluster Server Cores

Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014 Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014 My question is if I need to log ship do I need to match the ...
2
votes
1answer
166 views

SQL Server 2008 R2 service pack steps …on cluster

I have a sp3 to apply on SQL Server 2008 R2 on windows 2008 R2 cluster with four nodes and 6 instances. Node 4 do not have any resources but is possible owner for all the instances. Steps I am ...
3
votes
1answer
800 views

AlwaysOn Availability Groups: Confusion with some concepts

In Sql Server 2012, I am trying to install Failover Clustering to configure AlwaysOn Availability Groups. When I run Cluster Validation test wizard, it comes back with a lot of errors. One of them ...
0
votes
1answer
867 views

Can auto failover cause split-brain? (SQL AlwaysOn)

I have been studying Cluster voting and AlwaysOn failover. The topic of split-brain comes up and sounds terrible. This following from Microsoft seems to indicate that only a person with SA, doing ...
1
vote
2answers
184 views

Mixing 2 and 3 node AG on a single WSFC?

I have a 3 node availability group (Enterprise 2014), it is multi subnet, with two data centers and file share witness in a third data center. There are about 20 "production" database that exist on ...
0
votes
1answer
50 views

Cassandra - reinserting a node

I had to remove a cassandra dead node on a hurry (because an important script with a truncate query wouldn't work due to consistency level reasons -- any thoughts on that would be nice too). Anyway, ...
1
vote
2answers
59 views

High Level SAN Migration Strategy. Is this a good idea?

In the company I work for we are planning decommissioning an old SAN serving our production servers Which are 2 Nodes running 2 SQL Server instances using Clustering (one is the backup for one ...
0
votes
1answer
73 views

SQL 2008 Cluster Install, “Cluster shared disk Availability Check”

I am trying to setup a new sql server 2008 cluster, on windows 2012R2, and the installer is failing on the cluster shaed disk availability check. I have verified that there are 5 disks assigned to "...
0
votes
0answers
56 views

Create HA PostgreSQL cluster

We want to set up a highly available PostgreSQL cluster in our production environment. As of now, We have set up streaming replication. But we have to manually promote the slave as the master in case ...