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
0
votes
1answer
12 views

Removing router from MySQL InnoDB cluster

Currently I have configured 3 node MYSQL InnoDB Cluster with two routers. Is it possible to remove one of the router from cluster? what are the implications ? using cluster.listRouters() I could see ...
2
votes
1answer
54 views

Availability groups across sites: what happens if severs can't contact each other but both still can reach file share witness?

I'm currently planning a new SQL Server 2019 Enterprise Edition setup with HA/DR, possibly with availability groups. Let say we have the following setup: Site A: one SQL Server instance (SQL1) Site B:...
-1
votes
0answers
13 views

Postgres High Availablility multi-master replication on kubernetes

I'm trying to implement an multi-master replication on Kubernetes for Postgres database with High availability. If anyone tried this, Please help me I tried multiple ways, which are available in ...
0
votes
2answers
47 views

When queries start executing on standby server the replay lag starts to increase

I have a two servers with following specs: 8 vCPU, 32768 MB RAM, 640 GB SSD The master Postgres 13.3 database (db1) is installed on first server (Ubuntu 16.04.7) with the following config: ...
2
votes
3answers
87 views

Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?

We have a few Basic Availability groups in production and I've been reading about the limitations of them. I'm concerned about the following limitations: No backups on secondary replica. No integrity ...
1
vote
1answer
51 views

SQL AAG Cluster - Diagnosing Partner Quorum Failure

Recently we had a failure of our SQL Server (2016) Always On Availability Group, where our fileshare witness node was briefly inaccessible to our two nodes due to a CPU spike. We have two SQL server ...
0
votes
1answer
41 views

HADR Availability Group long sync time

I have the following problem / challenge: We operate an HA SQL cluster with several Availability Groups. In order to take full advantage of the load balancing, I redirect the SQL selects to the ...
0
votes
0answers
32 views

High Log Send Q in AG server

We have 6 SQL Server cluster all are part of AG, 1 is primary server and 5 are secondary read replicas. We are facing issue with High log Send Q size for specific database, we have 5 database in AG ...
-1
votes
1answer
16 views

What is the equivalent of on prem ha dr solutions in the azure cloud PaaS and SaaS?

On prem ha dr solutions are: Log shipping Mirroring Replication FCI AG What is the equivalent of each of the above in the azure cloud PaaS (azure sql managed instance) and SaaS (azure sql ...
0
votes
3answers
57 views

Is there any sql ha dr solution that allows write to multiple servers?

I am looking for a sql ha dr solution that allows users to write to multiple replicas. Is this possible in sql server? For example: AG allows read from multiple replicas. But write only to primary ...
0
votes
1answer
39 views

Configure cluster on an existing SQL Server - to setup AlwaysOn Availability Groups

We are already having an SQL Server Enterprise Edition instance running on an Physical Server. Now to configure AlwaysOn Availability Groups Can we configure WSFC (Windows Server Failover Cluster) ...
0
votes
1answer
112 views

SQL Server always on servers reboot

I have the below set up for availability group : Always on configured in SQL Server 2017: Primary is read write and secondary is read only. Both primary and secondary are configured with asynchronous ...
3
votes
1answer
93 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 ...
1
vote
1answer
30 views

Always On with multi AGs primary on each replica - Any gotcha's?

I have a bunch of Always On clusters that I manage and am really comfortable with them. I have one client who is running an Always On cluster with 2 replicas. They have 4 AG's that each have their ...
0
votes
1answer
38 views

Automatic Failover for Basic Availability Group

This will be my first project with Basic availability group so I thought would check before implementing . As per Microsoft documentation below it says we will need to have Software assurance for ...
1
vote
1answer
73 views

Implementing reconnection behavior for SQL Server always on availability group listener

I have an SQL Server 2019 Cluster with a high availability DB. I set my .NET 5.0 (using Entity Framework) app to connect to the listener, expecting that if the cluster fails over, things would just go ...
0
votes
1answer
43 views

How can i get AG dashboard values via SQL Query across all supported versions of SQL server

I am trying to ease the monitoring of availability groups across multiple SQL servers. Came across few dmvs which got me the data. But cannot figure out some important columns which i am seeing in ...
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 ...
1
vote
1answer
76 views

LISTENER_IP = ALL not working

I try to create an endpoint specifying to listen on any IP: CREATE ENDPOINT [Hadr_endpoint] AS TCP ( LISTENER_PORT = 5022, LISTENER_IP = ALL ) FOR DATABASE_MIRRORING ( ...
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 (...
1
vote
1answer
138 views

Estimated recovery time and REDO queue size related to DB up time

Can someone help me figure out if my understanding is correct on the below: On the AG Dashboard for my readable secondary replica I see: Estimated recovery time (secs) - 4598 REDO queue - almost 24 ...
0
votes
0answers
35 views

SQL Server: Always On Availability Group: getting Error: GetAccountToProcess failed: Cannot open database requested by the login. The login failed

When myself and our SA are testing our AO group, we are running a script that flows data into a table so we can monitor proper data. We are pointing this at our Listener: TestDBAG01, and it flows into ...
0
votes
1answer
34 views

what databases are already set up in the log-shipping, and which ones are not?

I am setting up log-shipping from server1 to server2. there are many databases on server1 and I want to automate the process. I have already done a few databases manually, while I am working on the ...
0
votes
1answer
42 views

Why does the secondary server not failover?

I hope someone can help. I will try to summarise as best as I can. We have four servers in a cluster with an AG set with Database Health Detection. Three servers are on site1 with the fourth on a ...
0
votes
0answers
42 views

Why is FCI not considered to be a DR solution? [duplicate]

FCI is said to be an HA solution. If one node crashes, it spins up the 2nd node so why is it said to not be a DR solution? There was a disaster at node 1 and node 2 picked up from there. Isn't that ...
0
votes
1answer
44 views

HA options for a VLDB

We have 2 VLDB's - 6TB (primary db, not much OLTP traffic) and 4TB (archive db). Data will be moved/archived (delete from primary and insert to archive) daily from 5 large tables. Currently this ...
1
vote
1answer
54 views

pacemaker and semi-synchronous replication

In the company I work we use a simple setup of a Primary-Secondary replication. Should the Primary break down for whatever reason, we do the switch manually. This also means, that MySQL hardly ever ...
2
votes
0answers
46 views

Alwayson fn_hadr_backup_is_preferred_replica takes a long time to return results

Our 2 nodes full sync mode Alwayson cluster has 20 databases which allocated into 4 different AG groups (9, 6, 3, 2). We set backup preference as on 'preferred secondary'. Find out that ...
0
votes
0answers
37 views

Multi-Master Replication / Mysql Slave Replication from Multiple Masters with Same Schema Names

Requirement:: Between two datacenters (DC, DRC) databases should be seamlessly replicated withstanding the datacenter failures. Both the data centers will be having on-premise servers. DC - Primary ...
0
votes
0answers
47 views

PostgreSQL Slave unable to catch up with the Master

We have a four node Patroni cluster setup wherein one of the nodes is unable to catchup with the leader because of huge lag. I have tried the below steps but none of them are working. Restart the ...
0
votes
0answers
11 views

always-on availability group readable secondary disconnected

I have AOAG that hosts many remote sites ( more than 10 each has its own databases) databases, in a centralized data center the customer required if one site disconnected from that centralized ...
1
vote
1answer
120 views

SQL Server Always On AG – Is a Passive Secondary Required for Automatic Failover?

It is my understanding that for automatic failover to occur in an Always On AG environment, the replicas just need to be configured with "automatic failover," "synchronous commit" ...
3
votes
1answer
1k views

Buffer Pool scan took 10 seconds error

Using SQL server 2017 (14.0.3381.3) with Always On High Availability environment. Getting error:"Buffer Pool scan took 10 seconds: database ID 8, command 'CHECKPOINT', operation 'FlushCache', ...
1
vote
0answers
60 views

SQL Always on Availability Groups Direct Seeding

Setting up a new SQL cluster and HA using SQL Availability Groups. SQL 2019 STD 2 Node Multi Subnet Basic AG Primary Node AWS Secondary Node VMWare on premise I am using the newer Automatic Seeding ...
1
vote
0answers
198 views

What are the available automatic failover solutions for MariaDB Master-Slave replication on Windows Server?

I am setting up a Master-Slave or Master-Master setup in MariaDB on two seperate servers running Windows Server. I also need to configure an automatic failover solution where client read requests gets ...
0
votes
1answer
24 views

Does listener gets affected when we replace secondary replica with another server in Availability Group?

I have created Multi Subnet Always On Availability Group. Now, I need to replace secondary replica with another server in Availability Group. In this case, Do I need to re-create listener? OR The ...
0
votes
1answer
31 views

what will cause a sql server AG readonly replica to stop serving readonly clients?

I understand that if a failover happens (among any nodes in an AG), then all nodes lose their existing connections. And I assume that if a primary suspends data movement, that will have no effect on ...
2
votes
2answers
141 views

behavior of a Sql Server availability group listener and a jdbc client during a failover?

i have a question about the behavior of the AG listener during a failover... when the failover happens, I realize that all the connections on both primary and secondaries are closed. if the client ...
0
votes
0answers
76 views

Archiving with hot standby streaming replication log shipping is not working

I get the following error message in my postgres logs: >LOG: archive command failed with exit code 1 >DETAIL: The failed archive command was: (ssh postgres@backupdb.com "test ! -f /var/...
0
votes
0answers
36 views

repmgr Hot Standby Replicatiom Postgresql 12.0

I would like to ask you about how to change Asynchronous Replication to Synchronous Replication ? I have 1 Master and 2 Standbys. That's 2 Standby is Asynchronous , then I want to make 1 Standby as a ...
0
votes
2answers
108 views

Can I use SQL Server Standard Edition as Primary and Enterprise SQL Server as Secondary node?

I have Software Assurance for SQL Server Enterprise Edition and I need to setup High Availability on it. The issue is my primary SQL Server has a Standard license. Could I add SQL Server Enterprise ...
5
votes
2answers
452 views

Availability Group - how much data was lost after forced failover

Let's consider a SQL Server AlwaysOn cluster with two nodes in asynchronous replication. Is there any way to calculate how much data was lost after forced failover? I mean in terms of time, to be able ...
0
votes
1answer
366 views

Why availability group resource goes offline in WSFC?

Sometimes I find the AG Cluster role in offline state which results the AG in resolving state. It doesn't allow the application to access the databases during this time. And then after sometime it ...
2
votes
1answer
570 views

How does Automatic Seeding work - Always On Availability Group

I found only these two statements from BOL regarding this Initial Data Synchronization method: Link 1 Automatic seeding uses the log stream transport to stream the backup using VDI to the secondary ...
0
votes
1answer
185 views

log_reuse_wait_desc - AVAILABILITY_REPLICA Unable to truncate transaction log

I have just 1 secondary replica and just one database in my availability group. Both Primary and Secondary replicas are in synchronous-commit availability mode. I inserted 1000 records into the table ...
0
votes
1answer
215 views

Repmgr : It automatically promotes to new master but other standby stopped

I'm trying to setup postgre with repmgr and here is the rsult The scenario is, i tried to spinup 1 primary and 2 standby. then i stop the primary so the postgres-2 got promoted. Unfortunately the ...
1
vote
2answers
110 views

Availability Group Listener and old client software

We've got a multisegment AG Listener named SQLAGL01 which points to these two addresses: 10.143.162.32 (the primary server) 10.140.165.32 (DR server) Because the 3rd party (which means we can't fix it,...
1
vote
2answers
209 views

Avoid downtime of Microsoft SQL Server during restarts

We are running an SQL Server Standard 2016. From time to time Microsoft updates need to be installed and the server will be restarted. We have been asked to look into keeping the database available ...
0
votes
1answer
43 views

Postgresql AutoFailover

I am having Java Application with Two nods in cluster however I have Postgresql 1 Master Database server and 3 nodes in Hot-Standby Mode. Problem: Since DB is a single point of failure, every time ...
0
votes
1answer
318 views

PostgreSQL CPU 100% after configure Wal log shipping hot standby

I have configured Hight Avaliabily WAL Log Shipping Hot Standby (SSL) with one node. But after I configure, both hosts (primary and secondary) take 100% CPU usage. The most strange is because I have ...

1
2 3 4 5
9