分散型可用性グループのフェールオーバーについて

このポストは 2019年1月に公開された Replica Failover within the Secondary Availability Group in a Distributed Availability Group の翻訳です。 ————— 分散型可用性グループ (distributed AG) は、特別な可用性グループであり、2つの可用性グループにまたがっています。このブログでは、分散型可用性グループのフェールオーバーについての問題を説明します。特に可用性グループ間の同期状態にかかわらず、分散型可用性グループのデータ損失への耐性をご紹介します。 検証のために、シンプルな分散型可用性グループ ‘TIWENDAG’ を作成します。 ‘TIWENDAG’ の構成は次の図のとおりです。 ‘TIWENAG1’ が分散型可用性グループ ‘TIWENDAG’ のプライマリ可用性グループで、’TIWENVM1′ がプライマリ レプリカ、’TIWENVM2′ がセカンダリレプリカです。’TIWENAG2′ が分散型可用性グループ ‘TIWENDAG’ のセカンダリ可用性グループで、’TIWENVM3′ がプライマリ レプリカ、’TIWENVM4′ がセカンダリレプリカです。 分散型可用性グループで定義されている、2つの可用性グループの自動フェールオーバーはサポートされています。例えば、可用性グループ TIWENAG1 でフェールオーバーモードが “自動” で設定されていると、TIWENAG1 がダウンした際にはTIWENAG1 (プライマリ) と TIWENAG2 (同期セカンダリ) 間で自動フェールオーバーが発生します。同様に、可用性グループ TIWENAG2 でTIWENVM3 (プライマリ) がダウンした場合には、TIWENVM4 (同期セカンダリ) に自動的にフェールオーバーされます。…


Friday Five: NHibernate Querying in Core 2.2 Framework, Azure NSG, and More!

  Building microservices through Event Driven Architecture part2: domain objects and business rules Gora Leye is a Solutions Architect, Technical Expert and Devoper based in Paris. He works predominantly in Microsoft stacks: Dotnet, Dotnet Core, Azure, Azure Active Directory/Graph, VSTS, Docker, Kubernetes, and software quality. Gora has a mastery of technical tests (unit tests, integration tests, acceptance tests,…


Reconnect Series: Johan Åhlén

“…if you want to do great things you need to do little things in a great way first.” Johan Åhlén is a Reconnect Member with a passion for exploring and making sense of data. He has been familiar with Microsoft SQL Server for over 20 years, and has also worked with .NET, C#, ASP.NET, MVC,…


Friday Five: Getting Started with Azure IaaS Inventory, Opinions on AI and More!

Generating Reports For NightScout Data Using Flow, Excel, And OneDrive Leon Tribe is a business thought leader, passionate public speaker, and the National Project Director at PowerObjects in Sydney, Australia. His passion is helping others make the world a better place through the intelligent use of technology. He does this with Dynamics 365. In recognition of his passion and…


Announcing the JDBC Driver 7.2 RTW!

We are pleased to announce the production release of the Microsoft JDBC Driver 7.2 for SQL Server! The 7.2 Release To World (RTW) includes the following items since the previous RTW release: Added Added APIs for DataSourceFactory and OSGI Framework #700 Added support for OffsetDateTime to be passed as ‘type’ in ResultSet.getObject() #830 Added support for Active…


Early technical preview of JDBC 7.1.4 for SQL Server released

We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added APIs for DataSourceFactory and OSGI Framework #700 Added support for OffsetDateTime to be…


How to get earlier versions of the Dynamics NAV development environment to work with TLS 1.2

Some of you have been struggling to get your version of Dynamics NAV to work with a SQL Server database that has implemented the latest version of Transport Layer Security. TLS 1.2 support on SQL Server is explained in more detail in this article. As stated there, several known vulnerabilities have been reported against Secure…

3

Early technical preview of JDBC 7.1.3 for SQL Server released

We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added a new SQLServerMetaData constructor for string values of length greater than 4000 #876…


Flat Cube became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Flat-Cube-became-default-in-SAP-BW/ba-p/368151 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP…


Columnstore became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Columnstore-became-default-in-SAP-BW/ba-p/368149 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP…