New answers tagged

0

Just found this question while looking for answers on a related topic. What I've done is to set up the MySQL Fabric controller as a pair of servers with multi-master replication and a daemon that looks for a heartbeat on the first server's mysqlfabric process and restarts it, starting the second server's mysqlfabric in case the first refuses to restart. Why ...


0

Given the wait types of LATCH_EX and ACCESS_METHODS_DATASET_PARENT I highly doubt AlwaysOn was the culprit. These two latch types may go hand in hand. You'll want to investigate where the latch_ex waits are actually happening - sys.dm_os_latch_stats may help here where the latch_class is not 'buffer'. Given that removing AlwaysOn did not help with the ...


1

If you were referring to Database Mirroring when you say mirroring (as opposed to SAN mirroring), then don't. It has been deprecated since 2012 now so it is a potential candidate for complete removal in the future releases. Go with Always On Availability Groups. The difference in DBA overhead should be mostly the same. What is different, IMHO, is the ...


2

I would recommend you to use Always on availability group for server reasons. Database mirroring is deprecated as of SQL Server 2012 and will be removed on the future versions, so it is better to not use it on a new developments AOA group will give you a feature which you cannot get it on mirroring. Using AoA group, is like using a combination both ...


7

A solution that will work with SQL Express would be ideal, SQL Standard is fine, but I dont want to have to upgrade to SQL Enterprise. If you want something straight out of the box, that's going to be difficult to find. However, 2016 does bring Standard Edition Availability Groups. Standard Edition before 2016 does have Mirroring. Additionally if you'...


3

I'm not sure I understand, you state you are going to use mirroring, in standard it is still available so why can't you use that? Or is the question that is there anything else available? You can also use Failover clustering in standard edition, the limit is you can only use 2 nodes but I don't see that as an issue for your request. Also, if you are using ...



Top 50 recent answers are included