Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
1answer
44 views

how to find out the log backups that I need to restore in order to bring log shipping from standby to online?

I have log shipping set up from server1 to server2. on server1 transaction logs backups are taken every 15 min to a network share folder. these transaction log backups are then copied (afte 1 hour) ...
0
votes
1answer
23 views

Listener Port 1433 for Always on Availability Group

In our Availability group I have a reporting server where report writers will connect directly and also crystal reports will be used, If the listener port is 1433 and the clients also gets connected ...
-1
votes
0answers
105 views

Unable to start database through Oracle Restart but works with SQLPlus. Restart seems to be trying to use an unkown and non-existent PFILE

ENVIRONMENT INFO: [oragrid@condor ~]$ uname -a Linux condor 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux New installation of Oracle Database 11gR2 ...
0
votes
1answer
43 views

is this time to remove the databases from the availability group? which ones?

While patching one of my servers that is part of an availability group, as a secondary, I had some problems - the real problem was that the host machine of one of the virtual servers in the ...
0
votes
1answer
26 views

mongodb replica set No Election of Primary with 6 of 7 Nodes UP

I have 8 instances running on Scaleway , 5 for Data and 3 Arbiter. And the versions of mongo on them are such : mongodb2 (mongodb 3.4.9) mongodb4 (mongodb 3.4.15) mongodb5 (mongodb 3.4.15) ...
0
votes
0answers
37 views

SQL Server error 19456 when adding the listener

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error ...
1
vote
0answers
16 views

Why use Failover replica on Google Cloud RDS?

we are thinking of migrating our MySQL database from our dedicated server to a Google Cloud RDS instance. However I would like to clarify the below: 1) What is the purpose of creating a failover ...
1
vote
0answers
30 views

Adding Databases to Availability Group

I'm attempting to add databases to an existing availability group using automated seeding but I randomly receive this error: "Seeding Check Message Timeout". I'm pulling this error message from sys....
1
vote
1answer
24 views

Enable Replication/CDC from High Availability Group

I am a newbie to this Replication concept and I am trying to build some scripts to automate our Build Process where we will be disabling/re-enabling Replication on a regular basis. Background: We ...
2
votes
1answer
38 views

Quorum question for SQL Cluster (Always On)

We are looking at setting up an SQL Always On High Availability environment at our organisation. Our organisation has two datacenters of with one much smaller one but this one's being created to ...
0
votes
0answers
50 views

MHA vs Orchestrator

Im going to setup an HA solution. Im planning to use Orchestrator. But seems MHA is also doing well. If anyone already used/using any one these solutions, please suggest me to choose a right one ...
0
votes
0answers
34 views

Executing stored proc in a SQL Agent Job fails on secondaries within a High Availability group with a sys.fn_hadr_is_primary_replica guard

I have a High Availability cluster of two servers. I have the same job setup on both servers within the cluster. The job has a single TSQL step, which is executed against master. The TSQL is as the ...
3
votes
1answer
50 views

MYSQL database failover

Current status I have a MySQL (MariaDB 10.2) server with various databases, to which a lot of people have access to. Which means that users can create MyISAM or InnoDB tables/databases. Problem ...
0
votes
2answers
81 views

DR/Reporting solution for a large SQL Server database

We have a large (3TB) database that is a part of AOG. We now have a need for a third copy of the data. Here are some of things we need: The third copy needs to be in sync with the primary in real ...
1
vote
0answers
30 views

How do Master / Slave JDBC URL handle broken MySQL Slave?

I own the following classical MySQL 5.7 set-up : one master server one slave server The master => slave link is done though GTID. I'm monitoring the link by querying show slave status on the slave ...
1
vote
1answer
118 views

Availability Groups Failover Readinness “No data loss” and rollback of nonqualified transactions

I have Availability Groups with Synchronous Replication and Automatic Failover setup with SQL Server 2016 SP2 in my production environment. I want to do a manual failover for patching and I have ...
1
vote
1answer
37 views

Shouldn't Windows Server Failover Clustering already take care of SQLServer Failover Clustering?

After reading this question, Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing? If Windows Server Failover Clustering is installed, ...
0
votes
1answer
18 views

Promoting MySQL slave with unknown replication delay

Consider I have a master on DC1 and slave on DC2. Now, DC1 network is completely down for indefinite time and I want to resume the service as soon as possible on DC2 by promoting the slave to master. ...
1
vote
0answers
42 views

Availability Group Always ON 2016 HADR_SYNC_COMMIT

I know it is not the best practice but we have a two node AG 2016 between two data centers. Server 1 and HQ and Server 2 at DR and they are clustered (multisubnet). AG is setup in Synchronous Commit ...
0
votes
0answers
31 views

How do I determine the cause of a SQL 2017 Mirroring Login Failure?

I have two SQL 2017 servers set up to create a Read-only replica on the secondary. All was working, but suddenly without any user intervention, the mirroring has stopped. I am seeing the following in ...
1
vote
0answers
101 views

Mirroring on-premise SQL Server to AWS EC2 SQL Server

Trying to mirror an on-premise SQL Server instance to EC2 instance, but not much information is available on this topic. The closest one I managed to find is: Implement SQL Server High Availability ...
1
vote
1answer
82 views

Difference between High Availability data synchronization across local replicas and DAG

I see a significant difference when synchronizing data between Primary - Secondary and between Primary HA and Secondary HA as part of Distributed Availability Groups. The difference in the amount of ...
0
votes
1answer
167 views

How to set-up failover in Postgres 9.6?

I have two postgres server with a master-slave architecture, the slave is replicating the DB from the master. In case the master goes down, the slave takes over and becomes the master. Now, the ...
3
votes
1answer
42 views

Is there any way to add a witness without restarting the witness afterwards?

I want to add a third instance of SQL server to my mirroring pairs to act as a Witness. When I set the witness, the mirror remains disconnected from the witness and the mirror's log accumulates errors....
0
votes
1answer
177 views

SQL Server ReadOnly Routing Connection String

Can we route read-only connection to readable secondary replica without setting connection string (ApplicationIntent = ReadOnly)?
2
votes
1answer
198 views

Mongo CP, Cassandra AP?

I have read lot of articles on net but still confused why Mongo CP, Cassandra AP, RDBMS CA ? Will explain my understanding and query along with that . Mongo Consider a scenario where I have ...
1
vote
0answers
176 views

Patroni : How to handle a slave which has been disconnected from master for long time?

Let's say if I am using asynchronous streaming replication with the below configuration in a 3 node cluster with Postgres 10.4 and Patroni 1.4.4 bootstrap: dcs: ttl: 30 loop_wait: 10 ...
1
vote
1answer
188 views

AlwaysOn High Availability Take database offline from primary

I have below scenario where i need your help: I have configured the AlwaysOn High Availability on my server. I have two replicas. Now I have requirement to make one database offline from the primary ...
0
votes
0answers
38 views

Index full population with AlwaysOn

Getting an error when running: ALTER FULLTEXT INDEX ON MyTbl START FULL POPULATION error: Msg 7654, Level 16, State 1, Line 3 Unable to obtain the population status of the table or indexed ...
7
votes
1answer
92 views

Multi-homed SQL Server with High Availability Groups

We have two servers (SQL-ATL01, SQL-ATL02) that make up a Failover Cluster, each running as part of a SQL Server High Availability Group (HAG). Each server has two network cards. One is a 10Gbit card ...
0
votes
1answer
54 views

Availability Groups Service Account has over 25000 sessions open

I am running Availability Groups on SQL Server 2014 with one database in the group. Today, the server was responding very slowly and when I got on the server I found that the Availability Groups ...
1
vote
2answers
959 views

What reason could cause AWS RDS connections to

It's my first time using RDS on AWS, I use a t2.medium instance running MySQL Aurora with default configs. The CPU usage and DB connections is quite normal until "something" happen, which cause the DB ...
1
vote
0answers
79 views

What is a good schema for a database where users can search for inventory availability on certain dates (such as Airbnb)?

I apologize if this is not the right venue to ask such a question. This is my first time on this site and I'm open to suggestions. I am trying to find a good schema for a database that needs to ...
1
vote
0answers
57 views

Can I run an index rebuild on a sql server HA replica or a copy the DB, and then swap with the primary?

We have a large database hosted in sql azure and we need to occasionally run maintenance tasks such as index rebuild. Pretty common of course, and we also try to minimize downtime. We use the premium ...
2
votes
1answer
1k views

Always On FCI vs Always On Availability Groups

What is the advantage of Always On Failover Clustering vs Always On Availability Groups? Basic Always On Failover Clustering provides server level protection, (eg: 2 servers with 1 shared disk space; ...
2
votes
1answer
33 views

Cost of replaying transaction log on sql server HA replica

I've been reading about the sql azure scale out. I suppose it makes senses to leverage the replicas hardware for read-only workloads. But it got me wondering, which is actually doing more work? The ...
0
votes
0answers
164 views

pgpool failover not working

I have setup pgpool 3.4 with streaming replication setup.I have installed pgppol on both the servers,Below are my file contents pgppol.conf listen_addresses = '*' port = 9999 socket_dir = '/tmp' ...
0
votes
1answer
41 views

Quorum configuration warning for cross subnet AAG failover

We have setup a 3 node AAG in our staging environment as a POC. The 3rd node has been configured in a different subnet and also as an asychronous replica. The Windows Server version is 2012 R2 and the ...
0
votes
0answers
47 views

rh-postgresql96(Red Hat provided postgresql) vs postgresql-9.6 (community postgresql)

Our client has provided us Red Hat machine for setting up PostgreSQL. We are allowed to install red hat provided packages only. So we have to install red hat provided postgresql (rh-postgresql96) ...
1
vote
1answer
52 views

Failover Cluster, Availability Group, and Disaster Recovery

We have an active/passive Windows Failover Cluster setup as an HA solution. Here is an example of what that might look like: Cluster1: [Node1 'active', Node2 'passive'] We're looking to set up a DR ...
1
vote
1answer
179 views

Why configuring automatic failover for SQL availibility group feature on sql failover cluster instance not allowed

I have set up an availability group where a primary is standalone server and replica is SQL failover cluster. This setup allows me only manual failover and when ever I try to set it automatic in FCI ...
0
votes
0answers
46 views

Create HA PostgreSQL cluster

We want to set up a highly available PostgreSQL cluster in our production environment. As of now, We have set up streaming replication. But we have to manually promote the slave as the master in case ...
1
vote
1answer
49 views

AG with overlapping AG groups

We are currently trying to implement a two node AG where node 1 has two AG's. The first AG is primary to node 1 and secondary to node 2, the second AG is primary to node 2 and secondary to node 1. I ...
0
votes
1answer
100 views

AlwaysOn High Availability - not always kicking in

We currently have a set up of two nodes A and B with AlwaysOn High Availability. When restarting node A, we can connect with the listener name 'xyz' to our SQL Server instance. In this scenario, B ...
0
votes
1answer
305 views

Is good idea to implement ProxySQL in production with Docker?

The idea is to have solution with ProxySQL to give high availability solution with docker implementation? But this question maybe not have sense, I am to investigate alternative solution without VIP ...
0
votes
0answers
58 views

What is the consistency of Postgresql HA cluster with Patroni

My understanding is that because the fail-over is using a consensus (etc or zookeeper) the system is will stay consistent under network partition. Does this mean that transaction running under the ...
0
votes
1answer
52 views

Is it possible to create a MySQL slave from a MariaDB master?

I need to create a MySQL slave instance which replicates the data from a MariaDB master. I guess it won't work. Any advices on how to create this replica architecture using MariaDB and MySQL? I am ...
4
votes
2answers
2k views

AlwaysOn AG versus FCI

Throughout MS documentation for AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) I see the following pattern: FCI is for HA scenarios. An AG synchronous secondary ...
0
votes
0answers
147 views

Backup in HA master/slave postgresql

I have 3 servers with streaming replication (master/slaves) and i'm using pgpool to provide HA. When a failover occur, one of the slaves is promoted to master and the remaining nodes deletes their ...
0
votes
0answers
16 views

How can I realize a load balancing where my two virtual mysql machines write and read data?

I want to use the following components to achieve load balancing: -. MYSQL ROUTER -. REPLICATION WITH GTIDs -. MYSQL 5.7 SERVERS The scenario I propose is the following: Let's say that I have 1000 ...