{"id":2800,"date":"2026-10-08T12:30:00","date_gmt":"2026-10-08T09:30:00","guid":{"rendered":"https:\/\/narhost.com\/blog\/?p=2800"},"modified":"2026-09-26T23:20:03","modified_gmt":"2026-09-26T20:20:03","slug":"veritabani-sunucusu-ayri-mi","status":"publish","type":"post","link":"https:\/\/narhost.com\/blog\/veritabani-sunucusu-ayri-mi\/","title":{"rendered":"Veritaban\u0131 Sunucusu Ne Zaman Ayr\u0131lmal\u0131, \u0130\u015faretler ve Bedeli"},"content":{"rendered":"<div id=\"ai-ozet\" class=\"ai-box\">\n<p class=\"ai-box-title\">K\u0131saca \u00f6zet<\/p>\n<ul>\n<li>Veritaban\u0131 sunucusu, web uygulamas\u0131n\u0131n verisini tutan MySQL, MariaDB veya PostgreSQL gibi motoru ayr\u0131 bir makinede \u00e7al\u0131\u015ft\u0131rmakt\u0131r; k\u00fc\u00e7\u00fck ve orta projelerde web ile veritaban\u0131 ayn\u0131 sunucuda durur.<\/li>\n<li>Ay\u0131rman\u0131n d\u00f6rt g\u00fc\u00e7l\u00fc i\u015fareti vard\u0131r: disk giri\u015f-\u00e7\u0131k\u0131\u015f\u0131nda s\u00fcrekli bekleme, web ve veritaban\u0131n\u0131n ayn\u0131 belle\u011fi payla\u015f\u0131rken birbirini s\u0131k\u0131\u015ft\u0131rmas\u0131, birden fazla uygulama sunucusuna ge\u00e7i\u015f ihtiyac\u0131 ve veritaban\u0131n\u0131 internetten tamamen yal\u0131tma iste\u011fi.<\/li>\n<li>Ay\u0131rman\u0131n bedeli a\u011f gecikmesi, ikinci sunucunun maliyeti ve iki ayr\u0131 i\u015fletim sistemini g\u00fcncel tutma y\u00fck\u00fcd\u00fcr.<\/li>\n<li>Tek sunucuda yava\u015flayan bir site \u00e7o\u011fu zaman eksik indeks ya da yetersiz \u00f6nbellek y\u00fcz\u00fcnden yava\u015ft\u0131r; ay\u0131rmadan \u00f6nce sorgular ve bellek ayar\u0131 g\u00f6zden ge\u00e7irilmelidir.<\/li>\n<li>Ayr\u0131 veritaban\u0131 sunucusu kuruldu\u011funda veritaban\u0131 portu yaln\u0131z uygulama sunucusunun adresine a\u00e7\u0131l\u0131r, yedek ise iki sunucunun d\u0131\u015f\u0131nda bir yerde tutulur.<\/li>\n<\/ul>\n<\/div>\n<p>Site b\u00fcy\u00fcd\u00fc, VPS&#8217;in bellek grafi\u011fi s\u00fcrekli tavanda, yo\u011fun saatlerde sayfalar saniyelerce bekliyor. Geli\u015ftiriciniz &#8220;veritaban\u0131n\u0131 ayr\u0131 bir sunucuya alal\u0131m&#8221; diyor, bir ba\u015fkas\u0131 &#8220;\u00f6nce sorgular\u0131 d\u00fczeltelim&#8221; diyor. \u0130kisi de hakl\u0131 olabilir. Veritaban\u0131 sunucusu ay\u0131rmak do\u011fru zamanda yap\u0131ld\u0131\u011f\u0131nda ciddi rahatlama sa\u011flar, erken yap\u0131ld\u0131\u011f\u0131nda ise iki kat bak\u0131m ve yeni bir gecikme kayna\u011f\u0131 getirir. Karar, hangi kayna\u011f\u0131n ger\u00e7ekten t\u00fckendi\u011fini \u00f6l\u00e7erek verilir.<\/p>\n<h2>Veritaban\u0131 Sunucusu Ay\u0131rmak Ne Demek<\/h2>\n<p>Tek sunucu mimarisinde web sunucusu, PHP veya uygulama s\u00fcre\u00e7leri ve veritaban\u0131 motoru ayn\u0131 i\u015fletim sistemi \u00fczerinde \u00e7al\u0131\u015f\u0131r. Uygulama veritaban\u0131na yerel ba\u011flant\u0131yla ula\u015f\u0131r; araya a\u011f girmez. Ayr\u0131k mimaride ise veritaban\u0131 motoru kendi sunucusuna ta\u015f\u0131n\u0131r. Uygulama sunucusu her sorguyu a\u011f \u00fczerinden g\u00f6nderir, veritaban\u0131 makinesi cevab\u0131 a\u011f \u00fczerinden d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p>Bu de\u011fi\u015fiklik kod taraf\u0131nda genellikle tek bir sat\u0131rd\u0131r: ba\u011flant\u0131 ayar\u0131ndaki &#8220;localhost&#8221; yerine yeni makinenin adresi yaz\u0131l\u0131r. As\u0131l i\u015f altyap\u0131 taraf\u0131ndad\u0131r. Yeni sunucunun kurulmas\u0131, veritaban\u0131 motorunun uzak ba\u011flant\u0131ya a\u00e7\u0131lmas\u0131, g\u00fcvenlik duvar\u0131n\u0131n yaz\u0131lmas\u0131, yedeklerin yeniden planlanmas\u0131 ve iki makinenin birlikte izlenmesi gerekir.<\/p>\n<div class=\"highlight-box\">\n<p class=\"label\">Bilgi<\/p>\n<p>Veritaban\u0131 motorlar\u0131 varsay\u0131lan olarak yaln\u0131z yerel ba\u011flant\u0131y\u0131 dinler. Veritaban\u0131n\u0131 ayr\u0131 bir makineye ald\u0131\u011f\u0131n\u0131zda motorun dinleme adresini ve kullan\u0131c\u0131 yetkilerini uzak ba\u011flant\u0131ya g\u00f6re de\u011fi\u015ftirmeniz gerekir. <a href=\"https:\/\/mariadb.com\/docs\/server\/mariadb-quickstart-guides\/mariadb-remote-connection-guide\" title=\"MariaDB resm\u00ee dok\u00fcmantasyonu \u2014 uzak ba\u011flant\u0131 rehberi\" target=\"_blank\" rel=\"noopener\">MariaDB&#8217;nin uzak ba\u011flant\u0131 rehberi<\/a> bu ayarlar\u0131n mant\u0131\u011f\u0131n\u0131 anlat\u0131r.<\/p>\n<\/div>\n<h2>Ay\u0131rma Zaman\u0131n\u0131n Geldi\u011fini G\u00f6steren \u0130\u015faretler<\/h2>\n<h3>Disk giri\u015f-\u00e7\u0131k\u0131\u015f\u0131 darbo\u011faz\u0131<\/h3>\n<p>Sunucu izleme ekran\u0131nda i\u015flemci bo\u015fta beklerken y\u00fck ortalamas\u0131 y\u00fcksekse ve disk bekleme s\u00fcresi (iowait) s\u00fcrekli art\u0131yorsa, disk hem web dosyalar\u0131na hem veritaban\u0131na yeti\u015femiyor demektir. B\u00fcy\u00fck tablolarda indeks taramas\u0131, ge\u00e7ici tablolar ve s\u0131k yaz\u0131lan g\u00fcnl\u00fckler ayn\u0131 diski kullanan web s\u00fcrecini de yava\u015flat\u0131r. Veritaban\u0131n\u0131 kendi diskine sahip bir sunucuya almak bu \u00e7eki\u015fmeyi bitirir.<\/p>\n<h3>Bellek bask\u0131s\u0131<\/h3>\n<p>Veritaban\u0131 motoru, s\u0131k okunan veriyi bellekte tutarak h\u0131zlan\u0131r. Ayn\u0131 sunucuda PHP i\u015f\u00e7ileri de her istekte bellek ister. Trafik artt\u0131k\u00e7a ikisi ayn\u0131 belle\u011fi payla\u015f\u0131r; motorun \u00f6nbelle\u011fi k\u00fc\u00e7\u00fcl\u00fcr, i\u015fletim sistemi takas alan\u0131na d\u00fc\u015fer ve her \u015fey yava\u015flar. Web taraf\u0131na daha fazla i\u015f\u00e7i eklemek veritaban\u0131n\u0131n \u00f6nbelle\u011fini, veritaban\u0131 \u00f6nbelle\u011fini b\u00fcy\u00fctmek de web i\u015f\u00e7ilerini s\u0131k\u0131\u015ft\u0131r\u0131r. Bu \u00e7eki\u015fme ayr\u0131k mimarinin en klasik gerek\u00e7esidir.<\/p>\n<h3>Yatay \u00f6l\u00e7ekleme ihtiyac\u0131<\/h3>\n<p>Tek uygulama sunucusu yetmedi\u011finde \u00f6n\u00fcne bir dengeleyici koyup iki ya da \u00fc\u00e7 uygulama sunucusuna ge\u00e7ersiniz. Bu sunucular\u0131n hepsi ayn\u0131 veriyi g\u00f6rmek zorundad\u0131r; veritaban\u0131 bu noktada ister istemez ayr\u0131 bir veritaban\u0131 sunucusu olur. Bu ge\u00e7i\u015fin ayr\u0131nt\u0131lar\u0131 <a href=\"https:\/\/narhost.com\/blog\/yuk-dengeleme-nedir\/\" title=\"Y\u00fck Dengeleme Nedir \u2014 Narhost Blog\">y\u00fck dengeleme yaz\u0131s\u0131nda<\/a> anlat\u0131l\u0131yor.<\/p>\n<h3>G\u00fcvenlik izolasyonu<\/h3>\n<p>Ayr\u0131k mimaride veritaban\u0131 internete hi\u00e7 a\u00e7\u0131lmaz; yaln\u0131z uygulama sunucusundan gelen ba\u011flant\u0131y\u0131 kabul eder. Web taraf\u0131nda bir a\u00e7\u0131k istismar edilse bile sald\u0131rgan\u0131n veritaban\u0131 makinesine do\u011frudan eri\u015fimi olmaz. Ki\u015fisel veri, \u00f6deme kayd\u0131 ya da sa\u011fl\u0131k bilgisi tutan uygulamalarda bu ayr\u0131m, performanstan ba\u011f\u0131ms\u0131z bir gerek\u00e7edir.<\/p>\n<figure class=\"nh-sema\"><img loading=\"lazy\" src=\"https:\/\/narhost.com\/blog\/wp-content\/uploads\/2026\/09\/veritabani-sunucusu-ayri-mi-sema-narhost.webp\" alt=\"veritaban\u0131 sunucusu ay\u0131rma karar\u0131n\u0131 \u00f6l\u00e7\u00fcm, i\u015faret, bedel ve g\u00fcvenli ba\u011flant\u0131 ad\u0131mlar\u0131yla g\u00f6steren \u015fema\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>\u00d6nce \u00f6l\u00e7, i\u015fareti do\u011frula, bedeli hesapla, sonra ba\u011flant\u0131y\u0131 yaln\u0131z uygulama sunucusuna a\u00e7.<\/figcaption><\/figure>\n<h2>Ayr\u0131 Sunucunun Bedeli Nedir<\/h2>\n<p>\u0130lk bedel a\u011f gecikmesidir. Yerel ba\u011flant\u0131da bir sorgunun gidi\u015f-d\u00f6n\u00fc\u015f\u00fc ihmal edilecek kadar k\u0131sad\u0131r; a\u011f \u00fczerinden her sorguya milisaniyenin alt\u0131nda da olsa ek s\u00fcre eklenir. Tek sayfada birka\u00e7 sorgu \u00e7al\u0131\u015ft\u0131ran bir sitede bu fark hissedilmez. Ancak bir sayfay\u0131 \u00fcretmek i\u00e7in y\u00fczlerce k\u00fc\u00e7\u00fck sorgu g\u00f6nderen, \u00f6zellikle d\u00f6ng\u00fc i\u00e7inde tek tek kay\u0131t \u00e7eken uygulamalarda toplam gecikme belirgin bi\u00e7imde b\u00fcy\u00fcr.<\/p>\n<p>\u0130kinci bedel maliyet ve y\u00f6netimdir. \u0130ki sunucunun kiras\u0131, iki i\u015fletim sisteminin g\u00fcncellemesi, iki ayr\u0131 g\u00fcvenlik duvar\u0131 ve izleme demektir. Y\u00f6netimsiz bir VPS&#8217;te bu i\u015flerin hepsi sizde kal\u0131r. \u00dc\u00e7\u00fcnc\u00fc bedel ise tek ar\u0131za noktas\u0131n\u0131n ortadan kalkmamas\u0131d\u0131r: veritaban\u0131 makinesi tek ba\u015f\u0131na duruyorsa o sunucu kapand\u0131\u011f\u0131nda b\u00fct\u00fcn uygulama sunucular\u0131 da hata verir.<\/p>\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>Yava\u015fl\u0131\u011f\u0131n kayna\u011f\u0131 eksik indeks, \u00f6nbelleksiz sorgu ya da d\u00f6ng\u00fc i\u00e7inde \u00e7al\u0131\u015fan y\u00fczlerce k\u00fc\u00e7\u00fck sorgu ise veritaban\u0131 sunucusu ay\u0131rmak sorunu \u00e7\u00f6zmez, a\u011f gecikmesiyle b\u00fcy\u00fct\u00fcr. \u00d6nce yava\u015f sorgu g\u00fcnl\u00fc\u011f\u00fcn\u00fc a\u00e7\u0131n ve en a\u011f\u0131r sorgular\u0131 d\u00fczeltin; bellek ayar\u0131n\u0131 sunucu boyutuna g\u00f6re yap\u0131n. Bunlardan sonra h\u00e2l\u00e2 kaynak yetmiyorsa ay\u0131rmay\u0131 konu\u015fun.<\/p>\n<\/div>\n<h2>Tek Sunucu mu Ayr\u0131 Veritaban\u0131 Sunucusu mu, Karar Tablosu<\/h2>\n<p>A\u015fa\u011f\u0131daki tablo iki mimariyi karar verirken bak\u0131lan eksenlerde kar\u015f\u0131la\u015ft\u0131r\u0131yor.<\/p>\n<table>\n<thead>\n<tr>\n<th>\u00d6l\u00e7\u00fct<\/th>\n<th>Tek sunucu (web + veritaban\u0131)<\/th>\n<th>Ayr\u0131 veritaban\u0131 sunucusu<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Uygun \u00f6l\u00e7ek<\/td>\n<td>Tek site, orta trafik, tek uygulama sunucusu<\/td>\n<td>Yo\u011fun trafik, birden fazla uygulama sunucusu<\/td>\n<\/tr>\n<tr>\n<td>Sorgu gecikmesi<\/td>\n<td>En d\u00fc\u015f\u00fck, yerel ba\u011flant\u0131<\/td>\n<td>Her sorguya a\u011f gecikmesi eklenir<\/td>\n<\/tr>\n<tr>\n<td>Kaynak \u00e7eki\u015fmesi<\/td>\n<td>Web ve veritaban\u0131 ayn\u0131 bellek ve diski payla\u015f\u0131r<\/td>\n<td>Her katman kendi kayna\u011f\u0131n\u0131 kullan\u0131r<\/td>\n<\/tr>\n<tr>\n<td>G\u00fcvenlik<\/td>\n<td>Veritaban\u0131 yerel dinler, web a\u00e7\u0131\u011f\u0131 do\u011frudan veriye yak\u0131nd\u0131r<\/td>\n<td>Veritaban\u0131 internete kapal\u0131, yaln\u0131z uygulama sunucusuna a\u00e7\u0131k<\/td>\n<\/tr>\n<tr>\n<td>Y\u00f6netim y\u00fck\u00fc ve maliyet<\/td>\n<td>Tek i\u015fletim sistemi, tek kira<\/td>\n<td>\u0130ki i\u015fletim sistemi, iki kira, iki izleme<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u00d6zel A\u011f ve Ba\u011flant\u0131 G\u00fcvenli\u011fi<\/h2>\n<p>\u0130ki sunucu aras\u0131ndaki trafik m\u00fcmk\u00fcnse internete \u00e7\u0131kmayan bir \u00f6zel a\u011f \u00fczerinden akmal\u0131d\u0131r. Sa\u011flay\u0131c\u0131n\u0131z\u0131n ayn\u0131 hesap alt\u0131ndaki sunucular i\u00e7in \u00f6zel a\u011f sunup sunmad\u0131\u011f\u0131n\u0131 sipari\u015f \u00f6ncesinde sorun. \u00d6zel a\u011f yoksa veritaban\u0131 makinesinin g\u00fcvenlik duvar\u0131nda veritaban\u0131 portunu yaln\u0131z uygulama sunucusunun IP adresine a\u00e7\u0131n, di\u011fer b\u00fct\u00fcn adreslerden gelen istekleri reddedin ve ba\u011flant\u0131y\u0131 TLS ile \u015fifreleyin.<\/p>\n<p>Veritaban\u0131 kullan\u0131c\u0131s\u0131n\u0131 da ayn\u0131 mant\u0131kla k\u0131s\u0131tlay\u0131n: uygulaman\u0131n kullan\u0131c\u0131s\u0131 yaln\u0131z uygulama sunucusunun adresinden ba\u011flanabilsin ve yaln\u0131z kendi veritaban\u0131nda yetkili olsun. Uzaktan ba\u011flant\u0131n\u0131n ad\u0131m ad\u0131m nas\u0131l kurulaca\u011f\u0131 ve istemciden nas\u0131l test edilece\u011fi destek merkezindeki <a href=\"https:\/\/narhost.com\/destek\/mysql-sunucuya-nasil-baglanilir\/\" title=\"MySQL Sunucuya Nas\u0131l Ba\u011flan\u0131l\u0131r \u2014 Narhost Destek Merkezi\">MySQL sunucuya ba\u011flanma kart\u0131nda<\/a> anlat\u0131l\u0131yor.<\/p>\n<div class=\"senaryo-block\">\n<p class=\"label\">\u00d6rnek senaryo<\/p>\n<p>G\u00fcnde 8.000 sipari\u015fe ula\u015fan bir e-ticaret sitesi, 8 GB bellekli tek bir VPS&#8217;te \u00e7al\u0131\u015f\u0131yordu. Kampanya saatlerinde veritaban\u0131 \u00f6nbelle\u011fi k\u00fc\u00e7\u00fcl\u00fcyor, disk bekleme s\u00fcresi y\u00fckseliyor, \u00f6deme ad\u0131m\u0131 6 saniyeye \u00e7\u0131k\u0131yordu. Ekip \u00f6nce yava\u015f sorgu g\u00fcnl\u00fc\u011f\u00fcnden en a\u011f\u0131r \u00fc\u00e7 sorguya indeks ekledi; \u00f6deme ad\u0131m\u0131 3 saniyeye indi ama kampanya saatlerinde t\u0131kanma s\u00fcrd\u00fc. Ard\u0131ndan veritaban\u0131n\u0131 ayr\u0131 bir veritaban\u0131 sunucusuna ta\u015f\u0131d\u0131lar, motorun belle\u011fini o sunucunun b\u00fcy\u00fck k\u0131sm\u0131na ay\u0131rd\u0131lar ve uygulama sunucusundaki PHP i\u015f\u00e7i say\u0131s\u0131n\u0131 art\u0131rd\u0131lar. \u00d6deme ad\u0131m\u0131 kampanya saatlerinde de 2 saniyenin alt\u0131nda kald\u0131.<\/p>\n<\/div>\n<h2>Yedekleme Plan\u0131 Nas\u0131l De\u011fi\u015fir<\/h2>\n<p>Ayr\u0131k mimaride yedek iki par\u00e7aya b\u00f6l\u00fcn\u00fcr. Uygulama sunucusunda kod, y\u00fcklenen dosyalar ve yap\u0131land\u0131rma durur; veritaban\u0131 makinesinde ise veri. \u0130kisinin yede\u011fi ayn\u0131 zaman aral\u0131\u011f\u0131nda al\u0131nmal\u0131d\u0131r, yoksa geri y\u00fcklemede dosyalar ile veritaban\u0131 birbirini tutmaz. Veritaban\u0131 yede\u011fi, \u00e7al\u0131\u015fan motoru kilitlemeyen bir y\u00f6ntemle al\u0131nmal\u0131 ve sunucunun d\u0131\u015f\u0131ndaki bir depoya kopyalanmal\u0131d\u0131r.<\/p>\n<p>Y\u00f6netimsiz sunucularda bu plan\u0131 kurmak sunucu sahibinin i\u015fidir. Veritaban\u0131 sunucusu ar\u0131zaland\u0131\u011f\u0131nda yede\u011fi ayn\u0131 makinede tutmak hi\u00e7bir i\u015fe yaramaz. En az bir kopyan\u0131n farkl\u0131 bir konumda durdu\u011fundan ve geri y\u00fckleme denemesinin ger\u00e7ekten yap\u0131ld\u0131\u011f\u0131ndan emin olun.<\/p>\n<h2>Veritaban\u0131 Sunucusu \u0130\u00e7in Kaynak Nas\u0131l Se\u00e7ilir<\/h2>\n<p>Veritaban\u0131 sunucusunda belirleyici kaynak bellek ve disk h\u0131z\u0131d\u0131r. S\u0131k kullan\u0131lan verinin tamam\u0131 ya da b\u00fcy\u00fck k\u0131sm\u0131 belle\u011fe s\u0131\u011fd\u0131\u011f\u0131nda sorgular diske inmeden cevaplan\u0131r. Bu y\u00fczden veritaban\u0131 makinesi i\u00e7in \u00e7ekirdek say\u0131s\u0131ndan \u00f6nce bellek ve NVMe disk \u00f6nceliklidir. Uygulama sunucusu ise daha \u00e7ok i\u015flemci ister, \u00e7\u00fcnk\u00fc sayfa \u00fcretimi orada yap\u0131l\u0131r. Genel boyutland\u0131rma mant\u0131\u011f\u0131 i\u00e7in <a href=\"https:\/\/narhost.com\/blog\/vps-ne-kadar-ram-cpu-gerekir\/\" title=\"VPS Ne Kadar RAM CPU Gerekir \u2014 Narhost Blog\">VPS i\u00e7in ne kadar RAM ve CPU gerekir yaz\u0131s\u0131na<\/a> bakabilirsiniz.<\/p>\n<p>Sanal sunucu t\u00fcr\u00fcn\u00fc se\u00e7erken de i\u015f y\u00fck\u00fcn\u00fc d\u00fc\u015f\u00fcn\u00fcn. S\u00fcrekli y\u00fcksek sorgu y\u00fck\u00fc olan bir veritaban\u0131 makinesinde \u00e7ekirdeklerin size ayr\u0131lm\u0131\u015f olmas\u0131 tutarl\u0131l\u0131k sa\u011flar. VPS, VDS ve bulut sunucu aras\u0131ndaki bu fark\u0131 tartan <a href=\"https:\/\/narhost.com\/blog\/vps-mi-vds-mi-bulut-sunucu-mu\/\" title=\"VPS mi VDS mi Bulut Sunucu mu \u2014 Narhost Blog\">VPS mi VDS mi bulut sunucu mu kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/a> karar i\u00e7in temel kaynakt\u0131r.<\/p>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Veritaban\u0131 sunucusu ay\u0131rmak bir performans refleksi de\u011fil, \u00f6l\u00e7\u00fclm\u00fc\u015f bir ihtiyaca cevapt\u0131r. Disk beklemesi, bellek \u00e7eki\u015fmesi, birden fazla uygulama sunucusu ya da veri yal\u0131t\u0131m\u0131 ihtiyac\u0131ndan biri varsa ay\u0131r\u0131n; yoksa \u00f6nce sorgular\u0131 ve \u00f6nbelle\u011fi d\u00fczeltip tek sunucuda kal\u0131n.<\/p>\n<\/div>\n<h2>Ay\u0131rmadan \u00d6nce Kontrol Listesi<\/h2>\n<ul class=\"kontrol-listesi\">\n<li>Yava\u015f sorgu g\u00fcnl\u00fc\u011f\u00fcn\u00fc a\u00e7\u0131n ve en a\u011f\u0131r sorgular\u0131 indeksle d\u00fczeltin.<\/li>\n<li>Bellek, disk bekleme s\u00fcresi ve i\u015flemci grafi\u011fini en az bir haftal\u0131k yo\u011fun d\u00f6nemde izleyin.<\/li>\n<li>Veritaban\u0131 motorunun bellek ayar\u0131n\u0131n sunucu boyutuna uygun oldu\u011funu kontrol edin.<\/li>\n<li>Uygulaman\u0131n sayfa ba\u015f\u0131na ka\u00e7 sorgu g\u00f6nderdi\u011fini \u00f6l\u00e7\u00fcn; d\u00f6ng\u00fc i\u00e7i sorgular\u0131 azalt\u0131n.<\/li>\n<li>\u0130ki sunucu aras\u0131nda \u00f6zel a\u011f olup olmad\u0131\u011f\u0131n\u0131 sa\u011flay\u0131c\u0131n\u0131za sorun.<\/li>\n<li>Veritaban\u0131 portunu yaln\u0131z uygulama sunucusunun IP adresine a\u00e7acak kural\u0131 \u00f6nceden yaz\u0131n.<\/li>\n<li>Yedeklerin iki sunucunun d\u0131\u015f\u0131nda bir yerde tutulaca\u011f\u0131 plan\u0131 haz\u0131rlay\u0131n ve geri y\u00fcklemeyi deneyin.<\/li>\n<\/ul>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>Veritaban\u0131 sunucusu ay\u0131rmak siteyi her zaman h\u0131zland\u0131r\u0131r m\u0131?<\/h3>\n<p>Hay\u0131r. Darbo\u011faz kaynak \u00e7eki\u015fmesiyse h\u0131zland\u0131r\u0131r; darbo\u011faz k\u00f6t\u00fc yaz\u0131lm\u0131\u015f sorgu ya da eksik indeksse a\u011f gecikmesi eklendi\u011fi i\u00e7in yava\u015flatabilir bile. Ay\u0131rmadan \u00f6nce yava\u015f sorgular\u0131 ve bellek ayar\u0131n\u0131 g\u00f6zden ge\u00e7irmek, karar\u0131n do\u011fru olup olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir. \u00d6l\u00e7meden yap\u0131lan ay\u0131rma \u00e7o\u011funlukla hayal k\u0131r\u0131kl\u0131\u011f\u0131yla biter.<\/p>\n<h3>Payla\u015f\u0131ml\u0131 hostingte veritaban\u0131 zaten ayr\u0131 m\u0131?<\/h3>\n<p>Payla\u015f\u0131ml\u0131 hostingte veritaban\u0131n\u0131n nerede \u00e7al\u0131\u015ft\u0131\u011f\u0131 sa\u011flay\u0131c\u0131n\u0131n mimarisine ba\u011fl\u0131d\u0131r ve sizin kontrol\u00fcn\u00fczde de\u011fildir. Sizin g\u00f6rece\u011finiz \u015fey paket s\u0131n\u0131rlar\u0131d\u0131r. Veritaban\u0131 mimarisini kendiniz belirlemek istiyorsan\u0131z bu, VPS veya VDS gerektiren bir karard\u0131r.<\/p>\n<h3>WordPress i\u00e7in ayr\u0131 veritaban\u0131 sunucusu gerekir mi?<\/h3>\n<p>Tek bir WordPress sitesinde \u00e7o\u011fu zaman gerekmez. Sayfa \u00f6nbelle\u011fi ve nesne \u00f6nbelle\u011fi do\u011fru kuruldu\u011funda veritaban\u0131na giden sorgu say\u0131s\u0131 ciddi \u00f6l\u00e7\u00fcde azal\u0131r. Yo\u011fun WooCommerce ma\u011fazalar\u0131nda, \u00e7ok say\u0131da giri\u015f yapm\u0131\u015f kullan\u0131c\u0131s\u0131 olan \u00fcyelik sitelerinde ya da birden fazla uygulama sunucusu kullan\u0131ld\u0131\u011f\u0131nda ayr\u0131m anlaml\u0131 h\u00e2le gelir.<\/p>\n<h3>Veritaban\u0131 ile uygulama sunucusu farkl\u0131 veri merkezlerinde olabilir mi?<\/h3>\n<p>Teknik olarak olabilir ama \u00f6nerilmez. Her sorgu iki veri merkezi aras\u0131ndaki mesafeyi kat eder ve gecikme milisaniyeler d\u00fczeyine \u00e7\u0131kar; sayfa ba\u015f\u0131na onlarca sorgu \u00e7al\u0131\u015fan bir uygulamada bu fark do\u011frudan hissedilir. \u0130ki sunucuyu ayn\u0131 veri merkezinde ve m\u00fcmk\u00fcnse ayn\u0131 \u00f6zel a\u011fda tutmak gerekir.<\/p>\n<h3>Ayr\u0131 veritaban\u0131 sunucusunu kim y\u00f6netir?<\/h3>\n<p>Y\u00f6netimsiz VPS ve VDS&#8217;te veritaban\u0131 sunucusunun i\u015fletim sistemi, veritaban\u0131 motoru, g\u00fcvenlik duvar\u0131 ve yede\u011fi sunucu sahibinin sorumlulu\u011fundad\u0131r. Sa\u011flay\u0131c\u0131 donan\u0131m\u0131, a\u011f\u0131 ve altyap\u0131y\u0131 sa\u011flar. Bu y\u00fczden ayr\u0131k mimariye ge\u00e7meden \u00f6nce iki sunucuyu kimin g\u00fcncelleyece\u011fini ekipte netle\u015ftirmek gerekir.<\/p>\n<\/div>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost&#8217;ta<\/p>\n<p>VPS paketlerimiz NVMe disk, 50 Gbps port ve an\u0131nda kurulumla gelir; root eri\u015fimi sizde oldu\u011fu i\u00e7in veritaban\u0131 motorunu, bellek ayar\u0131n\u0131 ve g\u00fcvenlik duvar\u0131n\u0131 kendiniz belirlersiniz. G\u00fcncel paketler <a href=\"https:\/\/narhost.com\/vps-sunucu\" title=\"Narhost VPS Sunucu paketleri\">VPS sunucu sayfas\u0131nda<\/a>.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/vps-sunucu\" title=\"Narhost VPS Sunucu paketleri\">VPS paketlerini incele<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Veritaban\u0131 sunucusu ay\u0131rmak, MySQL veya MariaDB gibi motoru web uygulamas\u0131ndan ayr\u0131 bir makinede \u00e7al\u0131\u015ft\u0131rmakt\u0131r. Disk beklemesi, bellek \u00e7eki\u015fmesi, \u00e7oklu uygulama sunucusu ve veri yal\u0131t\u0131m\u0131 ihtiyac\u0131 ay\u0131rma i\u015faretleridir; bedeli a\u011f gecikmesi ve iki sunucunun bak\u0131m\u0131d\u0131r.<\/p>\n","protected":false},"author":1,"featured_media":2801,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-2800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sunucu"],"_links":{"self":[{"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/posts\/2800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/comments?post=2800"}],"version-history":[{"count":1,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/posts\/2800\/revisions"}],"predecessor-version":[{"id":2802,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/posts\/2800\/revisions\/2802"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/media\/2801"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/media?parent=2800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/categories?post=2800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/blog\/wp-json\/wp\/v2\/tags?post=2800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}