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
44 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
32 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
102 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
40 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
28 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
39 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
17 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
26 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
37 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
209 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
46 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
34 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
39 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
70 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
53 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
69 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
74 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
46 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
79 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
65 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
137 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
506 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
31 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
63 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
43 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
102 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
42 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
20 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
66 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 ...
-2
votes
1answer
101 views

Can I use log shipping between different editions of SQL Server 2016?

Will log shipping work between different editions? Primary is SQL Server 2016 SE and Secondary is SQL Server 2016 EE. If not, how else can I set up high availability for this combination of servers?
0
votes
1answer
32 views

reportserver will not join basic availabiltiy group

I am running into a strange situation that I have not been able to resolve.  I have a 2 node Basic AG running sql server 2016 standard.  I am trying to add the reportserver DB to an AG, but it keeps ...
0
votes
1answer
87 views

In a replication setup, does corrupted data also gets replicated?

Say one of the tables got corrupted, will that corrupted table still get replicated to the other DB? Or, will the replication stop to prevent the other DB from being corrupted too? Note: Question is ...
1
vote
1answer
43 views

Altering endpoint of existing AG

Looking for some advice here: I currently have 3 SQL servers in a single AG with a single network card on each server. During times of heavy network usage, we are sometimes seeing failovers to a ...
1
vote
2answers
387 views

How to fail over availability groups on multiple remote servers

We have many SQL Server installations with availability groups. During our maintenance window, we will need to fail over all the HA groups to secondaries, patch the primary servers, then fail back, ...
2
votes
1answer
230 views

Database Engine and SSISDB architecture advice

I'm seeking some architecture advice involving the database engine and Integration Services components of SQL Server 2017. We have an existing SQL Server environment which is due for an upgrade and ...
0
votes
0answers
17 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
2
votes
1answer
96 views

Patching FileShareWitness for AlwaysOn AG

Situation: We have an AlwaysOn High Availability group with 4 replicas (2 for DR) a listener and an FileShareWitness. I've been tasked with creating a set of instructions for patching all of the ...
1
vote
1answer
885 views

How to monitor a file share witness for accessibility

In the context of a SQL Server Availability Group, what's the best way to monitor a file share witness for accessibility? I want to make sure the witness can be accessed by the Availability Group ...
1
vote
2answers
68 views

MySQL failover: how application can be switched to a new master in master-slave configuration?

In my case I have two MySQL servers. One is master and second one is slave. When slave is not available, my application can read and write from/to master. When master is not available, assume there ...
0
votes
1answer
66 views

Setting up AlwaysONAG in SQL server 2016 on windows 2016

I am going to set up AG's for the very first time, so with little or no experience, please guide me on below understanding: If i am setting up 4 node AOAG with below scenario: Node1-NY Data Center - ...
1
vote
0answers
38 views

Enabling FileStream in existing clustered servers in SQL Server 2012

I have heard that enabling FileStream in an already existing clustered environment is tough. I'm working on a consolidation project and currently analyzing the impact it will have if we migrated DBs ...
1
vote
0answers
18 views

AlwaysOn Replicas set to manual but failing automatically

My two synchronous-commit SQL AO replicas are set for manual failover mode but are failing over automatically. When I look through the logs and extended events, it looks just like what would happen if ...
0
votes
1answer
45 views

I am trying to achieve a Disaster recovery for Mongo DB

Right now i have a MongoDb HA in site one and i need another site with asynchronous replication enables in another location.This is a base plan of mine to achieve a disaster recovery . I dont have ...
0
votes
1answer
46 views

Security Considerations for AG vs Log Shipping

we are considering removing our log shipping server and adding another node to our Availability Groups. While I understand that this should be better cause it's a/synchronous and will move the data to ...
2
votes
1answer
328 views

MongoDB stepDown fails in a PSA Architecture

I have set up a MongoDB cluster using a 3-Member Primary-Secondary-Arbiter Architecture Environment: LXC containers Linux Debian Stretch (9.8) MongoDB server version: 4.0.6 MongoDB Containers: lxc-...
1
vote
2answers
60 views

Upgrade SQL Server 2014 AG to SQL Server 2017 AG

Is it possible to migrate SQL Server 2014 AG (Windows 2012, SQL Server 2014) to SQL Server 2017 AG (Windows 2016, SQL Server 2017) using rolling upgrade method? What I mean is Build 2 SQL Server ...
0
votes
1answer
128 views

File Share Witness with 4 Node Cluster

I am building a cluster of 4 nodes along with a file share witness. Every month due to server updates the server that holds the file share will need to be rebooted. My question is while the file ...
2
votes
2answers
306 views

Making a server with multiple instances a member of two effectively independent clusters

We're in the early stages of planning a new database environment for our ERP and CRM applications (third-party). The goal is to use Always On Availability Groups for HA, rolling patches, read-only ...
2
votes
0answers
118 views

2 SQL 2019 Servers with High Availability Linux with a shared Linux SQL Express 2019 Witness

Is it possible to have two SQL Always on High Availability servers in datacentre A replicating to two servers in datacentre B with one Witness using Express with two availability groups (one for each ...
0
votes
1answer
70 views

Native MariaDb encryption and clustering

Is native (table/Column/tablespace) database encryption possible in a clustered environment. The success criteria would be: Encrypted Logs Encryption in transit for all data protocols Native DB ...