Tag Info

New answers tagged

2

Does it mean that former primary replica (A) will become primary replica automatically? No, all that means is when your replica comes back into the picture, and when the Availability Group database gets back in a SYNCHRONIZED state that it would be failover ready. That operation will not happen automatically. You indeed would have to either do this ...


0

As noted, mirroring is not dead. (At least not yet.) The general population doubts that Microsoft would totally abandon HA for Standard Edition. However, there are other methods. In the SQL Server 2012 documentation when referring to mirroring it says: "If your edition of SQL Server does not support AlwaysOn Availability Groups, use log shipping." ...


0

Mirroring isn't dead, and that concern isn't a very good reason to move away from it. As of SQL Server 2014 it's still there, so there's no cause for concern until you start to look at moving off of 2014 to a newer version. With 2014 only being 9 days old, that should be a while. If you still want to see your other high availability options, look at the ...


0

I just want to add some useful links related to SQL Failover Cluster Good introduction to Failover As you are working on MS Azure MS Azure Cloud Storage options Although @spaghettidba mentioned this is possible I'm not sure how to setup SAN storage on MS Azure so you have to check this by yourself.


0

Replication is a data distribution technology, it was not meant for HA. That said, I would use a cluster. Standard edition supports 2-nodes clusters.


1

First off, there is no such thing as an "active/active" cluster. That is a huge misnomer, and can lead to a large amount of confusion. What you have is two failover cluster instances in a Windows failover cluster with at least two nodes. Secondly, this will not be possible if you are dealing two failover cluster instances. I wish to now have the ...


6

If you want to be able to sustain a failover of two nodes within the failover cluster, then you'll need to ensure that you have five voters for quorum. You currently have three nodes, and even if you were to add a disk witness, you'd still be at the same point: whether you have three or four possible quorum votes, you'd still need to have three votes for ...


1

pgbouncer maintains connections in a pool with a postgres server. TCP connection establishment times are significant in a high-volume environment. Clients making a large number of DB requests will have to setup a connection with a remote PGBouncer for each request. This is more expensive, than running PgBouncer locally (so the application connects to ...



Top 50 recent answers are included