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
0
votes
1answer
79 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 ...
1
vote
2answers
762 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 ...
3
votes
2answers
109 views

SQL Server 2017 Distributed Availability Groups

My Environment is SQL Server 2017 Distributed Availability Groups, details as follows: Configured SQL Distributed AG from DC1 to DC2. DC1 (Production): TEMPDB1 AND TEMPDB2 (HOSTED ON WSFC1) DC2 (DR)...
0
votes
1answer
22 views

MongoDB multi-datacenter deployment and shard keys

I am trying to check my understanding after reading docs and some older questions, so my question is quite loaded: In a sharded cluster, each shard should (and as of 3.6 must?) reside on its own ...
0
votes
1answer
26 views

SQL server Log Shipping

I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can ...
0
votes
1answer
31 views

How to stop all nodes on FCI SQL server?

My Setup: We have two nodes SQL setup with Active/Passive Windows Failover Cluster instance. My Goal: To stop the running SQL Server service on the active node and prevent failover from happening for ...
0
votes
0answers
18 views

Removing a Windows Server Cluster Node and Then Adding Back - Do I need to remove the Availability Group replica?

We had a secondary server bite the dust... we were remarkably able to resurrect it. Everything is great and intact... except for the windows server cluster configuration. We basically need to evict it ...
0
votes
1answer
84 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?
2
votes
1answer
656 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
0
votes
1answer
740 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
1answer
242 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
2
votes
1answer
39 views

SQL Server Assembly on Failover cluster after Framework update

We have database that relies on a CLR assembly. The assembly references other assemblies. After a Windows Framework update we need to drop and reinstall the assembly to have it work. Now the issue is ...
0
votes
1answer
215 views

Automatic MYSQL failover

We have a wordpress environment however this is not a wordpress question. Our scenario is that front Ends connect to a MYSQL backend (MYSQL VM1) which is replicated to a backup vm (MYSQL VM2). The ...
2
votes
2answers
4k views

Lease Timeout VS HealthCheck Timeout - AlwaysON

After all the reading this is what I understood. Is it correct? LeaseTimeout is a simple heartbeat between SQL Server resource DLL and the SQL Server instance. HealthCheck Timeout is related to ...
0
votes
0answers
18 views

SQL DR Availability Group cluster validation failure

I'm new to DBA out of necessity at work so please explain or point me in the right resources if you see anything I ask below is wrong: I'm trying to setup a test environment for Disaster Recovery ...
0
votes
1answer
26 views

Why do we still need VIP when using SCAN?

When we are using Single Client Access Name (SCAN), the clients connect to the database through the SCAN name in DNS or GNS like in the example below: stackdb = (DESCRIPTION = (ADDRESS = (...
0
votes
1answer
41 views

Increase TempDB Files, Shrink VLF's with FCI

I am planning to resize and increase the number of tempDB files and shrink the VLF's on an FCI. In this case, the tempdb files are stored on the network drive, rather than the local disk. I couldn't ...
0
votes
1answer
93 views

MySQL Create Index Semantics: Clustered vs. Nonclustered?

I'm new to databases and specifically MySQL, so pardon me if this is a simple question. I'm trying to make sense of what happens with MySQL when I call CREATE INDEX. I know that primary keys are ...
0
votes
1answer
418 views

Postgres-XL adding GTM Proxy seems to do nothing

I've set up a Postgres-XL cluster using this recipe: GTM: hostname=host1 nodename=gtm Coordinator: hostname=host2 nodename=coord1 Datanode1: hostname=host3 nodename=datanode1 Datanode2: hostname=...
0
votes
2answers
30 views

Multi-instance 2-node SQL Cluster - do instances need their own disks?

I currently have a single default instance of SQL2017 Standard on a 2-node cluster. Against my preference, I need to setup a second instance on the cluster (the new database requires some users to ...
0
votes
1answer
168 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
14 views

How to restart an installation of Oracle grid 19c

I would like to know how to perform an installation after trying a previous installation that gave an error. During the installation of the grid in a RAC 19c I was given an error almost finishing it ...
0
votes
1answer
16 views

Availability Group: Is it possible not to do automatic failover for particular groups?

We've got two Windows Server 2016 with SQLServer 2016 on AWS EC2 instances (node 1 and node 2) Because we're using a standard edition, we're limited to having one database per availability group. ...
1
vote
2answers
1k 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
10 views

Can PostgresSQL cluster have synchronus and asyncronus standbys at the same time for the same dbs?

In this question, Write concern in PostgreSQL Laurenz Albe explained how to control the set of standby servers when data is committed to PostgresSQL, and that gave birth to another question. What if I ...
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 ----...
0
votes
2answers
685 views

Is MySQL Cluster just for in-memory databases?

In MySQL website I see below definition for MySQL Cluster. MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. I want to use Clustering for a ...
3
votes
1answer
266 views

SQL Server 2014 EE not using all available processors

First of all let me apologize for not being clear on my requirements in my original question. I am now updating my question with my current scenario: I have few existing SQL 2014 Enterprise Edition ...
1
vote
1answer
1k views

How to update SQL Server 2005 clustered instances?

We have a 3 node cluster with an instance running on each. Windows 2003 R2 32bit (16GB) / SQL Server 2005 I want to bring them all up to build 9.00.5266 (SP 4 + CU3) (1 Node is already updated) The ...
0
votes
1answer
34 views

Multi-Subnet Always On with Availability Group for DR [closed]

I researched a lot of mutli-geographical DR - Disaster Recoververy solution architectures for MSSQL and most of the proposed solutions I came across recommends HA using 2 nodes Failover clustering in ...
3
votes
1answer
8k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
1
vote
1answer
5k 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 > ...
0
votes
0answers
17 views

Why won't node-1 restart successfully on my 4-node MariaDB Galera cluster, but the others will?

I setup a 4-node Galera cluster on the following platform: CentOS 8.1.1911, with MariaDB 10.3.17 and Galera 3.26. Galera config: wsrep_cluster_address="gcomm://192.168.10.47,192.168.10.48,192.168.11....
1
vote
1answer
29 views

64 Availability groups max on SQL STD : Failure when attempting to create a new NetBIOS interface while bringing a resource online

I was patching our DB Servers this morning and encountered a really strange error when failing over some Availability Groups : In our environment, we are running a somewhat unconventional setup, but ...
5
votes
1answer
774 views

How to Achieve Concurrent Write Transactions to MySQL Group Replication in Multi-Primary Mode

I've set up a MySQL "cluster" (four CentOS 7 servers running MySQL 5.7.19) using Group Replication in multi-primary mode, but I can't get it to accept writes from more than one thread at a time. This ...
2
votes
1answer
51 views

Can you create a clustered DB in Azure using Windows 2003 and SQL Server 2005?

We need to replicate an environment in Azure, running a clustered DB. The current physical environment is running on Windows 2003 and MS SQL Server 2005 R2. We know that there's no OS/DB support but ...
0
votes
0answers
11 views

Mongo DB Cluster activesessions skyrocketing

I have a forked instance of mongod running with the NUMACTL options right now. It is handling 40k - 50k updates per second without issue. I tried migrating this to a sharded cluster and started ...
0
votes
1answer
18 views

Removing AG and clustering - make nodes stand-alone

I am wanting to make a 2-node Always On cluster no longer a cluster (make them (2) stand-alone machines). I am trying to upgrade Sql and the wizard keeps getting stopped before it does it checks ...
0
votes
1answer
95 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?
4
votes
1answer
461 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 ...
1
vote
1answer
40 views

How not to have SQL Server to restart on the same node but failover on 1st failure in a cluster

By default SQL Server tries to restart on the same node in case of a failure, next it does failover. Personally I am good with the default behavior , but I am being asked a interesting question - is ...
0
votes
0answers
24 views

How does sql server FCI respond to failure?

Taking windows role default settings - (n-1) failovers ok within 6 hrs , where n=# of nodes, if nodes = 2, 1 failover within 6 hrs is allowed. Taking resource default settings - Within 15mins period, ...
0
votes
3answers
106 views

Need to configure Availability Groups between three different SQL failover instance

We have total 6 Nodes and 3 failover cluster (Each with two node). Cluster1.TestAD.com(Node1,Node2) - SQL Failover Instance (SQL1) - 1 TB Shared storage Cluster2.TestAD.com(Node3,Node4) - SQL ...
0
votes
1answer
692 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
26 views

Sql server error message “the database is read only” in a remotely server - availability database

I have a failover cluster with a high availability sql server service, the problem is that I cannot create a table, update, delete remotely even if I already give specific permissions and i had ...
0
votes
1answer
74 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 ...
1
vote
0answers
74 views

SQL server availability group cannot access database after disabling sql service

I've completed this setup: OS: Windows server 2016 Database: SQL Server 2017 2 node availability group configured with automatic failover on both nodes. Fileshare witness configured, both nodes ...
0
votes
0answers
44 views

Preferred owner failover change in FCI

I've inherited a few Windows servers with SQL Server installed. Some of them are in failover cluster which is perfect in case of outages. However I do not have much experience with SQL Server ...
0
votes
1answer
143 views

AlwaysOn database not synchronizing/recovery pending due to cluster loss quorum

I have this error in cluster event 'Cluster node 'MMPDB1NEW' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to ...
2
votes
1answer
93 views

Snapshot Folder Location for Replication with Clustered Instance

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...

1
2 3 4 5
13