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
0answers
9 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
8 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
72 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" ...
2
votes
1answer
69 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
40 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
50 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
29 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
45 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
24 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
31 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
60 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
342 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
127 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
24 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
131 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
108 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
79 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
63 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
96 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
31 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
171 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
24 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
224 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
112 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
212 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
89 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
82 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
76 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
2k 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
46 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
20 views

Can a basic availability group be used with a windows failover cluster on multiple subnets?

If I have a SQL server with IP address 192.168.1.100/24 and another SQL server with IP address 192.168.2.100/24, can I use a basic availability group in SQL? I only have a standard license.
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
vote
1answer
94 views

How not to have SQL Server to restart on the same node but failover on 1st failure in a cluster

By default SQL Server tries to restart on the same node in case of a failure, next it does failover. Personally I am good with the default behavior , but I am being asked a interesting question - is ...
1
vote
0answers
66 views

How to install PolyBase in an availability groups architecture for high availability?

Background: I’m designing a 2 node SQL 2019 availability groups installation hosted in VMs. We would have limited (single node) usage of PolyBase. The Microsoft Docs don’t reference installation for ...
0
votes
2answers
24 views

Always-on Avaialbility Group Secondary replica NOT identical to Primay

Can I have Always-on availability group primary node not identical to secondary? example: Primary Replica RAM 64, Cores 8 Secondary Replica RAM 256, Cores 32 As I estimate read-only queries to be ...
0
votes
0answers
39 views

Sql server error message “the database is read only” in a remotely server - availability database

I have a failover cluster with a high availability sql server service, the problem is that I cannot create a table, update, delete remotely even if I already give specific permissions and i had ...
0
votes
2answers
41 views

High availability sql server, secondary replicas can't be connected on the Availability group

I created an availability group (two nodes) , then my secondary replica isn't connected like on the picture. I verified on error logs and i have this error . how can I give permission to my secondary ...
0
votes
2answers
62 views

Is it possible to make a high availability PostgreSQL database cluster by open source softwares?

If use these tools can make a great modern database cluster with full features: pgbouncer (with HAProxy for HA) repmgr barman The main database will run on the repmgr servers. It has primary and ...
0
votes
0answers
412 views

Destroy cluster windows server 2012 r2

I want know how to delete a Windows Server Failover Cluster. My case is a bit special. I encountered some problems while creating a failover cluster, and I stopped the cluster services then I did "...
0
votes
1answer
51 views

On which machine we should install WAL-G?

We are using PostgreSQL version 12.1. Currently we have high availability and automatic failover using Patroni and it's working fine. Now we are planning for disaster recovery and we are planning to ...
1
vote
1answer
95 views

mysql 8 high availability with drbd, corosync and pacemaker

I would like to implement High Availability for MySQL8, is this version supported by drbd, heartbeat, corosync, pacemaker? I've looked around online to that regard but there isn't much information ...
0
votes
1answer
155 views

Mirroring sql server , how to change the port?

I have two servers on the same cluster, in fact my goal is to set up "high availability", but the databases that I have integrated are not synchronized, so I think it is " mirroring "that I created ...
0
votes
2answers
247 views

If I manually failover my AlwaysOn AG primary replica to the secondary and take the primary database offline will it auto-sync when back online?

I have an AlwaysOn AG setup between Database A (primary replica) on Server 1 and Database B (secondary replica) on Server 2. If I force a manual failover from my primary replica on Server 1 to the ...
1
vote
2answers
79 views

Adaptive compression and HADR

I'm looking into adaptive compression. I can't seem to find any information on how HADR is affected when a table is compressed and then reorg:ed. Example t=mytable db2 "alter table $t compress yes ...
0
votes
1answer
694 views

SQL Server AlwaysOn AG Secondary Replica is not joined [closed]

I have created an Availablity Group on SQL Server 2019. I selected 2 SQL server for Replicas but the Secondary replica has an error: This secondary database is not joined to the availability group....
0
votes
1answer
153 views

SQL Server AG secondary replica database still in Restoring mode

I created an AlwaysOn in SQL Server 2019 and I selected the Full Database and Log Backup option. Now it created a database in secondary replica but it is still in Restoring mode. My DB size is 16MB ...

1
2 3 4 5
8