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
2answers
38 views

Restoring secondary backup files on primary server in sql server

I want to restore log backup file on copy-only full backup in restoring mode on primary replica server these backups were taken from secondary replica but it was error when they are restored on ...
0
votes
2answers
42 views

Migrating from old AlwaysOn Availability Group to new AG cluster but keep ip addresses

We want to migrate our SQL Server 2012 on server 2012R2 to SQL Server 2019 on server 2016 and keep the ip addresses but change hostnames. i can not change the name of listener and ip addresses from ...
0
votes
1answer
16 views

MariaDB run a new cluster while keeping an old cluster running

I currently have a 5-cluster mariadb galera set up. Two of the servers are in the cloud while three of them are locally hosted. I kinda want to start the three on premise servers to act as a separate ...
0
votes
1answer
16 views

Does a read-write-split on your galera cluster still make sense when running the servers on the same (private) cloud environment?

I know about the claims that a Galera cluster should/might perform better in a lot of cases whenever a read-write-split is set up, so there are dedicated read and write hosts in the cluster. This ...
0
votes
2answers
49 views

3 Node WFCS - How to automatically FO to DR?

I am planning to implement a two-node Windows Server Failover Cluster (WSFC) for SQL Server Always On Availability Group in our main site, and the third node in our DR site. All application clients ...
0
votes
1answer
46 views

Can Availability Group be configured in a below structure?

I have Production and DR clusters as depicted on a picture below. My question is whether there is a way to configure Availability Group from datacenter1 to datacenter2? I tried to configure regular ...
0
votes
1answer
21 views

Does AOAG needs a Windows failover cluster?

I'm reading some windows docs about AOAG and I got confused: Always On availability groups, the high availability and disaster recovery solution introduced in SQL Server 2012 (11.x), requires Windows ...
0
votes
1answer
45 views

Any idea what Virtual Machine Cluster WMI is for?

We have a Windows Failover Cluster to host our SQL Server Availability Group. We have a resource that popped up that no one recalls creating named "Virtual Machine Cluster WMI". We have ...
0
votes
0answers
21 views

Procedures to safely perform SQL Server Always On database cluster failover during Updates & Patching?

I need some steps and guidance, to perform the Microsoft Cluster Failover (MSCS 2016) for my SQL Server 2017 Enterprise Edition – Always-On 2x nodes. This is to perform the Windows Server updates that ...
1
vote
1answer
100 views

SQL Server 2017 AlwaysOn Failover Cluster issue

I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2. there is no any running backup (SNAPSHOT) PROD : 10....
0
votes
1answer
47 views

How to Tune MariaDB Database System With Right Parameters

I have a MariaDB Galera 3-Node Cluster as the DB system but since I built, it is working with the default parameters. I only changed the parameter as max_connections=3000. It has been about 6 months ...
0
votes
1answer
126 views

Intermittently failover of my SQL Server resources on Windows Server 2016

I have 2 Windows 2016 VM's running on Vmware ESXi VMware ESXi, 6.7.0, 17700523 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2016. Basically everything is pointing ...
0
votes
1answer
80 views

Can I try SQL Server BIG Data Cluster for free?

I can not find information about test SQL Server Big Data Cluster in a development environment. We have some AKSes and would like to try installing SQL Server Big Data Cluster. Is it possible to do it ...
0
votes
0answers
21 views

Where Should I Install Galera Load Balancer? On Cluster Nodes?

I want to install Galera Load Balancer for my 3-Node Galera Cluster, but where should I install the galera load balancer? Can I install on the cluster nodes or should I build a new server for galera ...
0
votes
2answers
238 views

SQL Server 2019 Always On - Ensure that cluster name object (CNO) is granted permissions to the Secure DNS Zone

I have here a SQL Server 2019 Always On with a lot of errors like this one: 2 nodes configured in a cluster with file share witness. Cluster name: SQLCLS Listener name: SQLLSN Event: Cluster network ...
1
vote
0answers
79 views

What is the minimum hardware requirements for SQL Server Big Data Cluster?

I am in process of making POC and would like to test SQL Server Big Data Cluster solution. My first idea is to host it on my local computer and test it but I am not sure If it possible. In found ...
0
votes
1answer
41 views

Can we add FCI to AG or a single instance from FCI to AG?

I am exploring FCI and AG. In FCI we can have 2 nodes that share the same SAN storage. And failover results in the other node starting up. Where as AG is for a set of dbs. This question is about the ...
0
votes
2answers
65 views

Always On Failover Cluster Instances (FCI) on existing SQL Server

I have launched three EC2 Windows_Server-2019_SQL_2019_Standard instances. How can I implement Always On Failover Cluster Instances (FCI) on these existing SQL Servers. I can only find details like ...
0
votes
0answers
21 views

How to setup Network in Desired State Configuration for SQLSetup - Action = "InstallFailoverCluster"

I am looking to setup the network addressing correctly. Configuration SQLInstall { node localhost { SQLSetup 'InstallSQLClusterNode1-2019' { Action = 'InstallFailoverCluster' . . . ...
0
votes
0answers
59 views

Why is the FILESTREAM data not accessible, after AG listener is created?

I'm having a hard time figuring out why my app can't access filestream data, after we enable AG listener. Background info: Initial environment: APP Server Web Server IIS Windows Server 2012 R2 DB ...
0
votes
1answer
218 views

SQL Sever Alwayson - Increase the WSFC failover threshold

Im trying to simulate the Failover in my SQL server 2017 alwayson by stopping and starting the SQL server service. It worked 2 times, but after that, the failover is not happening, It showing an error ...
0
votes
0answers
28 views

Has anyone used a Windows Failover Cluster with SQL Server FILESTREAM FileTables and experienced any major issues?

Has anyone used a Windows Failover Cluster with FileTables and experienced any major issues? We're doing a proof of concept of this architecture with Windows Server 2019, SQL Server 2019 Standard ...
2
votes
0answers
35 views

mySQL cluster with Active Active DC

Let me give you a bit of background before jumping into the discussion. Our company is running two DC's in active active scenario, we spent a lot of money on getting specialized hardware to be ...
0
votes
0answers
46 views

Creating a new SQL Server Instance in a Failover environment

I am having a real hard time trying to create a new instance for a database using SQL Server 2019 Failover cluster. I am trying to follow these directions. I am stuck on Step 10 which is Instance ...
1
vote
1answer
94 views

Rollback options for a one-way SQL server AlwaysOn - rolling upgrade SQL server + Windows OS upgrade

We are thinking about an upgrade of our Windows 2012 R2 + SQL server 2012 failover cluster and AlwaysOn availability group. Microsoft has guidelines for the SQL upgrade and for the failover cluster ...
0
votes
0answers
37 views

Why MongoDB Shard becomes slow in data insertion over larger amount data inserted?

General We generate about 10GB of records each day. Each record is composed of four columns: id,A,B,C. The column id must be unique but will be never queried. Columns A,B,C must be indexed (or some ...
0
votes
0answers
16 views

Unable to add new instance on MySQL InnoDB cluster - "Segmentation fault"

My InnDB cluster got damaged, I dropped the metadata of all three nodes using dba.dropMetadata() and recreated the cluster again with dba.createCluster() and bootstrapped the mysqlrouter. Now, when I ...
3
votes
1answer
116 views

Why putting SQL Agent offline caused WSFC to fail over on passive node?

I have 2 node Windows Failover Cluster with Quorum disk. SQL agent is NOT a resource of the cluster. I needed to enable service broker on the server; for that I need to set SQL Agent offline, run tsql ...
0
votes
0answers
29 views

Remote Nodes is not detecting in cluster validate configuration in sql server 2019

I am not a professional DBA. In my organization, we are trying to implement active active node always on clustering. We have 2 nodes, primary and secondary. After installing WSFC, and during ...
2
votes
2answers
139 views

How does SQL Telemetry get installed on a server?

Can someone help me please? How is SQL Telemetry different from Microsoft Error Reporting that you get during a SQL install? I installed a successful SQL 2016 FCI instance, verified the installation, ...
0
votes
1answer
24 views

Windows clustering in Azure VM (Windows 2012 R2)

I am going through this document to build a SQL Server Always On cluster. I read through this page to understand why we need a load balancer in Azure for the listener to work. That brings me to this ...
0
votes
0answers
45 views

SQL Failover Cluster instance questions

We have just installed a SQL 2016 FCI that is giving errors that we are still working on. My questions are: Apart from normal SQ Errorlog and Failover Cluster Manager Cluster events, are there any ...
0
votes
1answer
55 views

Troubleshoot SQL FCI

I have just installed a Failover Cluster Instance (FCI) which was running ok. I then had to change the service accounts that the services were using and for some reason that I haven't been able to ...
0
votes
1answer
2k views

How to resolve Cluster account permission issues

Can anyone advise please? I am in the process of creating a SQL 2016 SP2 SQL FCI. The WSFC was created by the server team and handed over to me. I ran the cluster configuration validation tests and ...
0
votes
0answers
32 views

The best way to install and uninstall (multiple times) sql server failover cluster instance

On my test environment I have WSFC with 2 nodes. For testing purposes I have to install and uninstall sql server failover cluster instance multiple times. What I do to uninstall: In media folder I go ...
1
vote
1answer
91 views

Why sql service is still running after uninstalling failover cluster instance?

The installation of sql server failover cluster instance didn't go well. So I decided to remove whatever was installed and reinstall it again. To to uninstall sql failover cluster instance went ...
0
votes
0answers
99 views

Postgres major upgrade with repmgr

I have a three node cluster pg_version 10, i'm trying to upgrade it to pg_version 11. Also, that cluster is managed by repmgr 10, which should also be upgraded to version 11. I have followed after ...
0
votes
2answers
188 views

Testing WSFC failover puts secondary replica in RESOLVING mode

I have 2 locations and each has its own WSFC. Cluster 1: WSFC,Datacenter1, Node1, Node2. Listener1 Cluster 2: WSFC, Datacenter2, Node3, Node4. Listener2 Created an Availability group as EXTERNAL ...
0
votes
2answers
113 views

Connect two Percona XtraDB Clusters in two data centers

I have been trying to figure this out the past couple of weeks. We used to have a five-host Percona cluster at different providers. When it started acting up I read that it is a bad idea to have ...
0
votes
1answer
54 views

How to configure Always ON High Availability on this infrastructure?

I have SQL 2017 Enterprise Edition What would be the best way to set up High Availability in the below infrastructure? Datacenter 1 WSFC and FCI: Node1, Node 2, Shared Storage Datacenter 2 WSFC and ...
0
votes
0answers
140 views

SQL Server Failover Cluster Instance - how to get the vip for the virtual network name

I am configuring a SQL FCI for the first time. The WSFC will be configured by the server team and handed to me to install and configure SQL FCI over the 2-node cluster. In the installation steps, I ...
0
votes
2answers
62 views

Why choose SQL FCI over Database Mirroring

I have SQL 2016 Standard Edition to install and configure a HA/DR solution. I need automatic failover in a cluster of two nodes. I am proposing SQL FCI over database Mirroring for the following ...
1
vote
0answers
54 views

Windows Failover Cluster/Availability Groups - Issues because all servers of one site where unreachable

we had some issues because of maintenance and hope someone can explain what happened. Our cluster looks like this: Site A: Node A1 (Quorum vote) Node A2 (Quorum vote) Node A3 (Quorum vote) Node A4 (...
2
votes
1answer
134 views

What happens to application in-flight transactions in an SQL Failover Cluster Instance?

In a SQL Server FCI configuration, what happens to transactions that are in flight when the failover event happens? 1. If the transaction is committed just before the server crashes 2. If the ...
0
votes
1answer
75 views

Is there a SQL Server HA Configuration that is similar to Oracle RAC?

Please is there a SQL server High Availability configuration that is similar to Oracle RAC with respect to scalability? In Oracle RAC, in order to avoid overloaded resources, application requests can ...
1
vote
1answer
51 views

Is it possible to join MySQL 8.0 to a cluster of MySQL 5.7

I have a MySQL 5.7 (5.7.19-17-57-log Percona XtraDB Cluster) cluster using Galera, but I am in the middle of upgrading to 8.0 -- 8.0.23-14 Percona Server (GPL), Release '14'. I wasn't sure if it was ...
1
vote
2answers
600 views

Improving sql query execution time for 3 billion rows table

I have a 2+ billion row mysql table. I am also writing 1 million rows each day. The table contains some large columns like varchar(255) (to hold long urls) In order to perform analytics on this table ...
1
vote
1answer
94 views

Still can't create an AAG listener

I just built a test cluster with 2 MS SQL Server 2014 machines, 1 domain controller, an 1 file share witness. (All of them are Windows2016-based.) The 2 MS SQL Server machines are a WSFC members. When ...
0
votes
1answer
32 views

Sql failover cluster issue with different edition setup ( enterprise with standard)

I have come across one client who has setup like this where dba has installed sql server 2014 instance with enterprise edition setup on node1 and on node2 he has added mssqlserver 2014 in failover ...
2
votes
0answers
481 views

MySQL/InnoDB cluster unable to reboot

I have a three-node MySQL/InnoDB cluster (version 8.0.25), that has been deployed by Juju/OpenStack a couple of month ago. The cluster has recently crashed and I unfortunately can't manage to bring it ...

1
2 3 4 5
14