{"id":5025,"date":"2019-01-06T11:39:02","date_gmt":"2019-01-06T11:39:02","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=5025"},"modified":"2019-02-28T08:09:58","modified_gmt":"2019-02-28T08:09:58","slug":"sql-server-alwayson-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-alwayson-2\/","title":{"rendered":"SQL Server AlwaysOn -2"},"content":{"rendered":"

Merhaba Arkada\u015flar,<\/p>\n

Bu yaz\u0131mda SQL Server AlwaysOn u anlatmaya devam edece\u011fim. Bu yaz\u0131 bir \u00f6nceki yaz\u0131n\u0131n<\/a> devam\u0131 niteli\u011findedir. O y\u00fczden bu yaz\u0131ya ba\u015flamadan \u00f6nceki yaz\u0131y\u0131 okuman\u0131z\u0131 tavsiye ederim.<\/p>\n

\"\"<\/p>\n

<\/p>\n\n

AlwaysOn kurulumu i\u00e7in bir \u00f6nceki yaz\u0131da da bahsedilen gereksinimler tamamland\u0131ktan sonra art\u0131k elimizde 2 adet farkl\u0131 server da bulunan Standalone SQL Server Instancelar\u0131 bulunmaktad\u0131r. Bu Standalone SQL Server Instance lar\u0131n\u0131n diskleri, IP leri vs hepsi farkl\u0131 farkl\u0131 olmakla beraber a\u015fa\u011f\u0131daki gibide Windows Server Failover Clustering servisindede Windows Cluster olarak bulunmaktalar.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

SQL Server 2012 \u00fczerinde AlwaysOn \u00f6zelli\u011finin aktif edilebilmesi i\u00e7in \u00f6ncelikle iki node\u2019un da bir Cluster \u00fcyesi olmas\u0131 gerekir dedik. T\u00fcm \u00f6n ko\u015fullar sa\u011flan\u0131yor ise; a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip ederek bu \u00f6zellik aktif edilebilir.<\/p>\n

SQL Server Configuration Manager a\u00e7\u0131l\u0131r. \u00d6zellikler b\u00f6l\u00fcm\u00fcne gelmek i\u00e7in SQL Server (MSSQLSERVER)<\/strong> servisi \u00fczerine \u00e7ift t\u0131klan\u0131r. AlwaysOn High Availability Sekmesinde Enable AlwaysOn Availability Groups \u00f6zelli\u011fi t\u0131klanarak aktifle\u015ftirilir. E\u011fer bu ad\u0131mda Windows Cluster d\u00fczg\u00fcn kurulmam\u0131\u015fsa bu \u00f6zelli\u011fi aktif edemezsiniz. \u00c7\u00fcnk\u00fc SQL Server AlwaysOn Windows Cluster s\u0131z \u00e7al\u0131\u015fmaz, t\u0131pk\u0131 SQL Server Failover Cluster gibi.<\/p>\n

\"\"<\/p>\n

Bu i\u015flem sonras\u0131nda SQL Server servisinin restart<\/strong> edilmesi gerekir.<\/p>\n

Restart sonras\u0131 SQL Server Instance \u00f6zelliklerine bakt\u0131\u011f\u0131m\u0131zda AlwaysOn un aktif oldu\u011funu a\u015fa\u011f\u0131daki gibi g\u00f6rebiliyoruz.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\u015eimdi AlwaysOn kurulumuna ba\u015flayabiliriz.\u00a0SQL Server 2012, 2014, 2016\u00a0 AlwaysOn Availability Group yaratmak i\u00e7in \u00f6ncelikle SQL Server Management Studio ile SQL Server Instance\u2019a ba\u011flan\u0131l\u0131r. Object Explorer<\/strong> \u00fczerinde AlwaysOn High Availability<\/strong> \u00f6zelli\u011fi alt\u0131nda bulunan Availability Groups \u00fczerine sa\u011f t\u0131klanarak New Availability Group Wizard<\/strong> ba\u015flat\u0131l\u0131r.<\/p>\n

\"\"<\/p>\n

Introduction<\/strong> sayfas\u0131 Next diyerek ge\u00e7ilir.<\/p>\n

\"\"<\/p>\n

Olu\u015fturulmak istenen Availability Group i\u00e7in bir isim belirlenir.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Select Databases<\/strong> sayfas\u0131nda Availability Group\u2019a dahil edilmesi istenen veritabanlar\u0131 se\u00e7ilir. Bir veritaban\u0131n\u0131n Availability Group\u2019a dahil edilebilmesi i\u00e7in Full Recovery Mode<\/strong> \u00f6zelli\u011finin aktif olmas\u0131 ve i\u015flem \u00f6ncesinde mutlaka bir kez full yede\u011finin<\/strong> al\u0131nm\u0131\u015f olmas\u0131 gerekir.<\/p>\n

\"\"\"\"<\/p>\n

A\u015fa\u011f\u0131daki gibi backup al\u0131yoruz.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Ve uyar\u0131 gidiyor art\u0131k ilerleyebiliriz.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Specify Replicas<\/strong> sayfas\u0131nda, replikasyon yap\u0131lacak ikinci sunucu (varsa \u00fc\u00e7\u00fcnc\u00fc sunucu da) Add Replica<\/strong> k\u0131sm\u0131ndan di\u011fer node\u2019a ba\u011flant\u0131 sa\u011flanarak a\u015fa\u011f\u0131daki \u015fekilde eklenir.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Her iki node \u00fczerinde senaryoya ba\u011fl\u0131 olarak automatic failover<\/strong>, synchronous commit<\/strong>, readable secondary<\/strong> rolleri i\u00e7in sunuculara atamalar yap\u0131l\u0131r. (Bizim senaryomuza g\u00f6re her bir \u00f6zellik se\u00e7ilir, her bir sunucu readable secondary olarak belirlenir.)<\/p>\n

Primary Ve Secondary Nodelar eklendi ve Readable Secondary i her 2 Instance i\u00e7in Yes diyoruz, b\u00f6ylece Secondary Instances\u0131m\u0131z hert\u00fcrl\u00fc Readable olmu\u015f olacak. Automatic Failover se\u00e7ene\u011finide se\u00e7erek Automatic Failover \u0131 Aktifle\u015ftiriyoruz, yaln\u0131z bu \u00f6zellik 2 Instance a kadar ge\u00e7erlidir.<\/p>\n

\"\"<\/p>\n

Endpoints<\/strong> tab\u0131nda gerekli port ayarlar\u0131 yap\u0131l\u0131r. Endpointler Availability Groups\u2019a dahil olan SQL sunucular\u0131n replikasyon i\u015flemleri i\u00e7in sunucular aras\u0131ndaki haberle\u015fmeyi sa\u011flar. Bu nedenle dikkat edilmesi gereken nokta, endpointler i\u00e7in kullan\u0131lan port i\u00e7in Firewall \u00fczerinde ilgili portun a\u00e7\u0131lm\u0131\u015f olmas\u0131 gerekir.<\/p>\n

\"\"<\/p>\n

Bu ad\u0131mda Backup\u0131n nereden al\u0131naca\u011f\u0131n\u0131 vs belirliyoruz, Primary e gelen y\u00fck\u00fcn azalt\u0131lmas\u0131 i\u00e7in Backuplar\u0131 Secondaryden alman\u0131z\u0131 tavsiye ederim.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\"\"<\/p>\n

E\u011fer SQL sunucular\u0131na farkl\u0131 IP ve Hostname ile eri\u015fmek isteniyorsa, Listener<\/strong> tab\u0131ndan Availability Group Listener<\/strong> tan\u0131mlaman\u0131z gerekir. Listener tan\u0131mlama i\u015flemi kurulum s\u0131ras\u0131nda yap\u0131lmasa bile daha sonra ilgili availability group \u00fczerinden Add Listener<\/strong> se\u00e7ene\u011fi ile tan\u0131mlanabilir. Bu listener AlwaysOn listener\u0131 olarakta ge\u00e7er, Failover Clusterdaki Failover Cluster name ve IP ile ayn\u0131d\u0131r diyebiliriz. Kurulum bittikten sonra AlwaysOn a local IP lerden de\u011filde bu IP ve name ile eri\u015fiyor olaca\u011f\u0131z.<\/p>\n

Listener olu\u015fturulmadan \u00f6nce, availability grubu bar\u0131nd\u0131ran Windows Server Failover Cluster objesinin Create Computer Objects yetkisine sahip olmas\u0131 gerekir. Aksi takdirde, a\u015fa\u011f\u0131daki \u015fekilde bir hata al\u0131nacakt\u0131r. (create computer objects)<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Select Data Synchronization<\/strong> ad\u0131m\u0131nda t\u00fcm replikasyon sunucular\u0131n\u0131n eri\u015fiminin oldu\u011fu payla\u015f\u0131ml\u0131 bir lokasyon belirtilmesi gerekmektedir. Ayr\u0131ca bu lokasyon \u00fczerinde SQL Service<\/strong> ve Analysis Service<\/strong> hesaplar\u0131n\u0131n read\/write<\/strong> yetkilerinin tan\u0131mlanm\u0131\u015f olmas\u0131 gerekti\u011fi g\u00f6z ard\u0131 edilmemelidir<\/p>\n

\"\"<\/p>\n

Next diyerek ilerliyoruz ve t\u00fcm kontroller yap\u0131l\u0131yor.<\/p>\n

\"\" \"\"<\/p>\n

Kurulum ba\u015flad\u0131.<\/p>\n

\"\"<\/p>\n

Kurulum ba\u015far\u0131l\u0131 bir \u015fekilde a\u015fa\u011f\u0131daki gibi tamamlanm\u0131\u015ft\u0131r.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

B\u00f6ylece bu yaz\u0131n\u0131nda sonuna gelmi\u015f bulunmaktay\u0131m bir sonraki yaz\u0131da AlwaysOn a devam ediyor olaca\u011f\u0131m.<\/p>\n\n

 <\/p>\n

Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n

– Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Exadata Bak\u0131m ve Destek<\/span>
\n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Goldengate Bak\u0131m ve Destek<\/span>
\n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Linux Bak\u0131m ve Destek<\/span>
\n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EBS Bak\u0131m ve Destek<\/span>
\n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Weblogic Bak\u0131m ve Destek<\/span>
\n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
\n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle VM Server Bak\u0131m ve Destek<\/span>
\n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EPPM Bak\u0131m ve Destek<\/span>
\n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Primavera Bak\u0131m ve Destek<\/span>
\n– Oracle E\u011fitimleri<\/span>
\n– SQL Server E\u011fitimleri<\/span>
\n– Goldengate E\u011fitimleri<\/span>
\n– Exadata E\u011fitimleri<\/span>
\n– Linux E\u011fitimleri<\/span>
\n– Oracle EBS E\u011fitimleri<\/span>
\n– Oracle VM Server E\u011fitimleri<\/span>
\n– Weblogic E\u011fitimleri<\/span>
\n– Oracle EPPM E\u011fitimleri<\/span>
\n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Merhaba Arkada\u015flar, Bu yaz\u0131mda SQL Server AlwaysOn u anlatmaya devam edece\u011fim. Bu yaz\u0131 bir \u00f6nceki yaz\u0131n\u0131n devam\u0131 niteli\u011findedir. O y\u00fczden bu yaz\u0131ya ba\u015flamadan \u00f6nceki yaz\u0131y\u0131 okuman\u0131z\u0131 tavsiye ederim.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,23],"tags":[108,460,508,614,1000,1031,1515,1577,1583,1594,1601,1618,1619,1632,1647,1653],"class_list":["post-5025","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-alwayson","tag-database-high-availability","tag-deveci","tag-failover","tag-log-shipping","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-2008-log-shipping","tag-sql-server-2012-alwayson","tag-sql-server-alwayson","tag-sql-server-alwayson-kurulumu","tag-sql-server-disaster-recovery","tag-sql-server-high-availability","tag-sql-server-log-shipping"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=5025"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5025\/revisions"}],"predecessor-version":[{"id":5764,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5025\/revisions\/5764"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=5025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=5025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=5025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}