{"id":12569,"date":"2024-01-22T16:43:07","date_gmt":"2024-01-22T13:43:07","guid":{"rendered":"https:\/\/itsm.com\/?p=12569"},"modified":"2024-09-20T16:50:22","modified_gmt":"2024-09-20T13:50:22","slug":"masshtabirovanie-baz-dannyh-2","status":"publish","type":"post","link":"https:\/\/itsm.com\/tr\/blog\/masshtabirovanie-baz-dannyh-2\/","title":{"rendered":"Veritaban\u0131 \u00f6l\u00e7eklendirme"},"content":{"rendered":"

\u0130\u015f geli\u015ftirme s\u00fcrecinde, gerekli verilerin ve bunlarla yap\u0131lan i\u015flemlerin hacmi artar. Belirli bir noktada, bir sunucu art\u0131k y\u00fck ile ba\u015fa \u00e7\u0131kamaz ve ard\u0131ndan veritaban\u0131 \u00f6l\u00e7eklendirmesi gerekir. Bu s\u00fcre\u00e7 nas\u0131l ger\u00e7ekle\u015ftirilir?<\/p>\n

[cta_banner link=”https:\/\/itsm.com\/tr\/platform\/” title=”Daha detayl\u0131”]\u00d6l\u00e7eklenebilir ESM sistemi<\/a> [\/cta_banner]\n

Dikey \u00d6l\u00e7ekleme<\/h2>\n

Dikey \u00f6l\u00e7eklendirme sunucu kapasitesinin art\u0131r\u0131lmas\u0131n\u0131 i\u00e7erir. Y\u00f6ntemin ana avantaj\u0131 basitli\u011fidir. Kapasite eklerken kodu yeniden yazmaya gerek yoktur ve b\u00fcy\u00fck bir sunucuyu y\u00f6netmek t\u00fcm sistemi y\u00f6netmekten \u00e7ok daha kolayd\u0131r. Bu ayn\u0131 zamanda ana dezavantajd\u0131r – bir sunucunun kaynaklar\u0131n\u0131 \u00f6l\u00e7eklendirmenin olduk\u00e7a spesifik donan\u0131m s\u0131n\u0131rlamalar\u0131 vard\u0131r. B\u00f6yle bir \u00e7\u00f6z\u00fcm\u00fcn maliyetini de g\u00f6z \u00f6n\u00fcnde bulundurmak gerekir: \u00e7o\u011fu durumda \u00e7ok say\u0131da hesaplama kayna\u011f\u0131na sahip bir sunucu, toplamda ayn\u0131 performans\u0131 veren daha az g\u00fc\u00e7l\u00fc birka\u00e7 sunucudan daha pahal\u0131d\u0131r.<\/p>\n

Yatay \u00f6l\u00e7eklendirme<\/h2>\n

Yatay \u00f6l\u00e7eklendirme, verileri birden fazla sunucuya b\u00f6lerek performans\u0131 art\u0131rmak anlam\u0131na gelir. Bu y\u00f6ntem, hata tolerans\u0131n\u0131 azaltmadan performans\u0131 art\u0131rmay\u0131 i\u00e7erir. \u00dc\u00e7 ana yatay \u00f6l\u00e7eklendirme t\u00fcr\u00fc vard\u0131r.<\/p>\n

\u00c7o\u011faltma<\/h3>\n

Bu terim, verilerin sunucular aras\u0131nda kopyalanmas\u0131 anlam\u0131na gelir. Bu y\u00f6ntemi kullan\u0131rken iki t\u00fcr sunucu vard\u0131r: master ve slave. Master bilgileri yazmak veya de\u011fi\u015ftirmek i\u00e7in kullan\u0131l\u0131r, slave’ler ise master’dan bilgileri kopyalamak ve okumak i\u00e7in kullan\u0131l\u0131r. \u00c7o\u011fu zaman bir master ve birka\u00e7 slave kullan\u0131l\u0131r, \u00e7\u00fcnk\u00fc genellikle okuma istekleri de\u011fi\u015ftirme isteklerinden daha fazlad\u0131r. \u00c7o\u011faltman\u0131n ana avantaj\u0131 \u00e7ok say\u0131da veri kopyas\u0131d\u0131r. Dolay\u0131s\u0131yla, ana sunucu bile ar\u0131zalan\u0131rsa, ba\u015fka herhangi bir sunucu onun yerini alabilir. Ancak replikasyon bir \u00f6l\u00e7eklendirme mekanizmas\u0131 olarak \u00e7ok uygun de\u011fildir. Bunun nedeni sunucular aras\u0131nda veri aktar\u0131m\u0131ndaki senkronizasyonsuzluk ve gecikmelerdir. Replikasyon \u00e7o\u011funlukla di\u011fer \u00f6l\u00e7eklendirme y\u00f6ntemleriyle birlikte hata tolerans\u0131 sa\u011flama arac\u0131 olarak kullan\u0131l\u0131r.<\/p>\n

B\u00f6l\u00fcmleme\/B\u00f6l\u00fcmlere Ay\u0131rma<\/h3>\n

Bu \u00f6l\u00e7eklendirme y\u00f6ntemi, verilerin baz\u0131 \u00f6zelliklere g\u00f6re par\u00e7alara ayr\u0131lmas\u0131n\u0131 i\u00e7erir. \u00d6rne\u011fin, bir tablo pariteye g\u00f6re ikiye b\u00f6l\u00fcnebilir. B\u00f6l\u00fcmleme kullanman\u0131n nedeni performans\u0131 art\u0131rmakt\u0131r. Bunun nedeni, araman\u0131n t\u00fcm tablo \u00fczerinde de\u011fil, yaln\u0131zca bir par\u00e7as\u0131 \u00fczerinde ger\u00e7ekle\u015ftirilmesidir. Bu y\u00f6ntemin bir di\u011fer avantaj\u0131 da ilgisiz bir tablo par\u00e7as\u0131n\u0131 h\u0131zl\u0131 bir \u015fekilde silebilmesidir.<\/p>\n

Sharding\/sharding\/segmenting<\/h3>\n

Par\u00e7alama, bir tablonun par\u00e7alar\u0131n\u0131n farkl\u0131 fiziksel sunucularda ayr\u0131 ayr\u0131 depoland\u0131\u011f\u0131 bir veritaban\u0131 tasar\u0131m ilkesidir. Sharding, \u00f6zellikle replikasyon ile e\u015fle\u015ftirildi\u011finde b\u00fcy\u00fck \u00f6l\u00e7ekli i\u015flemler i\u00e7in en uygun \u00e7\u00f6z\u00fcmd\u00fcr. Ancak sunucular aras\u0131 ileti\u015fimin dikkate al\u0131nmas\u0131 gerekti\u011finden organize edilmesinin olduk\u00e7a zor oldu\u011funu belirtmek gerekir.<\/p>\n

\u00d6zet<\/h2>\n

Bilgi ve kullan\u0131c\u0131 hacminin her ge\u00e7en g\u00fcn artt\u0131\u011f\u0131 kurumsal y\u00fcksek y\u00fckl\u00fc sistemlerin olu\u015fturulmas\u0131 nedeniyle, sistemi \u00f6l\u00e7eklendirme yetene\u011fi, se\u00e7imindeki temel fakt\u00f6rlerden biridir. Sonu\u00e7ta, i\u015f geli\u015ftirmenin her a\u015famas\u0131na uzun ve karma\u015f\u0131k bir bilgi deste\u011fi optimizasyonu s\u00fcreci e\u015flik edecekse, bilgi sistemi se\u00e7iminin do\u011frulu\u011fu hakk\u0131nda d\u00fc\u015f\u00fcnmeye de\u011fer.<\/p>","protected":false},"excerpt":{"rendered":"

\u0130\u015f geli\u015ftirme s\u00fcrecinde, gerekli verilerin ve bunlarla yap\u0131lan i\u015flemlerin hacmi artar. Belirli bir noktada, bir sunucu art\u0131k y\u00fck ile ba\u015fa \u00e7\u0131kamaz ve ard\u0131ndan veritaban\u0131 \u00f6l\u00e7eklendirmesi gerekir. Bu s\u00fcre\u00e7 nas\u0131l ger\u00e7ekle\u015ftirilir? [cta_banner link=”https:\/\/itsm.com\/tr\/platform\/” title=”Daha detayl\u0131”]\u00d6l\u00e7eklenebilir ESM sistemi [\/cta_banner] Dikey \u00d6l\u00e7ekleme Dikey \u00f6l\u00e7eklendirme sunucu kapasitesinin art\u0131r\u0131lmas\u0131n\u0131 i\u00e7erir. Y\u00f6ntemin ana avantaj\u0131 basitli\u011fidir. Kapasite eklerken kodu yeniden yazmaya gerek […]<\/p>\n","protected":false},"author":48,"featured_media":12570,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[15],"yoast_head":"Veritaban\u0131 \u00f6l\u00e7eklendirme - SimpleOne - Business Process Automation Platform<\/title>\n<meta name=\"description\" content=\"SimpleOne - Business Process Automation Platform Veritaban\u0131 \u00f6l\u00e7eklendirme\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Veritaban\u0131 \u00f6l\u00e7eklendirme - SimpleOne - Business Process Automation Platform\" \/>\n<meta property=\"og:description\" content=\"SimpleOne - Business Process Automation Platform Veritaban\u0131 \u00f6l\u00e7eklendirme\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/\" \/>\n<meta property=\"og:site_name\" content=\"SimpleOne - Business Process Automation Platform\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-22T13:43:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itsm.com\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\" \/>\n\t<meta property=\"og:image:width\" content=\"921\" \/>\n\t<meta property=\"og:image:height\" content=\"641\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/itsm.com\/#organization\",\"name\":\"SimpleOne\",\"url\":\"https:\/\/itsm.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/itsm.com\/#logo\",\"inLanguage\":\"tr\",\"url\":\"\/wp-content\/uploads\/2023\/11\/main_logo-1.png\",\"contentUrl\":\"\/wp-content\/uploads\/2023\/11\/main_logo-1.png\",\"width\":166,\"height\":23,\"caption\":\"SimpleOne\"},\"image\":{\"@id\":\"https:\/\/itsm.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/itsm.com\/#website\",\"url\":\"https:\/\/itsm.com\/\",\"name\":\"SimpleOne - Business Process Automation Platform\",\"description\":\"\u3164\",\"publisher\":{\"@id\":\"https:\/\/itsm.com\/#organization\"},\"inLanguage\":\"tr\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage\",\"inLanguage\":\"tr\",\"url\":\"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\",\"contentUrl\":\"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\",\"width\":921,\"height\":641},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage\",\"url\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/\",\"name\":\"[:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:] - SimpleOne - Business Process Automation Platform\",\"isPartOf\":{\"@id\":\"https:\/\/itsm.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage\"},\"datePublished\":\"2024-01-22T13:43:07+00:00\",\"dateModified\":\"2024-09-20T13:50:22+00:00\",\"description\":\"SimpleOne - Business Process Automation Platform [:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:]\",\"breadcrumb\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/itsm.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database scaling\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage\"},\"author\":{\"@id\":\"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358\"},\"headline\":\"Veritaban\u0131 \u00f6l\u00e7eklendirme\",\"datePublished\":\"2024-01-22T13:43:07+00:00\",\"dateModified\":\"2024-09-20T13:50:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage\"},\"wordCount\":1701,\"publisher\":{\"@id\":\"https:\/\/itsm.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\",\"keywords\":[\"Y\u00fcksek y\u00fck\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358\",\"name\":\"lyubov azarenko\",\"url\":\"https:\/\/itsm.com\/tr\/author\/lyubov-azarenko\/\"}]}<\/script>","yoast_head_json":{"title":"[:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:] - SimpleOne - Business Process Automation Platform","description":"SimpleOne - Business Process Automation Platform Veritaban\u0131 \u00f6l\u00e7eklendirme","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"tr_TR","og_type":"article","og_title":"Veritaban\u0131 \u00f6l\u00e7eklendirme - SimpleOne - Business Process Automation Platform","og_description":"SimpleOne - Business Process Automation Platform Veritaban\u0131 \u00f6l\u00e7eklendirme","og_url":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/","og_site_name":"SimpleOne - Business Process Automation Platform","article_published_time":"2024-01-22T13:43:07+00:00","og_image":[{"width":921,"height":641,"url":"https:\/\/itsm.com\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/itsm.com\/#organization","name":"SimpleOne","url":"https:\/\/itsm.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/itsm.com\/#logo","inLanguage":"tr","url":"\/wp-content\/uploads\/2023\/11\/main_logo-1.png","contentUrl":"\/wp-content\/uploads\/2023\/11\/main_logo-1.png","width":166,"height":23,"caption":"SimpleOne"},"image":{"@id":"https:\/\/itsm.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/itsm.com\/#website","url":"https:\/\/itsm.com\/","name":"SimpleOne - Business Process Automation Platform","description":"\u3164","publisher":{"@id":"https:\/\/itsm.com\/#organization"},"inLanguage":"tr"},{"@type":"ImageObject","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage","inLanguage":"tr","url":"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","contentUrl":"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","width":921,"height":641},{"@type":"WebPage","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage","url":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/","name":"[:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:] - SimpleOne - Business Process Automation Platform","isPartOf":{"@id":"https:\/\/itsm.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage"},"datePublished":"2024-01-22T13:43:07+00:00","dateModified":"2024-09-20T13:50:22+00:00","description":"SimpleOne - Business Process Automation Platform [:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:]","breadcrumb":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/itsm.com\/"},{"@type":"ListItem","position":2,"name":"Database scaling"}]},{"@type":"Article","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#article","isPartOf":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage"},"author":{"@id":"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358"},"headline":"Veritaban\u0131 \u00f6l\u00e7eklendirme","datePublished":"2024-01-22T13:43:07+00:00","dateModified":"2024-09-20T13:50:22+00:00","mainEntityOfPage":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage"},"wordCount":1701,"publisher":{"@id":"https:\/\/itsm.com\/#organization"},"image":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","keywords":["Y\u00fcksek y\u00fck"],"articleSection":["Blog"],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358","name":"lyubov azarenko","url":"https:\/\/itsm.com\/tr\/author\/lyubov-azarenko\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/posts\/12569"}],"collection":[{"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/comments?post=12569"}],"version-history":[{"count":3,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/posts\/12569\/revisions"}],"predecessor-version":[{"id":12582,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/posts\/12569\/revisions\/12582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/media\/12570"}],"wp:attachment":[{"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/media?parent=12569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/categories?post=12569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itsm.com\/tr\/wp-json\/wp\/v2\/tags?post=12569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}