{"id":471,"date":"2024-03-23T17:45:58","date_gmt":"2024-03-23T17:45:58","guid":{"rendered":"https:\/\/www.metinpolat.net\/blog\/?p=471"},"modified":"2024-03-23T20:02:48","modified_gmt":"2024-03-23T20:02:48","slug":"mysql-nedir","status":"publish","type":"post","link":"https:\/\/www.metinpolat.net\/blog\/mysql-nedir\/","title":{"rendered":"MySQL Nedir?"},"content":{"rendered":"\n<p>MySQL, d\u00fcnya genelinde en pop\u00fcler a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemlerinden biridir. \u0130lk olarak 1995 y\u0131l\u0131nda Michael Widenius ve David Axmark taraf\u0131ndan geli\u015ftirilmeye ba\u015flanm\u0131\u015ft\u0131r. MySQL, web tabanl\u0131 uygulamalar, veri depolama, e-ticaret, ve log kay\u0131tlar\u0131 gibi bir\u00e7ok alanda tercih edilen bir veritaban\u0131 y\u00f6netim sistemidir. Structured Query Language (SQL) kullanarak veriler \u00fczerinde sorgulama, ekleme, g\u00fcncelleme ve silme i\u015flemleri yap\u0131labilir.<\/p>\n\n\n\n<p>MySQL, \u00f6zellikle PHP gibi server-side scripting dilleri ile birlikte kullan\u0131ld\u0131\u011f\u0131nda web geli\u015ftirme alan\u0131nda b\u00fcy\u00fck bir pop\u00fclerlik kazanm\u0131\u015ft\u0131r. WordPress, Joomla, Drupal gibi i\u00e7erik y\u00f6netim sistemleri ve Magento, OpenCart gibi e-ticaret platformlar\u0131 bu veritaban\u0131n\u0131 kullan\u0131r.<\/p>\n\n\n\n<p>MySQL&#8217;in Baz\u0131 \u00d6zellikleri:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A\u00e7\u0131k Kaynakl\u0131 Olmas\u0131:<\/strong> MySQL, GNU General Public License alt\u0131nda yay\u0131nlan\u0131r, bu da kullan\u0131c\u0131lar\u0131n yaz\u0131l\u0131m\u0131 \u00fccretsiz olarak kullanabilecekleri, de\u011fi\u015ftirebilecekleri ve hatta da\u011f\u0131tabilecekleri anlam\u0131na gelir.<\/li>\n\n\n\n<li><strong>Platformlar Aras\u0131 Destek:<\/strong> MySQL, Linux, Windows, MacOS, Solaris gibi bir\u00e7ok farkl\u0131 i\u015fletim sistemi \u00fczerinde \u00e7al\u0131\u015fabilir.<\/li>\n\n\n\n<li><strong>Y\u00fcksek Performans:<\/strong> MySQL, \u00e7ok b\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde h\u0131zl\u0131 ve etkili bir \u015fekilde i\u015flem yapabilme yetene\u011fine sahiptir. \u00d6zellikle web uygulamalar\u0131 i\u00e7in optimize edilmi\u015f bir\u00e7ok \u00f6zelli\u011fe sahiptir.<\/li>\n\n\n\n<li><strong>G\u00fcvenilirlik ve Stabilite:<\/strong> MySQL, g\u00fc\u00e7l\u00fc veri koruma \u00f6zellikleri, i\u015flem deste\u011fi, ve kapsaml\u0131 g\u00fcvenlik \u00f6zellikleri ile bilinir.<\/li>\n\n\n\n<li><strong>Esneklik:<\/strong> MySQL, \u00e7ok \u00e7e\u015fitli uygulama t\u00fcrlerine uyum sa\u011flayacak \u015fekilde yap\u0131land\u0131r\u0131labilir. K\u00fc\u00e7\u00fck projelerden b\u00fcy\u00fck, y\u00fcksek trafi\u011fe sahip web sitelerine kadar her t\u00fcrl\u00fc ihtiyac\u0131 kar\u015f\u0131layabilir.<\/li>\n\n\n\n<li><strong>Tutarl\u0131l\u0131k ve B\u00fct\u00fcnl\u00fck:<\/strong> MySQL, ACID (Atomiklik, Tutarl\u0131l\u0131k, \u0130zolasyon, Dayan\u0131kl\u0131l\u0131k) uyumlulu\u011fu sayesinde veritaban\u0131 i\u015flemlerinin g\u00fcvenilir ve hatas\u0131z bir \u015fekilde y\u00fcr\u00fct\u00fclmesini sa\u011flar.<\/li>\n<\/ul>\n\n\n\n<p>MySQL, Oracle Corporation taraf\u0131ndan sat\u0131n al\u0131nd\u0131ktan sonra, MySQL&#8217;in orijinal geli\u015ftiricilerinden baz\u0131lar\u0131 MariaDB ad\u0131nda yeni bir veritaban\u0131 geli\u015ftirmeye ba\u015flam\u0131\u015ft\u0131r. MariaDB, MySQL ile tamamen uyumlu olacak \u015fekilde tasarlanm\u0131\u015ft\u0131r ve a\u00e7\u0131k kaynakl\u0131 bir alternatif olarak sunulmaktad\u0131r. Ancak, MySQL halen d\u00fcnya \u00e7ap\u0131nda geni\u015f bir kullan\u0131c\u0131 kitlesine sahip olup, bir\u00e7ok uygulama ve hizmet i\u00e7in tercih edilen veritaban\u0131 y\u00f6netim sistemidir.<\/p>\n\n\n\n<p>MySQL, ilk s\u00fcr\u00fcm\u00fcn\u00fcn yay\u0131nlanmas\u0131ndan bu yana bir\u00e7ok farkl\u0131 s\u00fcr\u00fcm\u00fc piyasaya s\u00fcrm\u00fc\u015ft\u00fcr. Her yeni s\u00fcr\u00fcm, performans iyile\u015ftirmeleri, yeni \u00f6zellikler, g\u00fcvenlik g\u00fcncellemeleri ve hata d\u00fczeltmeleri i\u00e7erir. MySQL&#8217;in en \u00f6nemli s\u00fcr\u00fcmlerine genel bir bak\u0131\u015f a\u015fa\u011f\u0131da verilmi\u015ftir. Ancak, belirli \u00f6zellikler ve iyile\u015ftirmeler i\u00e7in her zaman resmi MySQL d\u00f6k\u00fcmantasyonuna ba\u015fvurmak en iyisidir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL 3.x<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bu serinin ilk s\u00fcr\u00fcmleri 1990&#8217;lar\u0131n sonlar\u0131nda yay\u0131nland\u0131. \u0130li\u015fkisel veritaban\u0131 y\u00f6netimi i\u00e7in temel bir altyap\u0131 sunuyordu.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL 4.x<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Yay\u0131nlanma Tarihi:<\/strong> 2003<\/li>\n\n\n\n<li>Bu s\u00fcr\u00fcm, sorgu optimizasyonu, tam metin arama yetenekleri ve daha iyi h\u0131z i\u00e7in \u00f6nemli iyile\u015ftirmeler getirdi. Ayr\u0131ca, bu s\u00fcr\u00fcmde InnoDB depolama motoru varsay\u0131lan olarak dahil edildi.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL 5.x<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Yay\u0131nlanma Tarihi:<\/strong> 2005<\/li>\n\n\n\n<li>MySQL 5.0, sakl\u0131 prosed\u00fcrler, tetikleyiciler, g\u00f6r\u00fcn\u00fcmler ve daha geli\u015fmi\u015f veritaban\u0131 y\u00f6netimi i\u00e7in di\u011fer \u00f6nemli \u00f6zelliklerle birlikte nesne y\u00f6nelimli programlamay\u0131 (OOP) destekleyen yeni \u00f6zellikler ekledi.<\/li>\n\n\n\n<li>\u0130lerleyen s\u00fcr\u00fcmler (5.1, 5.5, 5.6, 5.7), performans iyile\u015ftirmeleri, daha iyi JSON deste\u011fi, iyile\u015ftirilmi\u015f replikasyon ve daha fazlas\u0131n\u0131 sundu.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL 8.0<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Yay\u0131nlanma Tarihi:<\/strong> 2018<\/li>\n\n\n\n<li>MySQL 8.0, sorgu performans\u0131n\u0131 b\u00fcy\u00fck \u00f6l\u00e7\u00fcde art\u0131ran SQL pencere fonksiyonlar\u0131 ve ortak tablo ifadeleri gibi SQL standart \u00f6zelliklerini getirdi. Ayr\u0131ca, Unicode deste\u011fini geni\u015fletti (UTF-8 mb4), JSON deste\u011fini iyile\u015ftirdi, ve g\u00fcvenlik ile kullan\u0131labilirlik alanlar\u0131nda bir\u00e7ok yeni \u00f6zellik ekledi. Ayr\u0131ca, sistem tablolar\u0131 i\u00e7in yeni bir veri s\u00f6zl\u00fc\u011f\u00fc yap\u0131s\u0131na ge\u00e7i\u015f yapt\u0131.<\/li>\n<\/ul>\n\n\n\n<p>Her bir yeni MySQL s\u00fcr\u00fcm\u00fc, kullan\u0131c\u0131 ve geli\u015ftirici geri bildirimlerine dayanarak veritaban\u0131 y\u00f6netimi, performans ve g\u00fcvenlikte \u00f6nemli iyile\u015ftirmeler sunmaktad\u0131r. MySQL&#8217;in farkl\u0131 s\u00fcr\u00fcmleri aras\u0131nda ge\u00e7i\u015f yaparken, uyumluluk ve y\u00fckseltme gereksinimlerini dikkatli bir \u015fekilde de\u011ferlendirmek \u00f6nemlidir. Ayr\u0131ca, Oracle taraf\u0131ndan sa\u011flanan resmi MySQL s\u00fcr\u00fcm notlar\u0131 ve d\u00f6k\u00fcmantasyon, en g\u00fcncel bilgileri ve \u00f6zellikleri i\u00e7erir.<br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL S\u00fcr\u00fcm \u00d6\u011frenme<\/h3>\n\n\n\n<p>MySQL kabu\u011fu \u00fczerinden MySQL versiyonumuzu \u00f6\u011frenebiliriz.<br>MySQL veritaban\u0131m\u0131za ba\u011fland\u0131ktan sonra query sorgusuna a\u015fa\u011f\u0131daki sorguyu yazarak msql versiyon bilgilerini \u00f6\u011frenebilirsiniz.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSHOW VARIABLES LIKE &quot;%version%&quot;;\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">PHP ile MySQL S\u00fcr\u00fcm\u00fcn\u00fc \u00d6\u011frenme<\/h3>\n\n\n\n<p>A\u015fa\u011f\u0131daki PHP beti\u011fine mysql kullan\u0131c\u0131 ad\u0131 ve mysql \u015fifrenizi girip, mysql.php ismi ile FTP \u00fczerinden upload edip, dosyay\u0131 \u00e7a\u011f\u0131r\u0131n;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&lt;?php\n$db = new PDO('mysql:host=localhost', 'KULLANICI_ADI', '\u015e\u0130FRE');\n$version = $db-&gt;query('SHOW VARIABLES LIKE \\'version\\'')-&gt;fetch(PDO::FETCH_ASSOC);\necho $version&#x5B;'Value']; \/\/ \u00d6rnek \u00e7\u0131kt\u0131: 10.4.11-MariaDB\n?&gt;\n<\/pre><\/div>\n\n\n<p>Dosyay\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda mysql versiyonu \u00e7\u0131kt\u0131s\u0131n\u0131 ekrana basacakt\u0131r.<br>Ben bilgisayar\u0131mda localde \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131mda ekrandaki \u00e7\u0131kt\u0131 bu \u015fekilde oldu : 10.4.11-MariaDB<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><br><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>MySQL, d\u00fcnya genelinde en pop\u00fcler a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemlerinden biridir. \u0130lk olarak 1995 y\u0131l\u0131nda Michael Widenius ve David Axmark taraf\u0131ndan geli\u015ftirilmeye ba\u015flanm\u0131\u015ft\u0131r. MySQL, web tabanl\u0131 uygulamalar, veri depolama, e-ticaret, ve log kay\u0131tlar\u0131 gibi bir\u00e7ok alanda tercih edilen bir veritaban\u0131 y\u00f6netim sistemidir.<\/p>\n","protected":false},"author":1,"featured_media":472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,32,23],"tags":[34],"class_list":["post-471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-veritabani","category-yazilim","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/posts\/471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/comments?post=471"}],"version-history":[{"count":3,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/posts\/471\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/posts\/471\/revisions\/507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/media\/472"}],"wp:attachment":[{"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/media?parent=471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/categories?post=471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.metinpolat.net\/blog\/wp-json\/wp\/v2\/tags?post=471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}