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
23 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
95 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
28 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 ...
0
votes
1answer
29 views

Duplicate Ips for cluster nodes causing backup issues

We have a four node cluster (SQL Server 2014 on Windows 12) and we recently setup heart beat network on the nodes following a best practices source after experiencing some cluster instability issues. ...
1
vote
1answer
169 views

Cluster IP's under Access Point for Administering the Cluster

When adding the cluster IPs under Access Point for Administering the Cluster, do we only include IPs for the public subnets, or do we also need to include an IP for the private subnet(s)? This ...
0
votes
0answers
139 views

SQL Server error 19456 when adding the listener

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error ...
0
votes
1answer
133 views

Automatic fail over in Always on availability group with 3 Node in synchronous mode and 1 Node in Asynchronous Mode

I am laying out a plan where there will be 3 Node on site with automatic fail over with synchronous mode and 1 remote replica with asynchronous mode. My question is if the primary goes down which node ...
0
votes
1answer
68 views

Difference between Client Access Name in SQL server Fail over Cluster and Always on availability group

We are migrating from SQL Server Fail over Instance to Always On Availability group. The current network name is ABC\ABCTEST where ABC is the SQL server Virtual Name and ABCTEST is the named instance ...
2
votes
0answers
76 views

Percona Xtradb Cluster not accepting options on command line

I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error: CentOS 7: systemctl start mysql --wsrep-sst-donor=srv1 ...
2
votes
1answer
127 views

How can coupled databases be kept in sync with selective uni-directional syncing and with connections that can be off for days?

I am trying to create a database topology that looks like this: .------------. Bad Connection. Bad Connection. | Central DB | May go offline May go offline '-----...
2
votes
1answer
265 views

Quorum question for SQL Cluster (Always On)

We are looking at setting up an SQL Always On High Availability environment at our organisation. Our organisation has two datacenters of with one much smaller one but this one's being created to ...
1
vote
2answers
75 views

Cluster Configuration

I’m looking at some of the SQL servers in a (new to me) SQL estate. The servers are configured for AOAGs; there are two nodes, both are part of the WSFC. However, if I look at the SQL Server advanced ...
1
vote
1answer
542 views

Failover Cluster Owners

In Windows Server Failover Cluster Manager I can see "possible owners" under "Other Resource" and also under "Server Name". I have a 3 node AlwaysOn Availability Group with 2 servers in synchronous ...
1
vote
1answer
363 views

Disabling IPV6 on Always on availability group

In our environment we only have one network adapters for the Replicas and IPV4 is being used. By default the IPV6 is also enabled. My question is will there be any problems if I unchecked IPV6 from ...
1
vote
1answer
52 views

AG of 2 replicas on 2 nodes in WSFC : is it possible to add 3rd replica to AG and NOT add 3rd machine WSFC?

Please help to to research the possibility of below: We have availability group that consists of two replicas: replica 1: SQL Server 2017 on Windows Server 2016 replica 2: SQL Server 2017 on ...
3
votes
1answer
668 views

Does clustering provide disaster recovery in MS SQL Server?

I mean can the nodes of MS SQL Server failover clustering be geographically separated and besides high availability also provide disaster recovery?
1
vote
1answer
428 views

Edition upgrade on SQL Server failover clustered instance

We did Edition upgrade on our active node for the SQL Server instance SQL01 and that was successful. I have a question/doubt --> Do I need to proceed the same on other node as well since SQL Server ...
8
votes
2answers
705 views

Can one of Windows failover cluster nodes run on Linux?

As SQL Server is available for Linux can I configure Clustering on Linux nodes? I mean mixed with Windows - some nodes are on Linux, others on Windows in the same cluster?
1
vote
1answer
299 views

Quorom Configuration for 3 Node Windows cluster

We have 2 node onsite and the 3rd node on DR and there is no disk witness. Due to maintenance I set the DR site to be primary and the other 2 nodes to be manual in asynchronous mode and after both ...
0
votes
1answer
312 views

IP address to use with FCI, Always On AG and Always On (AG) FCI

My understanding is that HA can be achieved using either of the below and my concern was which IP address should client applications use when connecting to SQL Server: Failover Clustering: For this ...
0
votes
1answer
177 views

Automatic failover (Clustering/Always On AG)

Let's says we have 2 nodes (N1, N2) clustered (say C1) on-site. And an Always On AG is configured between this cluster C1 and a new SQL server instance N3 (N3 is off-site). Now, if there is a problem ...
0
votes
0answers
113 views

Moving tempdb from shared to local drive in a failover cluster

We have an existing failover cluster that I would like to have the tempdb in local drive. I'm not sure how to proceed. My thought process is below: Create two drives on each node one for tempdb and ...
0
votes
0answers
51 views

Cleaning up the environment on old cluster after migrating to newer SQL Server cluster

We migrated many instances of SQL Server 2008/R2 on Windows 2008R2 and 2012 on Windows 2012 to newer Windows 2016 with SQL Server 2014 and 2016 versions. The old clusters were configured with either ...
3
votes
1answer
1k views

Always ON - What is the difference between the virtual cluster name and Listener

In clustering you specify DNS name/IP address of cluster that is then used by all applications. In case of failover, the same DNS name/IP address will point to the appropriate database server. In ...
1
vote
1answer
5k views

Always On Failover Clustering vs Always On Availability Groups

I have some concerns over my understanding of SQL Server Always On. Kindly can you correct me (conceptually) where needed: Always On Clustering and Always On Availability Groups are 2 separate ...
1
vote
0answers
31 views

Java app crash after shard failover

I am using a Mongo sharded cluster with 4 shards. All shards are a 3 members replica set with a PRIMARY with priority 1, a SECONDARY with priority 0.5 and an arbiter. The Mongo config server is a 3 ...
1
vote
1answer
49 views

Multi-site SQL Server Cluster issue

We have a 12 node SQL Server FCI (6 nodes in our primary datacenter and the other 6 nodes at a DR site) which has been working well until an access control list (ACL) was applied to a network switch. ...
0
votes
2answers
187 views

Install standalone instance on cluster server with SQL Server

I've a cluster instance in 2016 SP1 version on Windows 2016 server. All work fine. I want to install a new instance in standalone mode (version 2008) on one server of this cluster. The data disk of ...
2
votes
1answer
138 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
136 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
195 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 ...
1
vote
0answers
80 views

Cassandra pool warning displaying continuously

I am using the Cassandra driver for python in Spyder. I am trying to fetch some data from Cassandra table. Here is my code: from cassandra.cluster import Cluster cluster=Cluster(['some_ip']) session=...
2
votes
1answer
52 views

Snapshot Folder Location for Replication with Clustered Instance

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...
0
votes
1answer
60 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
56 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 ...
2
votes
1answer
347 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
3
votes
1answer
86 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
79 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
173 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
102 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 ...
1
vote
1answer
59 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
28 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
583 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
155 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
151 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 ...
0
votes
1answer
585 views

How to set up a transactional replication to an Always On Availability Group (AG) with two replicas through connecting to the AG Listener

I want to replicate some tables on a SQL Server instance (Publisher) to an Always On Availability Group (AG) with two replicas (nodes) using its Availability Group Listener. The Distributor is the ...
1
vote
1answer
351 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
129 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
500 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 ...