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
88
votes
5answers
21k 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 ...
47
votes
4answers
33k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
30
votes
4answers
16k 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, ...
17
votes
2answers
22k views

“Access is denied” when connecting SSMS to Integration Services

I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name: Connecting to Integration Services service on the ...
15
votes
1answer
559 views

Is it safe to add a new node to a Cassandra cluster while a repair is running?

I'm getting ready to expand an existing Cassandra cluster. I have repairs scheduled to run on a reoccurring basis. Do I need to disable repairs when adding a new node to a cluster, or can I ...
10
votes
2answers
21k views

What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?

What are the main differences between Mirroring and Failover Clustering? What kind of problem each one solves and in what kind of scenarios is each one recommended over the other?
9
votes
3answers
3k views

SQL Server 2012 Standard Edition - multiple instances and memory utilization

If we have multiple instances of a SQL Server 2012 Standard Edition (which has a 64 GB memory limit) on one server which has 192 GBs of RAM, do both instances only have access to the first 64 GBs of ...
8
votes
2answers
726 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?
8
votes
1answer
10k views

MySQL high availability, failover and replication with Latency

We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...
7
votes
2answers
584 views

New Cluster Testing - Best Practice

We've finished setup of a 4-node SQL Server 2005 cluster. We are using Windows 2008 R2 as the underlying OS. We are looking for suggestions on a set of tests we could perform to test failover of the ...
7
votes
1answer
2k views

What is the safest way to run SSIS on Multiple Named SQL Server Instances?

I have an Active/Active SQL Server 2008 R2 cluster. There are two named instances on each node and no default instance. I need to deploy SSIS packages to the different instances. To do this, I ...
7
votes
1answer
2k views

De-Cluster SQL Server 2012

Is there any way to 'de-cluster' an instance of SQL Server 2012 that was installed using the 'New SQL Server Cluster Installation' option? We are having issues with the failover portion of clustering ...
7
votes
1answer
210 views

Failover timeout problem

I'm looking for an additional bit of help with regard to some problems I'm looking at for one of my company's clients. Basically I have two related problems with regard to a 2-node active/active ...
7
votes
1answer
4k views

SQL Cluster Resources Disappear After Removing Disk Resource

In the process of removing an usused disk resource from cluster, I would follow these steps: 1) remove dependencies on the disks by the SQL Server resource, 2) take the disk resource offline, 3) ...
6
votes
3answers
7k views

Is MSDTC required for SQL Server 2012 Fail Over Cluster?

I am making a 2 node SQL Server 2012 Failover Cluster; do I need to install the MSDTC component? If yes, can both be installed on single shared disk?
6
votes
3answers
5k views

Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster

SQL Server 2008 R2 multi-instance cluster (on VMware vSphere 5.1) 2 nodes, each running 2 instances (4 instances in total) 16GB RAM per node. The only time the instances are on the same node is when ...
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 ...
6
votes
3answers
14k views

How to allow connections to SQL Server with 2 differents ip

I have a small issue here: I have a SQL Server instance 2012 (let's call it SQLINSTANCE) on a cluster. I also have 2 network interfaces for this instance: - SQLINSTANCE.my.network - SQLINSTANCE.mgt....
6
votes
2answers
2k views

SQL Server FCI installation with Mount Point permissions issues

Please help me get past this installation issue. I am trying to install a SQL Server 2016 (SP1 slipstreamed) Failover Cluster Instance (FCI) on two Windows Server 2012 R2 VMs. I have 3 cluster disks....
6
votes
2answers
4k views

Advantages of using PgBouncer vs HAProxy?

Are there any advantages for using one over the other? I'm only looking at options to hide the actual IP address of the master and slave servers from my processes, and not having to restart them if ...
6
votes
2answers
7k views

Help solving a Clustering Issue: [sqsrvres] ODBC sqldriverconnect failed

I have a 2 node cluster (NODE-A & NODE-B) with 2 SQL instances spread between them. INST1 prefers NODE-A, INST2 prefers NODE-B. INST1 started generating errors then, failed over to NODE-B. ...
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 ...
6
votes
1answer
1k views

Storing logs on per day basis in PostgreSQL

Requirements here are to store historical logs. For the sake of simplicity I'll assume this sample scenario where we are selling some products on our website and we need to keep records of sales of ...
6
votes
2answers
1k views

Executing Powershell SMO against a cluster with elevated privileges to update service accounts

I'm working on a Powershell script to update service accounts on named SQL instances in a failover cluster. I'm trying to use the SMO and WMI to update this so that I can update the service account ...
6
votes
0answers
849 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 ...
5
votes
3answers
12k views

Understanding two NICs requirement for SQL fail over cluster

I am trying to make an SQL Server 2012 failover cluster. I have two DB machines. I understand that both machines need 2 NICs each. In my organization the IP scheme assigned is something like 192.168.1....
5
votes
3answers
4k views

Port number change

We are planning on setting a static port for SQL Server 2005/2008 failover clustering. Any guide on what port to choose/select for 4 nodes of each cluster?(Active/Active) I am also thinking some ...
5
votes
5answers
2k views

Setting up a Redundant Sql Server 2008 Configuration While Retaining High Performance and Minimal Downtime

We have a situation where we are moving to a new hosting facility and are attempting to configure our new database environment. However, none of us are formal DBA's so a lot of what we are doing is ...
5
votes
2answers
810 views

Best Setup for Database Cluster

I need to set up a good database clustering solution for a system that I am putting into production. I was hoping to get some advice from the experts as I am a primarily a developer and not a database ...
5
votes
2answers
4k views

AlwaysOn AG versus FCI

Throughout MS documentation for AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) I see the following pattern: FCI is for HA scenarios. An AG synchronous secondary ...
5
votes
2answers
5k views

Manually moving SQL instance to another node causes immediate database mirror failover

I have a two-node SQL cluster (2008 R2). Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
5
votes
1answer
228 views

SQL Server Mirroring kicks in before cluster has time to fail over

I have two clusters each with two nodes configured in active/passive; the two clusters take part in a high-availability mirroring session using a separate server as the witness. When a node fails in ...
5
votes
2answers
2k views

Restart the active node services without failover

On a 2 node Windows Server Failover cluster configuration, how do I restart the SQL Server services without failing over to the other node?
5
votes
2answers
2k views

Failover Cluster Diagnostic Logs

I know there must be a simple answer to this question, but I cannot find it anywhere. Our SQL 2012 FCI have SQLDIAG .XEL files in their MSSQL\LOG folder. In some instances, these files are often ...
5
votes
1answer
352 views

Migrating a cluster from SQL Server 2005 to SQL Server 2016

I am in the process of migrating a SQL Server Cluster. I would like to hear considerations for a successful migration. The specs of production cluster are: Windows Server 2003 SP2 32bit. SQL Server ...
5
votes
1answer
1k views

Traditional failover clustering vs. Availability Groups

I'm looking into Availability Groups to see if i can benefit from them, but I struggle to understand if I can or not. Today, we are running a traditional failover cluster with around 150 databases. ...
5
votes
4answers
837 views

SSIS in Clustered Enterprise

We have a 2-node clustered SQL Server 2014, Enterprise, environment for our data warehouse. Storage, network, and servers are all high performing (1tb mem, 32 cores CPU per node, all SSD) We are ...
5
votes
1answer
3k views

Understanding of SQL Server active/active cluster

I have a vague understanding of SQL Server's active/active cluster. Can anyone help to confirm if my understanding is correct? As I understand, active/active cluster use two or more Windows servers. ...
5
votes
2answers
1k views

SQL Server cluster resource won't come online unless its on port 1433

The 2-node SQL Server 2008 R2 cluster works fine until one of the resources got removed. I successfully added it back. However, the cluster is not able to online the SQL Service unless it is on 1433 ...
5
votes
1answer
4k views

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the ...
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 ...
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 ...
5
votes
1answer
709 views

Mirroring partner timeout - Not working the way advertised?

I'm testing a 2 node windows failover cluster with mirroring in high safety mode and automatic failover. My mirror is a standalone server as is the witness. All instances are 2008 R2 RTM Enterprise ...
5
votes
1answer
247 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 ...
5
votes
1answer
426 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 ...
5
votes
1answer
13k views

Problem adding a new node to a SQL Server 2012 Failover Cluster

I tried to add a new node to SQL Server (2012 Standard) Failover, that is already installed on another node in Windows2012 Failover Cluster I have an issue with non editable field wiht input for SQL ...
5
votes
1answer
626 views

How to Achieve Concurrent Write Transactions to MySQL Group Replication in Multi-Primary Mode

I've set up a MySQL "cluster" (four CentOS 7 servers running MySQL 5.7.19) using Group Replication in multi-primary mode, but I can't get it to accept writes from more than one thread at a time. This ...
5
votes
2answers
420 views

Cluster node upgrade of SQL Server 2008 R2 to SP3 fails when moving resource

I'm trying to update a cluster to SQL Server 2008 R2 SP3. I've installed SP3 on the passive node but when I failover the cluster it errors when running through it's upgrade scripts. The messages &...
5
votes
1answer
4k views

Mysql Cluster vs Percona/Maridb Cluster [closed]

We want to setup a mysql cluster with master-master sync replication, to provide HA so that one db for write from one app, other for write from other app. It is a webapp with high write and medium ...
4
votes
3answers
195 views

SQL Server: Multiple Availability Groups, one cluster, how do I keep the primary cluster node as primary?

I have a database server setup where there are three SQL Server database instances set up on three nodes of a Windows Server Failover Cluster (WSFC). The sysadmin, who is responsible for the ...