A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.

learn more… | top users | synonyms (1)

4
votes
1answer
3k 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) ...
1
vote
1answer
21 views

Permissions for Cluster service account in SQL server

Recently i faced an issue where the SQL server 2012 being hosted in a 2 node failover cluster failed to start. And since the cluster and windows event log didn't help much, i started checking the SQL ...
1
vote
1answer
385 views

MariaDB Galera Cluster without HAProxy, MYSQL Proxy, etc

I'm looking to deploy a MariaDB galera cluster across three servers. However, I've noticed that the documentation often references HAProxy or the like. Does this not cause a single point of failure ...
0
votes
0answers
12 views

Galera segments relay node — is there a way to prefer one?

I have geo-distributed cluster with 2 segments. Main segment is in Singapore, secondary -- in Europe. Recently I found out, that one node of main segment has RTT to Eu node about 5 times less, than ...
0
votes
1answer
202 views

unable to connect to specific instance ORacle RAC

I did several operations by connecting successfully to all 4 instances but suddenly during one of the jobs, it failed with a TNS error. I checked the connect from SQL and one of the nodes is giving an ...
0
votes
1answer
331 views

delete WSFC 2012 cluster role/group fails

PS C:\Windows\system32> get-cluster Name ---- sql2012poc_cl1 PS C:\Windows\system32> get-clustergroup Name OwnerNode State ---...
0
votes
0answers
29 views

Postgresql promoting slave server to master

I am trying to setup Postgresql(9.4) master-slave cluster. I am using the following tutorial: http://linux.xvx.cz/2014/10/loadbalancing-of-postgresql-databases.html The issue I am facing at the ...
0
votes
1answer
35 views

Is there a way remove SQL Server listener IP on maintenance

Is there a any way to stop listening listener on the SQL Server on production server. I want to be sure nobody is trying to connect my production server when it is maintenance mode. I disabled all ...
2
votes
2answers
3k 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....
0
votes
0answers
18 views

Clustering SSAS

We are using both SQL Server 2012 and 2014 always on. Here is my issue: we have an application that I have set up to use Availability groups(2014), however the issue I am having is that it uses ...
0
votes
1answer
25 views

Rebuild Windows cluster for Alwayson.

I am setting up Alwayson,somehow my cluster is gone ( get-clusternode shows down,down,down and Joining). SQL Server is working fine. What Should I do? Create new cluster or build new server? Any ...
5
votes
1answer
167 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 &...
1
vote
1answer
24 views

is shared storage safe in Postgres if all servers are read-only?

Description of shared storage in Postgres: https://wiki.postgresql.org/wiki/Shared_Storage Related question: http://serverfault.com/a/620315/137464 Both of these make it clear that it's not safe to ...
0
votes
1answer
34 views

Installing SQL Server TDE on a Windows Cluster

i'm going to be upgrading two Instances to Enterprise and thenI'm going to be installing TDE on two sides of a Windows Cluster. All of the databases are on one storage device and whichever Instance is ...
0
votes
0answers
21 views

Combining SQL Failover cluster with availability groups and SAN replication

We are looking at implementing the following Windows cluster containing 4 node FCI (2 nodes per data centre) with SAN replication - our current setup. manual failover (storage first then SQL resource)...
0
votes
1answer
63 views

Failed to create, join or add replica to availability group in SQL Server 2014

I have a 2 node FCI and a standalone SQL Server installation on a non FCI node. I have been automating the configuration/installation of FCIs, AGs, and DB Replicas which has worked fine up to now in ...
0
votes
1answer
146 views

PostgreSQL : Master-Slave replication strategy and solution for 3 servers.

We have currently 3 servers(X,Y,Z) running Debian X64, two of them host projects(Y,Z), which don't require that much database, as they serve more static content, but the third server(X) is largely ...
1
vote
1answer
669 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, ...
3
votes
0answers
123 views

Move SQL Server cluster from one location to other

I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...
0
votes
1answer
304 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
1
vote
1answer
475 views

SQL Server 2008 R2 Cluster Service pack 3 fail to failover node [duplicate]

I have a SQL Server R2 cluster on Windows 2008 R2 boxes, and today i was to install SP3. I installed it without any errors and rebooted the passive node. When i then try to failover to the passive ...
1
vote
1answer
271 views

SQL Server 2012 Cluster Service pack 3 fail to failover node

Roughly a year ago, i had this problem with an 2008R2 cluster. I asked about it here, but i didn't grab enough logs in the process. And now i have the same problem on my 2012 failover cluster. So i'm ...
1
vote
0answers
56 views

Mongos process memory usage and crashes

So our MongoS instances use up A LOT of memory. More than even the shards and sometimes crash because of it. Cluster structure 3x mongos 3x mongod Shards 3x mongod Replicas (one for each shard) 3x ...
5
votes
1answer
55 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. ...
-1
votes
1answer
25 views

Installing a Failover Cluster Instance on a Cluster already in use for Instances hosting Always On

I have been asked to install a SQL Server FCI on a 3 nodes cluster already hosting 4 different instances with Always On Availability Groups. While I am building the lab on my machine, I am wondering ...
0
votes
0answers
30 views

PostgreSQL Redhat Cluster Implementation(Active-Passive) With Streaming Replication setup For DR failover

We have a scenario Where Customer is looking For Cluster kind of solution with DR failover Setup. I am Planning to suggest the attached Architecture with customer. Few Clarification as per ...
0
votes
0answers
39 views

SQL Server 2014 Standard Max Memory vs. Cluster Shared Volume Cache

Deploying a new two node SQL Server 2014 FCI with Storage Spaces on a local (Cluster Shared Volume) CSV—JBOD will be attached directly to both SQL Server machines and the storage will not be tiered. ...
0
votes
0answers
41 views

Log shipping with active active cluster configuration

Scenario: We are planning to configure active active cluster for our SQL Server. Both will be having separate instances(A instance on node 1, B instance on node 2). 'A' instance will have Production ...
1
vote
0answers
59 views

Quorum Questions For An FCI And AlwaysOn in a WSFC

I was reading the white paper on FCI + AlwaysOn as well as several other resources on quorum voting differences in Windows Server 2008 and 2014 and had 3 questions. 1- Will giving a node in the ...
0
votes
1answer
32 views

Upgrading SQL Server 2008 failover cluster node to SQL Server 2012 failover cluster node [closed]

Please I want someone to help me with step by step method of upgrading SQL Server 2008 with failover cluster node on two different machines to SQL Server 2012 without losing the existing settings/...
2
votes
1answer
55 views

Fail to start sql cluster role

I have installed SQL Server using Failover Clustering on 2 nodes, running Windows Server 2012 R2 Enterprise Edition and SQL Server 2008R2 Standard SP1. Shared storage is provided by an iSCSI NAS ...
1
vote
0answers
8 views

2 Cluster managers Control same 2 nodes and control OLTP traffic?

can you have two cluster managers controlling the same 2 nodes so that you can achieve real time replication but still direct your oltp traffic to one node and your reports to the other node?
4
votes
2answers
59 views

Simultaneous money withdrawls from a distributed/replicated database

Lets say I have $10 in my bank account. The database is replicated in North America and Asia. At the exact same time I do a withdrawl of $10 in N. America and in Asia, meaning that my withdraw would ...
0
votes
1answer
71 views

SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over

I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database. When I fail-over the AG, the Availability ...
0
votes
1answer
33 views

Hardware Cluster to VMware, is vMotion an alternative for clustering?

We are migrating DB servers from "real" clusters to VMware. The question is with VMware how do you get similar functionality in VMware? Things like failover etc? Is vMotion the answer? I wonder what ...
1
vote
1answer
82 views

MongoDB cluster deployment

I am new to MongoDB. I am trying to deploy a MongoDB cluster. I am following: https://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ I initiated Config Server Replica Set and after that I ...
2
votes
2answers
859 views

Experience using ScaleArc in test or production?

Has anyone had any experience using ScaleArc? My CTO has asked my thoughts on it, and I have seen no information out there regarding real-world experiences.
0
votes
1answer
26 views

DR site SQL Server DB server not need Quorum Disk?

We have two SQL Server DB Servers and Shared disk in production site and 1 DB in DR Site. Production site has Quorum Disk on Shared Storage. Production site DB servers can access this share storage, ...
2
votes
2answers
26 views

SQL Server 2014 - Add Node inherits wrong configuration

I'm setting up a simple 2-node failover cluster with SQL 2014 on Server 2012 R2 in Core mode (no GUI). I have the cluster configured with identical machines, and I have the first node configured and ...
0
votes
0answers
36 views

Changing database parameters after removing a node from RAC oracle

Oracle 11.2.0.3 on SunOS 5.1 i have a client who is running a 2 node RAC environment but has shutdown the instance on one of the nodes. I was wondering whether after doing this they should change the ...
3
votes
1answer
58 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 ...
1
vote
0answers
35 views

2 SQL Clusters & 2 instances

Can anyone tell me why i wouldn't want to the architect Option 1 for SQL Server clustering? Option 1 is having 2 different clusters, and 2 different named instances on 2 VMs. One's Active is the ...
1
vote
1answer
57 views

Add New Cluster node

I have a Windows Server 2012 Failover Clustering Instance, hosting a SQL Server 2012 Enterprise Cluster, via NODE1 and NODE2. I need to add a new read-only Replica to this cluster: NODE3, which is a ...
0
votes
1answer
25 views

Should a Sql Server be accessible through the service's virtual network name?

In a working SQL-Server failover cluster environment I can open a SQL-Server connection using the configured service's IP address independantly of the current node it is on. I wonder if the assigned ...
3
votes
1answer
146 views

SQL Server Clustering - Active/Active or Active/Passive?

What is the logic of the Active/Active cluster vs Active/Passive cluster? I have searched a lot and read lots of documents but have not found the answer. In active active cluster can I have 1 ...
2
votes
1answer
58 views

Sql Server Cluster with multiple nodes

Does it make sense to think about a failover cluster configuration where less than 50% of all included nodes are standby? For example instead of setting up 4 clusters with two nodes each where one is ...
0
votes
1answer
204 views

Connect to Oracle RAC from SQL Developer?

We have set up RAC database on server. We can connect to database from sqlplus on the server using SCAN address. However, if I try to connect to RAC using SQL developer from client machine using SCAN ...
0
votes
1answer
51 views

WSFC File Share Witness

I've got a multi-site 2008 R2 WSFC with a file share witness. I noticed that the possible owners for the FSW is every node in the cluster. I thought the concept of a FSW was that no node of the ...
1
vote
1answer
48 views

Users in SQL Server cluster

Question on users: I have created a 2012 WFC and SQL Server 2014 is clustered on it. The cluster works as expected but have a question on Users. I added a windows domain group to the cluster as ...
1
vote
1answer
2k views

SQL Server Licensing & Clustering for Always On

For SQL Server 2014, reading this MSDN link and Microsoft PDF file about licensing, created a couple of questions. For Always On do we need WSFC or FCI? How are WSFC and FCI different? If we only ...