{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"SQL'de \u0130\u015flemler, Kilitlenmeler ve G\u00fcnl\u00fck Tabanl\u0131 Kurtarma Y\u00f6netimi","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"Je6bnTe8B3\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sqlde-islemler-kilitlenmeler-ve-gunluk-tabanli-kurtarma-yonetimi\/\">SQL&#8217;de \u0130\u015flemler, Kilitlenmeler ve G\u00fcnl\u00fck Tabanl\u0131 Kurtarma Y\u00f6netimi<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sqlde-islemler-kilitlenmeler-ve-gunluk-tabanli-kurtarma-yonetimi\/embed\/#?secret=Je6bnTe8B3\" width=\"600\" height=\"338\" title=\"&#8220;SQL&#8217;de \u0130\u015flemler, Kilitlenmeler ve G\u00fcnl\u00fck Tabanl\u0131 Kurtarma Y\u00f6netimi&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"Je6bnTe8B3\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Veritaban\u0131 sistemleri, modern uygulamalar\u0131n bel kemi\u011fidir ve veri tutarl\u0131l\u0131\u011f\u0131, eri\u015filebilirli\u011fi ile g\u00fcvenilirli\u011fi kritik \u00f6neme sahiptir. Peki, birden fazla kullan\u0131c\u0131n\u0131n ayn\u0131 anda veri \u00fczerinde i\u015flem yapt\u0131\u011f\u0131 durumlarda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l sa\u011fl\u0131yoruz? \u0130\u015fte bu sorunun cevab\u0131, SQL'deki i\u015flemler (transactions), kilitlenmeler (deadlocks) ve g\u00fcnl\u00fck tabanl\u0131 kurtarma (log-based recovery) mekanizmalar\u0131nda gizlidir. Bu makalede, bu temel kavramlar\u0131 ba\u015ftan sona ele alacak, kar\u015f\u0131la\u015fabilece\u011finiz sorunlar\u0131 ve \u00e7\u00f6z\u00fcm yollar\u0131n\u0131 ger\u00e7ek d\u00fcnya senaryolar\u0131yla ad\u0131m ad\u0131m inceleyece\u011fiz. Amac\u0131m\u0131z, veritaban\u0131 y\u00f6netimini daha iyi anlaman\u0131za ve sistemlerinizi daha sa\u011flam hale getirmenize yard\u0131mc\u0131 olmakt\u0131r."}