Questions tagged [automatic-failover]

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

34 questions
1
vote
2 answers

Automatic Failover not working in Hadoop

I'm trying to build a 3 node cluster (2 Namenode(nn1,nn2) and 1 datanode(dn1)) .Using Namenode WEBUI, I'm able to view that nn1 is active and nn2 is standby. however, when I kill the active nn1, standby nn2 is not going active. Please help me what…
Raj
  • 11
  • 1
  • 7
1
vote
1 answer

Grails Support to Handle Datasource Failure

I am looking for a solution for automatic database failover in grails application. I have two databases which reside on two different sites connected over WAN. On Site A, we have Database 01 which is primary database for application on the same site…
0
votes
2 answers

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/or downtime. I can run any number of brokers in…
vincent31337
  • 982
  • 1
  • 8
  • 15
0
votes
0 answers

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 an ingress controller and ingress. where I am…
0
votes
1 answer

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 software to do automatic failover? or is it built-in…
0
votes
1 answer

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) and grabs the lock in MySQL. I wanted to know…
0
votes
0 answers

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:…
0
votes
1 answer

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 master to slave within seconds. 1 Master node 2…
0
votes
1 answer

Pacemake not failover when nginx service down

I have setup HA-Cluster for nginx. So when nginx or node fail, then it will failover to second node. pcs status Cluster name: push_noti_cluster Stack: corosync Current DC: push2 (version 1.1.18-11.el7_5.3-2b07d5c5a9) - partition with quorum Last…
0
votes
0 answers

Fail over from Azure VM to Azure Web App

We want to fail over from Azure VM (Windows Server) to Azure Web App. VM hosts the web application, and Web App is just a page informing Website Under Maintenance message. This is for planned/un-planned maintenance events of the server. Once the…
0
votes
1 answer

How to update master database with data of slave database after failover in mysql

I'm using Mysql Server 5.6. I've setup master-slave replication and its working fine. The only problem is, when i get the master server up the data from the slave is not updated automatically to the master.
Lakshya
  • 29
  • 1
  • 6
0
votes
0 answers

Percona cluster automatic fail-over not working

I'm deploying Percona Xtradb-Cluster and get stuck at automatic fail-over. When I stop node 2 in database not auto update status. This is log: 2017-06-23 23:37:29 MySQL_Monitor.cpp:1126:monitor_ping(): [ERROR] Server 192.168.1.11:3306 missed 3…
0
votes
1 answer

keepalived transitions not happening as expected

I am trying to implement keepalived based failover for my service. Please find below my configurations for the master and backup nodes. Master node: vrrp_script chk_splunkd { script "pidof splunkd" interval 2 fall 2 rise…
Keerthana
  • 129
  • 1
  • 1
  • 10
0
votes
2 answers

Detecting network connectivity/ performance degradation of aws ec2 instances with 'health check type: EC2'

Many of my ec2 instances do not have an ELB. I want to do an automatic failover or at the very least have my autoscaling policies honor network connectivity issues, faulty ec2 hardware, performance degradation etc. which in turn would mark instance…
0
votes
2 answers

Mongodb architecture and failover with two data centres

I’m trying to figure out whether there is a way to seamlessly failover a mongo replicaset where most of the mongodb nodes live in the primary data centre. My current limitation is 2 data centres and third datacentre is out of the question. The issue…