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
vote
0answers
418 views

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

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
72 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 ...
2
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
37 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
316 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 ...
1
vote
1answer
323 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
378 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
239 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
85 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
269 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 ...
1
vote
1answer
58 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
72 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
208 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
2k 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
333 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
45 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
535 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
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 ...
3
votes
1answer
532 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 ...
1
vote
1answer
650 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
710 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
784 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
3k 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 ...
3
votes
1answer
349 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
852 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
57 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
174 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
205 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
589 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
698 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
114 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
269 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 ...
2
votes
1answer
37 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
176 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 ...
3
votes
1answer
520 views

Complete Failover Cluster Failure SQL Server 2012

We have experienced a full cluster failure on our 3 node cluster running SQL Server 2008 R2 with 7 SQL Server instances. It started when we rebooted one of the nodes and it returned an error: Node ...
3
votes
1answer
453 views

Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?

Or do you have to upgrade every FCI on the Failover Cluster? The documentation doesn't seem to be clear. We have a 7 instances on a 3 node cluster. We want to upgrade only one of the instances from ...
1
vote
0answers
352 views

High Availability in PostgreSQL with automated failover

I am currently working on designing an architecture for High Availability in PostgreSQL for a database of approximately 5TB in size. Also, I would like to re-direct my reads to a slave node(preferably ...
3
votes
1answer
231 views

How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?

The CLUSTER command on a big table can take a long time, and blocks both reads and writes to the table while it runs. I don't need the data in my table to be strictly sorted in index order, I just ...
3
votes
1answer
1k views

Failover Cluster and AlwaysOn Availability Groups across Data Centers

We have two 3 node clusters in separate data centers, let's call them ClusterP and ClusterS. ClusterP is our primary and ClusterS is our secondary for disaster recovery. Each cluster has multiple ...
1
vote
0answers
129 views

Failover cluster connection issue

I'm trying to run SQL Server Failover cluster in Azure. I have NODE1 and NODE2 in a cluster and another SERVER in the same network trying to connect to the database server using the instance from ...
3
votes
1answer
3k views

Problems with clustered DTC server 2008 R2 when failed over or restarted

I had a working clustred DTC, but due to a disk migration, I had to delete the service and recreate it. Thats how the problem started. When I recreate the service, it comes online perfectly. But when ...
0
votes
1answer
544 views

Failover Cluster - Add Witness Disk?

I'm trying to build SQL Server 2012 Cluster on top of Windows Cluster 2008R2. Can anyone please suggest.. do we need quorum disk in setting up SQL cluster 2012 on top of windows cluster 2008r2
3
votes
1answer
505 views

Multi-Site clustering on Windows 2012 for SQL Server 2012

I am hoping someone can point me in the right direction here. We are trying to do a proof of concept for a 3 node multi-site cluster on Windows Server 2012 R2 for our SQL Server environment. There ...
1
vote
1answer
483 views

Min no. of replicas to set up SQL Server Always ON over a Failover Cluster on a Windows Cluster

AO: Always ON FCI: Failover Cluster Instance WSFC: Windows Server Failover Cluster I'm scratching the surface of AO. I currently have one SQL 2012 FCI on a WSFC. Which means one Active node at a ...
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
2answers
118 views

MongoDB Synchronizing multiple Shards

I've got the following layout Picture Cluster RZ West is my first data center A and RZ Ost my second data center B. As you can see one secondary database of each cluster is available in the other ...
3
votes
1answer
515 views

Three Node Cluster that Allows For Two Failures

We are creating a three-node three-instance cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical ...