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
2answers
126 views

Would SQL Server in a Cluster failover if it is running out of RAM

I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running out of RAM (both physical and pagefile). In the instance level settings there is not Max RAM set (set to the ...
1
vote
1answer
114 views

Replicating two PostgreSQL databases without using master db

I'm trying to create a simplest possible db cluster for my application and i'm not sure if that's the best way to achieve that so i'm gonna try to explain my situation the best i can. Im basically ...
1
vote
1answer
312 views

Compare SQL Server high availability method

I want to provide high availability for my SQL Server. It is important that the service is back as soon as possible, more than making sure that data isn't lost. My SQL Server 2008 R2 is running on a ...
3
votes
0answers
449 views

WSREP: failed to report last committed and stop

I have galera cluster and I have 4 nodes. I'm importing some data. however one node gives error. Warning. The warning is; warning WSREP: Failed to report last committed 59102, -q (interrupted system ...
2
votes
2answers
269 views

MySQL Cluster Steps To Recover Data If Catstrophic Failure Occurs

I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that ...
0
votes
1answer
113 views

install Galera but mariadb existing on system

I try to install galera on ubuntu 14.04 system. It has already got mariadb and it's working. How can I install it? my command : sudo apt-get install -y rsync galera-3 mariadb-galera-server it ...
0
votes
0answers
81 views

Galera Cluster crashes because of “ALTER TABLE” statement?

We use on RHEL7 # rpm -qa | grep maria mariadb-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.41-2.el7ost.x86_64 mariadb-galera-server-5.5.41-2.el7ost.x86_64 Do I analyze logs correct that Galera ...
0
votes
1answer
403 views

Rebuild Indexes on SQL Server Standard edition

We have SQL Server 2008 R2 Standard on a Windows Server cluster. I want to defrag all indexes on a database. What is the best approach to disable all connections and allow the rebuild of indexes? ...
0
votes
1answer
207 views

SQL Server does not failback to the primary node

We are running SQL Server 2008 R2 on a Windows Server 2008 R2 two-node cluster. My choice of machine is primary, and the secondary is just a low-end machine for contingency planing. We had a ...
0
votes
1answer
50 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
2
votes
1answer
683 views

Restarting SQL Server Agent on a cluster installation

I've just enabled the mail profile in SQL Server Agent and I need to restart the service for it to take affect but the Agent is running as part of a SQL Server cluster and I don't want the cluster ...
-3
votes
1answer
34 views

Without Quorum Drive.. will it work node1 and node2 in cluster [closed]

Without Quorum Drive.. will it work node1 and node2 in cluster. How it is possible? if not required then where it stores cluster information?
4
votes
2answers
967 views

Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2?

[Cross post from StackOverflow] Brent Ozar published this webcast (slides, video with free registration) entitled "Real-Life SQL Server 2012: AlwaysOn Lessons Learned", in which he repeatedly states, ...
2
votes
1answer
118 views

SQL Server (2014) Failover Cluster Performance with many databases

We are considering implementing SQL failover clustering and I have a question about how SQL Failover clustering works with regards to performance. Specifically, we would have about 1000 dbs mounted ...
1
vote
1answer
108 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
0
votes
0answers
379 views

pgpoolAdmin for pgpool-II 3.4 : superuser: unknown (Connection error)

I cannot start/stop/reload my nodes through pgpoolAdmin and it says "superuser: unknown" even though I'm logged with the postgres account. What could be the cause? pgpool.conf is identical to another ...
0
votes
1answer
64 views

Sql Server 2012 Failover Replica in Synchronous Mode between Primary-Secondary on VPN is very slow

I have installed SQL Server 2012 Clustered HA with Replica in Sync mode between two nodes connected by an high-speed VPN. The DB is encrypted. Everything works fine, but to do the replication, the HA ...
7
votes
1answer
72 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 ...
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 ...
3
votes
1answer
537 views

Load balancing with Windows Clustering and AlwaysOn Availability Groups

I have some questions regarding Clustering and AlwaysON. If I need to build a 3 node cluster - 2 active and one passive. Each node will be 16 CPU and 128 GB RAM. Does this mean that I will have ...
2
votes
2answers
6k views

Creating High Availability Cluster with PostgreSQL

I am new to database design. I have a task to create a high-availability cluster. I Googled a lot, however I haven't found any good way to do this on PostgreSQL. Where should I start and what are ...
1
vote
1answer
525 views

Geo-clustering using SQL Server 2012 Enterprise with AlwaysOn

We are trying to take our current SQL 2012 Enterprise edition 3 node cluster (OS 2012) and add a 4th node to the cluster that will be at another location. And everything I find is telling me to use ...
0
votes
0answers
40 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 ...
0
votes
1answer
207 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?
1
vote
0answers
77 views

SQL Server agent error on a the mirror database

I configured mirroring on one of my databases. The database is in a SQL Server cluster. The mirroring is working great, but all the jobs that set to run fail. The error is: Date 9/10/2015 8:...
1
vote
0answers
38 views

Queries running slower on production (failover cluster) than on homologation env [duplicate]

I have a Windows Server 2012 cluster with two nodes running SQL Server 2012 for production and a Windows 2012 single server with SQL Server 2012 for homologation. I just restored the production ...
2
votes
0answers
152 views

SQL Server Always On Failover Cluster Design

I have two databases. One I'd like to set up in an availability group between two servers (two instances, one on each server). The database is not huge and I'm not expecting it to grow exponentially....
1
vote
1answer
614 views

How can I be sure if MongoDB is doing the balance?

I have the following structure: Two Ubuntu 14.04.2, both with MongoDB v3.0.4 instaled. Both in the same LAN. I want to make them work as a cluster. In the first one, that I call "MC1", I run the ...
3
votes
2answers
974 views

SQL Server Configuration Manager 2012 - unable to set IP All = No

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the ...
0
votes
0answers
29 views

Upgrade MongoDB cluster from 2.4.10 to 3.0.4

I have a MongoDB cluster running on 2.4.10 in production. According to the MongoDB docs, I have to do a step upgrade: from 2.4.10 -> 2.6 -> 3.0.4 For rollback we have to do step rollback: from ...
0
votes
1answer
37 views

SQL Server 2014 - Replica Server not available

I'm new to Sql Server and want to install SQL server alwayson clustering on my test environment. I followed the steps by this site: On each node I can connect to SQL Server but why my 2nd node is not ...
3
votes
2answers
320 views

SQL Server 2012 SP2 update failure

I have been having failures to install SQL Server 2012 SP2 on a 2-node active\passive cluster. I have uploaded detail and summary logs for the latest run on the passive node here: https://www.dropbox....
2
votes
0answers
432 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on VM'...
1
vote
0answers
59 views

Cluster Quorum Voting [closed]

I have a cluster of 4 SQL Servers setup. 2 of the servers are in RackSpace in Chicago. 1 is in Rackspace, in Reston, VA, and one is in our office in Greenville, SC. I want to change the cluster ...
2
votes
1answer
891 views

Configuring Postgres 9.2 streaming replication with Redhat Clustering Suite for High Availability

I'm in the process of configuring PostgreSQL 9.2 streaming replication with Redhat Clustering Suite for high availability. I have 1 master and 1 hot standby configured to replicate the data from ...
0
votes
0answers
415 views

SQL Server Setup The network path was not found (uninstall node)

We have a cluster with 8 nodes. this instance is installed on 2 nodes S141 (active) and S142 (passive) I want to uninstall with the command: Setup.exe /Action=RemoveNode /qs /INSTANCENAME="SQL16" /...
1
vote
1answer
68 views

when can AG primary replica be a different host to WFC primary?

To set up an Availability Group with two servers, the servers both participate in a Windows Failover Cluster. I've seen cases after certain failover modes where the primary IP address in the cluster (...
3
votes
0answers
80 views

PostgreSQL Streaming Replication Tools - Windows

Is there any clusterware available for PostgreSQL clusters running on Windows OS? I'm specifically interested in automatic failover and STONITH functionality. I've done a fairly extensive Google ...
1
vote
1answer
132 views

SQL Server Failover cluster installation fails `RequireKerberos` to value '1'

Hi I am trying to create a SQL Server Failover cluster. Windows Cluster is configured and working as expected but now when I try to install SQL Server it throws the following error: OS: ...
1
vote
2answers
5k views

MariaDB Galera Cluster Replication error, no state received?

I have a very minimal, fresh out of the box setup for MariaDB with Galera clustering. My master node of the cluster is able to run, and is reporting that there is only one node attached to the cluster,...
4
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 ...
1
vote
0answers
822 views

Postgres database zero down time production deployment

I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
3
votes
2answers
3k views

SQL Server cluster questions please

We have SQL Server 2008 R2 cluster active/active/active (a, b, c) and three instances run on this environment. We did a test on one of the instances, and failover test. Manual failover from node c ...
0
votes
0answers
375 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, ...
5
votes
2answers
9k views

Understanding two NICs requirement for SQL fail over cluster

I am trying to make an SQL Server 2012 failover cluster. I have two DB machines. I understand that both machines need 2 NICs each. In my organization the IP scheme assigned is something like 192.168.1....
1
vote
1answer
345 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
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
104 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 ...
1
vote
2answers
201 views

MySQL CLuster SETUP

Good day! About MySQL Cluster, is it possible to set it up on only two machines? Is it advisable? We currently have MySQL replication setup on our two databases, and we would like to implement R/W ...
0
votes
3answers
87 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 ...