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

0
votes
1answer
13 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 ...
3
votes
1answer
40 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
32 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
43 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
23 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
50 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
34 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 ...
1
vote
1answer
342 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 ...
1
vote
1answer
537 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, ...
0
votes
1answer
240 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 ...
0
votes
1answer
122 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 ...
4
votes
1answer
2k 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) ...
0
votes
1answer
63 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
23 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
40 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 ...
0
votes
1answer
241 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 ...
2
votes
2answers
2k 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 - ...
1
vote
1answer
1k 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 ...
2
votes
1answer
72 views

The right way of starting up a Galera Cluster

I am confused about the bootstrap process of MariaDB Galera Cluster. Let's say we have 3 nodes of a MariaDB Galera Cluster, working and functioning normally on CentOS6/7. However, at some point we ...
0
votes
1answer
41 views

Windows cluster failed over, but SQL instances didn't move

I recently inherited a SQL Cluster (2008R2) which for the most part behaves itself impeccably. The windows cluster is made up of two nodes running Active/Passive, Node1 and Node2 are dedicated ...
2
votes
0answers
44 views

DBCC failure due to sparse files on Windows Cluster

We have a SQL Server 2014 SP1 cluster on Windows Server 2012 R2, and came across a problem with DBCC jobs failing and issuing the following messages: Msg 1823, Level 16, State 2, Line 3 A ...
2
votes
1answer
283 views

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep '(galera|maria)' mariadb-libs-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.40-6.el7ost.x86_64 mariadb-galera-server-5.5.40-6.el7ost.x86_64 ...
0
votes
1answer
13 views

Installing a SQL Server patch on a node within a 2-Node FCI

When installing a SQL patch on a 2-Node Automatic FCI with a shared disk (in the same datacenter / same subnet), with quorum achieved by Node and FileShare Majority, is it possible to install a SQL ...
0
votes
2answers
37 views

Is MySQL Cluster just for in-memory databases?

In MySQL website I see below definition for MySQL Cluster. MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. I want to use Clustering for ...
0
votes
1answer
33 views

Do SQL Sharding or Cluster help speed up slow queries, or just concurency?

I am having a performance problem with my current single instance database as the volumes of data grow. The application I am working on receives inserts once a month, and the oldest month is deleted ...
0
votes
0answers
43 views

How to do rolling upgrade MariaDB 10.0 -> 10.1 on ubuntu 14

I'm trying to figure out how to do a rolling upgrade of our galera cluster running on MariaDB on Ubuntu 14.04. In testing, the first node I upgraded started complaining about the timestamp column in ...
3
votes
1answer
2k views

Event 4104, MSDTC Client 2

I am using Idera SQL Diagnostic Manager to monitor a Windows Server Failover Cluster with two SQL Server 2008 R2 clusters configured to run with one SQL Server cluster on each node. It just started ...
0
votes
0answers
34 views

SQL Server clustering issue

I am facing a serious issue while building a clustered fail-over instance. After installing clustered instance on both of the nodes, SQL Server is running on only one node (the first node) and as soon ...
3
votes
0answers
48 views

Read replica setting giving error “No candidate servers found”

I am running my website with Laravel 5 + MongoDB. I am using mongo cluster to speed up data read and write, and to lower CPU usage of the mongo server. I have set up the replica like this: ...
6
votes
3answers
2k 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?
1
vote
0answers
32 views

Upgrade cluster sql server 2014

How can I upgrade SQL Server cluster 2012 to SQL Server 2014? Version – Standard. We have 2 nodes and 2 instances on each node. Have you manuals for upgrade 2 instances on cluster SQL Server 2014 We ...
0
votes
3answers
216 views

9 node percona xtradb cluster

We are looking to launch a 9 node percona xtradb cluster on Amazon where each ec2 node uses 20k iops disks. I was afraid if a 9 node cluster will work and mostly what I see is 3 node clusters. We ...
1
vote
1answer
58 views

Is MySQL Cluster a right choice?

I'm having a MySQL dual-master Replication of MySQL, each one of the servers have 21 GB memory, I'm now searching for a clustering solution for this project, It's possible to have 6 server: two of ...
2
votes
2answers
63 views

SQL Server Cluster Installation Failed

I need help trying to solve this as I've spent tons of time trying to figure this out but have had no luck. I created a VMWare Workstation test environment and I have been trying to install SQL ...
1
vote
1answer
114 views

What does node eviction mean in the Oracle RAC world?

Software environment: Oracle 12c with RAC running on RHEL The question might sound rather banal, but I wasn't able to find any word on this in the Oracle documentation I read thus far. By searching ...
0
votes
0answers
23 views

MariaDB Galera cluster write all nodes

I've setup a MariaDB Galera cluster. It replicates OK, and works OK. I want to be able to allow inserts in all the cluster nodes, not only on the first node, and right now, I can't do it. It allow ...
1
vote
0answers
119 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 ...
14
votes
2answers
15k 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 ...
1
vote
1answer
379 views

Risk in evicting node from SQL Server cluster without prior uninstalling of SQL Server binaries

I have to perform upgrade of a SQL Server failover cluster with several SQL Server 2005 instances running on two Windows Server 2003. Since the plan is to have servers running Windows Server 2008 and ...
2
votes
1answer
101 views

Can't recycle the ERRORLOG - error 17049

When we attempted to run sp_cycle_errorlog we get the following: Msg 17049, Level 16, State 1, Procedure sp_cycle_errorlog, Line 9 Unable to cycle error log file from ...
1
vote
1answer
32 views

Default instance name in a cluster

I have a cluster set up with two virtual instance names WIN2K8SQL1\INST1 WIN2K8SQL2\INST2 that was set up by the IaaS company. Now developers are complaining about the naming convention so ...
3
votes
0answers
2k views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work ...
0
votes
1answer
74 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 ...
3
votes
1answer
57 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. ...
3
votes
2answers
85 views

SQL SERVER 2014 Standard - High Availability Listener solution

The company has SQL Server 2014 Standard licenses and we're standing the servers up in a VMware environment. My initial plan is to create 2 instances on each DB server and run Instance1 on SQL1 as ...
0
votes
1answer
36 views

MariaDB Galera Cluster Replication

Does the replication between an async slave connected to a master withing the cluster affect the performance of the master in the cluster?
3
votes
0answers
18 views

Cluster of Clusters (Not using MySQL-Cluster)

I'll start with an apology, I'm an Ops guy at heart, not a DBA, so I may use the wrong terminology, not in an effort to annoy, merely because I don't know any better. OK, that over with, on to the ...
6
votes
2answers
979 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 ...
4
votes
1answer
1k views

Migrating Sql Cluster Installation To New Drive

We are migrating from an old SAN to a new SAN and need to migrate our SQL Server instance to new LUNs. We are able to migrate the data without any problem, but the SQL Server instance itself is ...
1
vote
2answers
67 views

Remove a node from Failover Cluster

We had 5 SQL Server 2012 servers configured with AlwaysOn. A few days ago we dismissed 2 of them, we removed them from the availability group and then stopped SQL services. We need to reuse these ...