Stack Overflow
Stack Overflow

Questions tagged [automatic-failover]

Use this tag for questions related to Automatic failover, which is supported only in database mirroring sessions.

34 questions
6
votes
1 answer

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 failover group is configured with an automatic…
mslot
  • 4,959
  • 9
  • 44
  • 76
3
votes
2 answers

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 reads if the primary region fails. Currently the…
SetiSeeker
  • 6,482
  • 9
  • 42
  • 64
3
votes
0 answers

PostgreSQL/PostDock: Auto recovery failed in master node

I use Docker service and Docker swarm to deploy the PostDock cluster This is my docker-compose.yml setup: version: "3.3" networks: postdock: external: true services: pgmaster: image: postdock/postgres environment: …
moeman
  • 119
  • 4
3
votes
2 answers

PgPool-II and repmgr Automatic Failover

I have pgpool-II for HA and repmgr for automatic failover. Pgpool-II also can also run failover I am just wondering doing automatic failover using pgpool or repmgr? If pgpool can do the failover do I need to use repmgr? and use shell scripts to the…
varun7447
  • 574
  • 1
  • 6
  • 27
3
votes
0 answers

How to manage failover in ZooKeeper across datacenters using observers

I have an application running in 3 different datacenters that uses ZooKeeper for many tasks. Following the recommended practices, we have deployed three ZooKeeper ensembles where one datacenter contains common ZooKeeper instances and the other two…
Matheus Portela
  • 2,420
  • 1
  • 21
  • 32
3
votes
1 answer

How SailsJS connects to mysql with replication failover?

I have developed an application using SailsJS, using sails-mysql adapter. I want to setup replication and automatic failover for MySQL. In a typical java application using JConnector, I would have specify the master and slave configuration on my…
Edison
  • 85
  • 1
  • 7
2
votes
0 answers

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' => 'pgsql', 'write' => [ …
abbood
  • 23,101
  • 16
  • 132
  • 246
2
votes
0 answers

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 have a requirement for configuring the auto failover…
user2594
  • 386
  • 1
  • 5
  • 18
2
votes
2 answers

Mongo: How to automatically connect to secondary in case of primary failure

I have a replica of three mongod instances, one of them is the primary instance, and the other two are secondary. I connected a mongo instance to the primary, and then I turned off the mongod primary instance, simulating a failure. Typically, as…
Nicolas
  • 91
  • 2
  • 6
1
vote
0 answers

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 standby node as witness node or how it will work ,…
rajkishore patro
  • 78
  • 1
  • 5
1
vote
1 answer

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.asbcdef.database.windows.net My current connection…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
1
vote
0 answers

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 socket connection for client /10.23...... (no…
somu
  • 11
  • 2
1
vote
0 answers

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 @tags3 = (SELECT CAST( t.target_data AS XML…
Judi Durai
  • 11
  • 1
  • 3
1
vote
1 answer

Sequelize connecting to fail over write replica

I am using Sequelize 4.38.0. After reading the docs, I have setup a master write database with 2 read replicas. I am trying to add a fail over for the master write database for high availability. Does sequelize support this? Within the config…
Bradley Kovacs
  • 119
  • 1
  • 7
1
vote
1 answer

Issue in Azure Auto-Failover Group with Azure SQL

Am working on the Azure SQL with Auto-Failover Group, for this I created one SQL Server along with one database and I created another copy of database in another SQL Server which is created with the help of Geo-Replication in other region. For that,…
Mani
  • 1,228
  • 3
  • 10
  • 28
1
2 3