{"id":35764,"date":"2025-12-03T17:31:21","date_gmt":"2025-12-03T14:31:21","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/"},"modified":"2025-12-03T17:31:21","modified_gmt":"2025-12-03T14:31:21","slug":"neden-openbsdde-mariadb-11-4-kullanmalisiniz","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/","title":{"rendered":"Neden OpenBSD&#8217;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?"},"content":{"rendered":"<p><body><\/p>\n<h1>MariaDB 11.4 OpenBSD 7.8 \u00dczerine Kurulum Rehberi<\/h1>\n<style>\n    \/* Basit bir mobil uyumlu stil \u00f6rne\u011fi *\/\n    body {\n        font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n        line-height: 1.6;\n        color: #333;\n        margin: 0 auto;\n        padding: 20px;\n        max-width: 1200px;\n        background-color: #f9f9f9;\n    }\n    h2 {\n        color: #2c3e50;\n        border-bottom: 2px solid #3498db;\n        padding-bottom: 10px;\n        margin-top: 40px;\n    }\n    h3 {\n        color: #34495e;\n        margin-top: 30px;\n    }\n    p {\n        margin-bottom: 15px;\n    }\n    code {\n        background-color: #eee;\n        padding: 2px 4px;\n        border-radius: 3px;\n        font-family: 'Consolas', 'Monaco', monospace;\n    }\n    pre {\n        background-color: #282c34;\n        color: #abb2bf;\n        padding: 15px;\n        border-radius: 8px;\n        overflow-x: auto;\n        margin-bottom: 20px;\n    }\n    pre code {\n        background-color: transparent;\n        color: inherit;\n        padding: 0;\n        border-radius: 0;\n        white-space: pre; \/* \u0130\u00e7eri\u011fin sar\u0131lmas\u0131n\u0131 \u00f6nler *\/\n    }\n    .expert-tip {\n        background-color: #eaf7ff;\n        border-left: 5px solid #3498db;\n        padding: 15px;\n        margin: 20px 0;\n        border-radius: 5px;\n    }\n    ul, ol {\n        margin-left: 20px;\n        margin-bottom: 15px;\n    }\n    li {\n        margin-bottom: 8px;\n    }\n    table {\n        width: 100%;\n        border-collapse: collapse;\n        margin: 20px 0;\n    }\n    th, td {\n        border: 1px solid #ddd;\n        padding: 10px;\n        text-align: left;\n    }\n    th {\n        background-color: #f2f2f2;\n        color: #333;\n    }<\/p>\n<p>    \/* Mobil Cihazlar \u0130\u00e7in Medya Sorgusu *\/\n    @media (max-width: 768px) {\n        body {\n            padding: 10px;\n        }\n        h2 {\n            font-size: 1.5em;\n        }\n        h3 {\n            font-size: 1.2em;\n        }\n        pre {\n            padding: 10px;\n            font-size: 0.9em;\n        }\n        table, thead, tbody, th, td, tr {\n            display: block;\n        }\n        thead tr {\n            position: absolute;\n            top: -9999px;\n            left: -9999px;\n        }\n        tr {\n            border: 1px solid #ccc;\n            margin-bottom: 10px;\n        }\n        td {\n            border: none;\n            border-bottom: 1px solid #eee;\n            position: relative;\n            padding-left: 50%;\n            text-align: right;\n        }\n        td:before {\n            position: absolute;\n            top: 6px;\n            left: 6px;\n            width: 45%;\n            padding-right: 10px;\n            white-space: nowrap;\n            content: attr(data-label);\n            font-weight: bold;\n            text-align: left;\n        }\n    }\n<\/style>\n<p>OpenBSD&#8217;nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4&#8217;\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB&#8217;yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.<\/p>\n<p>G\u00fcn\u00fcm\u00fcz dijital d\u00fcnyas\u0131nda veri g\u00fcvenli\u011fi ve sistem kararl\u0131l\u0131\u011f\u0131 hi\u00e7 olmad\u0131\u011f\u0131 kadar kritik bir \u00f6neme sahip. Bir veritaban\u0131 sunucusu se\u00e7erken yaln\u0131zca performans de\u011fil, ayn\u0131 zamanda temel i\u015fletim sisteminin sundu\u011fu g\u00fcvenlik katmanlar\u0131 da b\u00fcy\u00fck bir rol oynar. \u0130\u015fte bu noktada OpenBSD ve MariaDB 11.4 kombinasyonu, bir\u00e7ok sistem y\u00f6neticisi ve geli\u015ftirici i\u00e7in cazip bir se\u00e7enek olarak \u00f6ne \u00e7\u0131k\u0131yor. Peki, neden bu ikiliyi tercih etmelisiniz?<\/p>\n<p>\u00d6ncelikle, OpenBSD&#8217;nin &#8220;varsay\u0131lan olarak g\u00fcvenli&#8221; felsefesiyle ba\u015flayal\u0131m. Bu i\u015fletim sistemi, y\u0131llard\u0131r s\u00fcregelen titiz g\u00fcvenlik denetimleri ve a\u00e7\u0131k kaynak kodlu yap\u0131s\u0131yla tan\u0131n\u0131r. Yaz\u0131l\u0131mlar en az yetki prensibiyle \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r, potansiyel g\u00fcvenlik a\u00e7\u0131klar\u0131 proaktif olarak ele al\u0131n\u0131r ve gereksiz servisler varsay\u0131lan olarak kapal\u0131 gelir. Bu yakla\u015f\u0131m, sald\u0131r\u0131 y\u00fczeyini \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r ve kritik verilerinizi bar\u0131nd\u0131racak bir sunucu i\u00e7in sa\u011flam bir temel olu\u015fturur. \u00d6zellikle bir veritaban\u0131 sunucusu gibi hassas bir bile\u015fen bar\u0131nd\u0131r\u0131rken, i\u015fletim sistemi katman\u0131ndaki bu d\u00fczeyde bir g\u00fcvenlik, size paha bi\u00e7ilmez bir huzur sa\u011flar. \u00d6rne\u011fin, bir web uygulamas\u0131n\u0131n arka ucunda \u00e7al\u0131\u015fan ve m\u00fc\u015fteri bilgilerini, finansal verileri veya ki\u015fisel kimlik bilgilerini depolayan bir MariaDB sunucusu d\u00fc\u015f\u00fcn\u00fcn. OpenBSD&#8217;nin koruyucu kalkan\u0131 sayesinde, bu verilerin k\u00f6t\u00fc niyetli akt\u00f6rlerin eline ge\u00e7me riski minimuma indirilmi\u015f olur. Sistem y\u00f6neticisi olarak, karma\u015f\u0131k g\u00fcvenlik duvar\u0131 kurallar\u0131 veya ek g\u00fcvenlik yaz\u0131l\u0131mlar\u0131 i\u00e7in harcayaca\u011f\u0131n\u0131z zaman\u0131, uygulaman\u0131z\u0131n optimizasyonuna veya di\u011fer altyap\u0131 ihtiya\u00e7lar\u0131na ay\u0131rabilirsiniz.<\/p>\n<p>Di\u011fer yandan, MariaDB 11.4, MySQL&#8217;den t\u00fcremi\u015f, a\u00e7\u0131k kaynakl\u0131 ve topluluk odakl\u0131 bir veritaban\u0131 y\u00f6netim sistemidir. MySQL&#8217;in t\u00fcm g\u00fc\u00e7l\u00fc \u00f6zelliklerini miras al\u0131rken, bir dizi \u00f6nemli iyile\u015ftirme ve yeni \u00f6zellik sunar. Performans optimizasyonlar\u0131, daha geli\u015fmi\u015f replikasyon se\u00e7enekleri, geli\u015fmi\u015f g\u00fcvenlik eklentileri ve daha geni\u015f depolama motoru deste\u011fi gibi yenilikler, MariaDB&#8217;yi modern uygulamalar i\u00e7in ideal bir se\u00e7im haline getirir. 11.4 s\u00fcr\u00fcm\u00fc ile gelen g\u00fcncellemeler, \u00f6zellikle \u00f6l\u00e7eklenebilirlik ve performans konusunda dikkate de\u011fer geli\u015fmeler sunar. \u00d6rne\u011fin, y\u00fcksek trafikli bir e-ticaret sitesi veya yo\u011fun veri i\u015fleme gerektiren analitik bir platform i\u00e7in MariaDB 11.4, sorgu h\u0131zlar\u0131nda ve e\u015fzamanl\u0131 ba\u011flant\u0131 y\u00f6netiminde \u00f6nemli avantajlar sa\u011flayabilir. Ayr\u0131ca, MariaDB&#8217;nin aktif toplulu\u011fu ve s\u00fcrekli geli\u015fimi, uzun vadeli destek ve g\u00fcvenilirlik a\u00e7\u0131s\u0131ndan da b\u00fcy\u00fck bir art\u0131d\u0131r.<\/p>\n<p>Bu iki g\u00fc\u00e7l\u00fc bile\u015feni bir araya getirdi\u011finizde, elde etti\u011finiz sonu\u00e7 basit\u00e7e \u015fudur: Y\u00fcksek g\u00fcvenlik standartlar\u0131na sahip, stabil ve performansl\u0131 bir veritaban\u0131 altyap\u0131s\u0131. Bir finansal teknoloji \u015firketi i\u00e7in m\u00fc\u015fteri i\u015flemlerini y\u00f6neten bir sistem tasarl\u0131yorsan\u0131z, OpenBSD&#8217;nin sa\u011flaml\u0131\u011f\u0131 ve MariaDB&#8217;nin veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve h\u0131z\u0131n\u0131 bir araya getirmek, projelerinizin temelini sa\u011flam bir \u015fekilde atman\u0131z\u0131 sa\u011flar. Ya da belki de ki\u015fisel bir blog veya k\u00fc\u00e7\u00fck \u00f6l\u00e7ekli bir web sitesi bar\u0131nd\u0131r\u0131yorsunuz, ancak yine de veri g\u00fcvenli\u011finden taviz vermek istemiyorsunuz. \u0130\u015fte bu durumda bile, OpenBSD&#8217;nin hafifli\u011fi ve MariaDB&#8217;nin verimlili\u011fi, kaynaklar\u0131 minimumda tutarak maksimum g\u00fcvenlik ve performans\u0131 sunacakt\u0131r. Dolay\u0131s\u0131yla, bu rehber, sadece teknik ad\u0131mlar\u0131 g\u00f6stermekle kalmayacak, ayn\u0131 zamanda bu \u00f6zel kombinasyonun i\u015fletmeniz veya projeniz i\u00e7in neden stratejik bir de\u011fer ta\u015f\u0131d\u0131\u011f\u0131n\u0131 da vurgulayacakt\u0131r.<\/p>\n<h2>MariaDB ve OpenBSD&#8217;yi Tan\u0131yal\u0131m m\u0131? Temel Kavramlara Giri\u015f<\/h2>\n<p>Teknik bir kurulum s\u00fcrecine dalmadan \u00f6nce, MariaDB ve OpenBSD&#8217;nin ne olduklar\u0131n\u0131 ve bu ikilinin birbirini nas\u0131l tamamlad\u0131\u011f\u0131n\u0131 anlamak, ataca\u011f\u0131n\u0131z ad\u0131mlar\u0131n mant\u0131\u011f\u0131n\u0131 kavraman\u0131za yard\u0131mc\u0131 olacakt\u0131r. Bu b\u00f6l\u00fcm, \u00f6zellikle konuya yeni ba\u015flayanlar i\u00e7in temel bilgileri \u00f6zetleyerek sa\u011flam bir zemin olu\u015fturmay\u0131 ama\u00e7lamaktad\u0131r.<\/p>\n<h3>MariaDB Nedir ve Neden Tercih Edilir?<\/h3>\n<p>MariaDB, asl\u0131nda MySQL veritaban\u0131n\u0131n bir &#8220;\u00e7atallanmas\u0131d\u0131r&#8221; (fork). MySQL&#8217;in 2008 y\u0131l\u0131nda Sun Microsystems taraf\u0131ndan sat\u0131n al\u0131nmas\u0131 ve ard\u0131ndan 2010&#8217;da Oracle&#8217;a ge\u00e7mesiyle, a\u00e7\u0131k kaynak toplulu\u011fu aras\u0131nda MySQL&#8217;in gelece\u011fi hakk\u0131nda endi\u015feler do\u011fdu. Bu endi\u015feler \u00fczerine, MySQL&#8217;in orijinal yarat\u0131c\u0131lar\u0131 taraf\u0131ndan MariaDB projesi ba\u015flat\u0131ld\u0131. Temel amac\u0131, tamamen a\u00e7\u0131k kaynakl\u0131 ve topluluk odakl\u0131 bir alternatif sunmakt\u0131. MariaDB, MySQL ile y\u00fcksek derecede uyumludur, yani mevcut MySQL uygulamalar\u0131n\u0131z\u0131n \u00e7o\u011fu genellikle MariaDB \u00fczerinde sorunsuz bir \u015fekilde \u00e7al\u0131\u015fabilir. Bu uyumluluk, ge\u00e7i\u015f yapmay\u0131 d\u00fc\u015f\u00fcnenler i\u00e7in b\u00fcy\u00fck bir avantajd\u0131r.<\/p>\n<p>MariaDB&#8217;yi tercih etmeniz i\u00e7in bir\u00e7ok neden bulunmaktad\u0131r:<\/p>\n<ul>\n<li><strong>A\u00e7\u0131k Kaynak ve Topluluk Odakl\u0131l\u0131k:<\/strong> MariaDB, GNU GPL lisans\u0131 alt\u0131nda tamamen a\u00e7\u0131k kaynakl\u0131d\u0131r ve aktif bir topluluk taraf\u0131ndan geli\u015ftirilmektedir. Bu, \u015feffafl\u0131k, s\u00fcrekli iyile\u015ftirme ve uzun vadeli destek anlam\u0131na gelir.<\/li>\n<li><strong>Performans \u0130yile\u015ftirmeleri:<\/strong> MariaDB, MySQL&#8217;e g\u00f6re bir\u00e7ok performans iyile\u015ftirmesi sunar. \u00d6zellikle sorgu iyile\u015ftiricileri, e\u015fzamanl\u0131 ba\u011flant\u0131 y\u00f6netimi ve depolama motorlar\u0131ndaki geli\u015fmeler, yo\u011fun i\u015f y\u00fckleri alt\u0131nda daha iyi performans sa\u011flar.<\/li>\n<li><strong>Yeni \u00d6zellikler:<\/strong> Daha yeni s\u00fcr\u00fcmler, geli\u015fmi\u015f replikasyon se\u00e7enekleri (\u00f6rne\u011fin, \u00e7ok kaynakl\u0131 replikasyon), JSON deste\u011fi, sistem versiyonlama tablolar\u0131 ve dinamik s\u00fctunlar gibi MySQL&#8217;de bulunmayan veya daha geli\u015fmi\u015f bir \u015fekilde sunulan \u00f6zellikler i\u00e7erir.<\/li>\n<li><strong>Depolama Motoru \u00c7e\u015fitlili\u011fi:<\/strong> InnoDB&#8217;nin yan\u0131 s\u0131ra Aria, XtraDB, MyRocks gibi farkl\u0131 depolama motorlar\u0131na destek verir. Bu, belirli i\u015f y\u00fckleri i\u00e7in en uygun motoru se\u00e7me esnekli\u011fi sunar. \u00d6rne\u011fin, MyRocks, \u00f6zellikle y\u00fcksek yazma yo\u011funluklu i\u015f y\u00fcklerinde ve b\u00fcy\u00fck veri k\u00fcmelerinde depolama verimlili\u011fi a\u00e7\u0131s\u0131ndan \u00f6nemli avantajlar sa\u011flayabilir.<\/li>\n<li><strong>Geli\u015fmi\u015f G\u00fcvenlik:<\/strong> MariaDB, g\u00fcvenlik eklentileri (\u00f6rne\u011fin, GSSAPI\/Kerberos kimlik do\u011frulamas\u0131), rol tabanl\u0131 eri\u015fim kontrol\u00fc ve \u015fifreleme \u00f6zellikleri ile veri g\u00fcvenli\u011fini art\u0131rmaya y\u00f6nelik s\u00fcrekli \u00e7al\u0131\u015fmalar yapar.<\/li>\n<\/ul>\n<p>K\u0131sacas\u0131, MariaDB modern uygulamalar\u0131n ihtiya\u00e7 duydu\u011fu performans\u0131, esnekli\u011fi ve g\u00fcvenli\u011fi sunarken, a\u00e7\u0131k kaynak ruhuna sad\u0131k kalmaya devam eden g\u00fc\u00e7l\u00fc bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir.<\/p>\n<h3>OpenBSD Nedir ve Neden G\u00fcvenlik Oda\u011f\u0131ndad\u0131r?<\/h3>\n<p>OpenBSD, UNIX benzeri, \u00fccretsiz ve a\u00e7\u0131k kaynakl\u0131 bir i\u015fletim sistemidir. Di\u011fer pop\u00fcler a\u00e7\u0131k kaynak i\u015fletim sistemlerinden ayr\u0131lmas\u0131n\u0131n en \u00f6nemli nedeni, g\u00fcvenlik ve kod kalitesine verilen a\u015f\u0131r\u0131 \u00f6nemdir. OpenBSD projesi, &#8220;Sadece iki g\u00fcvenlik a\u00e7\u0131\u011f\u0131 bulursan\u0131z, bu bir ba\u015far\u0131d\u0131r&#8221; slogan\u0131yla bilinir ve kod taban\u0131n\u0131 s\u00fcrekli olarak denetler, g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 bulmaya ve d\u00fczeltmeye odaklan\u0131r.<\/p>\n<p>OpenBSD&#8217;nin temel \u00f6zellikleri ve g\u00fcvenlik odakl\u0131 yakla\u015f\u0131m\u0131 \u015funlar\u0131 i\u00e7erir:<\/p>\n<ul>\n<li><strong>Kod \u0130ncelemesi ve Audit:<\/strong> OpenBSD geli\u015ftiricileri, kod taban\u0131n\u0131n tamam\u0131n\u0131 d\u00fczenli olarak manuel olarak inceler. Bu titiz inceleme s\u00fcreci, potansiyel g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131, hatalar\u0131 ve k\u00f6t\u00fc niyetli kodlar\u0131 tespit etmeyi ama\u00e7lar. Bu, di\u011fer bir\u00e7ok i\u015fletim sisteminde bu denli kapsaml\u0131 yap\u0131lmayan benzersiz bir uygulamad\u0131r.<\/li>\n<li><strong>Geli\u015ftirici Sorumlulu\u011fu:<\/strong> Bir geli\u015ftirici OpenBSD&#8217;ye bir kod katk\u0131s\u0131nda bulundu\u011funda, bu kodla ilgili g\u00fcvenlik a\u00e7\u0131klar\u0131ndan ki\u015fisel olarak sorumlu tutulur. Bu, y\u00fcksek kalite standartlar\u0131n\u0131 korumak i\u00e7in g\u00fc\u00e7l\u00fc bir te\u015fviktir.<\/li>\n<li><strong>Minimum Kurulum:<\/strong> OpenBSD varsay\u0131lan olarak minimum d\u00fczeyde servis \u00e7al\u0131\u015ft\u0131r\u0131r ve yaln\u0131zca gerekli bile\u015fenleri kurar. Bu, sald\u0131r\u0131 y\u00fczeyini \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r, \u00e7\u00fcnk\u00fc \u00e7al\u0131\u015fmayan bir servis hacklenemez.<\/li>\n<li><strong>Proaktif G\u00fcvenlik Mekanizmalar\u0131:<\/strong> Adres Alan\u0131 D\u00fczensizle\u015ftirme (ASLR), Y\u00fcr\u00fct\u00fclemez Y\u0131\u011f\u0131n (W^X), \u00c7ekirdek Rastgeleli\u011fi (Kernel Randomization) gibi modern g\u00fcvenlik mekanizmalar\u0131n\u0131 \u00e7ekirdek seviyesinde entegre eder ve bunlar\u0131 varsay\u0131lan olarak etkinle\u015ftirir.<\/li>\n<li><strong>Sandboxing ve Pledge\/Unveil:<\/strong> OpenBSD&#8217;nin en yenilik\u00e7i g\u00fcvenlik \u00f6zelliklerinden ikisi <code>pledge()<\/code> ve <code>unveil()<\/code> sistem \u00e7a\u011fr\u0131lar\u0131d\u0131r. <code>pledge()<\/code> bir program\u0131n gelecekte yapabilece\u011fi sistem \u00e7a\u011fr\u0131lar\u0131n\u0131 k\u0131s\u0131tlar; \u00f6rne\u011fin, bir web sunucusunun sadece a\u011f ve dosya okuma i\u015flemleri yapmas\u0131na izin verebilirsiniz. <code>unveil()<\/code> ise bir programa yaln\u0131zca belirli dosya yollar\u0131na eri\u015fim izni verir. Bu mekanizmalar, bir program\u0131n ele ge\u00e7irilmesi durumunda bile, yapabilece\u011fi zarar\u0131 b\u00fcy\u00fck \u00f6l\u00e7\u00fcde s\u0131n\u0131rlar.<\/li>\n<li><strong>Paket Filtresi (PF):<\/strong> OpenBSD&#8217;nin kendi entegre g\u00fcvenlik duvar\u0131 olan PF (Packet Filter), g\u00fc\u00e7l\u00fc, esnek ve kullan\u0131m\u0131 kolayd\u0131r. A\u011f trafi\u011fini detayl\u0131 bir \u015fekilde kontrol etmenizi sa\u011flar.<\/li>\n<\/ul>\n<p>OpenBSD, kararl\u0131, temiz ve her \u015feyden \u00f6nce g\u00fcvenli bir platform arayanlar i\u00e7in idealdir. Bir veritaban\u0131 sunucusu gibi kritik bir bile\u015feni bar\u0131nd\u0131r\u0131rken, OpenBSD&#8217;nin sa\u011flad\u0131\u011f\u0131 bu g\u00fcvenlik katmanlar\u0131, verilerinizin korunmas\u0131nda kilit rol oynar. Bu nedenle, MariaDB 11.4&#8217;\u00fc OpenBSD 7.8 \u00fczerine kurmak, sadece bir kurulum de\u011fil, ayn\u0131 zamanda g\u00fcvenli ve performansl\u0131 bir altyap\u0131 in\u015fa etme taahh\u00fcd\u00fcd\u00fcr.<\/p>\n<h2>Ad\u0131m Ad\u0131m Kurulum: MariaDB 11.4 OpenBSD 7.8&#8217;e Nas\u0131l Y\u00fcklenir?<\/h2>\n<p>Art\u0131k MariaDB ve OpenBSD&#8217;nin ne olduklar\u0131n\u0131 ve neden bu kombinasyonu se\u00e7ti\u011fimizi anlad\u0131\u011f\u0131m\u0131za g\u00f6re, kurulum s\u00fcrecine ge\u00e7ebiliriz. Bu b\u00f6l\u00fcm, MariaDB 11.4&#8217;\u00fc OpenBSD 7.8 i\u015fletim sisteminize ba\u015far\u0131yla y\u00fcklemeniz i\u00e7in gerekli t\u00fcm ad\u0131mlar\u0131 detayl\u0131 bir \u015fekilde a\u00e7\u0131klayacakt\u0131r. Her ad\u0131m\u0131 dikkatle takip ederek, sorunsuz bir kurulum ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<h3>Sistem \u00d6n Haz\u0131rl\u0131\u011f\u0131: Kuruluma Ba\u015flamadan \u00d6nce Neler Yapmal\u0131y\u0131z?<\/h3>\n<p>Herhangi bir yaz\u0131l\u0131m kurulumuna ba\u015flamadan \u00f6nce sistemin haz\u0131r oldu\u011fundan emin olmak, ileride ya\u015fanabilecek bir\u00e7ok sorunun \u00f6n\u00fcne ge\u00e7er. OpenBSD ortam\u0131nda MariaDB kurmadan \u00f6nce yapmam\u0131z gereken baz\u0131 temel \u00f6n haz\u0131rl\u0131klar bulunmaktad\u0131r.<\/p>\n<h4>1. Sistem G\u00fcncellemeleri ve Y\u00fckseltmeleri<\/h4>\n<p>\u00d6ncelikle, sisteminizin en g\u00fcncel paketlere ve g\u00fcvenlik yamalar\u0131na sahip oldu\u011fundan emin olmal\u0131y\u0131z. Bu, hem stabilite hem de g\u00fcvenlik a\u00e7\u0131s\u0131ndan kritik \u00f6neme sahiptir. OpenBSD&#8217;de sistem ve paket g\u00fcncellemelerini yapmak i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 kullan\u0131r\u0131z:<\/p>\n<pre><code>\ndoas pkg_add -u\ndoas syspatch\ndoas reboot\n<\/pre>\n<p><\/code><\/p>\n<ul>\n<li><code>doas pkg_add -u<\/code>: Bu komut, y\u00fckl\u00fc t\u00fcm paketleri en son s\u00fcr\u00fcmlerine y\u00fckseltir. OpenBSD'nin paket y\u00f6netimi sistemi olduk\u00e7a sa\u011flamd\u0131r ve ba\u011f\u0131ml\u0131l\u0131klar\u0131 otomatik olarak \u00e7\u00f6zer. Bu sayede MariaDB'nin ihtiya\u00e7 duydu\u011fu t\u00fcm k\u00fct\u00fcphanelerin g\u00fcncel oldu\u011fundan emin oluruz.<\/li>\n<li><code>doas syspatch<\/code>: Bu komut, i\u015fletim sisteminin \u00e7ekirde\u011fi ve temel bile\u015fenleri i\u00e7in yay\u0131nlanm\u0131\u015f g\u00fcvenlik yamalar\u0131n\u0131 indirir ve uygular. OpenBSD, bu yamalar\u0131 d\u00fczenli olarak yay\u0131nlar ve sisteminizi g\u00fcncel tutmak, bilinen g\u00fcvenlik a\u00e7\u0131klar\u0131na kar\u015f\u0131 korunman\u0131n en iyi yoludur.<\/li>\n<li><code>doas reboot<\/code>: \u00c7o\u011fu \u00e7ekirdek yamas\u0131 ve baz\u0131 sistem g\u00fcncellemeleri, etkili olabilmek i\u00e7in sistemin yeniden ba\u015flat\u0131lmas\u0131n\u0131 gerektirir. G\u00fcncellemeleri uygulad\u0131ktan sonra sistemi yeniden ba\u015flatmak, t\u00fcm de\u011fi\u015fikliklerin do\u011fru bir \u015fekilde etkinle\u015fmesini sa\u011flar. Bu ad\u0131m, \u00f6zellikle uzun s\u00fcredir \u00e7al\u0131\u015fmakta olan bir sunucuda \u00f6nemlidir.<\/li>\n<\/ul>\n<p>Bu ad\u0131mlar\u0131 tamamlad\u0131ktan sonra, sisteminiz MariaDB kurulumu i\u00e7in g\u00fcncel ve g\u00fcvenli bir temel \u00fczerinde olacakt\u0131r.<\/p>\n<h4>2. Disk Alan\u0131 Kontrol\u00fc<\/h4>\n<p>Veritabanlar\u0131, zamanla olduk\u00e7a b\u00fcy\u00fck boyutlara ula\u015fabilir. Bu nedenle, MariaDB'yi kuraca\u011f\u0131n\u0131z disk b\u00f6l\u00fcm\u00fcnde yeterli bo\u015f alan oldu\u011fundan emin olmak \u00f6nemlidir. \u00d6zellikle veritaban\u0131 dosyalar\u0131n\u0131n depolanaca\u011f\u0131 <code>\/var<\/code> b\u00f6l\u00fcm\u00fc, genellikle en \u00e7ok b\u00fcy\u00fcyen yerdir. Bo\u015f disk alan\u0131n\u0131 kontrol etmek i\u00e7in:<\/p>\n<pre><code>\ndf -h\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komut, t\u00fcm ba\u011fl\u0131 dosya sistemlerinin mevcut ve kullan\u0131lan disk alan\u0131n\u0131 insan taraf\u0131ndan okunabilir (human-readable) formatta g\u00f6sterir. MariaDB i\u00e7in en az birka\u00e7 gigabayt (uygulaman\u0131z\u0131n ve veri beklentinizin b\u00fcy\u00fckl\u00fc\u011f\u00fcne ba\u011fl\u0131 olarak \u00e7ok daha fazlas\u0131) bo\u015f alan\u0131n\u0131z oldu\u011fundan emin olun. \u00d6zellikle kritik \u00fcretim ortamlar\u0131nda, disk alan\u0131n\u0131 \u00f6nceden planlamak ve gerekti\u011finde geni\u015fletme se\u00e7eneklerini de\u011ferlendirmek hayati \u00f6neme sahiptir. E\u011fer disk alan\u0131n\u0131z yetersizse, yeni bir disk eklemek veya mevcut disklerinizi geni\u015fletmek gibi ad\u0131mlar atman\u0131z gerekebilir. OpenBSD'nin disk y\u00f6netimi ara\u00e7lar\u0131 (\u00f6rne\u011fin, <code>fdisk<\/code>, <code>disklabel<\/code>) bu t\u00fcr i\u015flemleri yapman\u0131za olanak tan\u0131r.<\/p>\n<h4>3. Temel A\u011f Yap\u0131land\u0131rmas\u0131 Kontrol\u00fc<\/h4>\n<p>MariaDB genellikle a\u011f \u00fczerinden eri\u015filen bir servis oldu\u011fu i\u00e7in, a\u011f ba\u011flant\u0131n\u0131z\u0131n d\u00fczg\u00fcn \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan emin olmak \u00f6nemlidir. Sunucunuzun IP adresi, a\u011f ge\u00e7idi ve DNS ayarlar\u0131n\u0131n do\u011fru oldu\u011fundan emin olun. Bu, genellikle OpenBSD kurulumu s\u0131ras\u0131nda yap\u0131l\u0131r, ancak bir kontrol yapmakta fayda vard\u0131r. Temel a\u011f yap\u0131land\u0131rmas\u0131n\u0131 kontrol etmek i\u00e7in <code>ifconfig<\/code> komutunu kullanabilirsiniz:<\/p>\n<pre><code>\nifconfig\nping google.com\n<\/pre>\n<p><\/code><\/p>\n<p><code>ifconfig<\/code> ile a\u011f aray\u00fczlerinizin durumunu ve IP adreslerini g\u00f6rebilirsiniz. <code>ping google.com<\/code> komutu ile de internet ba\u011flant\u0131n\u0131z\u0131n aktif olup olmad\u0131\u011f\u0131n\u0131 ve DNS \u00e7\u00f6z\u00fcmlemesinin \u00e7al\u0131\u015f\u0131p \u00e7al\u0131\u015fmad\u0131\u011f\u0131n\u0131 test edebilirsiniz. E\u011fer a\u011f ba\u011flant\u0131s\u0131nda bir sorun varsa, MariaDB'nin d\u0131\u015far\u0131dan veya i\u00e7eriden eri\u015fiminde problemler ya\u015fanabilir. Ayr\u0131ca, g\u00fcvenlik duvar\u0131 (PF) ayarlar\u0131n\u0131z\u0131 da g\u00f6zden ge\u00e7irmeniz gerekebilir, ancak bu ad\u0131mlar\u0131 MariaDB kurulumundan sonra ele alaca\u011f\u0131z.<\/p>\n<p>Bu \u00f6n haz\u0131rl\u0131k ad\u0131mlar\u0131n\u0131 tamamlad\u0131\u011f\u0131n\u0131zda, MariaDB 11.4'\u00fcn OpenBSD 7.8 sisteminize kurulumuna g\u00fcvenle ge\u00e7ebilirsiniz. Bu haz\u0131rl\u0131klar, hem kurulum s\u00fcrecini kolayla\u015ft\u0131racak hem de gelecekteki olas\u0131 sorunlar\u0131n \u00f6n\u00fcne ge\u00e7erek daha stabil bir \u00e7al\u0131\u015fma ortam\u0131 sa\u011flayacakt\u0131r.<\/p>\n<h3>MariaDB Paketinin Kurulumu: <code>pkg_add<\/code> ile Veritaban\u0131 Sunucusunu Nas\u0131l Ediniriz?<\/h3>\n<p>OpenBSD'nin paket y\u00f6netim sistemi, yaz\u0131l\u0131m kurulumunu olduk\u00e7a basitle\u015ftirir. MariaDB 11.4'\u00fc sisteminize kurmak i\u00e7in de bu kolayl\u0131\u011f\u0131 kullanaca\u011f\u0131z. OpenBSD, kararl\u0131l\u0131k ve g\u00fcvenlik odakl\u0131 oldu\u011fu i\u00e7in, genellikle kararl\u0131 s\u00fcr\u00fcm paketlerini sunar. MariaDB 11.4, OpenBSD 7.8'in port a\u011fac\u0131nda mevcut ve do\u011frudan kurulabilir.<\/p>\n<h4>1. MariaDB Paketini Y\u00fckleme<\/h4>\n<p>MariaDB sunucusunu y\u00fcklemek i\u00e7in tek bir komut yeterlidir. Bir <code>doas<\/code> (OpenBSD'nin <code>sudo<\/code> benzeri yetki y\u00fckseltme arac\u0131) yetkisine sahip bir kullan\u0131c\u0131 olarak a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre><code>\ndoas pkg_add mariadb-server\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komutu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, <code>pkg_add<\/code> otomatik olarak OpenBSD'nin resmi paket depolar\u0131ndan <code>mariadb-server<\/code> paketini ve onun t\u00fcm ba\u011f\u0131ml\u0131l\u0131klar\u0131n\u0131 indirip kuracakt\u0131r. Paket y\u00f6neticisi, kurulum s\u0131ras\u0131nda size hangi MariaDB s\u00fcr\u00fcm\u00fcn\u00fcn kurulaca\u011f\u0131n\u0131 g\u00f6sterecektir; OpenBSD 7.8 i\u00e7in bu, b\u00fcy\u00fck ihtimalle MariaDB 11.4.x olacakt\u0131r. Kurulum i\u015flemi, internet ba\u011flant\u0131n\u0131z\u0131n h\u0131z\u0131na ve sunucunuzun performans\u0131na ba\u011fl\u0131 olarak birka\u00e7 dakika s\u00fcrebilir.<\/p>\n<p>Kurulum s\u0131ras\u0131nda <code>pkg_add<\/code> size a\u015fa\u011f\u0131daki gibi bir \u00e7\u0131kt\u0131 g\u00f6sterebilir (bu sadece bir \u00f6rnek ve ger\u00e7ek \u00e7\u0131kt\u0131 farkl\u0131l\u0131k g\u00f6sterebilir):<\/p>\n<pre><code>\nmariadb-server-11.4.2p0: ok\nAmbiguity: bzip2, bzip2-java, bzip2-php73, bzip2-php74, bzip2-php80, bzip2-php81, bzip2-php82, bzip2-php83, bzip2-php84, do you mean bzip2-1.0.8p0? [yes]\nmysql-client-11.4.2p0: ok\n... (di\u011fer ba\u011f\u0131ml\u0131l\u0131klar) ...\n<\/pre>\n<p><\/code><\/p>\n<p>Bazen <code>pkg_add<\/code>, farkl\u0131 s\u00fcr\u00fcmleri veya varyantlar\u0131 olan bir ba\u011f\u0131ml\u0131l\u0131k i\u00e7in size bir se\u00e7enek sunabilir (\u00f6rne\u011fin <code>bzip2<\/code> \u00f6rne\u011finde oldu\u011fu gibi). Genellikle varsay\u0131lan se\u00e7ene\u011fi onaylamak (<code>[yes]<\/code> tu\u015funa basmak) yeterlidir.<\/p>\n<h4>2. Kurulum Sonras\u0131 Mesajlar\u0131 Okuma<\/h4>\n<p><code>pkg_add<\/code>, bir paketi kurduktan sonra bazen kritik bilgiler i\u00e7eren mesajlar g\u00f6r\u00fcnt\u00fcler. Bu mesajlar, hizmeti ba\u015flatmak, ilk yap\u0131land\u0131rmay\u0131 yapmak veya belirli izinleri ayarlamak i\u00e7in gerekli olabilecek talimatlar\u0131 i\u00e7erir. MariaDB kurulumu sonras\u0131 genellikle a\u015fa\u011f\u0131daki gibi bir mesaj al\u0131rs\u0131n\u0131z:<\/p>\n<pre><code>\n--- Message from mariadb-server-11.4.2p0 ---\nTo initialize the database, you must run:\n# mysql_install_db --user=_mysql --datadir=\/var\/mariadb\n\nBefore starting the server, ensure that \/var\/mariadb is properly\nowned by _mysql:_mysql.\nThe database server can be started via rcctl:\n# rcctl enable mysqld\n# rcctl start mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Bu mesajlar son derece \u00f6nemlidir ve bir sonraki ad\u0131m olan ilk yap\u0131land\u0131rma i\u00e7in bize yol g\u00f6sterir. Bu mesajlar genellikle \u015funlar\u0131 belirtir:<\/p>\n<ul>\n<li><strong>Veritaban\u0131 Ba\u015flatma Komutu:<\/strong> <code>mysql_install_db<\/code> komutunu \u00e7al\u0131\u015ft\u0131rarak MariaDB veri dizinini olu\u015fturman\u0131z gerekti\u011fini belirtir. Bu komut, MariaDB'nin sistem veritabanlar\u0131n\u0131 (<code>mysql<\/code>, <code>information_schema<\/code> vb.) ve temel dizin yap\u0131s\u0131n\u0131 olu\u015fturur.<\/li>\n<li><strong>\u0130zinler ve Sahiplik:<\/strong> Veri dizininin (genellikle <code>\/var\/mariadb<\/code>) do\u011fru kullan\u0131c\u0131 (<code>_mysql<\/code>) ve grup (<code>_mysql<\/code>) taraf\u0131ndan sahiplenilmesi gerekti\u011fini vurgular. OpenBSD, hizmetlerin \u00f6zel ve yetkisiz kullan\u0131c\u0131lar alt\u0131nda \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayan \"privilege separation\" (ayr\u0131cal\u0131k ay\u0131rma) prensibini s\u0131k\u00e7a kullan\u0131r, bu da g\u00fcvenli\u011fi art\u0131r\u0131r.<\/li>\n<li><strong>Hizmet Y\u00f6netimi:<\/strong> MariaDB hizmetini (<code>mysqld<\/code> olarak adland\u0131r\u0131l\u0131r) <code>rcctl<\/code> arac\u0131yla nas\u0131l etkinle\u015ftirece\u011finizi ve ba\u015flataca\u011f\u0131n\u0131z\u0131 g\u00f6sterir.<\/li>\n<\/ul>\n<p>Bu mesajlar\u0131 not al\u0131n veya akl\u0131n\u0131zda tutun, \u00e7\u00fcnk\u00fc MariaDB'yi yap\u0131land\u0131rma ve ba\u015flatma ad\u0131mlar\u0131nda bunlar\u0131 kullanaca\u011f\u0131z. Bu noktada, MariaDB paketleri sisteminize ba\u015far\u0131yla y\u00fcklenmi\u015f ancak hen\u00fcz \u00e7al\u0131\u015f\u0131r durumda de\u011fildir. Bir sonraki b\u00f6l\u00fcmde, bu hizmeti nas\u0131l yap\u0131land\u0131raca\u011f\u0131m\u0131z\u0131 ve g\u00fcvenli bir \u015fekilde nas\u0131l ba\u015flataca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.<\/p>\n<h2>MariaDB Yap\u0131land\u0131rmas\u0131 ve G\u00fcvenli\u011fi: \u0130lk \u00c7al\u0131\u015ft\u0131rma ve Koruma Ad\u0131mlar\u0131 Nelerdir?<\/h2>\n<p>MariaDB paketlerini ba\u015far\u0131yla kurmu\u015f olmam\u0131za ra\u011fmen, hen\u00fcz veritaban\u0131 sunucumuz \u00e7al\u0131\u015f\u0131r durumda de\u011fil ve g\u00fcvenli\u011fi optimize edilmi\u015f de\u011fil. Bu b\u00f6l\u00fcmde, MariaDB'yi ilk kez nas\u0131l ba\u015flataca\u011f\u0131m\u0131z\u0131, temel g\u00fcvenlik ayarlar\u0131n\u0131 nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 ve sistem ba\u015flat\u0131l\u0131rken otomatik olarak \u00e7al\u0131\u015fmas\u0131n\u0131 nas\u0131l sa\u011flayaca\u011f\u0131m\u0131z\u0131 ad\u0131m ad\u0131m ele alaca\u011f\u0131z. Bu ad\u0131mlar, kararl\u0131 ve g\u00fcvenli bir veritaban\u0131 ortam\u0131 olu\u015fturmak i\u00e7in hayati \u00f6neme sahiptir.<\/p>\n<h3>\u0130lk Ba\u015flatma ve G\u00fcvenli Kurulum: <code>mysql_install_db<\/code> ve <code>mysql_secure_installation<\/code> Kullan\u0131m\u0131<\/h3>\n<p>MariaDB'nin d\u00fczg\u00fcn bir \u015fekilde \u00e7al\u0131\u015fabilmesi i\u00e7in \u00f6nce veri dizininin olu\u015fturulmas\u0131 ve ard\u0131ndan temel g\u00fcvenlik ayarlar\u0131n\u0131n yap\u0131lmas\u0131 gerekir. Bu iki i\u015flem, <code>mysql_install_db<\/code> ve <code>mysql_secure_installation<\/code> ara\u00e7lar\u0131 arac\u0131l\u0131\u011f\u0131yla ger\u00e7ekle\u015ftirilir.<\/p>\n<h4>1. Veritaban\u0131 Veri Dizinini Ba\u015flatma (Initialize Data Directory)<\/h4>\n<p>MariaDB'nin verilerini saklayaca\u011f\u0131 dizin yap\u0131s\u0131n\u0131 ve varsay\u0131lan sistem veritabanlar\u0131n\u0131 olu\u015fturmak i\u00e7in <code>mysql_install_db<\/code> komutunu kullanmal\u0131y\u0131z. OpenBSD'de MariaDB, <code>_mysql<\/code> kullan\u0131c\u0131s\u0131 alt\u0131nda \u00e7al\u0131\u015facak \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015ft\u0131r ve veri dizini genellikle <code>\/var\/mariadb<\/code>'dir.<\/p>\n<pre><code>\ndoas mysql_install_db --user=_mysql --datadir=\/var\/mariadb\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komutun \u00e7\u0131kt\u0131s\u0131 genellikle herhangi bir hata mesaj\u0131 i\u00e7ermezse, i\u015flem ba\u015far\u0131l\u0131 demektir. Bu ad\u0131m, <code>mysql<\/code>, <code>information_schema<\/code>, <code>performance_schema<\/code> gibi kritik sistem veritabanlar\u0131n\u0131 olu\u015fturur ve MariaDB sunucusunun \u00e7al\u0131\u015fmaya ba\u015flamas\u0131 i\u00e7in gerekli temel altyap\u0131y\u0131 haz\u0131rlar. E\u011fer bu ad\u0131m\u0131 atlarsan\u0131z, MariaDB sunucusu ba\u015flat\u0131lamaz.<\/p>\n<p><strong>\u00d6rnek Vaka Analizi:<\/strong> Bir web geli\u015ftiricisi, yeni bir forum sitesi i\u00e7in OpenBSD \u00fczerine MariaDB kurmaya \u00e7al\u0131\u015f\u0131yor. <code>pkg_add<\/code> komutundan sonra, hevesle <code>rcctl start mysqld<\/code> komutunu \u00e7al\u0131\u015ft\u0131r\u0131yor ve \"Failed to start mysqld\" hatas\u0131 al\u0131yor. G\u00fcnl\u00fckleri kontrol etti\u011finde, veri dizininin eksik oldu\u011funu veya do\u011fru izinlere sahip olmad\u0131\u011f\u0131n\u0131 g\u00f6steren mesajlar g\u00f6r\u00fcyor. Bu durumun \u00e7\u00f6z\u00fcm\u00fc, <code>mysql_install_db<\/code> komutunu \u00e7al\u0131\u015ft\u0131rmak ve MariaDB'nin veri dizinini do\u011fru bir \u015fekilde ba\u015flatmakt\u0131r. Bu k\u00fc\u00e7\u00fck ama kritik ad\u0131m\u0131n atlanmas\u0131, t\u00fcm kurulum s\u00fcrecini sekteye u\u011fratabilir.<\/p>\n<h4>2. MariaDB Hizmetini Ba\u015flatma<\/h4>\n<p>Veri dizinini ba\u015flatt\u0131ktan sonra, MariaDB sunucusunu ge\u00e7ici olarak ba\u015flatabiliriz. Bu, <code>mysql_secure_installation<\/code> scriptini \u00e7al\u0131\u015ft\u0131rabilmemiz i\u00e7in gereklidir.<\/p>\n<pre><code>\ndoas rcctl start mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komut, MariaDB hizmetini arka planda ba\u015flat\u0131r. Hizmetin ba\u015far\u0131l\u0131 bir \u015fekilde ba\u015flat\u0131l\u0131p ba\u015flat\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <code>rcctl status mysqld<\/code> komutunu kullanabilirsiniz.<\/p>\n<pre><code>\ndoas rcctl status mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>E\u011fer \"mysqld is running\" benzeri bir \u00e7\u0131kt\u0131 al\u0131rsan\u0131z, hizmet ba\u015far\u0131yla \u00e7al\u0131\u015f\u0131yor demektir.<\/p>\n<h4>3. MariaDB G\u00fcvenli\u011fini Sa\u011flama (<code>mysql_secure_installation<\/code>)<\/h4>\n<p>MariaDB'nin ilk kurulumundan sonra, varsay\u0131lan olarak baz\u0131 g\u00fcvenlik a\u00e7\u0131klar\u0131 bulunabilir. \u00d6rne\u011fin, \"root\" kullan\u0131c\u0131s\u0131 i\u00e7in \u015fifre yoktur, herkese a\u00e7\u0131k test veritabanlar\u0131 bulunur veya root kullan\u0131c\u0131s\u0131n\u0131n uzaktan ba\u011flanmas\u0131na izin verilir. <code>mysql_secure_installation<\/code> scripti, bu a\u00e7\u0131klar\u0131 kapatmak i\u00e7in interaktif bir \u015fekilde size rehberlik eder.<\/p>\n<pre><code>\ndoas mysql_secure_installation\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komutu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, a\u015fa\u011f\u0131daki ad\u0131mlarla kar\u015f\u0131la\u015facaks\u0131n\u0131z:<\/p>\n<ol>\n<li><strong>Enter current password for root (enter for none):<\/strong> \u0130lk kurulumda root kullan\u0131c\u0131s\u0131n\u0131n \u015fifresi yoktur, bu y\u00fczden direkt Enter tu\u015funa bas\u0131n.<\/li>\n<li><strong>Set root password? [Y\/n]:<\/strong> Y tu\u015funa basarak root kullan\u0131c\u0131s\u0131 i\u00e7in g\u00fc\u00e7l\u00fc bir \u015fifre belirleyin. Bu, veritaban\u0131n\u0131z\u0131n en \u00f6nemli g\u00fcvenlik ad\u0131mlar\u0131ndan biridir. \u015eifrenizi dikkatlice se\u00e7in ve g\u00fcvenli bir yerde saklay\u0131n.<\/li>\n<li><strong>Remove anonymous users? [Y\/n]:<\/strong> Y tu\u015funa basarak anonim kullan\u0131c\u0131lar\u0131 kald\u0131r\u0131n. Bu kullan\u0131c\u0131lar genellikle g\u00fcvenlik zafiyeti olu\u015fturur.<\/li>\n<li><strong>Disallow root login remotely? [Y\/n]:<\/strong> Y tu\u015funa basarak root kullan\u0131c\u0131s\u0131n\u0131n uzaktan ba\u011flant\u0131s\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rak\u0131n. Root kullan\u0131c\u0131s\u0131 ile yaln\u0131zca yerel makineden (localhost) ba\u011flanmak, g\u00fcvenlik i\u00e7in en iyi uygulamad\u0131r. Y\u00f6netim i\u015flemleri i\u00e7in uzaktan eri\u015fime ihtiyac\u0131n\u0131z varsa, ayr\u0131 bir kullan\u0131c\u0131 olu\u015fturman\u0131z ve ona belirli ayr\u0131cal\u0131klar vermeniz \u00f6nerilir.<\/li>\n<li><strong>Remove test database and access to it? [Y\/n]:<\/strong> Y tu\u015funa basarak \"test\" veritaban\u0131n\u0131 ve ona eri\u015fim haklar\u0131n\u0131 kald\u0131r\u0131n. Bu veritaban\u0131 genellikle k\u00f6t\u00fc niyetli ki\u015filer taraf\u0131ndan kullan\u0131labilir.<\/li>\n<li><strong>Reload privilege tables now? [Y\/n]:<\/strong> Y tu\u015funa basarak ayr\u0131cal\u0131k tablolar\u0131n\u0131 yeniden y\u00fckleyin. Bu, yapt\u0131\u011f\u0131n\u0131z g\u00fcvenlik de\u011fi\u015fikliklerinin hemen etkinle\u015fmesini sa\u011flar.<\/li>\n<\/ol>\n<p>T\u00fcm bu ad\u0131mlar\u0131 tamamlad\u0131ktan sonra, MariaDB sunucunuzun temel g\u00fcvenlik ayarlar\u0131 yap\u0131lm\u0131\u015f olacakt\u0131r. Bu ad\u0131mlar, veritaban\u0131n\u0131z\u0131n potansiyel sald\u0131r\u0131lara kar\u015f\u0131 daha diren\u00e7li hale gelmesini sa\u011flar. Bu y\u00fczden her zaman <code>mysql_secure_installation<\/code> komutunu \u00e7al\u0131\u015ft\u0131rmak, kurulum sonras\u0131 ilk i\u015flerinizden biri olmal\u0131d\u0131r.<\/p>\n<h3>MariaDB Hizmetini Y\u00f6netmek: Ba\u015flatma, Durdurma ve Otomatik Ba\u015flang\u0131\u00e7 Nas\u0131l Ayarlan\u0131r?<\/h3>\n<p>MariaDB sunucusunu g\u00fcnl\u00fck operasyonlarda y\u00f6netmek ve sistem yeniden ba\u015flat\u0131ld\u0131\u011f\u0131nda otomatik olarak devreye girmesini sa\u011flamak, stabil bir veritaban\u0131 ortam\u0131 i\u00e7in vazge\u00e7ilmezdir. OpenBSD'de bu t\u00fcr hizmetlerin y\u00f6netimi <code>rcctl<\/code> komutu arac\u0131l\u0131\u011f\u0131yla yap\u0131l\u0131r.<\/p>\n<h4>1. MariaDB Hizmetini Ba\u015flatma ve Durdurma<\/h4>\n<p>Daha \u00f6nce g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi, MariaDB hizmetini manuel olarak ba\u015flatmak i\u00e7in:<\/p>\n<pre><code>\ndoas rcctl start mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Benzer \u015fekilde, hizmeti durdurmak i\u00e7in:<\/p>\n<pre><code>\ndoas rcctl stop mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Hizmeti yeniden ba\u015flatmak (durdurup tekrar ba\u015flatmak) i\u00e7in:<\/p>\n<pre><code>\ndoas rcctl restart mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Ve hizmetin mevcut durumunu kontrol etmek i\u00e7in:<\/p>\n<pre><code>\ndoas rcctl status mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komutlar, MariaDB sunucunuzu gerekti\u011finde y\u00f6netmenizi sa\u011flar. \u00d6rne\u011fin, bir yap\u0131land\u0131rma de\u011fi\u015fikli\u011fi yapt\u0131ktan sonra (<code>my.cnf<\/code> dosyas\u0131nda oldu\u011fu gibi), bu de\u011fi\u015fikliklerin etkili olmas\u0131 i\u00e7in hizmeti yeniden ba\u015flatman\u0131z gerekebilir.<\/p>\n<h4>2. MariaDB'yi Sistem A\u00e7\u0131l\u0131\u015f\u0131nda Otomatik Ba\u015flatma<\/h4>\n<p>Bir sunucunun her yeniden ba\u015flat\u0131l\u0131\u015f\u0131nda MariaDB'yi manuel olarak ba\u015flatmak istemezsiniz. OpenBSD'nin <code>rcctl<\/code> arac\u0131, hizmetleri sistem ba\u015flang\u0131c\u0131nda otomatik olarak etkinle\u015ftirmek i\u00e7in kolay bir yol sunar. MariaDB'nin (<code>mysqld<\/code> hizmeti) otomatik olarak ba\u015flamas\u0131n\u0131 sa\u011flamak i\u00e7in:<\/p>\n<pre><code>\ndoas rcctl enable mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Bu komut, <code>\/etc\/rc.conf.local<\/code> dosyas\u0131na gerekli sat\u0131r\u0131 ekler ve MariaDB'nin bir sonraki sistem ba\u015flat\u0131l\u0131\u015f\u0131ndan itibaren otomatik olarak devreye girmesini sa\u011flar. Bu de\u011fi\u015fikli\u011fin etkili olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <code>rcctl get mysqld status<\/code> veya <code>rcctl get mysqld flags<\/code> komutunu kullanabilirsiniz.<\/p>\n<p>E\u011fer MariaDB'nin otomatik ba\u015flamas\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakmak isterseniz:<\/p>\n<pre><code>\ndoas rcctl disable mysqld\n<\/pre>\n<p><\/code><\/p>\n<p>Bu ad\u0131mlarla birlikte, MariaDB 11.4'\u00fc OpenBSD 7.8 sisteminizde ba\u015far\u0131yla kurmu\u015f, temel g\u00fcvenlik ayarlar\u0131n\u0131 yapm\u0131\u015f ve hizmeti gerekti\u011finde y\u00f6netebilecek duruma gelmi\u015f olursunuz. Art\u0131k veritaban\u0131n\u0131za ba\u011flanabilir, tablolar olu\u015fturabilir ve uygulamalar\u0131n\u0131z\u0131 MariaDB \u00fczerinde \u00e7al\u0131\u015ft\u0131rabilirsiniz. Bu temel kurulum, ileri d\u00fczey yap\u0131land\u0131rma ve optimizasyonlar i\u00e7in sa\u011flam bir temel olu\u015fturur.<\/p>\n<h2>\u0130leri D\u00fczey \u0130pu\u00e7lar\u0131 ve Optimizasyon: Performans ve G\u00fcvenlik \u0130\u00e7in Ek Ad\u0131mlar<\/h2>\n<p>MariaDB 11.4'\u00fc OpenBSD 7.8 \u00fczerine temel kurulumu tamamlad\u0131n\u0131z. \u015eimdi s\u0131ra, bu kurulumu daha da optimize etmeye, performans\u0131 art\u0131rmaya ve g\u00fcvenlik seviyesini en \u00fcst d\u00fczeye \u00e7\u0131karmaya geldi. Bu b\u00f6l\u00fcmde, deneyimli sistem y\u00f6neticileri ve geli\u015ftiriciler i\u00e7in \u00f6nemli ipu\u00e7lar\u0131, yap\u0131land\u0131rma \u00f6nerileri ve bir vaka analizi sunaca\u011f\u0131z.<\/p>\n<h3>MariaDB Yap\u0131land\u0131rmas\u0131 (<code>my.cnf<\/code>) ve Performans Optimizasyonu<\/h3>\n<p>MariaDB'nin performans\u0131, b\u00fcy\u00fck \u00f6l\u00e7\u00fcde <code>my.cnf<\/code> yap\u0131land\u0131rma dosyas\u0131na ba\u011fl\u0131d\u0131r. Bu dosya, MariaDB sunucusunun nas\u0131l davranaca\u011f\u0131n\u0131 belirleyen \u00e7e\u015fitli parametreleri i\u00e7erir. OpenBSD'de bu dosya genellikle <code>\/etc\/my.cnf<\/code> veya <code>\/usr\/local\/etc\/my.cnf<\/code> konumunda bulunur. Kurulum sonras\u0131 varsay\u0131lan ayarlar \u00e7o\u011fu zaman k\u00fc\u00e7\u00fck veya orta \u00f6l\u00e7ekli i\u015f y\u00fckleri i\u00e7in yeterli olsa da, ciddi bir performans art\u0131\u015f\u0131 i\u00e7in elle optimizasyon gerekebilir. \u0130\u015fte baz\u0131 kritik parametreler ve a\u00e7\u0131klamalar\u0131:<\/p>\n<pre><code>\n<span style=\"color: #61afef;\">[mysqld]<\/span>\n<span style=\"color: #e06c75;\"># Genel Ayarlar<\/span>\n<span style=\"color: #98c379;\"># Sunucu karakter setini UTF-8 olarak ayarlar. T\u00fcm ba\u011flant\u0131lar\u0131n ve depolamalar\u0131n bu formatta olmas\u0131n\u0131 sa\u011flar.<\/span>\n<span style=\"color: #e5c07b;\">character-set-server<\/span> = <span style=\"color: #98c379;\">utf8mb4<\/span>\n<span style=\"color: #e5c07b;\">collation-server<\/span> = <span style=\"color: #98c379;\">utf8mb4_unicode_ci<\/span>\n\n<span style=\"color: #e06c75;\"># Bellek Ayarlar\u0131<\/span>\n<span style=\"color: #98c379;\"># Sorgular\u0131n s\u0131ralama i\u015flemleri i\u00e7in kullan\u0131lan arabellek boyutu. Y\u00fcksek de\u011ferler, s\u0131ralama performans\u0131n\u0131 art\u0131r\u0131r.<\/span>\n<span style=\"color: #e5c07b;\">sort_buffer_size<\/span> = <span style=\"color: #98c379;\">4M<\/span>\n<span style=\"color: #98c379;\"># Birle\u015ftirmeler (JOIN) i\u00e7in kullan\u0131lan arabellek boyutu.<\/span>\n<span style=\"color: #e5c07b;\">join_buffer_size<\/span> = <span style=\"color: #98c379;\">4M<\/span>\n<span style=\"color: #98c379;\"># T\u00fcm ba\u011flant\u0131lar aras\u0131nda payla\u015f\u0131lan genel arabellek.<\/span>\n<span style=\"color: #e5c07b;\">key_buffer_size<\/span> = <span style=\"color: #98c379;\">128M<\/span>\n<span style=\"color: #98c379;\"># Her ba\u011flant\u0131 i\u00e7in ayr\u0131lan thread arabelle\u011fi.<\/span>\n<span style=\"color: #e5c07b;\">thread_cache_size<\/span> = <span style=\"color: #98c379;\">128<\/span> <span style=\"color: #98c379;\"># Artan ba\u011flant\u0131 talebi i\u00e7in.<\/span>\n\n<span style=\"color: #e06c75;\"># InnoDB Ayarlar\u0131 (E\u011fer InnoDB kullan\u0131yorsan\u0131z ki genellikle b\u00f6yledir)<\/span>\n<span style=\"color: #98c379;\"># InnoDB'nin kulland\u0131\u011f\u0131 ana bellek alan\u0131. Genellikle sistem RAM'inin %50-70'i kadar ayarlan\u0131r.<\/span>\n<span style=\"color: #e5c07b;\">innodb_buffer_pool_size<\/span> = <span style=\"color: #98c379;\">2G<\/span> <span style=\"color: #98c379;\"># \u00d6rnek: 4GB RAM'li bir sunucu i\u00e7in.<\/span>\n<span style=\"color: #98c379;\"># Her bir i\u015flem log dosyas\u0131n\u0131n boyutu.<\/span>\n<span style=\"color: #e5c07b;\">innodb_log_file_size<\/span> = <span style=\"color: #98c379;\">256M<\/span>\n<span style=\"color: #98c379;\"># InnoDB'nin disk yazma performans\u0131n\u0131 etkiler. \"2\" \u00e7o\u011fu senaryo i\u00e7in g\u00fcvenli ve h\u0131zl\u0131d\u0131r.<\/span>\n<span style=\"color: #e5c07b;\">innodb_flush_log_at_trx_commit<\/span> = <span style=\"color: #98c379;\">2<\/span>\n<span style=\"color: #98c379;\"># E\u015fzamanl\u0131 InnoDB okuma\/yazma i\u015flemleri i\u00e7in I\/O thread say\u0131s\u0131.<\/span>\n<span style=\"color: #e5c07b;\">innodb_io_capacity<\/span> = <span style=\"color: #98c379;\">2000<\/span> <span style=\"color: #98c379;\"># Y\u00fcksek h\u0131zl\u0131 SSD'ler i\u00e7in daha y\u00fcksek de\u011ferler.<\/span>\n\n<span style=\"color: #e06c75;\"># Ba\u011flant\u0131 Ayarlar\u0131<\/span>\n<span style=\"color: #98c379;\"># Maksimum e\u015fzamanl\u0131 ba\u011flant\u0131 say\u0131s\u0131.<\/span>\n<span style=\"color: #e5c07b;\">max_connections<\/span> = <span style=\"color: #98c379;\">200<\/span>\n<span style=\"color: #98c379;\"># Uzun s\u00fcre i\u015flem yapmayan ba\u011flant\u0131lar\u0131 kapatma s\u00fcresi.<\/span>\n<span style=\"color: #e5c07b;\">wait_timeout<\/span> = <span style=\"color: #98c379;\">600<\/span>\n\n<span style=\"color: #e06c75;\"># G\u00fcnl\u00fck Kay\u0131tlar\u0131 (Logging)<\/span>\n<span style=\"color: #98c379;\"># Yava\u015f sorgular\u0131 g\u00fcnl\u00fc\u011fe kaydet. Performans sorunlar\u0131n\u0131 tespit etmek i\u00e7in kritik.<\/span>\n<span style=\"color: #e5c07b;\">slow_query_log<\/span> = <span style=\"color: #98c379;\">1<\/span>\n<span style=\"color: #e5c07b;\">slow_query_log_file<\/span> = <span style=\"color: #98c379;\">\/var\/log\/mariadb\/mariadb-slow.log<\/span>\n<span style=\"color: #e5c07b;\">long_query_time<\/span> = <span style=\"color: #98c379;\">1<\/span> <span style=\"color: #98c379;\"># 1 saniyeden uzun s\u00fcren sorgular\u0131 kaydet.<\/span>\n<\/pre>\n<p><\/code><\/p>\n<p><strong>\u00d6nemli Not:<\/strong> Bu de\u011ferler \u00f6rnek te\u015fkil etmektedir ve sunucunuzun RAM miktar\u0131na, CPU g\u00fcc\u00fcne, disk tipine (SSD\/HDD) ve uygulaman\u0131z\u0131n i\u015f y\u00fck\u00fc profiline g\u00f6re \u00f6zelle\u015ftirilmelidir. Yanl\u0131\u015f yap\u0131land\u0131rma, performans\u0131 d\u00fc\u015f\u00fcrebilir veya sistem karars\u0131zl\u0131\u011f\u0131na yol a\u00e7abilir. De\u011fi\u015fiklik yapt\u0131ktan sonra MariaDB hizmetini yeniden ba\u015flatmay\u0131 unutmay\u0131n: <code>doas rcctl restart mysqld<\/code>.<\/p>\n<div class=\"expert-tip\">\n  Uzman \u0130pucu: MariaDB yap\u0131land\u0131rmalar\u0131n\u0131 optimize ederken, \u00f6nce k\u00fc\u00e7\u00fck de\u011fi\u015fiklikler yap\u0131n ve sunucunuzun davran\u0131\u015f\u0131n\u0131 izleyin. <code>mariadb-admin status<\/code>, <code>SHOW GLOBAL STATUS;<\/code> ve <code>SHOW ENGINE INNODB STATUS;<\/code> gibi komutlarla sunucu performans\u0131n\u0131 ve kaynak kullan\u0131m\u0131n\u0131 takip edebilirsiniz. \u00d6zellikle <code>innodb_buffer_pool_size<\/code> parametresi, performans\u0131 en \u00e7ok etkileyen ayard\u0131r ve genellikle sistem RAM'inin %50-70'i kadar ayarlanmas\u0131 \u00f6nerilir. Ayr\u0131ca, sisteminizin CPU \u00e7ekirdek say\u0131s\u0131 da baz\u0131 parametrelerin ayarlanmas\u0131nda (\u00f6rn. <code>innodb_read_io_threads<\/code>, <code>innodb_write_io_threads<\/code>) g\u00f6z \u00f6n\u00fcnde bulundurulmal\u0131d\u0131r.\n<\/div>\n<h3>OpenBSD Paket Filtresi (PF) ile A\u011f G\u00fcvenli\u011fi<\/h3>\n<p>MariaDB sunucusuna yaln\u0131zca belirli IP adreslerinden veya yerel olarak eri\u015fime izin vermek, genel g\u00fcvenli\u011fi \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r. OpenBSD'nin g\u00fc\u00e7l\u00fc g\u00fcvenlik duvar\u0131 olan PF (Packet Filter) bu konuda bize yard\u0131mc\u0131 olur. Varsay\u0131lan olarak, MariaDB 3306 portunu kullan\u0131r.<\/p>\n<p>A\u015fa\u011f\u0131da, <code>\/etc\/pf.conf<\/code> dosyan\u0131za ekleyebilece\u011finiz basit bir PF kural\u0131 \u00f6rne\u011fi bulunmaktad\u0131r:<\/p>\n<pre><code>\n<span style=\"color: #61afef;\"># makro tan\u0131mlamalar\u0131<\/span>\n<span style=\"color: #e5c07b;\">ext_if<\/span> = <span style=\"color: #98c379;\">\"em0\"<\/span> <span style=\"color: #98c379;\"># D\u0131\u015f a\u011f aray\u00fcz\u00fcn\u00fcz\u00fcn ad\u0131, \u00f6rn: em0, ix0<\/span>\n<span style=\"color: #e5c07b;\">mariadb_port<\/span> = <span style=\"color: #98c379;\">\"3306\"<\/span>\n<span style=\"color: #e5c07b;\">trusted_network<\/span> = <span style=\"color: #98c379;\">\"192.168.1.0\/24\"<\/span> <span style=\"color: #98c379;\"># G\u00fcvenilir a\u011f\u0131n\u0131z\u0131n IP aral\u0131\u011f\u0131<\/span>\n<span style=\"color: #e5c07b;\">trusted_ip<\/span> = <span style=\"color: #98c379;\">\"10.0.0.5\"<\/span> <span style=\"color: #98c379;\"># G\u00fcvenilir bir tek IP adresi<\/span>\n\n<span style=\"color: #61afef;\"># Varsay\u0131lan olarak t\u00fcm trafi\u011fi engelle<\/span>\n<span style=\"color: #e06c75;\">block return all<\/span>\n\n<span style=\"color: #61afef;\"># \u0130\u00e7 aray\u00fczden veya yerel ba\u011flant\u0131lardan gelen MariaDB trafi\u011fine izin ver<\/span>\n<span style=\"color: #e06c75;\">pass in on lo proto tcp to port { $mariadb_port }<\/span>\n<span style=\"color: #e06c75;\">pass in on $ext_if proto tcp from $trusted_network to port { $mariadb_port }<\/span>\n<span style=\"color: #e06c75;\">pass in on $ext_if proto tcp from $trusted_ip to port { $mariadb_port }<\/span>\n\n<span style=\"color: #61afef;\"># Harici ba\u011flant\u0131lardan, sadece belirli bir kaynaktan gelen MariaDB ba\u011flant\u0131lar\u0131na izin ver<\/span>\n<span style=\"color: #e06c75;\"># E\u011fer sadece localhost'tan eri\u015fim isteniyorsa, bu kurala gerek yoktur.<\/span>\n<span style=\"color: #e06c75;\"># Bu kural\u0131 ekledikten sonra, pf.conf dosyas\u0131n\u0131 kontrol edin ve y\u00fckleyin.<\/span>\n<\/pre>\n<p><\/code><\/p>\n<p>De\u011fi\u015fiklikleri <code>\/etc\/pf.conf<\/code> dosyas\u0131na kaydettikten sonra, yap\u0131land\u0131rmay\u0131 test etmek ve y\u00fcklemek i\u00e7in:<\/p>\n<pre><code>\ndoas pfctl -nf \/etc\/pf.conf   <span style=\"color: #98c379;\"># Yap\u0131land\u0131rmay\u0131 kontrol et, hata olup olmad\u0131\u011f\u0131n\u0131 g\u00f6rmek i\u00e7in<\/span>\ndoas pfctl -f \/etc\/pf.conf    <span style=\"color: #98c379;\"># Yap\u0131land\u0131rmay\u0131 y\u00fckle<\/span>\n<\/pre>\n<p><\/code><\/p>\n<p>Bu kurallar, MariaDB'ye yaln\u0131zca g\u00fcvenilir a\u011flardan veya IP adreslerinden eri\u015filmesini sa\u011flar. Bu, yetkisiz eri\u015fim denemelerini \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r ve veritaban\u0131 sunucunuzu daha g\u00fcvenli hale getirir.<\/p>\n<h3>Yedekleme Stratejileri ve Felaket Kurtarma<\/h3>\n<p>Herhangi bir veritaban\u0131 i\u00e7in en \u00f6nemli g\u00fcvenlik ve s\u00fcreklilik ad\u0131mlar\u0131ndan biri d\u00fczenli yedeklemelerdir. OpenBSD ve MariaDB ortam\u0131nda etkili bir yedekleme stratejisi geli\u015ftirmek hayati \u00f6neme sahiptir. \u0130\u015fte birka\u00e7 y\u00f6ntem:<\/p>\n<ul>\n<li><strong><code>mariabackup<\/code> (XtraBackup):<\/strong> InnoDB depolama motoru i\u00e7in en geli\u015fmi\u015f yedekleme arac\u0131d\u0131r. S\u0131cak (online) yedeklemeler yapabilir ve veritaban\u0131n\u0131n \u00e7al\u0131\u015fmas\u0131n\u0131 durdurmadan tutarl\u0131 yedekler alman\u0131z\u0131 sa\u011flar. Genellikle ayr\u0131 bir paket olarak kurulur.<\/li>\n<li><strong><code>mysqldump<\/code>:<\/strong> Daha basit ve yayg\u0131n olarak kullan\u0131lan bir y\u00f6ntemdir. Veritaban\u0131n\u0131n mant\u0131ksal bir yede\u011fini (SQL sorgular\u0131 olarak) olu\u015fturur. K\u00fc\u00e7\u00fck ve orta \u00f6l\u00e7ekli veritabanlar\u0131 i\u00e7in uygundur. B\u00fcy\u00fck veritabanlar\u0131nda yedekleme s\u0131ras\u0131nda sunucuyu kilitleyebilir.<\/li>\n<li><strong>LVM Snapshot (E\u011fer LVM kullan\u0131yorsan\u0131z):<\/strong> E\u011fer MariaDB veri dizininiz bir LVM mant\u0131ksal birimi \u00fczerindeyse, anl\u0131k g\u00f6r\u00fcnt\u00fc (snapshot) alarak tutarl\u0131 bir yedek alabilirsiniz. Bu y\u00f6ntem daha h\u0131zl\u0131 olabilir ve b\u00fcy\u00fck veritabanlar\u0131 i\u00e7in uygundur.<\/li>\n<\/ul>\n<p><strong>Ger\u00e7ek D\u00fcnya Senaryosu:<\/strong> K\u00fc\u00e7\u00fck bir e-ticaret \u015firketinin OpenBSD sunucusu \u00fczerinde MariaDB ile \u00e7al\u0131\u015fan bir envanter sistemi bulunuyor. Sistem y\u00f6neticisi, gece yar\u0131s\u0131 otomatik \u00e7al\u0131\u015fan bir cron i\u015fi ile haftal\u0131k olarak <code>mysqldump<\/code> kullanarak yedekler al\u0131yor ve bunlar\u0131 ayr\u0131 bir NFS payla\u015f\u0131m\u0131na veya g\u00fcvenli bulut depolama alan\u0131na kopyal\u0131yor. Bir g\u00fcn, yanl\u0131\u015f bir SQL sorgusu nedeniyle envanter verilerinin bozuldu\u011funu fark ediyorlar. Hemen en son iyi yedeklemeyi geri y\u00fckleyerek sistemlerini dakikalar i\u00e7inde eski haline getiriyorlar. Bu durum, d\u00fczenli ve test edilmi\u015f yedekleme stratejisinin \u00f6nemini a\u00e7\u0131k\u00e7a g\u00f6stermektedir.<\/p>\n<pre><code>\n<span style=\"color: #61afef;\"># mysqldump ile yedek alma \u00f6rne\u011fi<\/span>\n<span style=\"color: #98c379;\"># T\u00fcm veritabanlar\u0131n\u0131 yedekle<\/span>\n<span style=\"color: #e06c75;\">doas mysqldump --all-databases --single-transaction --flush-logs --master-data=2 -u root -p > \/path\/to\/backup\/full_backup_$(date +%Y%m%d%H%M%S).sql<\/span>\n\n<span style=\"color: #98c379;\"># Belirli bir veritaban\u0131n\u0131 yedekle<\/span>\n<span style=\"color: #e06c75;\">doas mysqldump my_database -u root -p > \/path\/to\/backup\/my_database_backup_$(date +%Y%m%d%H%M%S).sql<\/span>\n<\/pre>\n<p><\/code><\/p>\n<p>Yedeklemeleri mutlaka farkl\u0131 bir konuma (uzak sunucu, bulut depolama) kopyalay\u0131n ve d\u00fczenli olarak geri y\u00fckleme testleri yaparak yedeklerinizin ge\u00e7erlili\u011finden emin olun. Felaket kurtarma plan\u0131n\u0131z\u0131n bir par\u00e7as\u0131 olarak bu testler vazge\u00e7ilmezdir.<\/p>\n<h2>Sonu\u00e7 ve S\u0131k\u00e7a Sorulan Sorular: Ba\u015far\u0131l\u0131 Bir Kurulumun Ard\u0131ndan<\/h2>\n<p>Bu kapsaml\u0131 rehber boyunca, MariaDB 11.4'\u00fc OpenBSD 7.8 i\u015fletim sisteminiz \u00fczerine ad\u0131m ad\u0131m nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, temel g\u00fcvenlik ayarlar\u0131n\u0131 nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 ve performans\u0131 optimize etmek i\u00e7in nelere dikkat etmeniz gerekti\u011fini detayl\u0131 bir \u015fekilde inceledik. OpenBSD'nin \u00fcst\u00fcn g\u00fcvenlik mimarisi ile MariaDB'nin modern veritaban\u0131 \u00f6zelliklerini bir araya getirerek, hem g\u00fcvenli hem de y\u00fcksek performansl\u0131 bir veritaban\u0131 altyap\u0131s\u0131 kurma yetene\u011fini kazand\u0131n\u0131z. Art\u0131k bu sa\u011flam temeli kullanarak kendi uygulamalar\u0131n\u0131z\u0131 geli\u015ftirebilir veya mevcut sistemlerinizi bu g\u00fcvenilir platforma ta\u015f\u0131yabilirsiniz.<\/p>\n<p>Kurulum s\u00fcreci sadece ba\u015flang\u0131\u00e7t\u0131r; MariaDB sunucunuzun performans\u0131n\u0131 d\u00fczenli olarak izlemek, g\u00fcvenlik yamalar\u0131n\u0131 uygulamak ve yedekleme stratejilerinizi g\u00f6zden ge\u00e7irmek, uzun vadeli kararl\u0131l\u0131k ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fc i\u00e7in kritik \u00f6neme sahiptir. Unutmay\u0131n ki OpenBSD'nin \"varsay\u0131lan olarak g\u00fcvenli\" yakla\u015f\u0131m\u0131, sizin de g\u00fcvenlik bilincine sahip olman\u0131zla peki\u015fir. Kulland\u0131\u011f\u0131n\u0131z uygulamalar\u0131 g\u00fcncel tutmak, MariaDB kullan\u0131c\u0131lar\u0131na en az yetki prensibiyle izinler vermek ve d\u00fczenli olarak g\u00fcvenlik denetimleri yapmak, sisteminizin g\u00fcvenli\u011fini s\u00fcrekli olarak sa\u011flam tutman\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p>\n<p>Umar\u0131z bu rehber, OpenBSD \u00fczerinde MariaDB deneyiminizi sorunsuz ve verimli hale getirmi\u015ftir. G\u00fcvenli ve h\u0131zl\u0131 veritaban\u0131 operasyonlar\u0131n\u0131zda ba\u015far\u0131lar dileriz!<\/p>\n<h3>S\u0131k\u00e7a Sorulan Sorular (SSS)<\/h3>\n<p>MariaDB 11.4'\u00fc OpenBSD 7.8 \u00fczerine kurarken veya sonras\u0131nda akl\u0131n\u0131za tak\u0131labilecek baz\u0131 yayg\u0131n sorular\u0131 ve cevaplar\u0131n\u0131 a\u015fa\u011f\u0131da bulabilirsiniz:<\/p>\n<dl>\n<dt><strong>1. MariaDB root \u015fifremi unuttum, ne yapmal\u0131y\u0131m?<\/strong><\/dt>\n<dd>\n        MariaDB root \u015fifrenizi unutman\u0131z durumunda, sunucuyu g\u00fcvenli modda (\u015fifre istemeden) ba\u015flat\u0131p \u015fifrenizi s\u0131f\u0131rlayabilirsiniz.<\/p>\n<ol>\n<li>MariaDB servisini durdurun:\n<pre><code>doas rcctl stop mysqld<\/pre>\n<p><\/code><\/li>\n<li>MariaDB'yi \u015fifresiz ba\u015flat\u0131n:\n<pre><code>doas mysqld_safe --skip-grant-tables &<\/pre>\n<p><\/code><\/li>\n<li>MariaDB'ye ba\u011flan\u0131n:\n<pre><code>mysql -u root<\/pre>\n<p><\/code><\/li>\n<li>\u015eifreyi s\u0131f\u0131rlay\u0131n (MariaDB 10.4 ve sonras\u0131 i\u00e7in):\n<pre><code>\n                ALTER USER 'root'@'localhost' IDENTIFIED BY 'YeniG\u00fc\u00e7l\u00fc\u015eifreniz';\n                FLUSH PRIVILEGES;\n                QUIT;\n                <\/pre>\n<p><\/code>\n            <\/li>\n<li>MariaDB'yi yeniden ba\u015flat\u0131n:\n<pre><code>doas rcctl restart mysqld<\/pre>\n<p><\/code><\/li>\n<\/ol>\n<\/dd>\n<dt><strong>2. MariaDB'ye uzaktan ba\u011flanam\u0131yorum, sorun ne olabilir?<\/strong><\/dt>\n<dd>\n        Uzaktan ba\u011flanamaman\u0131n birka\u00e7 nedeni olabilir:<\/p>\n<ul>\n<li><strong>G\u00fcvenlik Duvar\u0131 (PF):<\/strong> OpenBSD'nin PF g\u00fcvenlik duvar\u0131 MariaDB portunu (varsay\u0131lan 3306) engelliyor olabilir. <code>\/etc\/pf.conf<\/code> dosyan\u0131z\u0131 kontrol edip ilgili <code>pass in<\/code> kural\u0131n\u0131 ekledi\u011finizden ve PF'yi yeniden y\u00fckledi\u011finizden emin olun.<\/li>\n<li><strong>MariaDB Kullan\u0131c\u0131 \u0130zinleri:<\/strong> Uzaktan ba\u011flanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z MariaDB kullan\u0131c\u0131s\u0131n\u0131n do\u011fru host izinlerine sahip olmas\u0131 gerekir. \u00d6rne\u011fin, <code>'kullanici'@'%'<\/code> (herhangi bir hosttan) veya <code>'kullanici'@'192.168.1.100'<\/code> (belirli bir IP'den) gibi izinler vermeniz gerekebilir.<\/li>\n<li><strong><code>bind-address<\/code> Ayar\u0131:<\/strong> <code>\/etc\/my.cnf<\/code> dosyas\u0131ndaki <code>bind-address<\/code> parametresi sadece <code>127.0.0.1<\/code> (localhost) olarak ayarlanm\u0131\u015fsa, MariaDB sadece yerel ba\u011flant\u0131lar\u0131 kabul eder. Uzaktan ba\u011flant\u0131lara izin vermek i\u00e7in bu ayar\u0131 sunucunuzun IP adresine veya <code>0.0.0.0<\/code>'a (t\u00fcm IP'lerden) de\u011fi\u015ftirmelisiniz (g\u00fcvenlik risklerini g\u00f6z \u00f6n\u00fcnde bulundurarak).<\/li>\n<\/ul>\n<\/dd>\n<dt><strong>3. MariaDB hizmeti ba\u015flam\u0131yor, g\u00fcnl\u00fckleri nerede bulabilirim?<\/strong><\/dt>\n<dd>\n        MariaDB hizmeti ba\u015flat\u0131lamad\u0131\u011f\u0131nda hata mesajlar\u0131n\u0131 genellikle OpenBSD'nin genel sistem g\u00fcnl\u00fcklerinde bulabilirsiniz. Ana g\u00fcnl\u00fck dosyas\u0131 <code>\/var\/log\/messages<\/code>'t\u0131r. Bu dosyay\u0131 inceleyerek veya <code>dmesg<\/code> komutunu kullanarak MariaDB'nin neden ba\u015flat\u0131lamad\u0131\u011f\u0131na dair ipu\u00e7lar\u0131 arayabilirsiniz. \u00d6zellikle <code>mysql_install_db<\/code> ad\u0131m\u0131n\u0131 atlad\u0131ysan\u0131z veya veri dizini izinleri yanl\u0131\u015fsa, g\u00fcnl\u00fcklerde bu t\u00fcr hatalar\u0131 g\u00f6rebilirsiniz.\n    <\/dd>\n<dt><strong>4. MariaDB'yi farkl\u0131 bir veri dizinine kurabilir miyim?<\/strong><\/dt>\n<dd>\n        Evet, MariaDB'yi farkl\u0131 bir veri dizinine kurabilirsiniz. Bunun i\u00e7in:<\/p>\n<ol>\n<li>Yeni bir dizin olu\u015fturun ve do\u011fru izinleri verin (\u00f6rne\u011fin <code>\/data\/mariadb<\/code>).<\/li>\n<li><code>\/etc\/my.cnf<\/code> dosyas\u0131nda <code>datadir<\/code> parametresini yeni dizin yolunu g\u00f6sterecek \u015fekilde g\u00fcncelleyin.<\/li>\n<li><code>mysql_install_db<\/code> komutunu yeni <code>datadir<\/code> ile \u00e7al\u0131\u015ft\u0131r\u0131n:\n<pre><code>doas mysql_install_db --user=_mysql --datadir=\/data\/mariadb<\/pre>\n<p><\/code><\/li>\n<li>MariaDB hizmetini ba\u015flat\u0131n.<\/li>\n<\/ol>\n<p>        Bu i\u015flem, disk alan\u0131n\u0131z\u0131n yetersiz oldu\u011fu veya veri dosyalar\u0131n\u0131 belirli bir diske yerle\u015ftirmek istedi\u011finiz durumlarda faydal\u0131d\u0131r.\n    <\/dd>\n<dt><strong>5. OpenBSD'de MariaDB g\u00fcncellemelerini nas\u0131l yapar\u0131m?<\/strong><\/dt>\n<dd>\n        MariaDB paketini g\u00fcncellemek i\u00e7in OpenBSD'nin standart paket g\u00fcncelleme komutunu kullanabilirsiniz:<\/p>\n<pre><code>doas pkg_add -u<\/pre>\n<p><\/code><br \/>\n        Bu komut, sistemdeki t\u00fcm paketleri (MariaDB dahil) en son kararl\u0131 s\u00fcr\u00fcmlerine g\u00fcncelleyecektir. B\u00fcy\u00fck s\u00fcr\u00fcm y\u00fckseltmeleri (\u00f6rne\u011fin 11.4'ten 11.5'e) genellikle \u00f6zel ge\u00e7i\u015f ad\u0131mlar\u0131 gerektirebilir ve <code>pkg_add<\/code> bu t\u00fcr durumlarda size bilgi verecektir. Y\u00fckseltme \u00f6ncesi her zaman yedek almak iyi bir uygulamad\u0131r.\n    <\/dd>\n<\/dl>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"MariaDB 11.4 OpenBSD 7.8 \u00dczerine Kurulum Rehberi OpenBSD&#8217;nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4&#8217;\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-35764","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Neden OpenBSD&#039;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?<\/title>\n<meta name=\"description\" content=\"OpenBSD&#039;nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4&#039;\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB&#039;yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Neden OpenBSD&#039;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?\" \/>\n<meta property=\"og:description\" content=\"OpenBSD&#039;nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4&#039;\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB&#039;yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-03T14:31:21+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"31 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Neden OpenBSD&#8217;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?\",\"datePublished\":\"2025-12-03T14:31:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\"},\"wordCount\":5419,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\",\"name\":\"Neden OpenBSD'de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-12-03T14:31:21+00:00\",\"description\":\"OpenBSD'nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4'\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB'yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Neden OpenBSD&#8217;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Neden OpenBSD'de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?","description":"OpenBSD'nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4'\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB'yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/","og_locale":"tr_TR","og_type":"article","og_title":"Neden OpenBSD'de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?","og_description":"OpenBSD'nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4'\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB'yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.","og_url":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-12-03T14:31:21+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"31 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Neden OpenBSD&#8217;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?","datePublished":"2025-12-03T14:31:21+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/"},"wordCount":5419,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/","url":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/","name":"Neden OpenBSD'de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-12-03T14:31:21+00:00","description":"OpenBSD'nin e\u015fsiz g\u00fcvenli\u011fi ile MariaDB 11.4'\u00fcn g\u00fcncel ve performansl\u0131 \u00f6zelliklerini bir araya getirmek mi istiyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 kurulum s\u00fcre\u00e7lerini hi\u00e7 zorlanmadan tamamlaman\u0131z i\u00e7in ad\u0131m ad\u0131m yol g\u00f6sterecek, kar\u015f\u0131la\u015fabilece\u011finiz t\u00fcm senaryolara \u0131\u015f\u0131k tutacak ve OpenBSD 7.8 \u00fczerinde MariaDB'yi g\u00fcvenle nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 anlatacak.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/neden-openbsdde-mariadb-11-4-kullanmalisiniz\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Neden OpenBSD&#8217;de MariaDB 11.4 Kullanmal\u0131s\u0131n\u0131z?"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/35764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=35764"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/35764\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=35764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=35764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=35764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}