{"id":3110,"date":"2013-04-04T10:38:15","date_gmt":"2013-04-04T10:38:15","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=3110"},"modified":"2019-02-28T08:51:39","modified_gmt":"2019-02-28T08:51:39","slug":"sql-server-2008-failover-cluster-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-2008-failover-cluster-2\/","title":{"rendered":"SQL SERVER 2008 FAILOVER CLUSTER -2"},"content":{"rendered":"

Merhaba,<\/p>\n

Bu yaz\u0131mda \u00f6nceki yaz\u0131mda anlatt\u0131\u011f\u0131m Failover Cluster kurulumunun 2.aya\u011f\u0131 olan Cluster a node ekleme b\u00f6l\u00fcm\u00fcn\u00fc anlataca\u011f\u0131m. Bu yaz\u0131y\u0131 okumadan \u00f6nce bir \u00f6nceki <\/a>yaz\u0131y\u0131 okuman\u0131z gerekir \u00e7\u00fcnk\u00fc bu yaz\u0131 \u00f6nceki yaz\u0131n\u0131n<\/a> devam\u0131 niteli\u011findedir.<\/p>\n

\"ActivePassiveCluster\"<\/a><\/p>\n

<\/p>\n\n

Failover Cluster mimarisine uygulaman\u0131n kritikli\u011fine g\u00f6re node eklenir. Bankac\u0131l\u0131k ve Telekom\u00fcnikasyon uygulamalar\u0131nda 4 node a kadar \u00e7\u0131k\u0131ld\u0131\u011f\u0131n\u0131 biliyorum. SQL Server 2008 Enterprise R2 de zaten en fazla 16 node a kadar \u00e7\u0131k\u0131labiliyor bu say\u0131 SQL Server 2012 de 64 e kadar \u00e7\u0131km\u0131\u015ft\u0131r. Yine belirteyim eklenecek node un say\u0131s\u0131 tamamen uygulaman\u0131n kritikli\u011fine g\u00f6re de\u011fi\u015fir. Neticede eklenen her node demek bir sunucu ve ona ayr\u0131lan kaynaklar demek. Node say\u0131s\u0131 art\u0131k\u00e7a maliyet artar ancak High Availability y\u00fczdeniz de artar \u00e7\u00fcnk\u00fc down olan her sunucunun alternatif node unun bulunmas\u0131 maksimum hizmet potansiyelimizi art\u0131racakt\u0131r. \u00d6nceki yaz\u0131m\u0131zda Windows Cluster kurulumu bulunan 2 ayr\u0131 sunucunun birinde SQL Server Cluster kurulumunu yapm\u0131\u015ft\u0131k. \u015eimdi ayn\u0131 Cluster a node ekliyoruz. Ad\u0131mlar a\u015fa\u011f\u0131daki gibi olacakt\u0131r.<\/p>\n

1. Kurulum dosyalar\u0131n\u0131n i\u00e7inde a\u015fa\u011f\u0131daki gibi setup.exe yi \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/p>\n

\"1\"<\/a><\/p>\n

 <\/p>\n

\"2\"<\/a><\/p>\n

2. Bu ad\u0131mda OK butonuna t\u0131klay\u0131p devam ediyoruz.<\/p>\n

\"3\"<\/a><\/p>\n

3. Bu ad\u0131mda Product Key i girip Next butonuna t\u0131klay\u0131p devam ediyoruz.<\/p>\n

\"4\"<\/a><\/p>\n

4. Bu ad\u0131mda Next butonuna t\u0131klay\u0131p devam ediyoruz.<\/p>\n

\"5\"<\/a><\/p>\n

4. Bu ad\u0131mda Install butonuna t\u0131klay\u0131p devam ediyoruz. \"6\"<\/a><\/p>\n

5. Bu ad\u0131mda a\u015fa\u011f\u0131daki resimde de g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi Windows Cluster \u00fczerinde Sistemsel ve Networksel gerekli parametreler check ediliyor. Bir sorun olursa devam etmeyecektir yada kurulum problemli olacakt\u0131r. A\u015fa\u011f\u0131da da g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi bizim kurulumuzda s\u0131k\u0131nt\u0131 olmad\u0131\u011f\u0131 i\u00e7in baz\u0131 \u00f6nemsiz warningler d\u0131\u015f\u0131nda hata bulunmamaktad\u0131r. Next butonuna bas\u0131p devam ediyoruz.<\/p>\n

\"7\"<\/a><\/p>\n

6.Bu ad\u0131mda Cluster \u0131n Node Configurasyonu yap\u0131lmaktad\u0131r. Instance Name, Kurulan Node un Ad\u0131 ve Cluster Network Name de\u011ferleri girilir. Aktif ve pasif Node a istedi\u011fimiz ad\u0131 verebiliriz ancak Cluster Name i \u00f6nceden belirlenmi\u015f olan Cluster Name i girmek zorunday\u0131z. Next deyip devam ediyoruz.<\/p>\n

\"8\"<\/a><\/p>\n

7. Bu ad\u0131mda Instance \u0131 \u00e7al\u0131\u015ft\u0131ran Account lar \u00f6nceki Node ile ayn\u0131 olaca\u011f\u0131 i\u00e7in Next deyip devam ediyoruz.<\/p>\n

\"9\"<\/a><\/p>\n

8. Bu ad\u0131mda Next butonuna t\u0131klay\u0131p devam ediyoruz.<\/p>\n

\"10\"<\/a><\/p>\n

9. Bu ad\u0131mda Next butonuna t\u0131klay\u0131p devam ediyoruz.<\/p>\n

\"11\"<\/a><\/p>\n

10. Bu ad\u0131mda Install butonuna t\u0131klay\u0131p kurulumu tamaml\u0131yoruz.<\/p>\n

\"12\"<\/a><\/p>\n

\"14\"<\/a><\/p>\n

A\u015fa\u011f\u0131da da g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi Cluster a Node ekleme i\u015flemimiz ba\u015far\u0131l\u0131 bir \u015fekilde tamamlanm\u0131\u015ft\u0131r.<\/p>\n

\"15\"<\/a><\/p>\n

SQL Server 2008 R2 de Failover Cluster kurulumunu tamamlad\u0131k. Elimizde Aktif ve pasif \u00e7al\u0131\u015fan bir Failover Cluster veritaban\u0131 bulunmaktad\u0131r. Uygulaman\u0131n eri\u015fim bilgisine Cluster IP yi veriyoruz uygulama her \u015fekilde veritaban\u0131m\u0131za eri\u015fecek ve servis alacakt\u0131r. Sunucu Down oldu\u011fu zaman otomatik olarak Windows Cluster SQL Server Servislerini di\u011fer node a ta\u015f\u0131y\u0131p shared disk i de oraya mount edecektir.<\/p>\n

B\u00f6ylece veritaban\u0131m\u0131z pasif olan node un aktif olmas\u0131yla hizmet vermeye devam edecektir. Bazen aktif node da bir bak\u0131m \u00e7al\u0131\u015fmas\u0131 olabilir bu durumda admin manuel olarak ta Failover yapabilir. SQL Server Cluster veritaban\u0131m\u0131zla beraber bu veritaban\u0131na ba\u011flanacak olan uygulama i\u00e7in High Availability i sa\u011flam\u0131\u015f oluruz.<\/p>\n

Kurulumu tamamlad\u0131ktan sonra SQL Server Cluster \u0131 Sistemsel olarak Y\u00f6netmek i\u00e7in Sunucu \u00dczerinde Server Manager<\/strong> adl\u0131 tool bulunmaktad\u0131r. Bu tool u a\u00e7t\u0131\u011f\u0131m\u0131z zaman a\u015fa\u011f\u0131daki gibi Cluster \u0131 y\u00f6netebilece\u011fimiz aray\u00fcz gelmektedir. Buradan Cluster konfig\u00fcrasyonu hakk\u0131ndaki bilgileri bulabilir ayr\u0131ca Cluster \u0131 Sistemsel olarak y\u00f6netebiliriz.<\/p>\n

\"16\"<\/a><\/p>\n

A\u015fa\u011f\u0131daki resimde ise kurmu\u015f oldu\u011fumuz Failover Cluster \u0131n Aktif olan node unu a\u00e7\u0131yoruz. A\u015fa\u011f\u0131da oklarla da g\u00f6sterildi\u011fi gibi aktif olarak se\u00e7mi\u015f oldu\u011fumuz Node un Online oldu\u011fu g\u00f6r\u00fclmektedir. Burada Node un \u00fcst\u00fcne sa\u011f t\u0131klayarak manuel failover yapabiliriz. Diskleri mount veya diskmount edebiliriz. K\u0131saca yukar\u0131da da bahsetti\u011fim gibi Server Manager tool unda Cluster ile ilgili olarak her t\u00fcrl\u00fc i\u015flemi ger\u00e7ekle\u015ftirebiliriz.<\/p>\n

\"17\"<\/a><\/p>\n

B\u00f6ylece bu yaz\u0131m\u0131n daha sonuna gelmi\u015f bulunmaktay\u0131m. Bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle Esen Kal\u0131n…<\/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, Bu yaz\u0131mda \u00f6nceki yaz\u0131mda anlatt\u0131\u011f\u0131m Failover Cluster kurulumunun 2.aya\u011f\u0131 olan Cluster a node ekleme b\u00f6l\u00fcm\u00fcn\u00fc anlataca\u011f\u0131m. Bu yaz\u0131y\u0131 okumadan \u00f6nce bir \u00f6nceki yaz\u0131y\u0131 okuman\u0131z gerekir \u00e7\u00fcnk\u00fc bu yaz\u0131 \u00f6nceki yaz\u0131n\u0131n devam\u0131 niteli\u011findedir.<\/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":[508,615,616,617,717,1031,1515,1577,1583,1624,1646,1647],"class_list":["post-3110","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-deveci","tag-failover-cluster","tag-failover-cluster-node-ekleme","tag-failover-clustering","tag-high-availability","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-cluster","tag-sql-server-failover-cluster","tag-sql-server-high-availability"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/3110","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=3110"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/3110\/revisions"}],"predecessor-version":[{"id":5890,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/3110\/revisions\/5890"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=3110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=3110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=3110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}