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
1answer
34 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 ...
2
votes
1answer
171 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 'G:\SQL_DATA1\MSSQL10_50....
1
vote
0answers
35 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
1answer
139 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
68 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
0answers
21 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 ...
3
votes
1answer
48 views

Keeping service up while taking drive offline in clustered instance

I have clustered instance with two (2) data drives on it. Drive J has around 50 databases on it and drive K has about 15. One of the system administrators was trying to increase the size on K by 20 GB ...
0
votes
1answer
40 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
1answer
152 views

Multi Subnet Availability Group IP Requirement for Windows Failover Cluster

Does the Windows Failover Cluster for a multi-subnet SQL Server Availability Group require a static IP entry for each subnet? The instructions I am finding for a Failover Cluster Instance (FCI) in a ...
0
votes
1answer
311 views

Difference installing SQL Server 2014 on stand alone vs. VM Cluster [closed]

I have installed SQL Server many times on standalone servers with DASD and SAN storage allocated to it. We have a new Hyper-V Virtual machine Cluster set up for us by a third party IT shop. I am ...
0
votes
1answer
49 views

Adding more space + bandwidth to a MongoDB cluster

I've read a lot about sharding and have gone through cluster setup process as well. What I can't get my head around is the actual database capacity after its sharded. So say for instance I have one ...
1
vote
2answers
123 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 ...
1
vote
0answers
58 views

SQL Server 2008 R2 service pack steps …on cluster

I have a sp3 to apply on SQL Server 2008 R2 on windows 2008 R2 cluster with four nodes and 6 instances. Node 4 do not have any resources but is possible owner for all the instances. Steps I am ...
0
votes
0answers
41 views

Problems with MariaDB - won't resync nodes - Can we build a good diagnostic set of instructions?

I have a 3 node ubuntu server MariaDB cluster using rsync, which keeps coming un-synced. When it happens I try to add it back in, reboot, and try again, try again with bootstrap... Recently I've found ...
1
vote
0answers
101 views

Error adding Database to TSA Cluster - db2haicu

I'm testing TSA Clustering using two test servers. It's replicating our production environment. I'm using two nodes shared disk topology. When running db2haicu, I am getting the following error in ...
0
votes
0answers
70 views

mariadb error transaction deadlock

I use galera cluster with 4 nodes, mariadb, we insert nearly 12million data. Insert task was finished. However we have lost 11000 data. I don't know where they go. In error log it writes; 151220 17:...
2
votes
0answers
50 views

PostgreSQL on Cluster

question - I'm working on a project that involves heavy computation and will continually grow in terms of the database it works with. I want to build a small cluster (NUCs I'm thinking) the run a ...
1
vote
1answer
43 views

SQL Server FCI online with incorrect file path

I just encountered this strange issue with my SQL FCI yesterday. Windows 2008 R2 and SQL 2012 - 2 nodes FCI SQL server/ SQL agent resources are online and working as normal, but the system databases ...
3
votes
1answer
86 views

Can SQL Server 2012 FCI have multiple names?

Is it possible to have multiple names for the same SQL Server Failover Cluster Instance (virtual server)? IT has a naming convention they like, but it hard codes the Windows cluster name into the SQL ...
1
vote
0answers
156 views

Is is possible to convert SQL Server from single instance to failover clustered node?

If SQL Server 2014 Enterprise has already been installed, can it still be converted/added to a failover cluster? Specific scenario - Amazon EC2 instance of Windows 2012 + SQL Server 2014 (license ...
2
votes
1answer
158 views

Change port number for SQL 2012 Cluster

I have been trying to change the port number of a SQL 2012 cluster with little success. I had thought that I could just do this the same way as normal through configuration manager however, even with ...
2
votes
1answer
77 views

Is it possible to have a SQL Server cluster with Hadoop?

I know how Hadoop works. Is there any possible way to have SQL Server run under Hadoop to build a cluster based on SQL Server and not Drill or Hive. Just a wild question. Any good tutorial/...
0
votes
0answers
38 views

Galera 3 node cluster - force an online state transfer without downtime on existing node

We have 3 node Galera cluster. On node 3 I wish to force a state transfer. We have out of sync issues, because table was MyISAM. Now InnoDB. Howto do that? Delete data files and restart? The cluster ...
1
vote
0answers
37 views

SQL Server Installation in a 2 node cluster

I'm installing SQL Server 2014 in a cluster for the first time, and am running into an issue. Environment: x2 Windows Server 2008 R2 - with a load balancer in front Steps so far: Have the IP's ...
1
vote
1answer
80 views

Log shipping 2008 r2 SP2 server to a 2008 r2 SP3 CLUSTER

We have recently configured one database to be replicated with log shipping in production, using SQL Server 2008 R2. We have up and running more than 150 database replicas without any problems. But ...
0
votes
1answer
201 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 ...
1
vote
2answers
124 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
355 views

SQL Server failover cluster installation fails on primary node

I'm trying to install SQL Server 2014 fail-over cluster, but the installation fails with following log i have tried a lot of things but without any success.. The installation failed with following ...
1
vote
1answer
112 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 ...
3
votes
0answers
440 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 ...
1
vote
1answer
309 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 ...
0
votes
1answer
110 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
80 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
390 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
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
674 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 ...
0
votes
1answer
203 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 ...
-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?
3
votes
2answers
109 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 ...
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
376 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 ...
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 ...
3
votes
1answer
529 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 ...
1
vote
1answer
513 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 ...
1
vote
0answers
75 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
150 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
603 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 ...
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 ...