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
36 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 ...
-2
votes
0answers
36 views

Assuming SAN data is fault tolerant, is FCI the only SQL technology to replicate entire sql server (instance level HA DR)?

By replicate entire sql server I mean: Databases Logins Jobs And absolutely every other aspect of sql server. The only SQL technology to achieve this, assuming fault tolerant SAN, is failover ...
0
votes
0answers
31 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 ...
-2
votes
0answers
29 views

Is SQL failover clustering the only solution that doesnt require dba to syncronize logins, jobs etc amongst each server?

I am exploring ha dr solutions: Log shipping Mirroring Replication FCI AG Amongst all, only FCI doesn't require dba to sync the logins and jobs amongst all servers (obviously because serves share the ...
0
votes
3answers
55 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
37 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
80 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
63 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
33 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
42 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
41 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
53 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
56 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
53 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
112 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
34 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
33 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
40 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
39 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
45 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
43 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
33 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
32 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
113 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
752 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
52 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
187 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
118 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
71 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
34 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
95 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
431 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
338 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
451 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
170 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
189 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
104 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
185 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
41 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
294 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
28 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 ...

1
2 3 4 5
9