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
26 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
19 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
36 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
46 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
43 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
50 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
72 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
30 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
28 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
38 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
38 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
37 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
38 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
29 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
21 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
10 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
97 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
452 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
47 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
147 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
92 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
56 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
32 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
71 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
390 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
260 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 ...
0
votes
0answers
25 views

AOAG windows 2 node cluster in confusion

We have a 2 node cluster alwayson availability group running with 4 resources/roles. due to VM backup one of the node lost connectivity to node 2 and it marked node 2 as removed from cluster and tried ...
2
votes
1answer
285 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
145 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
148 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
90 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
143 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
35 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
236 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 ...
0
votes
0answers
38 views

Scale out methods with high availability [duplicate]

We have a two site AlwaysOn Cluster and looking to do a High Available multi-site write solution. We have looked at Replication, Sharding, and SQL Elastic options for having multi-site write for a ...
0
votes
0answers
26 views

db choice for activity log

I'm working on a geo-replicated web platform, composed of an ecosystem of microservices. We need to improve and rework the user activity tracing pipeline and I'm looking for "the best" ...
0
votes
0answers
14 views

Alternative (modern?) way of achieving effect of synchronous commits

For a project we currently plan to establish a high-availability architecture based on two data centers (with short distance) and using synchronous commits at the DB level, using a commercial DB ...
0
votes
1answer
343 views

Good practices for patching SQL nodes in High Availability solution [duplicate]

Our database structure utilizes two roles in the Window Failover Cluster Manager. One is for FCI - switching between the active/passive node in the Primary Data center. One is for SQL Availability ...
2
votes
1answer
155 views

How to implement High Availability for all nodes in a sharded database?

I'm doing some research into implementing sharding for one of my large (~2 TB) production databases. Currently the database has HADR via a multi-replica AlwaysOn Availability Group. Since sharding a ...
0
votes
1answer
285 views

SQL Server Standard 2016 Service Pack and Cumulative Update [duplicate]

We are currently using SQL Server 2016 Standard Edition with ALWAYS-ON High Availability. We have two different clusters of SQL servers. We need to update it to the latest version of SQL (As per my ...
1
vote
1answer
96 views

Implement SQL Server 2012 AlwaysOn

I have two SQL Server instances running on Windows Server, SQL Server cluster with 2 nodes with shared storage (Active, Active type). The SQL Server version running is SQL Server 2012 Enterprise ...
1
vote
1answer
130 views

Need advice on how to migrate from existing database mirroring to availability groups

Need some practical/general guidance on moving from database mirroring to AOAG Current setup - 2 standalone servers with database mirroring configured as async. Server A: Windows 2016 running SQL ...
1
vote
1answer
102 views

Write concern in PostgreSQL

In MongoDB it is called write concern, that is the number of the servers in a replica set, that the data should be committed before the cluster acknowledges the write request. How is it called in the ...
1
vote
0answers
3k views

Issue: Data synchronization state of availability database is not healthy

I have a sqlserver 2017 cluster (sql server 14.0.3026.27) with two secondary nodes set with Availability Mode = Synchronous commit. The server has 8 databases that are replicated on the secondary ...
0
votes
1answer
115 views

Postgresql Streaming Replication on Windows failover

Hello i have setup streaming replication using PostgreSQL 11 on Windows working OK. How can i manually use the replica ( it is hot_standby=on ) in case Master fails ? What are the steps i have to ...
0
votes
0answers
16 views

SQL Server High Availability mode When I failover the node Permissions are going away [duplicate]

I created an Availability group with 2 Servers. When I fail over from one node to another the permissions are going away. (I granted a SQL server login DBO permissions) So what I did was I wanted the ...
0
votes
0answers
25 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, ...

1
2 3 4 5
8