Questions tagged [high-availability]

High availability is an architectural consideration often involving degrees of redundancy to insure availability in case of system or component failure.

High availability is an architectural consideration often involving degrees of redundancy to insure availability in case of system or component failure. Highly available systems are commonly implemented in situations where the risk outweighs the cost.

Best practices such as change control, standardized procedures, and monitoring can also enable high availability.

967 questions
4
votes
1 answer

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which Replication method should be used for real time…
4
votes
1 answer

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is designated to High availability solutions. I must say that…
4
votes
2 answers

How to change the master in a MongoDB cluster without restarting the process?

Reading the documentation of MongoDB about how to configure a master-slave configuration of a cluster (our cluster will have more than 12 nodes, so unfortunately we can't have a replica-set configuration), how can I promote a slave to master without…
Kico Lobo
  • 145
  • 2
  • 6
4
votes
2 answers

Per-packet round-robin load balancing for UDP

I need to load-balance UDP traffic between a number of "realservers" and do it in a truly round-robin fashion. I've started with keepalived, but unexpectedly discovered, that LVS treats UDP traffic as a "connection" (whatever that is in terms of…
shylent
  • 812
  • 11
  • 22
4
votes
3 answers

Does it work to run mysql with the data directory on a CephFS mount?

We have a database cluster that uses MySQL on DRBD with Pacemaker+Corosync, which is great. My question is whether it is possible (and whether anyone has been successful) to mount a CephFS drive to /var/lib/mysql and run MySQL from there. The…
Bryan Agee
  • 1,209
  • 2
  • 11
  • 27
4
votes
1 answer

How does a SQL Server Availability Group decide on which secondary will become the new primary when an automatic failover is triggered?

How does a SQL Server Availability Group with multiple synchronous-commit secondary replicas decide on which secondary replica will become the new primary when an automatic failover is triggered? Can't find any information on this in the…
4
votes
3 answers

How to handle server failure in an n-tier architecture?

Imagine I have an n-tier architecture in an auto-scaled cloud environment with say: a load balancer in a failover pair reverse proxy tier web app tier db tier Each tier needs to connect to the instances in the tier below. What are the standard…
andy
  • 159
  • 1
  • 10
4
votes
3 answers

Risks of Network Partitioning When a Split Brain Creates a Security Flaw

I'm looking to create a high-availability, scalable networking solution by using a distributed system of data. A node here, describes a network that has control over one copy of the data. These nodes might contain more than one machine but has one…
4
votes
1 answer

Ganeti and automatic failover

I'm building a simple 2-node cluster with Ganeti+DRBD... What is the recommended way to setup automatic failover? I'm used to Heartbeat, but they say it should be avoided with my setup.
Joril
  • 1,610
  • 1
  • 21
  • 28
4
votes
2 answers

Is it possible to synchronize the states of TCP proxies in real time (for real-high-availability of SLB)?

Consider that there are two server Load Balancers working in TCP proxy mode (e.g., for L7 Load Balancing). Is it possible to synchronize their states in real time so that they can be a backup for each other? In case that one is down, the other…
Song
  • 41
  • 1
  • 2
4
votes
3 answers

Should redundant servers have exactly the same configuration, or slightly different?

If you provide a service on two servers to ensure high-availability, is it better to configure them in exactly the same way, of instead should you introduce slight differences to prevent "freak configuration" errors? We host a Django-based website…
Jan Fabry
  • 926
  • 1
  • 11
  • 18
4
votes
2 answers

Is this a solid (and cheap) High Availability idea for my website and database if the zombi's attack?

I have an Idea for fail-over high availability for my website but i am not sure if this is good, bad or a disaster in itself. My main server hosts an ASP.net website that uses a SQL server database on another server. Both servers are running…
SetiSeeker
  • 275
  • 2
  • 9
4
votes
4 answers

High availability without dropping connections

Is it possible to have a high availability setup, in this example going to 2 webservers, and allow it to fail over without dropping connections? I have two webservers that are using comet, an HTTP technique where you have long-lived HTTP…
John Smith
  • 41
  • 2
4
votes
1 answer

relation between heartbeat,openais,corosync

i am planning for high availability on lucid ubuntu, i started with drbd after a simple configuration on drbd I went to heartbeat and had a simple config on it too. on drbd official site a document told me heartbeat is legacy and i should meet…
amin
  • 225
  • 2
  • 11
4
votes
2 answers

Google network architecture

I am aware that this question might be closed as "not a real question", "subjective" or even "argumentative". If this is a mistake, I am sorry. I am not good at all at networking but I'm trying to get better and learn more. (you might know the…