[{"_1":2,"_68":-5,"_69":-5},"loaderData",{"_3":4,"_38":39,"_66":-5,"_67":-5},"root",{"_5":-5,"_6":-5,"_7":8,"_22":23,"_24":25,"_26":27,"_30":31,"_36":37},"user","shoppingCartId","shoppingCart",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":14},"id","no-cart","count",0,"free",true,"updatedAt","2026-02-19T02:37:53.267Z","paymentGateway","STRIPE","cartItems",[],"loading","locale","en","readerTheme","light","constants",{"_28":29},"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","publishers",{"_32":33,"_34":35},"companies",[],"universities",[],"needsLocaleCookieSync",false,"routes/_store+/_readers+/email_author.$slug/route",{"_40":41,"_65":-5},"book",{"_9":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMTQxNDI","title","SQL Server AlwaysOn Availability Groups","state","unpublished","contactAuthorMethod","email","aboutText","

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

","authors",[53],{"_9":54,"_55":56,"_5":57},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8xNDc0OA","name","Choirul Amri",{"_58":59},"avatar",{"_60":61,"_62":63,"_64":14},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/311651/medium/WP_20160210_008_%282%29.jpg?1558331918","styleName","medium","exists","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Author