Questions tagged [automatic-failover]
Use this tag for questions related to Automatic failover, which is supported only in database mirroring sessions.
automatic-failover
34
questions
0
votes
0
answers
8
views
How to implement client side connection failover in RSOCKET
I am running 2 instances of my RSOCKET Server app on localhost:7000 and localhost:5000, the expectation is that the client application should try connecting port 7000 and if the connection is good, ...
- 111
0
votes
2
answers
441
views
Running Kafka cost-effectively at the expense of lower resilience
Let's say I have a cheap and less reliable datacenter A, and an expensive and more reliable datacenter B. I want to run Kafka in the most cost-effective way, even if that means risking data loss and/...
- 1,074
1
vote
0
answers
184
views
add failover in HA proxy in kubernetes
I am trying to implement failover https://www.haproxy.com/blog/failover-and-worst-case-management-with-haproxy/ using HA proxy. My current environment is on Azure. I have deployed two application and ...
- 1,992
2
votes
0
answers
608
views
Does laravel automatically failover Database connections?
Background
We use Laravel to serve an enterprise application. We specifically separate the analytical queries from the operational one like so:
'pgsql' => [
'driver' => '...
- 23.4k
0
votes
1
answer
352
views
Automatic Failover in postgreSQL 14
I have read that PostgreSQL doesn't detect server failure so it doesn't do automatic failover, but all the articles were in 2020 (two years ago).
My question is Does Postgres 14 need third-party ...
0
votes
1
answer
345
views
To fix a broker as master in ActiveMQ shared JDBC storage with MySQL
I am new to ActiveMQ. I am trying to configure ActiveMQ high availability using shared JDBC master/slave with MySQL. When the master fails the slave automatically takes charge (i.e. becomes the master)...
- 251
3
votes
2
answers
3k
views
How do you update TableServiceClient in ASP.NET Core, to point to a secondary region, when using Azure geo redundant (RA-GRS) table storage?
I am using the latest Azure.Data.Tables nuget package, version 12.3.0 to connect to Azure table storage in an ASP.NET Core C# Application.
My application needs to failover to a secondary region for ...
- 6,604
1
vote
0
answers
301
views
Can i use EDB postgres failover manager without having a witness node >
I am having one master node and one standby node with EDB streaming replication enabled. I want to use EDB failover manager tool. However i dont have any witness node. Is there any way i can use my ...
0
votes
0
answers
137
views
muti-tenancy, regional residency and regional faili-over in AWS
For architecting a multi-tenant SAAS serverless application on AWS, This is how we plan to manage "users" and multi-tenancy. A relevant blog post here: https://medium.com/@tarekbecker/...
- 4,791
1
vote
1
answer
414
views
Should we have to use Failover Group server name or Primary server name in SQL Server managed instance connection string
We have configured a failover group for our SQL Server Managed Instance in Azure portal:
Primary Managed Instance : myprod01.asbcdef.database.windows.net
Failover Group Name : failover-myprod01....
- 93.2k
1
vote
0
answers
333
views
Zookeeper Leader Auto Failover
We are using spark standalone cluster 3 zookeepers in HA mode.I am seeing this issue in zookeeper.log.
Exception causing close of session 0x0 due to java.io.IOException: Len error 1195725856
Closed ...
- 11
2
votes
0
answers
3k
views
Recover connection after failover as HikariCP doesn't detect DB DNS change
Environment
Hikari CP Version : 3.4.1
JDK version: 1.8.0_251
Database: Azure SQL
SpringBoot Version: 2.2.2 RELEASE
MS-SQL JDBC Driver version:- 8.4.1-jre8
I am working on a Spring Boot app where I ...
- 396
1
vote
0
answers
11k
views
Find out when the last failover occurred in AlwaysOn availability groups
I used below metioned query to find out if any failover happened in the last 30 minutes
create table #errormsg(duration datetime,errornum int,dbmessage varchar(max))
DECLARE @tags3 VARCHAR(5000)SET @...
- 11
0
votes
1
answer
497
views
MYSQL HA on kubernetes (vmware)
I have setup MYSQLHA as per https://kublr.com/blog/setting-up-mysql-replication-clusters-in-kubernetes-2/ have two nodes up and ready able to deploy pods on each of them and replicate data from ...
6
votes
1
answer
5k
views
Azure SQL failover group, what does the grace period mean?
I am currently reading this: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group, and I have a hard time understanding the automatic failover policy:
By default, a ...
- 5,176