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.

Filter by
Sorted by
Tagged with
2
votes
1answer
159 views

SSRS is missing after failover to other node

We have 2 node setup cluster, after a failover I can't see the reporting services, even the service it self is missing. I checked control panel program manager, SSRS is not installed, I open ...
5
votes
2answers
1k views

Is it safe to run a Windows Failover Cluster Public and Heartbeat on a Single NIC?

I have a 2-Node Windows Failover Cluster (Windows Server 2016, SQL Server 2017) with a Quorum Disk Witness on fibre-connected shared storage. How important is it that the heartbeat is on its own ...
1
vote
2answers
203 views

SQL Server 2014 Standard FCI Does Not Failover

Have a peculiar case where a previously working FCI, after installing a large backlog of Windows updates, is now failing often and not failing over. On occasion, and this appears to happen around ...
1
vote
1answer
32 views

Can I add 1 primary node in existing cluster?

I have a 2 node windows 2012 cluster and SQL Server 2012 installed on both. In this I have added a database on nodeA as primary and one on nodeB as secondary. I want to add more 2 databases which will ...
1
vote
0answers
399 views

clussvc.exe consuming high cpu

We have a 4 node cluster running 2 SQL Failover Instances. Windows 2012 Standard & SQL 2014 Microsoft Failover Cluster Service has been consitently between 25 - 30 % CPU. This is happening on 2 ...
0
votes
1answer
36 views

MySQL clusters - sync a table [closed]

I've been developing a software that runs on hardware and now I need to synchronise DB on them, but only partly - several tables using MySQL Clusters(don't matter which style), each of hardware can ...
0
votes
0answers
85 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
177 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
321 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 ...
2
votes
0answers
2k views

Cassandra - High Number of Dropped Mutations (Specific Table on a specific Node in the cluster)

History Leading to this issue: My Compression strategy in Production was LZ4 Compression. But I modified it to Deflate For compression change, we had to use nodetool Upgradesstables to forcefully ...
2
votes
1answer
51 views

Log Shipping with Failover Cluster Server Cores

Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014 Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014 My question is if I need to log ship do I need to match the ...
1
vote
1answer
304 views

Why configuring automatic failover for SQL availibility group feature on sql failover cluster instance not allowed

I have set up an availability group where a primary is standalone server and replica is SQL failover cluster. This setup allows me only manual failover and when ever I try to set it automatic in FCI ...
0
votes
2answers
71 views

Growing MySQL NDB Database. How to get High Availability?

Since last 2 year, we were using NDB Cluster for live database of our app, which is now have size of 7-10 GB, running on 6 Dedicated servers (6 data node, 2 api node, 1 mgm node) to have get maximun ...
0
votes
1answer
612 views

Can auto failover cause split-brain? (SQL AlwaysOn)

I have been studying Cluster voting and AlwaysOn failover. The topic of split-brain comes up and sounds terrible. This following from Microsoft seems to indicate that only a person with SA, doing ...
0
votes
1answer
39 views

Cassandra - reinserting a node

I had to remove a cassandra dead node on a hurry (because an important script with a truncate query wouldn't work due to consistency level reasons -- any thoughts on that would be nice too). Anyway, ...
0
votes
0answers
54 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
1answer
57 views

SQL 2008 Cluster Install, “Cluster shared disk Availability Check”

I am trying to setup a new sql server 2008 cluster, on windows 2012R2, and the installer is failing on the cluster shaed disk availability check. I have verified that there are 5 disks assigned to "...
1
vote
0answers
510 views

MySQL InnoDb Cluster Replication Issue

I am trying to setup MySQL InnoDB Cluster. I am using version 5.7.20 of the MySQL server. I am able to create a cluster. When I try to add the first slave is when I run into my issue. It complains ...
0
votes
0answers
72 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 ...
1
vote
1answer
858 views

SST not starting on a new node on MariaDB Galera Cluster

I have two MariaDB servers I want to use to create a new MariaDB Galera Cluster: Server mysql1, with some data and configured as a donor Server mysql2, with no data and /var/lib/mysql empty, which I ...
2
votes
1answer
958 views

Unable to Force a WSFC Cluster to Start Without a Quorum

I was testing a three node AlwaysOn availability group cluster. SQL Server is on Node 1 and I powered off Node 1 and Node 3 simultaneously. The cluster lost its quorum and appear to be down. I ...
0
votes
1answer
62 views

Log Shipping back up location to a network share instead of clustered file share

Below is my current cluster set up Node 1 - Active Node 2 - Passive While doing Log SHipping can I save the back ups to a network share instead of a clustered file share? The service account ...
2
votes
1answer
631 views

Upgraded to SQL Server 2017 and now see WSFC lease timeouts

I recently upgraded a production DB environment from SQL Server 2016 Standard Edition to 2017 Enterprise Edition (CU3). We used a Basic Availability Group when on Standard Edition and recreated the AG'...
1
vote
1answer
124 views

Cluster Validation on Remote Node

I have a 3 Node always availability group: 2 Nodes are In house – Synchronous Mode. 1 Node is remote - Asynchronous Mode. Every now and then the Remote Node loses connectivity and goes offline ...
1
vote
2answers
43 views

High Level SAN Migration Strategy. Is this a good idea?

In the company I work for we are planning decommissioning an old SAN serving our production servers Which are 2 Nodes running 2 SQL Server instances using Clustering (one is the backup for one ...
2
votes
4answers
2k views

Log Shipping or Always on as DR for SQL Failover CLuster

Which is easier to maintain as Disaster Recovery on a remote site for a 2-node SQL Server Cluster Log Shipping Single Instance of Always on Availability Group Instance. Any suggestion will be ...
1
vote
1answer
476 views

MySQL InnoDB cluster pricing

On https://www.mysql.com/products/community/, the InnoDB Cluster is listed as part of the MySQL community edition, but when clicking the "Download MySQL Community Edition" link and further, I end up ...
0
votes
1answer
81 views

Log Shipping with Clustered Instance- back up

Current Set up- Clustered Instance Active/Passive Node -1 Node -2 Current Back ups goes to Network Drive Cluster Drive E drive Virtual Name ABC Shared Folder - e\Share New instance- for Log ...
0
votes
2answers
520 views

SQL Failover Clustering with Availability Groups: Single or Multiple Databases

Company wants to implement AlwaysOn SQL Failover Clustering with Availability Groups, for server level and data protection. Are arrangements below, only possible if 1 database is on the server, or ...
0
votes
1answer
59 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
1answer
467 views

Migrate from SQL 2016 Failover Cluster to Availability Groups

We have a 16 node SQL 2016 failover cluster with around 20 SQL instances and total number of databases around 600. Since we are upgrading our hardware to Hyper-Converged infrastructure which has ...
2
votes
2answers
16k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 “No such file or directory”) when configuring cluster

I have 3 MariaDB nodes. Want to configure cluster. Specified in gcomm:// in my.cnf ips of all members in cluster according to this. And added ?pc.wait_prim=no at then of gcomm://ip1,ip2,ip3 Then ...
5
votes
2answers
4k views

AlwaysOn AG versus FCI

Throughout MS documentation for AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) I see the following pattern: FCI is for HA scenarios. An AG synchronous secondary ...
1
vote
1answer
413 views

SQL Always on availability with failover and mixed authentication

I have 2 boxes running SQL Server 2016, and set up using Always On Availability. I have a listener set up to choose which server to talk to in case of a failover, which seems to work fine, except for ...
1
vote
2answers
143 views

Mixing 2 and 3 node AG on a single WSFC?

I have a 3 node availability group (Enterprise 2014), it is multi subnet, with two data centers and file share witness in a third data center. There are about 20 "production" database that exist on ...
1
vote
3answers
648 views

Can you run two WSFC instances on two servers where each node is the primary for a different availability group?

I'm drawing up a proposal for upcoming infrastructure changes. This will include a production server and reports/data warehouse server, each with Always On. To keep hardware and licencing costs down, ...
0
votes
1answer
172 views

I can't add an extra node to mariadb cluster 10.1

I was installing a test mariadb cluster but I have a problem when I want to add an extra node. Both nodes use Red Hat Enterprise Linux Server release 7.3 (Maipo) These were the following steps: On ...
2
votes
3answers
2k views

Preparing a cluster installation fails at Setup Support Rules Step (Not Clustered or the cluster service is up and online)

Today I was trying to install a SQL Server 2008 R2 Cluster environment on Windows Server 2012 R2 servers and after doing all the necessary steps to prepare the cluster (like Creating an iSCSI Virtual ...
2
votes
1answer
12k views

Cluster network name resource 'Cluster Name' failed registration

I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
2
votes
2answers
600 views

MongoDB Cluster - Can't access member of shard with credentials

I have a Sharded Cluster and I am trying to access a specific member of a replica set within a shard. When connecting to the mongos it is fine, but when using the same credentials on a member of the ...
1
vote
1answer
997 views

AlwaysOn AG: Current Host Server - Owner Node - Primary Instance

I'm building up a SQL Server AlwaysOn AG and I'm on the step "failover", manual and automatic: I noticed that in the Windows Server Failover Cluster a "Current Host Server" exists. My knowledge says ...
2
votes
3answers
2k views

SQL Server Cluster: There is no SQL Server failover cluster available to join

I have set up a SQL Server 2016 Standard cluster (Cluster-SQL) on node 1 (Cluster-Node-1) which is appearing in Windows Failover Cluster manager without issue. When I attempt to add a second node (...
2
votes
1answer
603 views

File share witness vs 3rd Node for WSFC + AG with only 2 nodes?

I am migrating from Mirroring to AGs on SQL Server 2014 / Windows 2012 R2. I will have a 2 node cluster. I need this cluster to be online at all times for a production environment. I am reading ...
0
votes
0answers
120 views

Just use WSFC without Always On Failover Cluster Instance? [duplicate]

There was some unanswered questions about the difference between "Windows Server Failover Clustering" and "Always On Failover Cluster Instance". From MS document: A Windows Server Failover ...
2
votes
2answers
579 views

In 2-node cluster using failover with Dynamic Quorum, is Witness needed?

I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum. There is one thing that made me confused: do we really need a Witness in this case? Since ...
1
vote
1answer
929 views

Use Windows 2016 Storage Replica for SQL Server failover cluster instance

We have two standalone servers with local storage. Based on our needs we have determined that we need to use AlwaysOn failover cluster instances. Can we use the "Storage Replica overview" feature of ...
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
1answer
895 views

SQL Server Standard Edition Failover Cluster Installing Windows Updates

i have a question concerning the installation of sql server updates on a sql server 2012 standard edition failover cluster. For example a service pack installation. Is it possible to install the ...
1
vote
0answers
96 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 ...
0
votes
2answers
2k views

Always on Failback

Does always on supports automatic failback like sql cluster? Since the preferred owners and possible owners are controlled by the AG how can a particular node be set as preferred primary when failback ...