Questions tagged [clustering]

A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.

126 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
100 views

PostgreSQL partitioning vs. using multiple DBs

I'm building a DB that will have several tables partitioned into 64 partitions. Although I'm using PG 10, I'm using the inheritance method as I need greater control over each table than what is ...
1
vote
1answer
4k views

SQL Server Cluster Service Online Pending Status

I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > ...
1
vote
0answers
110 views

Could not find subkey System\CurrentControlSet\Services\MSSQLFDLauncher$INSTANCE_NAME

I am getting the following error when attempting to add a node to an existing SQL Server 2016 Clustered instance on a Windows 2012 R2 Server TITLE: SQL Server Setup failure. SQL Server Setup ...
1
vote
0answers
2k views

MultiSubnetFailover option not supported on one server?

I have a SQL Server Cluster with Availability Groups. I connect to that server from a Windows 2012 R2 server with PHP 7.0.18 and Apache using ODBC and PHP ODBC Drivers. I have two Windows 2012 R2 ...
1
vote
0answers
548 views

Could not fail over Always on AG to DR ones Prod was down - Help!

Set-up: Prod-HA-DR - SQL 2012 SP2 Prod-HA Synch, DR Asynch Databases are distributed on Prod and HA equally like Active-Active Instances. PROD-HA in Datacenter A DR - In Datacenter B Scenario: This ...
1
vote
1answer
42 views

Setting up a SQL Server cluster for the first time, some questions!

I am a SharePoint architect but looking to implement AOAG with SharePoint in an Azure lab environment. I'm building the first node in a cluster and I'm a little confused: I have my cluster object ...
1
vote
0answers
752 views

SSAS 2012 role fails to start in a Win 2012 cluster

I started a thread in MSDN SSAS Forum. Please see this and help me understand the problem. I have never seen this sort of issue before. I'll try to explain the issue here as well. I got SQL Server ...
1
vote
2answers
960 views

SQL Server 2016 - Configuration Manager WMI Problem

Background: Windows Server 2016 Core SQL Server 2016 Enterprise (obviously 64-bit) Windows Failover Cluster SQL Failover Cluster I am attempting to connect to SQL Server Configuration Manager via my ...
1
vote
1answer
37 views

migrating from one SQL cluster to another cluster

I have 2 existing SQL clusters. Both 2008 R2. Each have unique instance names. Server1\inst1 ServerA\reports. We are decommissioning Server1 cluster and need to migrate DBs over to ServerA\reports ...
1
vote
0answers
332 views

Services Cannot Connect to Multi-Subnet Availability Group After Failover

We have a two-node SQL Server 2014 AlwaysOn Availability Group that spans multiple subnets. We also have two proprietary services on the same cluster role as our AG. We decided to put them on the same ...
1
vote
0answers
284 views

Quorum Questions For An FCI And AlwaysOn in a WSFC

I was reading the white paper on FCI + AlwaysOn as well as several other resources on quorum voting differences in Windows Server 2008 and 2014 and had 3 questions. 1- Will giving a node in the ...
1
vote
0answers
9 views

2 Cluster managers Control same 2 nodes and control OLTP traffic?

can you have two cluster managers controlling the same 2 nodes so that you can achieve real time replication but still direct your oltp traffic to one node and your reports to the other node?
1
vote
0answers
363 views

Firewall Rules, IP address failover cluster

We are having issues with some applications running and connecting to a failover cluster through a firewall (not Windows firewall). In the firewall settings we configure the IP addresses from the ...
1
vote
0answers
44 views

2 SQL Clusters & 2 instances

Can anyone tell me why i wouldn't want to the architect Option 1 for SQL Server clustering? Option 1 is having 2 different clusters, and 2 different named instances on 2 VMs. One's Active is the ...
1
vote
0answers
690 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 ...
1
vote
0answers
57 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
0answers
244 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
1k 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
2answers
1k 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 ----...
1
vote
0answers
652 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 ...
1
vote
0answers
223 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
331 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
44 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
223 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 active/...
1
vote
0answers
684 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
1answer
667 views

MongoDB cluster deployment

I am new to MongoDB. I am trying to deploy a MongoDB cluster. I am following: https://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ I initiated Config Server Replica Set and after that I ...
0
votes
0answers
12 views

Neo4j cluster - kubernetes, helm - no load to replicas

I have neo4j in kubernetes cluster deployed via official helm chart, core stateful set works fine, but when readonly replicas are deployed, there is no load to them. Anyone was already solving this ...
0
votes
0answers
10 views

Cassandara ec2 Number of Nodes and autoscale for increasing 70Gb of Data

I am beginner in Cassandra, I currently have 72 GBs of Data that is growing and i will have approximately 1gbs inserted into database daily. How can i decide number of nodes in the cluster and how ...
0
votes
0answers
16 views

Not able to add a node into windows failover cluster

I had two node cluster but due to disk corruption one node was removed. After maintenance when second node came back we tried to add it into the cluster but getting exception. I checked the even log ...
0
votes
0answers
59 views

mysql 8 innodb clustering - adding instance fails with error “Unknown database 'mysql_innodb_cluster_metadata'”

I'm setting up my first mysql innodb cluster, following the instructions here: https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html I've configured the instances ...
0
votes
1answer
44 views

How to setup a SQL Cluster between 2 sites in active passive mode without shared storage

we need to install SQL at 2 sites, 1 primary and 1 DR. We don't to pay for license for the DR and need to know how will we setup a SQL cluster/replication/alwayson/bag or any other method that will ...
0
votes
0answers
12 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
0
votes
1answer
263 views

HA PostgreSQL installation using patroni and pgbouncer

I'm not having a problem yet, just searching for advise I want to build installation of PostgreSQL on 3 nodes using patroni: master and 2 standbys (for failover only). There are PostgreSQL and ...
0
votes
0answers
28 views

Configure Availability Group in SQL Server 2016

Can you tell me how you add the second node as the replica to the AG? I am using this feature on AWS instances, I have followed all the steps as shown in different videos, but when I try to add the ...
0
votes
0answers
140 views

Sync PostgreSQL with Cloud and multi Local Locations

I need help with a complex (for me) multi server setup with PostgreSQL. I have to setup a Cloud Server and 3 Local Servers for our company. Each Server will have: Linux Ubuntu 16.04 Docker ...
0
votes
1answer
49 views

Availability Group Upgrade 2012 to 2016 Data Move

I'm working with a team to upgrade a four node AlwaysOn Availability Group from SQL Server 2012 to 2016. Two of the nodes are local and two are in Azure. The database holds a large amount of data (2 ...
0
votes
1answer
181 views

EventID 1196 | SQL Cluster & FailoverClustering

I have Pre-Staged the SQLCluster objects, since login had no Domain admin rights. Later SQL Cluster installation completed successfully.(Also tested with failover and failback).It is working fine till ...
0
votes
0answers
20 views

mysql cluster with 1 master 1 node and 2 slave

My Query is I want to set up MySQL cluster with 1 Master 1 Node and 2 Slave with Auto failover. If my master is down node should assign slave as a master. Can anyone suggest me an idea to do that? As ...
0
votes
0answers
145 views

SQL Server error 19456 when adding the listener

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error ...
0
votes
0answers
127 views

Moving tempdb from shared to local drive in a failover cluster

We have an existing failover cluster that I would like to have the tempdb in local drive. I'm not sure how to proceed. My thought process is below: Create two drives on each node one for tempdb and ...
0
votes
0answers
51 views

Cleaning up the environment on old cluster after migrating to newer SQL Server cluster

We migrated many instances of SQL Server 2008/R2 on Windows 2008R2 and 2012 on Windows 2012 to newer Windows 2016 with SQL Server 2014 and 2016 versions. The old clusters were configured with either ...
0
votes
1answer
62 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
0
votes
0answers
88 views

Remove node from failover cluster without access to said cluster or domain

I have a server running Windows Server 2012 and SQL Server 2008 R2. The server used to be part of a SQL cluster but it is now standalone and no longer has access to the cluster. I want to repurpose ...
0
votes
1answer
181 views

MySQL Cluster - Data Node Restarting when database corrupt

I initially Have MySQL cluster with 2 Management and 2 Datanode. I added 2 Data node online and redistribute its data. So my current cluster setup is 4 Management Node + SQL and 4 Data node. There ...
0
votes
1answer
339 views

Log Shipping failover when Primary is not accessible

Log Shipping Failover I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible. My Steps for failover will be 1) Copy ...
0
votes
0answers
55 views

Create HA PostgreSQL cluster

We want to set up a highly available PostgreSQL cluster in our production environment. As of now, We have set up streaming replication. But we have to manually promote the slave as the master in case ...
0
votes
0answers
81 views

Expanding Cluster Drive space

I will need to expand my existing cluster drive (sql cluster with 2 node active and passive) which has sys and user database data files. My san admin told he will need to delete all the existing data ...
0
votes
1answer
61 views

SQL Server Failover Cluster Scalable by adding nodes?

In the book Pro SQL Server Always On Availability Groups They write about scalability. Here is what they say Windows Server 2012 (and above), failover clustering supports up to 64 cluster nodes. ...
0
votes
0answers
1k views

Availability Group Lease Timeout: what is causing 100% CPU utilization and lease time outs on PRIMARY replica?

We have an availability group Replica-01 (Sync on-premise) PRIMARY Replica-02 (Sync on-premise) SECONDARY Replica-03 (Async Azure VM) SECONDARY Replica-01 is sometimes having lease time out and ...
0
votes
0answers
573 views

Adding Azure VM as 3rd node to the 2-node On-Premise Windows Server Failover Cluster - Problem

We have 2-node WSFC, which is hosted on-premise in our datacenter This WSFC is running one clustered role which is SQL Server Availability Group Node-1: Windows Server 2016 - two subnets - 192.168.7....