Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

777 questions
92
votes
5 answers

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 once. My question is this, why can't relational…
fregas
  • 1,051
  • 1
  • 9
  • 7
49
votes
4 answers

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 am struggling to understand when to use which…
marc_s
  • 9,052
  • 6
  • 46
  • 52
36
votes
4 answers

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, but there is a bit of a debate on what the ideal…
PicoDeGallo
  • 1,554
  • 1
  • 20
  • 30
17
votes
2 answers

"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 computer 'FooDB' failed with the following error: "Access…
James Lupolt
  • 4,278
  • 5
  • 31
  • 46
15
votes
1 answer

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 bootstrap new nodes while repairs are running elsewhere…
Gene
  • 305
  • 2
  • 11
10
votes
2 answers

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?
ivanmp
  • 2,323
  • 3
  • 24
  • 36
9
votes
1 answer

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 concepts. Clustering is a HA solution and AG is a DR…
variable
  • 3,590
  • 4
  • 37
  • 100
9
votes
3 answers

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 memory, or can they access different portions of…
SQL3D
  • 231
  • 2
  • 9
8
votes
3 answers

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 I am patching the other node. Brent Ozar's…
SomeGuy
  • 2,053
  • 8
  • 35
  • 48
8
votes
1 answer

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 every product made by a salesman on a per day…
Gufran
  • 301
  • 1
  • 2
  • 10
8
votes
2 answers

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?
igelr
  • 2,162
  • 3
  • 26
  • 56
8
votes
1 answer

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 MySQL we will run ... either Community or…
KM.
  • 1,367
  • 4
  • 14
  • 20
7
votes
1 answer

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 needed to modify the MsDtsSrvr.ini.xml file to add the…
SomeGuy
  • 2,053
  • 8
  • 35
  • 48
7
votes
1 answer

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) delete the disk resource from the SQL resource group,…
MattyZDBA
  • 1,955
  • 3
  • 20
  • 32
7
votes
2 answers

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 the master fails. If Nagios detects a failing…
François Beausoleil
  • 1,463
  • 3
  • 15
  • 24
1
2 3
…
51 52