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)

1
vote
3answers
260 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 ...
7
votes
1answer
66 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 ...
0
votes
0answers
344 views

Can't connect to an Active Node in an Active/Passive cluster

While being logged into an active node SQL Server 2012 node, I tried connecting to it from within the SQL Server Management Studio but was unable to do so. I tried the fully qualified name and the IP, ...
1
vote
1answer
321 views

Can't remove active node from SQL Server 2008 R2 Clustered Instance

I am trying to remove the active and only node from a SQL Server 2008 R2 failover cluster. Everything checks out and then I get this error Final result: Failed: see details ...
1
vote
1answer
101 views

SQL Server Failover Cluster Instance compatible with VMware HA?

Imaginary Setup: Microsoft SQL Server Failover Cluster Instance on virtual machine in an ESX-Cluster. Question: In case of a hardware failure, what will happen with both high availability ...
0
votes
1answer
183 views

Restart the active node services without failover [closed]

On a 2 node cluster configuration, How to restart the SQL services on the Active node without failing over on to another node?
2
votes
2answers
45 views

Disabling sql services while performing maintenance on SQL Server 2008 R2 cluster

Our storage team is performing updates on an MPIO driver for our SQL Server 2008 R2 cluster. They suggested disabling the sql server service on the node they are doing the update on - will disabling ...
0
votes
1answer
955 views

Oracle RAC, unable to connect to node vip [closed]

I have a new oracle RAC installation running 11.2.0.4 on redhat 6. I can connect to sqlplus from a client using the node name but it is timing out when i use the node vip eg. first one works, second ...
0
votes
1answer
50 views

Failover Cluster Instance work without quorum

I have a environment with three nodes with installed SQL Server on them. All three nodes are parts of FCI and quorum setting is Node Majority. In start, first node is role owner, and all three nodes ...
1
vote
1answer
637 views

Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?

We are applying SQL Server 2012 Service Pack 2 (SP2) to a two-node active/passive cluster, starting with the passive node (as per best practices): How to install a Service Pack at a SQL Server 2012 ...
2
votes
0answers
38 views

Alwayson cannot fail over using tsql

I have an Alwayson test environment with the following settings. My test goals are as follows: When SqlNod1 is primary instance, I want SqlNod2 to answer read-only queries. When SqlNod2 is primary ...
2
votes
0answers
441 views

Multi-Instance Windows Failover Cluster - Min / Max Memory Allocation Dilemma

We run numerous 2 node SQL Server 2008 R2 Failover Clusters in Windows Server 2008 R2 on a VMWare eSXi virtual platform. Each cluster hosts 3-4 SQL instances with varying degrees of memory ...
0
votes
0answers
423 views

Couldn't setup postgresql cluster with heartbeat pgsql ra

I'm trying to install postgresql cluster with the following configuration: 2 virtual hosts with RHEL 6.6 x64: postgresql 9.1 with hot standby replication pacemaker 1.1.12 resource-agents 3.9.6 I ...
1
vote
1answer
450 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 ...
0
votes
3answers
84 views

Clustering MySQL with InnoDB engine

I have a MySQL single server setup with all tables using the InnoDB engine (because I need support for foreign keys). As response times are getting longer, I now believe I need to create a cluster of ...
3
votes
1answer
2k 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 ...
0
votes
0answers
38 views

Can two databases share one data folder?

I'm planning to install a database (same configuration) on two separate machines, PC1 and PC2. PC1 is the main database while PC2 is the backup.. Is it possible that they can have the same datadir in ...
1
vote
0answers
338 views

SQL Server cluster instance restarted twice, need help digging through cluster logs

Scenario: two Windows Server 2012 Standard boxes, housing 4 SQL Server 2012 Standard instances (2 active on each node). Housed in Cisco UCS B200 blades and on a Hitachi HUS 110 SAN (all cluster drives ...
2
votes
1answer
399 views

In mongodb cluster, Can I shut down one config server and one data server in the shard at the same time

I have one mongodb cluster, including 3 config servers, and one shard (3 data servers in this shard). One data server and one config server are on the same machine. Can I shut both of them down to ...
1
vote
1answer
430 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 ...
0
votes
1answer
291 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 ...
2
votes
1answer
89 views

Agent service account shows as not clustered

One of the SQL Server 2008 R2 instances I administer is running on a two node Windows Cluster (Windows Server 2008 R2 Enterprise) When I run the DMV sys.dm_server_services, SQL Server Service Account ...
1
vote
0answers
303 views

ComputerNamePhysicalNetBIOS and “Current Host Server” shows different machines

I have a SQL Server 2008 R2 instance on a two node (say names X and Y) windows server cluster (Windows Server 2008 R2 Enterprise). Server Manager on both nodes shows 'X' as the 'Current Host Server'...
1
vote
1answer
60 views

SQL Cluster, AlwaysOn AG, or Something Else? [closed]

I really needs some help with Setting up SQL servers. We are re-configuring our network and have no clue how to resolve our SQL issue. My Network Admin. wants an "Active/Active" with shared storage (...
1
vote
1answer
76 views

Setup MongoDB replica servers with different power?

Is it a good practice to setup replicas with the same machine size (wrt. CPUs, RAM, Bandwidth, etc.) or can replicas be based on smaller machines? One usecase might be to have a small non-voting ...
1
vote
2answers
220 views

How to configure an instance to listen on port 1433 to allow remote connection

Trying to connect using SQL Server Management Studio 2012 on a Windows 8.1 Client computer from outside the cluster's domain. Cluster is a two node Virtual Cluster made from Windows Server 2012 R2. ...
3
votes
1answer
3k views

Multiple IPs registered for listener when using AlwaysOn AGs w/ multi-subnet clustering

We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...
3
votes
2answers
338 views

Change SQL Server 2000 from Active/Active to Active/Passive

I know it's cringe-worthy to use this term, but I have a SQL Server 2000 cluster with one clusetered instance running on it with multiple resources running on one of the two servers in the cluster all ...
0
votes
1answer
46 views

What is exactly a uniform server in a galera cluster setup?

In many manuals about performance tuning and avoid Galera's MySQL cluster limitations they write the below suggestion. It is possible for a slow/overloaded master node to affect performance of ...
1
vote
1answer
612 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
284 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 ---...
3
votes
1answer
586 views

Controlled shutdown/startup of a cluster

My three node SQL Server 2008 R2 physical server cluster needs to be shutdown, moved along with its storage to a new location, and restarted once in the new location. My desire is to have a clean, ...
1
vote
1answer
1k views

MariaDB Galera Cluster wsrep_cluster_address not working

I have configured MariaDB galera cluster with three nodes on CentOS-6.5 64bits: db1 - 192.168.1.111 db2 - 192.168.1.112 db3 - 192.168.1.113 My /etc/my.cnf.d/server.cnf file is configured as follows:...
1
vote
1answer
710 views

What permissions do I need to grant on service accounts on SQL root path when relocating?

During a Win2012 with SQL Server 2012 two-node cluster installation, I accidentally set the system root to be the mount point volume hosting folders for the various attached LUNs for the system and ...
0
votes
1answer
777 views

MongoDB replica set - no election after primary node failed

For testing I killed the primary node of my two-node replica set while the cluster was under heavy write load. I was expecting the secondary node would take over after a few seconds, but this isn't ...
2
votes
1answer
857 views

SQL Server 2012 Install error “The instance selected for installation is already installed and clustered on computer…”

I am trying to setup a new environment for SQL Server 2012 AlwaysOn. I inadvertently used some SQL Server 2008 config files initially to do the installs but ran into too many problems. I un-installed ...
2
votes
1answer
4k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
3
votes
1answer
381 views

Perfmon and SQL Server Clustering

I'll be going onsite to run some performance tests for a client. They have a Windows Failover Cluster, which has a clustered instance of SQL Server. Let's assume for this post that my client's ...
4
votes
2answers
893 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 ...
0
votes
0answers
58 views

Migrate from Percona Cluster to MariaDB Cluster

We are at present running latest version (5.6) of Percona Cluster. Since 5.6 upgrade we are having major stability problems and all minor updates are getting worse. Is there any possibility of ...
0
votes
1answer
188 views

PostgreSQL replication with periodic log shipping

I'm using Windows Server 2008 R2 with 64-bit PostgreSQL 9.2 on both test machines. What I wish to achieve is that one server will be a master and other will be a slave. This is just for tests, finally ...
1
vote
0answers
212 views

Prevent SQL Server failback after cluster aware updating

We have SQL Server 2012 in a two-node cluster with Windows Server 2012 (node and disk majority). Neither of the nodes are marked as preferred owner and the "Prevent Failback" option is selected. ...
0
votes
0answers
638 views

Configuring multiple listeners on SQL Server 2012 through High Availability

We have configured two SQL servers on Azure and they are in HA. There are about 10 databases and we wanted to have two critical ones on one dedicated HA group. The listener worked fine until we ...
3
votes
1answer
2k 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 ...
3
votes
1answer
742 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 ...
2
votes
1answer
2k views

Linked Server and MSDTC on cluster

I'm trying to set up a linked server between two instances we have on our network. I've done this many times before without an issue, but this time I repeatedly get the following error: OLE DB ...
2
votes
1answer
116 views

Temporarily splitting a SQL Server cluster

I currently have a pair of database servers up and running separately, but with the same structure and (hopefully) the same data on both of them. The applications that utilize the data from these ...
2
votes
1answer
285 views

Need scalable database solution for very big automated data entry database

I've been working on MySQL database in simple web applications for a long time and i now have a project which should maintain about 1,000 up to 10,000 query per minute (it is some logging database ...
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
180 views

Setting up my first SQL Server cluster

I've been working with SQL Server for about 6 years and have completed a couple of certification exams so I consider myself reasonably knowledgeable. I am however, about to spec and build my first ...