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
45 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 ...
0
votes
1answer
13 views

Availability Group: Is it possible not to do automatic failover for particular groups?

We've got two Windows Server 2016 with SQLServer 2016 on AWS EC2 instances (node 1 and node 2) Because we're using a standard edition, we're limited to having one database per availability group. ...
1
vote
1answer
53 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
30 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
36 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
25 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
14 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
14 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
24 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
38 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
32 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
23 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
25 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
0answers
17 views

How to use PostgreSQL backup tool Barman's passive feature?

There are 2 servers Backup Server(Installed Barman) Passive Server(Installed Barman) Configuration Backup Server /etc/barman.d/postgresql-server-db1.conf [db1] description = "DB1 PostgreSQL ...
0
votes
2answers
31 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
43 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
87 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 "...
1
vote
1answer
43 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
39 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
66 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
36 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
225 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
86 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 ...
3
votes
1answer
161 views

SQL Server AlwaysOn Availablity Group Automatic seeding

I created an AlwaysOn in SQL Server 2019 and I selected Automatic seeding, but it does not create my database in secondary nodes, On the other hand, if I create my database manually I give and error ...
0
votes
1answer
192 views

Patroni with etcd starting up

I have an existing PostgreSQL cluster v11.5 with streaming replication. I want to set up high availability managed by Patroni. I installed Patroni on both machines, I set up an etcd cluster on three ...
0
votes
1answer
57 views

HA and Automatic Failover with PostgreSQL

The most popular third-party tools are pgpool and regmgr. pgpool can do HA and automatic failover, regmgr can also do replication and automatic failover. Some articles show using both of them to do ...
1
vote
1answer
48 views

Setup an aerospike high-availbilty cluster?

Are there any guide to set up an aerospike HA? I had search google but there was no possible result in return. Look like Aerospike is not really popular in common. P/s: Lab purpose so there only ...
0
votes
0answers
40 views

RH Cluster with PostgreSQL 10 and a shared storage for PGData

I am trying to setup a two-node cluster running Postgres 10 and plan to store PGData on a SAN. The cluster is realized on RH using Pacemaker/Corosync. My general idea is to use VIP (floating IP) for ...
0
votes
1answer
33 views

SQL Server Distributed Availability Group Usage Pattern

I have got a client with DAG setup on 2016 & 2017 servers. I understand that their usage is most likely for DR purposes. What I'm a little unclear on (and I can't find any info on it) is how they ...
0
votes
1answer
72 views

SSIS Package Failing since Database failed over to Secondary (Basic Availability Group)

Our SSIs package running via SQL Agent Job on a dedicated Reporting server had been running fine since deployed more than 3 weeks ago. Due to performance issue we had to fail over the database to ...
2
votes
1answer
360 views

Highly Available PostgreSQL with patroni

I follow this guide to set up an lab for Postgres HA. I follow exactly the guide (change the IP address in my case), after all it all work though on Postgres server 1 But when come to Postgres ...
2
votes
2answers
70 views

Using SQL Server 2017, can log backups be safely taken on primary when using Log Shipping or Availability Groups?

We have a CommVault server taking log 15-minutely log backups of our primary (on-premise) DBs (combined with full nightlies), for point-in-time restores. We want to enable high availability for DR ...
0
votes
1answer
36 views

Adding ReadOnly Domain-less replica to existing AG with two replicas on two nodes WSFC

I have AG setup as follows: Multi sub-net WSFC (Windows Server 2016) - All nodes part of same domain AG with two replicas (SQL 2017) - Each node (mentioned above) contains one standalone instance. ...
0
votes
1answer
45 views

Restore database with Availability Groups

I have high availability enabled with two servers and when trying to restore a database I realised I had to un-synchronize the database and then remove it from the availability group. I use Ola ...
1
vote
0answers
136 views

REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT for Readscale AG failover

I have 2 node Readscale AG setup where each node is on a different data center. I want to know if SET (REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT = 1); needs to be run even after setting both the ...
0
votes
1answer
61 views

Postgresql 9.6 HA issues

(Editing the question with additional information: ) We are in process of testing a Postgres 9.6 active-passive HA cluster using streaming replication on Rhel 7.5. The HA setup is done using ...
0
votes
1answer
163 views

What happens if a DC goes down in a Postgresql, Patroni, etcd multi DC setup

I have a question regarding how Patroni and etcd handle the below scenarios. Assume there are two sites in this deployment, Site1 and Site2 and it's a 5 node cluster spread across these two sites. ...
1
vote
1answer
129 views

SERVERPROPERTY('HadrManagerStatus') equating to 1 even if Always On is not configured

We have a SQL Server Enterprise 2017. I would like to get insights as to why our SERVERPROPERTY('HadrManagerStatus')returns 1 even if Always On is not configured in this instance. I have a local ...
-1
votes
1answer
75 views

SQL Server Database replication from Enterprise to Express version

We need to replicate one of our enterprise SQL Server database to DR site for HA purpose, due to budget reason, we would like to install another SQL Server Express rather than the enterprise or ...
2
votes
1answer
287 views

Adding indexes to production MySQL database without downtime?

I am looking to improve the performance of queries on a large MySQL database that is running in production by adding proper indexes. We have tried to add the indexes on the live database, but of ...
2
votes
2answers
88 views

SQL Server on Windows Server (VMware) - online storage swap

I have a VM cluster designed to store multiple SQL Server instances. We use variety of storage providers (i.e. 3PAR, XIV) which have to be changed now (not relevant to what brand). On Oracle on Linux ...
4
votes
1answer
207 views

Always On Primary Replica On Prem, Secondary Replica On Azure

We want to create an Always On Availability group where the primary replica will be On-premises and the secondary replica will be on an Azure VM. I have researched and I know it's possible to do this, ...
6
votes
2answers
807 views

What is the best option for High availability on a data warehouse?

I have a customer who have an existing 1.5Tb data warehouse and are currently planning for a complete refresh of the DW on a new environment. Their infrastructure manager has organised 2 servers with ...
0
votes
1answer
35 views

Moving SQL server 2016 DB's from mirroring to HA

We have Windows Server 2016 machines with SQL server 2016 standard edition. Currently mirroring is implemented and now are planning to move to HA with 1 listener for each DB. We have multiple DB's ...
2
votes
1answer
95 views

What is the difference between sys.dm_hadr_ tables and sys.availability_groups / sys.availability_replicas?

Browsing around some sys tables, I see: sys.dm_hadr_availability_replica_cluster_nodes.group_name = sys.availability_groups.name and sys.dm_hadr_availability_replica_cluster_nodes....
0
votes
1answer
62 views

MySql Galera Multi site high availability

We have a datacenter with 3 percona glera nodes We have a store that wants to be in sync with our datacenter(multi master) our store's internet connection is not reliable ( may be down for 30 min), ...
2
votes
1answer
197 views

Database level health check did not trigger failover on losing a disk

I'm testing the new database level detection option in 2016 SQL Enterprise SP2 CU7 edition, and it does not seem to be working as expected. We have a 2 node setup, synchronous commit, automatic ...
0
votes
2answers
52 views

Accumulated logs - Log shipping SQL Server

If I have a log shipping scenario where a report runs for 30 minutes and the log shipping is set up for not killing the connection, and because of that, the restore will fail, the question is if all ...
2
votes
1answer
23 views

Network Maintenance and High Availability Group Prep

We have had a RAID card on one of our switches die, and the replacement had issues which caused my availability groups to failover multiple times between my 2 nodes like a game of tennis and left a ...
0
votes
1answer
68 views

Bidirectional data transfer

I have two nodes and one database. I want to transfer data between them. DML operations on server node-1 should transfer to node-2 and DML operations on node-2 should transfer to node-1 as well. Is ...

1
2 3 4 5
8