1.Database Mirroring nedir Neden Kullan\u0131l\u0131r ?<\/strong><\/p>\nDatabase mirroring, beklenmedik bir hata, felaket yada istenmeyen durumlarda felaketten d\u00f6nme ve y\u00fcksek eri\u015filebilirli\u011fi (High availability) sa\u011flamak i\u00e7in Microsoft un SQL Server i\u00e7in geli\u015ftirmi\u015f oldu\u011fu bir \u00e7\u00f6z\u00fcmd\u00fcr.<\/p>\n
Microsoft ilk olarak SQL Server 2005 ile bu teknolojiyi tan\u0131tm\u0131\u015ft\u0131r. Dolay\u0131s\u0131yla SQL Server 2005 \u00f6ncesi s\u00fcr\u00fcmlerde bu teknoloji bulunmamaktad\u0131r. Database Mirroring olay\u0131 SQL Server 2005\/2008\/2008 R2 ile aktif bir \u015fekilde kullan\u0131lmaktad\u0131r.<\/p>\n
Database Mirroring olay\u0131 temelde bir veritaban\u0131n\u0131n farkl\u0131 bir sunucuda aktif bir kopyas\u0131 tutularak kaynak veritaban\u0131nda meydana gelebilecek sunucu hatas\u0131, veritaban\u0131 bozulmas\u0131, Disk bozulmas\u0131 \u00a0vsvs gibi hatalar sonucu database in servis veremedi\u011fi durumda mirror sunucuda bulunan mirror database den devam etmek i\u00e7in kullan\u0131lmaktad\u0131r.<\/p>\n
Mirroring olay\u0131nda ki temel hedef Failover Cluster da oldu\u011fu gibi S\u0131f\u0131r veri kayb\u0131, Maksimum d\u00fczeyde servis sa\u011flamak ve i\u015f s\u00fcreklili\u011fi olu\u015fturmakt\u0131r. Mirroring teknolojisinin kullan\u0131ld\u0131\u011f\u0131 ba\u015fka bir alan ise raporlamad\u0131r.<\/p>\n
OLTP sistemlerde sistem y\u00fck\u00fcn\u00fc azaltmak i\u00e7in Raporlama yapan ekipleri mirror database e y\u00f6nlendirilebilir buda ana sunucudaki i\u015f y\u00fck\u00fcn\u00fc azaltacakt\u0131r. Tabi bu durum \u00e7ok a\u015f\u0131r\u0131 yo\u011fun Transaction alan veritabanlar\u0131n da veritaban\u0131n\u0131 rahatlatmak i\u00e7in ge\u00e7erlidir. Burda dikkat edilmesi gereken bir \u015fey vard\u0131r ki oda Mirror database ancak Snapshot \u0131 al\u0131nd\u0131ktan sonra okunabilir moda gelir bu \u015fekilde raporlama yap\u0131labilir.<\/p>\n
2.Mirroring i\u00e7in \u00f6ncesi gereksinimler<\/strong><\/p>\nMirroring olay\u0131n\u0131n ger\u00e7eklenebilmesi i\u00e7in minimum olarak bir Principal ve bir Mirror sunucuya ihtiya\u00e7 vard\u0131r. Witness sunucu kullanmak zorunlu de\u011fildir. E\u011fer Rol de\u011fi\u015fikli\u011fini manuel olarak yapacaksan\u0131z ve bu sizin uygulamalar\u0131n\u0131z i\u00e7in bir sorun te\u015fkil etmiyorsa kullanmayabilirsiniz.<\/p>\n
Witness sunucu otomatik ge\u00e7i\u015f i\u00e7in gereklidir yani Principal database eri\u015fime kapand\u0131\u011f\u0131nda Witness otomatik olarak Mirror database i devreye al\u0131r ve Mirror database inin servise a\u00e7\u0131lmas\u0131n\u0131 sa\u011flar. Database mirroring olay\u0131n\u0131n ger\u00e7eklenebilmesi i\u00e7in SQL Server Versiyonlar\u0131n\u0131n ve s\u00fcr\u00fcm numaralar\u0131n\u0131n her iki sunucuda da ayn\u0131 olmas\u0131 gerekmektedir. Ancak Principal ve Mirror sunucular\u0131n\u0131n bu olay\u0131 ger\u00e7ekle\u015ftirebilmesi i\u00e7in \u0130\u015fletim sistemlerinin ayn\u0131 s\u00fcr\u00fcm olmas\u0131 zorunlu de\u011fildir.<\/p>\n
Di\u011fer taraftan Principal ve Mirror sunucuda mirroring yap\u0131labilmesi i\u00e7in her iki SQL Server \u0131 \u00e7al\u0131\u015ft\u0131ran Service Account \u0131n\u0131n kesinlikle ayn\u0131 olmas\u0131 gerekmektedir.<\/p>\n
Bu yaz\u0131m\u0131n sonuna gelmi\u015f bulunmaktay\u0131m. Bir sonraki yaz\u0131da bu yaz\u0131n\u0131n devam\u0131 niteli\u011finde olacak ve Database Mirroring Konfig\u00fcrasyonunu ve ger\u00e7eklenmesini SQL Server 2008 de uygulamal\u0131 olarak anlataca\u011f\u0131m. \u015eimdilik esenle 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 ve bundan sonraki bir ka\u00e7 makalemde SQL Server 2008 de database mirroring kavram\u0131n\u0131n ne oldu\u011funu neden kullan\u0131ld\u0131\u011f\u0131n\u0131 ve SQL Server 2008 de bu \u00e7\u00f6z\u00fcm\u00fcn uygulanmas\u0131n\u0131 g\u00f6rsel olarak anlataca\u011f\u0131m.<\/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":[466,508,717,1031,1049,1515,1577,1583,1630,1647],"class_list":["post-2871","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-database-mirroring","tag-deveci","tag-high-availability","tag-mehmet-salih-deveci","tag-mirroring","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-database-mirroring","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\/2871","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=2871"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2871\/revisions"}],"predecessor-version":[{"id":5900,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2871\/revisions\/5900"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=2871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=2871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=2871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Database_Mirroring\"](\"http:\/\/salihdeveci.files.wordpress.com\/2013\/01\/database_mirroring.jpg\")
<\/a><\/p>\n