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
2answers
42 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 ...
2
votes
1answer
1k 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
17 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 ...
0
votes
1answer
85 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
55 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
34 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 ...
0
votes
1answer
38 views

Cannot start MySQL Cluster Management Service

Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid= on command line. This is what EventViewer is saying
0
votes
1answer
679 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 ...
4
votes
0answers
28 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 ...
3
votes
0answers
2k views

Event 4104, MSDTC Client 2

I have an Active/Active Sql 2008 R2 cluster that I monitor with Idera Sql Diagnostic Manager. It just started reporting that one of the instances does not have DTC or Sql Server Agent installed. I've ...
2
votes
0answers
29 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
120 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 ...
2
votes
0answers
951 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 ...
2
votes
0answers
240 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 ...
2
votes
0answers
109 views

Are there any best practices before moving SQL Server to another node (controlled failover)?

Let's say there are multiple jobs running on the SQL Server - we have index maintenance jobs, backups, replication, etc. We would like to perform a switchover using Failover Cluster Manager. Are there ...
1
vote
0answers
152 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 ...
1
vote
0answers
90 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
0answers
185 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, ...
1
vote
0answers
124 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. ...
1
vote
0answers
81 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 ...
1
vote
0answers
190 views

MariaDB Galera Cluster

I have two mariadb servers in cluster that is working galera and xtradb. it is my primary server configuration: [mysqld] datadir=/var/lib/mysql query_cache_size=0 binlog_format=ROW ...
1
vote
0answers
578 views

SQL Server Configuration Manager 2012 - TCP/IP, 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 ...
1
vote
0answers
558 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 ...
1
vote
0answers
36 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
1
vote
0answers
2k views

High availability PostgreSQL 9.3 server on Windows

I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
1
vote
0answers
85 views

Upgrade/migrate a Microsoft Cluster

We currently have active/active windows 2008 cluster hosting 2 instances of SQL 2008 R2. We have a new hardware for windows 2012 clustering. We want to use this new hardware to upgrade the ...
1
vote
0answers
466 views

How to shut down clustered SQL Server 2008 R2 with NOWAIT?

Is it possible to shutdown with nowait on a clustered instance? I want to delay recovery to when the instance starts, and I want to shut down as quickly as possible without issuing checkpoints to my ...
1
vote
0answers
181 views

Error in alter table reorganize partition for MySQL Cluster

My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition. Some parameters of ...
1
vote
0answers
47 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 ...
0
votes
0answers
31 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, ...
0
votes
0answers
17 views

What is the sequence to enable the authentication in mongodb cluster without stopping the service

Assume that the cluster is running with authentication disabled. There are one mongos instance, 3 config servers, and two replication sets. each replication set has 3 mongod instances. My order is ...
0
votes
0answers
23 views

mysql sharding techniques

I have developed one website for social network and I have used mysql for data storage. Now a days, many tables become a very huge (2-3 tables has 30 million records & 3-4 table has 300k records) ...
0
votes
0answers
48 views

Query to Find Cluster Nodes for an Instance

I need a way, using T-SQL, to find the nodes available to a SQL instance. I have 3 nodes in a cluster running several instances of SQL Server, each instance is 2012 Standard and so can only be ...
0
votes
0answers
33 views

Filestream on a SQL Cluster during failover sits at 'Pending Recovery'

We have an application using FILESTREAM storage which is also hosted on a SQL cluster. Unfortunately, when we fail the SQL cluster over between say, node 1 and node 2, it works on one node, but when ...
0
votes
0answers
80 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 ...
0
votes
0answers
102 views

Oracle 11g xe replication/cluster free license?

I am new to db clustering/replication and I want to set up a cluster/replication of a database backed by t2 nodes. I used docker and spun up a preconfigured oracle 11g xe database ...
0
votes
0answers
58 views

Mirroring via dedicated NIC between two multi-instance clusters

Scenario: Two node SQL Server 2012 cluster in Primary Site. Two node SQL Server 2012 cluster in DR site. Both sites connected via general MPLS network. Replication line available between the two. ...
0
votes
0answers
71 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 ...
0
votes
0answers
20 views

SQL nodes in MySQL Cluster

I running mysql cluster in windows 8.1 on 3 machines 2 mngmd 2 sql node 3 data nodes in the first machine I tried to connect MySQL server with localhost and tried to put my old database it ...
0
votes
0answers
40 views

Understanding flow control in MariaDB Galera Cluster?

I am not clear how node state changed. What is the different between node state: JOINED, SYNCED, DONOR/DESYNCED, CLOSED, DESTROYED. These are all state I see in log. I am using MariaDB Galera Cluster ...
0
votes
0answers
29 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
0answers
318 views

Cassandra cluster on Windows Machine

I am new to Cassandra, and have been trying to create a cluster using DevOps. When I add a node , I get the following error: Error provisioning cluster: Unable to SSH to some of the hosts ...
0
votes
0answers
298 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 ...
0
votes
0answers
207 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 ...
0
votes
0answers
236 views

Create a high availability cluster configuration PostgreSQL for Windows

I want a server to be replicated, here is the scenario: When my primary server goes down or fail I want the secondary or the standby server to take over, I'm using Windows 7 for the primary server, ...
0
votes
0answers
203 views

How to setup a Postgres-xc streaming replication with master-slave(for HA)?

Can you guys please help me about how to make streaming replication with master-slave configuration using Postgres-xc to confirm an HA environment? Thanks
0
votes
0answers
373 views

PostgreSQL: Slave doesn't replicate the Master's data

I'm using PostgreSQL 9.2.3 on both computers, both of which run Win2008R2. I've setup streaming replication by following this guide: ...