Leanpub Header

Skip to main content
Go to Leanpub.com

SQL Server AlwaysOn Availability Groups

Perencanaan, Konfigurasi, dan Optimasi

Choirul Amri

This book is written in Bahasa Indonesia.

Free With Membership

Interested in this book? Show your support by saying what you'd like to pay for it!

$
PDF
EPUB
About

About

About the Book

Teknologi Availability Groups merupakan teknik high availability yang handal untuk mendukung ketersediaan database. Buku ini memaparkan teknologi AlwaysOn Availability Groups yang dapat diimplementasikan pada SQL Server 2012 dan SQL Server 2014. Penjelasan diberikan mulai tahap perencanaan, instalasi, konfigurasi, dan pemantauan kinerja selama proses operasional di production. Setiap bab disertai dengan latihan yang dapat diikuti tahap demi tahap untuk membangun fasilitas Lab milik Anda sendiri. 

Daftar Isi

Pengenalan AlwaysOn Availability Groups
  • Konsep High Availability dan Disaster Recovery
  • SLA
  • Recovery Point Objective
  • Recovery Time Objective
  • Fitur SQL Server untuk mendukung HA dan DR

Arsitektur AlwaysOn Availability Group
  • Fitur Utama Availability Groups
  • Windows Server Failover Cluster
  • Availability Replica
  • Metode Sinkronisasi Data
  • Metode Failover
  • Active Secondary
  • Readable Secondary

Instalasi AlwaysOn Availability Group
  • Prasyarat Software dan Hardware
  • Persiapan Role dan Features Windows Server
  • Konfigurasi Windows Cluster
  • Instalasi SQL Server
  • Konfigurasi AlwaysOn Availability Group
  • Testing Failover

Konektivitas Aplikasi dan Read Only Routing
  • Persyaratan Aplikasi
  • Konfigurasi Listener
  • Konektivitas Aplikasi ke Availability Group Listener
  • Koneksi ke Primary Replica Menggunakan Listener
  • Koneksi ke Readable Secondary Menggunakan Listener
  • Konfigurasi Read Only Routing

Failover dan Perpindahan Role
  • Relasi antara Failover dan Availability Mode
  • Automatic Failover (tanpa data loss)
  • Planned Manual Failover (tanpa data loss)
  • Forced Manual Failover (dengan data loss)

Konfigurasi Quorum Tingkat Lanjut
  • Peranan Quorum dalam Cluster
  • Node majority
  • Node and disk majority
  • Node and file share majority
  • Dynamic Quorum di Windows Server 2012
  • Dynamic Witness di Windows 2012 R2

Pemantauan Kinerja Availability Groups
  • Proses Sinkronisasi Data Antar Replica
  • Pemantauan menggunakan dashboard availability group
  • Pemantauan menggunakan SQL DMV
  • Otomasi pemantauan kinerja

Integrasi dengan Microsoft Azure
  • Skenario Availability Groups dengan Microsoft Azure
  • Skenario Hybrid IT dalam Availability Group
  • Menambah Azure Replica ke Availability Group
  • Konfigurasi "Azure Only" Availability Group

Share this book

Categories

SoftwareSQL Server

Feedback

Email the Author

Author

About the Author

Choirul Amri

Choirul is an IT Pro, writer, and community enthusiast. He is passionate about database performance, automation, and making it highly available. He was Microsoft MVP for ASP.NET (2005 -2007) and SQL MVP (2008 - 2011). 

Blog: http://choirulamri.org

Twitter: mchoirul

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

Earn $8 on a $10 Purchase, and $16 on a $20 Purchase

We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub