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
2
votes
1answer
184 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
359 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
327 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,...
1
vote
1answer
42 views

Setting up a SQL Server cluster for the first time, some questions!

I am a SharePoint architect but looking to implement AOAG with SharePoint in an Azure lab environment. I'm building the first node in a cluster and I'm a little confused: I have my cluster object ...
1
vote
1answer
1k views

Confused about the “Maximum Failures in the Specified Period” setting on SQL Server Cluster

The failover properties of the SQL Server role on my two-node SQL cluster are as follows: Maximum Failures in the Specified Period: 2 Time period: 6 (hrs) I would expect that forcing failover (...
0
votes
1answer
43 views

Availability groups taking time to change states

I created a 2 node AG setup as a POC today and when I tried to do an automatic failover by stopping the sql server service on the primary node, the one in the secondary went into resolving state and ...
4
votes
1answer
7k views

Are “Always On Failover Cluster Instances” and “SQL Server Failover Clustering” the same thing?

I'm reading documentations of SQL Server. On this page at https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/windows-server-failover-clustering-wsfc-with-sql-server, it says: ...
0
votes
1answer
289 views

Add Secondary Node to existing WSFC Cluster

I need to add new server in my existing WSFC cluster server setup. I need few details on following : 1. I have Windows Server Failover Cluster setup on 2012 R2 with SQL Server 2012, Can I have my new ...
3
votes
1answer
59 views

Always On AG cluster with 2 servers that fail over to each other

I have 2 servers. One is dedicated as an OLTP server and the other will be a DW server. The OLTP server will have our application DB on it and our DW will have a couple of databases on it used for ...
1
vote
1answer
152 views

Fileshare witness for 3 node Multisubnet AAG setup

I am planning for a 3 node AG, 2 in DC and 1 in San Jose. Host OS will be Windows Server 2012 R2. We dont have an option of a 3rd site, so my question is where can I place the FSW if I have to do a ...
30
votes
4answers
15k views

CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?

We are beginning to provision a set of physical servers for a virtual cluster of SQL Server 2016 nodes within VMware. We will be utilizing Enterprise Edition licenses. We plan on setting up 6 nodes, ...
1
vote
1answer
678 views

Is the chunk size a limit to the max data size that can be associated with a shard key value?

I haven't read about the relation between chunk size and the data size associated to a single shard key value in a collection, so, another way to ask the question could be, can a shard key span more ...
1
vote
0answers
752 views

SSAS 2012 role fails to start in a Win 2012 cluster

I started a thread in MSDN SSAS Forum. Please see this and help me understand the problem. I have never seen this sort of issue before. I'll try to explain the issue here as well. I got SQL Server ...
0
votes
0answers
357 views

Change Port numbers on multiple instances in SQL server 2016 failover Cluster?

Can any body tell me the process to change Port numbers for SQL server 2016 (Default 1433), there are any difference between failover Cluster and Standalone environments? I want to know in SQL 2016 ...
1
vote
1answer
464 views

Can we use VMDK for FCI on SQL Servers?

Can I share a VMDK among 2 nodes for an active passive setup for a SQL Server Failover Cluster setup? Most of the articles I see mention to use RDM's, however we use Veeam backup for the environment ...
0
votes
1answer
704 views

How to do Oracle database cluster / Failover without shared storage

I have 2 or 3 RHEL 6 servers and I don't want to have a dedicated storage device. I think maybe you can replicate changes from one node of a cluster to another in real-time. I want to cluster them so ...
1
vote
2answers
598 views

Manual failover of AAG in SQL Server 2012

Just a question regarding manual failovers. Does it matter if we use SSMS to perform the failover vs going to the Failover Cluster Manager and move the role to the secondary node? Is there a ...
0
votes
2answers
354 views

SQL Cluster with different Edition

Is it possible to join new node SQL in Failover cluster with different Edition? As example: Cluster Failover running based on SQL Enterprise Evaluation Edition add a new node based on SQL Standard ...
4
votes
0answers
302 views

Should Full Text Filter Daemon Service be a cluster resource?

Our newly installed and configures Sql Server Always On Availability Failover Cluster with Sql 2016 Enterprise Edition with four instances and six nodes. It includes the DB Engine Service and the ...
6
votes
1answer
2k views

Availability Groups using Multi-Subnet Clustering: Preferred Owners for Roles and Possible Owners for AG Listener IPs

We use a SQL Server 2016 Availability Group (AG) on a Windows Server 2012 multi-subnet failover cluster for HA/DR. There are two nodes in our New York datacenter (10.7.x.x subnet) and one node in our ...
0
votes
1answer
91 views

Fileshare witness for Multisite AvailabilityGroup setup

If I am having a multisite AG with 2 nodes in the primary datacenter and 2 nodes in the DR - Where can I place the quorum for its continuous availability? I am assuming a 3rd site - but my management ...
0
votes
1answer
116 views

IP configuration for MultiSubnet AAG setup

Is it a good practice to have all the ip's in a different subnet for an AAG setup as mentioned in the link below? When I wanted to setup a 2 node AAG, the windows team in my office built the cluster ...
2
votes
1answer
957 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: ...
1
vote
1answer
439 views

Cluster command locking read only queries on replica

I noticed that clustering can take a long time and lock the table entirely, even for reads. Index Organized Tables and incremental clustering would be perfect, but sadly they aren't supported by ...
0
votes
1answer
200 views

Automatic MYSQL failover

We have a wordpress environment however this is not a wordpress question. Our scenario is that front Ends connect to a MYSQL backend (MYSQL VM1) which is replicated to a backup vm (MYSQL VM2). The ...
0
votes
3answers
732 views

SQL SERVER 2014 FCI Cluster taking too long to failover

I support a multi-instance, two node failover cluster (active-active). Both instances are running SQL 2014, on Windows Server 2008R2. The nodes each have 3/4 TB of memory and 32 cores (64 with HT). ...
0
votes
1answer
212 views

How to sync two or more collocation database server?

I can't tell if mysql clustering could be a solution(I am thinking about galera or xtradb clustering). But my biggest problem is about the unstable internet connection. Actually it is planned as ...
5
votes
1answer
238 views

Powershell Missing Cluster Name for FCI

I'm running the following simple Powershell command. $Server = New-Object ('Microsoft.SqlServer.Management.Smo.Server') 'SerName' $Server | SELECT * For FCI clusters the ClusterName value is always ...
3
votes
3answers
2k views

MySQL H.A with automatic failover

MySQL has a lot of different highly available solutions, I would like to know what are the differences between all the current implementations, here are the implementations that look currently up to ...
4
votes
0answers
350 views

Cluster migration to new hardware, same OS, but SQL Server 2012 to 2016

I have a 3 node cluster running on Windows Server 2012 R2. Two nodes for the databases, the 3rd node is an Always On db used for reporting. I have new hardware built running the same OS, but will need ...
1
vote
1answer
540 views

SQL Server 2008 Patch on Clustered Server

I am patching SQL server, going from SP1 to SP3, on a cluster while following Microsoft's instructions on how to do it. Every single place I read tells me to do the following: Pause the passive ...
3
votes
1answer
1k views

SQL Server 2016 SP1 CU1 Install Fails

I am trying to install CU1 for SQL Server 2016 SP1 on a clustered node and it fails with an error that I am not able to find information on. In the summary log file it has the following: Instance ...
0
votes
1answer
359 views

GFS2 as shared storage for MySQL cluster with active active setting

I am using MySQL 5.7 on RHEL 7.1. For cluster management I am using Pacemaker and corosync. For shared storage, I am using GFS2 file system with iSCSI server I am trying to implement MySQL active-...
6
votes
3answers
1k views

SQL Server Always On Node and File Share Majority

I am looking for some guidance on architecting our SQL Server 2016 SP1 Always On Availability Groups HADR solution on Windows Server 2012 R2. We have a primary site A with a primary replica and a ...
2
votes
1answer
466 views

Are multiple databases sharding for read on docker as a good idea?

So I have a server with multiple CPU cores and it installed a database. Do you think that if we install multiple databases (data sharding) with docker, then each request will go to different databases ...
0
votes
1answer
700 views

Spatial Data Cluster in sql-server ? ( like ST_ClusterWithin in Postgis )

Postgres 9.5 providing ST_ClusterWithin for Cluster the spatial data in DB level. Is there any available solution for data clustering in MS SQL (NOT SERVER CLUSTER) OR Is there Any Function ( like ...
3
votes
2answers
4k views

How is the 2 Node Cluster Limit Enforced for SQL Server Standard Edition?

I know Books Online says that standard edition only supports 2 nodes but how is this actually enforced? Will it: Not let you install a new instance on a cluster with more than 2 nodes? Not let you ...
0
votes
1answer
670 views

Synchronize between two elastic-search for redundancy [closed]

I am new to all the DB and therefore also to ElasticSearch. I got a project where I have to connect two Elastic Search DBs from two different IPs for redundancy. I searched google and https://www....
1
vote
1answer
567 views

Remove a SQL Server Patch only visible in View Installed Update List

Kindly help me regarding our issue with a Clustered Environment's applied patch. The situation is: We removed a SQL Patch: GDR 6248 for SQL Server 2012 (KB3194721) (64 bit). When we successfully ...
0
votes
1answer
62 views

Storage does not failover in Windows cluster

I created a lab setup for a 2 node cluster using Windows 2012 R2. I first configured the quorum and performed a failover between both the nodes, the quorum would also map to the respective node. But ...
1
vote
1answer
162 views

Creating MySQL NDB cluster on Hyper-V

I want to create a MySQL NDB cluster on Hyper-V for testing so I have some questions in this regard. Can I use Windows XP 32 bit? (because I already have a VM) If not then can I use Windows 7 or 10? ...
0
votes
1answer
52 views

Problem in MySQL cluster when using two clusters

I have a master-slave MySQL Cluster 1 which is two way. It is working fine. I have another MySQL master-slave Cluster 2 where data is coming from Cluster 1 master to Cluster 2 master. It is also ...
0
votes
1answer
247 views

Can I seed Percona XtraDB cluster from the existing backup?

I have a running setup of Percona MySQL 5.7. I would like to try out Percona XtraDB cluster. The current data size is ~500GB. From what I've observed (seen in a couple of YouTube videos: https://www....
0
votes
1answer
39 views

Alwayson + FCI with independent Storage

I have setup with FCI+AG solution but with independent disks. There is no listener, and the applications are connecting to the FCI. Is this setup even reasonable to use? The only option I see here is ...
0
votes
1answer
508 views

Is it possible to have one Sql-Server cluster node in multiple Sql-Server clusters?

Is it possible to create FAILOVER CLUSTER A with Node01 (active) and Node02 (passive) and FAILOVER CLUSTER B with the same Node02 (passive) and Node03 (active)? I realized that SQL Server instances ...
1
vote
2answers
958 views

SQL Server 2016 - Configuration Manager WMI Problem

Background: Windows Server 2016 Core SQL Server 2016 Enterprise (obviously 64-bit) Windows Failover Cluster SQL Failover Cluster I am attempting to connect to SQL Server Configuration Manager via my ...
1
vote
1answer
120 views

SQL Network Name owned by Available Storage OwnerGroup in Server 2012 FCI

I did a simple get-clusterresource and noticed the 'owner group' is 'available storage'. Not SQL Server (instance)for the SQL Server Network Name (instance). I want to fix this ASAP but I'm having a ...
5
votes
1answer
404 views

SQL Server mirrored backup using cluster shared volumes

I have SQL Server 2014 cluster with 2 nodes and a third server with iSCSI target server configured on it, all of them are virtual Servers with Windows Server 2012 R2. Both nodes of cluster are iSCSI ...
3
votes
0answers
285 views

Error: “Computer X is Joined to a cluster” when creating a new cluster

I am trying to create a New Cluster for Always On Availability Groups. On Failover Cluster Manager when I try to add the cluster nodes I get the following error: Computer X is joined to a cluster. ...
0
votes
1answer
107 views

SQL Clustering options with 2012 standard Ed

i need help to find the best solution (if one exists..) to build a sql cluster using two servers and two sql Standard Edition licenses (2012 or 2014 or 2016). No shared storage is available No need ...