Skip to main content

Questions tagged [high-availability]

High-availability technologies mask the effects of hardware or software failure, so that perceived downtime for users and applications is minimized.

Filter by
Sorted by
Tagged with
-2 votes
1 answer
60 views

ALTER AVAILABILITY GROUP in T-SQL not working

I am trying to set up a maintenance job in my SQL Server 2016 database that runs a check to see if one of my secondary nodes is the primary, if it is, I want it to failover to the actual server that ...
Doug's user avatar
  • 1
0 votes
0 answers
17 views

citus high availability setup with patroni

We want to setup patroni HA setup with 3 coordinator, 2 worker node 1 & 2 worker node 2. I am getting system id mismatch when i start 2nd coordinator. First one is running fine, only facing issue ...
jack's user avatar
  • 101
0 votes
1 answer
73 views

Availability group failover-tempdb

Does anyone know if SQL AG will initiate automatic failover to secondary if tempdb is full in primary ? I believe Database level health detection is only for user database in AG
Mario's user avatar
  • 47
0 votes
1 answer
63 views

Will a 2-node windows server failover cluster go down if the disk witness owner crashes?

In a 2 node WSFC where Node 1 owns the disk witness, would Node 1 crashing result in the entire cluster going down (loss of quorum because only 1/3 votes remain)? Or does disk witness ownership ...
Marcus's user avatar
  • 69
0 votes
1 answer
16 views

Why is my 4-node replicaset setup is not working?

I have a 4 Node setup which is being hosted On-Prem by 2 Host Servers (DC1, DC2) 192.168.0.1 - Primary (Located in DC1) 192.168.0.2 - Secondary (Located in DC2) 192.168.0.3 - Arbiter (Located in DC2) ...
JRA's user avatar
  • 149
0 votes
0 answers
200 views

Patroni failed to get list of machines from etcd

I am running a patroni cluster (3.4) on linux with an etcd cluster. Normally the cluster runs perfectly fine but sometimes I get some errors saying Request to etcd server failed (ReadtmeoutError, ...
mymarcelsql's user avatar
1 vote
0 answers
91 views

Configuring 3:1 Failover Cluster for SQL Developer Edition on Windows Server with AWS AMI

We are in the process of configuring a 3:1 failover cluster mechanism for SQL Developer Edition hosted on Windows Server, deployed using an AWS AMI. Our objective is to ensure that if any of the three ...
Rahul's user avatar
  • 11
0 votes
0 answers
35 views

Data Loss and data redeundancy when forced failed over to secondary replica on DR Data Center in SQL Server 2016

We are using SQL Server 2016 Enterprise edition and planning to have 2 datacenters primary and the remote Disaster recovery(DR). We have 2 replicas (primary replica and secondary replica) in the ...
Manoj Jeganathan's user avatar
0 votes
1 answer
58 views

MS SQL 2019 Always on AG - Readable to secondary

I have a 2-node cluster that uses Always on AG, with multiple AGs and databases. All the AGs have the same properties: Connections in primary role: Allow all connections Readable secondary: no I ...
fisken's user avatar
  • 3
2 votes
1 answer
70 views

Getting "PAGEIOLATCH_SH" on a Named Replica of a HyperScale Database in Azure?

I have a monitoring query that populates a dashboard. It was created to monitor the transactions that occur on the primary replica. To avoid overloading the Primary Replica, I created a Named Replica. ...
Heliot's user avatar
  • 19
0 votes
0 answers
37 views

How Does Time Sync Affect SQL Server AG Log Sync?

I'm overseeing an Always On Availability Group (AG) setup in SQL Server, configured with five servers. One server functions as the quorum disk, with the remaining servers designated as primary and ...
Ali varzeshi's user avatar
0 votes
0 answers
51 views

Repmgr installation and primary register

When I run /usr/pgsql-13/bin/repmgr -f /var/lib/pgsql/repmgr.conf primary register I get an error: NOTICE: attempting to install extension "repmgr" ERROR: unable to create "repmgr" ...
Minja 's user avatar
3 votes
1 answer
95 views

Can I use different endpoint URLs for the primary replica in a SQL Server Availability Group?

I am setting up a SQL Server Availability Group with three synchronous replicas within a cluster (one primary and two secondary) and an additional asynchronous replica from another cluster in another ...
Neaj Morshad's user avatar
4 votes
2 answers
820 views

HADR_SYNC_COMMIT waits on SQL Server

Let me preface this post by saying that I am missing a few events from my trace, but I have since added them for the next time this occurs. Lately we have been seeing weird spurts of HADR_SYNC_COMMIT ...
Data Dill's user avatar
  • 245
0 votes
1 answer
101 views

High Availability postgres db cluster with Patroni and Etcd

I am building a HA Postgres db cluster with one master and multiple slaves. Please look at the below points and correct me if I am wrong: For each slave node, I need to use pg_basebackup to sync and ...
Abizer Susnerwala's user avatar
0 votes
0 answers
270 views

Failed to start patroni

I am trying to configure patroni and etcd. Etcd is working fine, but patroni is failing to start. I have 3 servers, I have installed patroni and etcd on each server. When I try to start patroni on ...
Farid Zahidov's user avatar
0 votes
1 answer
164 views

Configuring SQL Server 2019 Always ON between 2 Azure reqions

I have SQL Server on Azure VM which I want to replicate across a separate region. I will only be using 2 servers, each in a separate region. I have the following questions as I need to clear all ...
dennis's user avatar
  • 1
0 votes
0 answers
36 views

What is the risk of deleting millions rows from an offline table?

I'm a junior DBA for a medium-sized company that helps merchants exchange money during sales. Our services operate 24/7, 365 days a year, so performance and uptime is absolutely critical. We have a ...
Hey_Mindo's user avatar
0 votes
1 answer
629 views

Configuring a Failover Cluster Fileshare Witness?

I'm relatively new to high availability groups in SQL Server, and am hoping for a bit of advice on best practices for configuration. I didn't set up this configuration, I inherited it and am trying to ...
fuandon's user avatar
  • 101
0 votes
1 answer
116 views

SQL Server Service Broker on a High Availability Group

I'm using a instance with Microsoft SQL Server 2016 || Enterprise Edition and I need to enable Service Broker for my database with this sentence: ALTER DATABASE DB SET ENABLE_BROKER; The size of the ...
Carolina's user avatar
1 vote
1 answer
354 views

Configuring High Availability for MySQL Router in a MySQL InnoDB Cluster

I've configured a MySQL InnoDB Cluster for high availability with two servers on a Windows system (Server 1: h01xxxxxxxxx1, IP: 10.xxx.xx.61, Server 2: h01xxxxxxxxx2, IP: 10.xxx.xx.71), running ...
alaa's user avatar
  • 11
0 votes
0 answers
60 views

SQL Server 2017 HA Availability Group LSN issue

I ran across a issue I have not seen before and not sure how to correct the issue. We have 2019 SQL setup using HA AV group and the other day I had to recover to a Point in Time but as I was taking ...
tbear58203's user avatar
0 votes
1 answer
25 views

Can a user connect to multiple Basic Availability Groups via listeners?

Assuming multiple, let's say 50, basic availability groups are on the primary replica. Each AG has its own listener. The primary replica goes down, and all the AG's fail over to the secondary. How ...
Marcus's user avatar
  • 69
1 vote
1 answer
382 views

Basic Availability Groups: can each AG share a listener?

What are the potential consequences of using the same listener for each Availability Group when using Basic AGs? Is it even possible?
Marcus's user avatar
  • 69
0 votes
0 answers
205 views

How to temporarily switch PostgreSQL to logical replication to allow major version upgrade without downtime?

We have a PostgreSQL cluster running on one master (db1) and two async hot-standby servers (db2 and db3) replicating from it. All the servers are working as a backend for a web service and all the ...
Mikko Rantalainen's user avatar
2 votes
2 answers
648 views

Why is PostgreSQL data checksums not enabled by default?

According to user comments PostgreSQL data checksums have very minimal runtime overhead (both CPU and storage) but would allow (among other things) using pg_rewind for point in time recovery (PITR). ...
Mikko Rantalainen's user avatar
1 vote
1 answer
248 views

Ola Hallengren's Maintenance Solution script doesn't dump transactional log file to Destination

At one of our client sites, I implemented a high availability (HA) solution. However, during the backup process, I encountered an issue related to backup environment configuration. We had configured ...
kedar's user avatar
  • 23
0 votes
1 answer
157 views

Can not Truncate the database because “secondaries has no log was added”

I am a newbie to SQL Server. I got an error when trying to truncate the database: Database can not shrink until all secondaries have moved past the point where the log was added. When I check the ...
Anh Nguyen's user avatar
1 vote
2 answers
8k views

SQL Server Connection String - MultiSubnetFailover True or Yes?

The MultiSubnetFailover option in database connection strings controls how the client attempts to connect to a database server, especially when multiple IPs are available. There is conflicting ...
Riley Major's user avatar
  • 1,903
0 votes
1 answer
263 views

SQL Sever High Availability - 3 nodes configuration

We have already configured SQL Server High Availability group (Windows Cluster grouping) with 2 different sub nets 10.x.x.x and 192.168.x.x (data center - more than 30 miles away). At present, there ...
user avatar
-1 votes
1 answer
111 views

Remove Databases from HA Group using TSQL - SQL Server

I am trying to automate following steps using TSQL (It is currently working fine using Manual -GUI interface of SQLServer), working on SQLServer 2022 Create a table, with columns to store DBName, ...
Baseer Ul Hassan's user avatar
2 votes
1 answer
308 views

Different query result in SQL Server high availability group's nodes

I have high availability group with two nodes and I ensure they have "synchronized commit" mode. So I assured they are identical in records of tables. A developer reported a bug for ...
Avahita's user avatar
  • 41
0 votes
1 answer
313 views

HA 3-Node Postgres cluster on VMs with Repmgr

We are considering a 3-node Postgres setup where 1-master and 2-standby with replication and master failover handled by repmgr and connection pooling with Pgbouncer. Is there a way to let our ...
Oxycash's user avatar
0 votes
1 answer
1k views

PgPool-II can't find the servers where the databases live (even though the PgPool is on a db server)

PgPool-II 4.3.3 Postgresql 13.9 RHEL 8.6 Postgresql is installed on FOOBARa and FOOBARb, and data is successfully being stream replicated from a to b. Then I installed PgPool-II on a, and configured ...
RonJohn's user avatar
  • 647
0 votes
1 answer
210 views

Galera WAN Clustering use case, having remote nodes performance impact is not clear

In official doc Galera Use Cases for the 2nd, WAN Clustering use case I am reading the following: "Synchronous replication works fine over the WAN network. There will be a delay, which is ...
g.pickardou's user avatar
0 votes
1 answer
429 views

Galera cluster performance, node count, and where to write?

As far I understand Galera does not scale write performance, best case it does not degrade it, compared to one single server, so we use Galera for HA. (read performance may benefit and it can be load ...
g.pickardou's user avatar
0 votes
2 answers
127 views

SQL Server Always On - security updates without DB disconnecting from application

Our real-time communication application relies on database access, and it cannot be disconnected from the DB when running. Recently our customer’s DB maintenance team notified us that the DB will be ...
user avatar
0 votes
1 answer
148 views

How to reliably restore slave to master in MySQL Multi Source Replication?

I have multi source mysql replication setup configured, so I have this big server which act as a slave to other smaller server. The setup looks similar to below. Everything is working fine— until one ...
Liso's user avatar
  • 103
1 vote
0 answers
217 views

Multi master with some slaves vs single master with some slaves

I need some advice on architecture. I have a national database that relies on postgres and some architectural design that involves orchestrating several components, very much similar to the picture ...
padjee's user avatar
  • 187
0 votes
1 answer
615 views

how to make PostgreSQL-13 slave node as read-write once primary node is down

I have two servers in master-slave configuration format. They are in streaming state and synchronization state is "Sync". I also used "repmgr" to make them as a cluster in primary ...
Diwakar SHARMA's user avatar
0 votes
1 answer
391 views

Does further partitioning a MariaDB table require downtime?

I need to add partitions to an already partitioned table, the table has RANGE partitions by year(timestamp), but the previous admin stopped partitioning awhile ago. Now the table has grown to 4.1 ...
Fernando Pérez's user avatar
1 vote
2 answers
447 views

what after WAL LSN value of type pg_lsn reach its limit

I am trying to determine the optimal Standby for automated failover based on the highest value of pg_last_wal_receive_lsn() of all slaves. But what if max_wal_size is reached, does pg_lsn values go to ...
Lucky Shofar's user avatar
0 votes
2 answers
681 views

Can I change the password of the domain account which I used to create the failover cluster?

Can I change the password of the domain account which I used to create the failover cluster? Will it affect the cluster at all? I have also created the Always On availability groups using that domain ...
user avatar
0 votes
0 answers
26 views

Oracle Accessing Data from Two Databases Transparently

Our Oracle version is 19c We have a need to split our data into two separate databases. Most recent data will go into DB_1. Older data will go into DB_2. We do have Webserver tier. One options is to ...
oradbanj's user avatar
  • 141
0 votes
1 answer
223 views

Oracle DataGuard between 11.2.0.4 (primary) and 19c (physical standby)

Our production database is on 11.2.0.4. It needs to be upgraded to 19c. Can I setup physical standby which is at 19c and keep it in sync with primary ? Thereafter - during a weekend maintenance, the ...
oradbanj's user avatar
  • 141
0 votes
1 answer
87 views

How to extend Distributed availability groups to another datacenter

Actually I have a Distributed availability groups with SQL Server 2016 configured like this: The endpoint are configured like this: USE [master] GO CREATE ENDPOINT [endpoint_istance2] STATE=...
user_0's user avatar
  • 1,023
0 votes
2 answers
5k views

System/database design for comments/replies and upvotes at scale

Recently I started discovering a topic around "How to design db schema for storing structures similar to Instagram/Facebook/Reddit comments?". After extensive research, I was able to find a ...
IDobrodushniy's user avatar
-1 votes
1 answer
866 views

Replication from a secondary in a high availability group

We have a couple of servers in a SQL Server HA group, one acting as primary and the other as secondary. This system is working fine and fails over as expected (though this is very rare). However we ...
blobbles's user avatar
  • 1,621
0 votes
1 answer
186 views

SQL 2019 High Availability Stored proc issue on secondary server

I've just upgraded my High Availability environment from SQL 2017 to 2019 version 15.0.4236.7 I have same SQL Agent Jobs on both servers with a initial clause to determine if the job should run (if ...
Tomasz's user avatar
  • 186
-2 votes
1 answer
462 views

SQL Server High Availability Dashboard comes up blank when accessed. Is there a fix for this?

Recently whenever I access my SQL Server High Availability Dashboard, it comes up blank and I am not able to see the databases and the synchronization between the servers. Is there a solution to ...
user avatar

1
2 3 4 5
10