{"id":31684,"date":"2025-10-12T20:41:04","date_gmt":"2025-10-12T17:41:04","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=31684"},"modified":"2025-10-12T20:41:04","modified_gmt":"2025-10-12T17:41:04","slug":"proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/","title":{"rendered":"ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma"},"content":{"rendered":"<p><body><\/p>\n<h2>ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma<\/h2>\n<p>MySQL veritaban\u0131, modern web uygulamalar\u0131n\u0131n ve kurumsal sistemlerin belkemi\u011fini olu\u015fturan g\u00fc\u00e7l\u00fc ve esnek bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. Ancak, uygulaman\u0131n kullan\u0131c\u0131 say\u0131s\u0131 artt\u0131k\u00e7a ve veri hacmi b\u00fcy\u00fcd\u00fck\u00e7e, tek bir MySQL sunucusunun performans\u0131 ve kullan\u0131labilirli\u011fi yetersiz kalabilir. Bu noktada, veritaban\u0131 mimarisini \u00f6l\u00e7eklendirmek ve y\u00fcksek eri\u015filebilirli\u011fi sa\u011flamak kritik hale gelir. Y\u00fck dengeleme, sorgu y\u00f6nlendirme ve otomatik hata tolerans\u0131 (failover) gibi \u00f6zellikler, bu zorluklar\u0131n \u00fcstesinden gelmek i\u00e7in vazge\u00e7ilmezdir. \u0130\u015fte tam da bu ihtiya\u00e7lara cevap veren g\u00fc\u00e7l\u00fc bir ara\u00e7 olan ProxySQL devreye girer.<\/p>\n<p>Bu makalede, ProxySQL&#8217;in ne oldu\u011funu, neden MySQL ile birlikte kullan\u0131lmas\u0131 gerekti\u011fini ve \u00f6zellikle Ubuntu 16.04 i\u015fletim sistemi \u00fczerinde nas\u0131l kurulup yap\u0131land\u0131r\u0131laca\u011f\u0131n\u0131 ad\u0131m ad\u0131m inceleyece\u011fiz. Amac\u0131m\u0131z, uygulamalar\u0131n\u0131z\u0131n MySQL veritabanlar\u0131na daha verimli, g\u00fcvenli ve kesintisiz bir \u015fekilde eri\u015fmesini sa\u011flamak i\u00e7in ProxySQL&#8217;i bir y\u00fck dengeleyici olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 g\u00f6stermektir.<\/p>\n<h3>ProxySQL Nedir?<\/h3>\n<p>ProxySQL, y\u00fcksek performansl\u0131, a\u00e7\u0131k kaynakl\u0131, hafif ve tamamen \u015feffaf bir MySQL proxy&#8217;sidir. C++ ile yaz\u0131lm\u0131\u015f olup, MySQL istemcileri ile MySQL sunucular\u0131 aras\u0131nda oturur ve t\u00fcm a\u011f trafi\u011fini dinler. Bu konumland\u0131rma sayesinde, ProxySQL gelen sorgular\u0131 analiz edebilir, y\u00f6nlendirebilir, de\u011fi\u015ftirebilir, \u00f6nbelle\u011fe alabilir ve hatta arka u\u00e7 MySQL sunucular\u0131n\u0131n sa\u011fl\u0131\u011f\u0131n\u0131 izleyebilir.<\/p>\n<p>ProxySQL&#8217;in temel amac\u0131, MySQL altyap\u0131s\u0131n\u0131n \u00f6l\u00e7eklenebilirli\u011fini, performans\u0131n\u0131 ve y\u00fcksek eri\u015filebilirli\u011fini art\u0131rmakt\u0131r. Bir uygulama, do\u011frudan MySQL sunucusuna ba\u011flanmak yerine ProxySQL&#8217;e ba\u011flan\u0131r. ProxySQL, uygulaman\u0131n isteklerini al\u0131r, yap\u0131land\u0131r\u0131lm\u0131\u015f kurallara g\u00f6re i\u015fler ve uygun arka u\u00e7 MySQL sunucusuna y\u00f6nlendirir.<\/p>\n<h4>ProxySQL&#8217;in Temel \u00d6zellikleri:<\/h4>\n<p>*   <strong>Sorgu Y\u00f6nlendirme (Query Routing):<\/strong> Okuma (SELECT) sorgular\u0131n\u0131 \u00e7o\u011falt\u0131lm\u0131\u015f (replica\/slave) sunuculara, yazma (INSERT, UPDATE, DELETE) sorgular\u0131n\u0131 ise ana (master) sunucuya y\u00f6nlendirme yetene\u011fi. Bu, ana sunucunun y\u00fck\u00fcn\u00fc hafifletir ve okuma kapasitesini art\u0131r\u0131r.<br \/>\n*   <strong>Y\u00fck Dengeleme (Load Balancing):<\/strong> Birden fazla arka u\u00e7 sunucu aras\u0131nda sorgular\u0131 da\u011f\u0131tmak i\u00e7in Round-Robin, Least Connections gibi farkl\u0131 algoritmalar sunar.<br \/>\n*   <strong>Ba\u011flant\u0131 Havuzlama (Connection Pooling):<\/strong> Uygulamalar\u0131n her sorgu i\u00e7in yeni bir ba\u011flant\u0131 a\u00e7mas\u0131n\u0131 engeller. Mevcut ba\u011flant\u0131lar\u0131 yeniden kullanarak performans art\u0131\u015f\u0131 sa\u011flar ve MySQL sunucular\u0131ndaki ba\u011flant\u0131 y\u00fck\u00fcn\u00fc azalt\u0131r.<br \/>\n*   <strong>Otomatik Hata Tolerans\u0131 (Automatic Failover):<\/strong> Arka u\u00e7 MySQL sunucular\u0131n\u0131n sa\u011fl\u0131\u011f\u0131n\u0131 s\u00fcrekli izler. Bir sunucu \u00e7evrimd\u0131\u015f\u0131 oldu\u011funda veya yan\u0131t vermedi\u011finde, ProxySQL otomatik olarak o sunucuyu havuzdan \u00e7\u0131kar\u0131r ve sorgular\u0131 sa\u011fl\u0131kl\u0131 sunuculara y\u00f6nlendirir. Sunucu tekrar \u00e7evrimi\u00e7i oldu\u011funda otomatik olarak havuza geri ekler.<br \/>\n*   <strong>Sorgu \u00d6nbellekleme (Query Caching):<\/strong> Belirli sorgular\u0131n sonu\u00e7lar\u0131n\u0131 ProxySQL i\u00e7inde \u00f6nbelle\u011fe alarak, ayn\u0131 sorgular tekrar geldi\u011finde do\u011frudan \u00f6nbellekten yan\u0131t verebilir. Bu, veritaban\u0131 sunucusunun y\u00fck\u00fcn\u00fc \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r ve yan\u0131t s\u00fcrelerini h\u0131zland\u0131r\u0131r.<br \/>\n*   <strong>Sorgu Yeniden Yazma\/Filtreleme (Query Rewriting\/Filtering):<\/strong> Gelen sorgular\u0131 belirli kurallara g\u00f6re de\u011fi\u015ftirebilir veya istenmeyen sorgular\u0131 engelleyebilir. G\u00fcvenlik ve performans optimizasyonu i\u00e7in kullan\u0131labilir.<br \/>\n*   <strong>\u00c7al\u0131\u015fma Zaman\u0131 Yap\u0131land\u0131rmas\u0131 (Runtime Configuration):<\/strong> T\u00fcm yap\u0131land\u0131rma de\u011fi\u015fiklikleri, ProxySQL&#8217;i yeniden ba\u015flatmaya gerek kalmadan \u00e7al\u0131\u015fma zaman\u0131nda uygulanabilir. Bu, kesintisiz operasyon sa\u011flar.<br \/>\n*   <strong>\u0130zleme ve \u0130statistikler (Monitoring and Statistics):<\/strong> Ba\u011flant\u0131lar, sorgular, arka u\u00e7 sunucu durumu ve kural e\u015fle\u015fmeleri hakk\u0131nda detayl\u0131 istatistikler sunar. Bu veriler, performans sorunlar\u0131n\u0131 te\u015fhis etmek ve optimizasyon yapmak i\u00e7in kullan\u0131labilir.<\/p>\n<h3>Neden ProxySQL MySQL ile Kullan\u0131lmal\u0131?<\/h3>\n<p>ProxySQL&#8217;in MySQL altyap\u0131n\u0131za entegre edilmesi, tek bir sunucunun veya basit bir master-slave kurulumunun \u00f6tesinde bir\u00e7ok avantaj sunar:<\/p>\n<p>*   <strong>\u00d6l\u00e7eklenebilirlik:<\/strong> Uygulaman\u0131z\u0131n trafik y\u00fck\u00fc artt\u0131\u011f\u0131nda, yeni okuma replikalar\u0131 eklemek ve ProxySQL&#8217;i bunlar\u0131 kullanacak \u015fekilde yap\u0131land\u0131rmak \u00e7ok kolayd\u0131r. Bu, uygulaman\u0131n genel okuma kapasitesini art\u0131r\u0131r. Yazma i\u015flemleri i\u00e7in de master-master veya sharding gibi daha karma\u015f\u0131k mimarilere ge\u00e7i\u015fte ProxySQL esneklik sa\u011flar.<br \/>\n*   <strong>Y\u00fcksek Eri\u015filebilirlik (High Availability):<\/strong> ProxySQL, arka u\u00e7 MySQL sunucular\u0131n\u0131n durumunu s\u00fcrekli izler. Bir ana sunucu \u00e7\u00f6kt\u00fc\u011f\u00fcnde veya bir replika sunucuyla ba\u011flant\u0131 kesildi\u011finde, ProxySQL otomatik olarak bu sunucuyu istek havuzundan \u00e7\u0131kar\u0131r ve sorgular\u0131 di\u011fer sa\u011fl\u0131kl\u0131 sunuculara y\u00f6nlendirir. Bu, uygulama kesintilerini en aza indirir.<br \/>\n*   <strong>Performans \u0130yile\u015ftirmeleri:<\/strong><br \/>\n    *   <strong>Ba\u011flant\u0131 Havuzlama:<\/strong> Uygulama taraf\u0131ndan a\u00e7\u0131lan ve kapanan ba\u011flant\u0131 say\u0131s\u0131n\u0131 azaltarak MySQL sunucular\u0131n\u0131n kaynak t\u00fcketimini d\u00fc\u015f\u00fcr\u00fcr.<br \/>\n    *   <strong>Sorgu Y\u00f6nlendirme:<\/strong> Okuma y\u00fck\u00fcn\u00fc replikalara da\u011f\u0131tarak ana sunucunun sadece yazma i\u015flemlerine odaklanmas\u0131n\u0131 sa\u011flar, bu da genel performans\u0131 art\u0131r\u0131r.<br \/>\n    *   <strong>Sorgu \u00d6nbellekleme:<\/strong> S\u0131k tekrar eden sorgular i\u00e7in veritaban\u0131na gitmeye gerek kalmadan h\u0131zl\u0131 yan\u0131tlar sunar.<br \/>\n*   <strong>Basitle\u015ftirilmi\u015f Uygulama Mimarisi:<\/strong> Uygulamalar, birden fazla MySQL sunucusunun karma\u015f\u0131k topolojisini bilmek zorunda kalmaz. Her zaman tek bir ProxySQL IP adresine ve portuna ba\u011flan\u0131r. Bu, uygulama kodunu basitle\u015ftirir ve bak\u0131m maliyetlerini d\u00fc\u015f\u00fcr\u00fcr.<br \/>\n*   <strong>Geli\u015fmi\u015f G\u00fcvenlik ve Kontrol:<\/strong> ProxySQL, istenmeyen sorgular\u0131 engelleyebilir veya belirli kullan\u0131c\u0131lar\u0131n belirli veritabanlar\u0131na eri\u015fimini k\u0131s\u0131tlayabilir. Ayr\u0131ca, arka u\u00e7 MySQL sunucular\u0131n\u0131n IP adreslerini ve portlar\u0131n\u0131 uygulamalardan gizleyerek g\u00fcvenlik katman\u0131 ekler.<br \/>\n*   <strong>Dinamik Yap\u0131land\u0131rma:<\/strong> \u00c7al\u0131\u015fma zaman\u0131nda yap\u0131lan de\u011fi\u015fiklikler sayesinde, altyap\u0131n\u0131zda kesinti olmadan sunucu ekleyip \u00e7\u0131karabilir, kurallar\u0131 de\u011fi\u015ftirebilir veya performans ayarlar\u0131n\u0131 yapabilirsiniz.<\/p>\n<p>Bu avantajlar, ProxySQL&#8217;i modern MySQL da\u011f\u0131t\u0131mlar\u0131 i\u00e7in vazge\u00e7ilmez bir bile\u015fen haline getirir.<\/p>\n<h3>\u00d6n Gereksinimler<\/h3>\n<p>ProxySQL kurulumuna ba\u015flamadan \u00f6nce, a\u015fa\u011f\u0131daki \u00f6n gereksinimlerin kar\u015f\u0131land\u0131\u011f\u0131ndan emin olmal\u0131s\u0131n\u0131z:<\/p>\n<p>*   <strong>\u0130\u015fletim Sistemi:<\/strong> Ubuntu 16.04 sunucusu (ProxySQL&#8217;i kuraca\u011f\u0131m\u0131z sunucu). Bu makale spesifik olarak Ubuntu 16.04&#8217;\u00fc hedeflemektedir.<br \/>\n*   <strong>MySQL Sunucular\u0131:<\/strong> En az iki adet MySQL sunucusu. Tipik bir kurulumda bir adet ana (master) MySQL sunucusu ve bir veya daha fazla \u00e7o\u011falt\u0131lm\u0131\u015f (replica\/slave) MySQL sunucusu olacakt\u0131r. Bu sunucular aras\u0131nda MySQL replikasyonu aktif ve sa\u011fl\u0131kl\u0131 olmal\u0131d\u0131r.<br \/>\n    *   \u00d6rnek IP Adresleri:<br \/>\n        *   MySQL Master: <code>192.168.1.10<\/code><br \/>\n        *   MySQL Slave: <code>192.168.1.11<\/code><br \/>\n        *   ProxySQL Sunucusu: <code>192.168.1.12<\/code><br \/>\n*   <strong>A\u011f Ba\u011flant\u0131s\u0131:<\/strong> ProxySQL sunucusu ile t\u00fcm MySQL sunucular\u0131 aras\u0131nda a\u011f ba\u011flant\u0131s\u0131 olmal\u0131d\u0131r. Gerekirse g\u00fcvenlik duvar\u0131 (firewall) kurallar\u0131n\u0131 ayarlay\u0131n (MySQL i\u00e7in varsay\u0131lan port 3306).<br \/>\n*   <strong>Yetkilendirme:<\/strong> Kurulum ve yap\u0131land\u0131rma i\u015flemleri i\u00e7in <code>root<\/code> veya <code>sudo<\/code> yetkilerine sahip bir kullan\u0131c\u0131.<br \/>\n*   <strong>Temel Bilgiler:<\/strong> Linux komut sat\u0131r\u0131, MySQL y\u00f6netimi ve a\u011f kavramlar\u0131 hakk\u0131nda temel bilgi.<\/p>\n<h3>Ubuntu 16.04 \u00dczerine ProxySQL Kurulumu<\/h3>\n<p>ProxySQL&#8217;i Ubuntu 16.04 \u00fczerine kurmak olduk\u00e7a basittir. ProxySQL, kendi resmi APT deposunu sa\u011flar, bu da kurulumu kolayla\u015ft\u0131r\u0131r.<\/p>\n<p>1.  <strong>Sistem G\u00fcncellemesi:<\/strong><br \/>\n    \u00d6ncelikle, sistem paket listesini g\u00fcncelleyelim ve mevcut paketleri y\u00fckseltelim:<\/p>\n<pre><code class=\"language-bash\">sudo apt update\n    sudo apt upgrade -y<\/code><\/pre>\n<p>2.  <strong>ProxySQL APT Deposunu Ekleme:<\/strong><br \/>\n    ProxySQL&#8217;in APT deposunu sisteminize eklemeniz gerekir. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 kullan\u0131n:<\/p>\n<pre><code class=\"language-bash\">sudo apt-get install -y lsb-release curl\n    curl -sS https:\/\/repo.proxysql.com\/ProxySQL\/proxysql-2.0.x\/repo_pub_key | sudo apt-key add -\n    echo \"deb https:\/\/repo.proxysql.com\/ProxySQL\/proxysql-2.0.x\/$(lsb_release -sc)\/ .\/\" | sudo tee \/etc\/apt\/sources.list.d\/proxysql.list<\/code><\/pre>\n<p>    <em>Not: Yukar\u0131daki komutlar ProxySQL 2.0.x serisi i\u00e7in ge\u00e7erlidir. E\u011fer daha yeni bir s\u00fcr\u00fcm kurmak isterseniz, <code>proxysql-2.0.x<\/code> k\u0131sm\u0131n\u0131 ilgili s\u00fcr\u00fcmle (\u00f6rn. <code>proxysql-2.x<\/code>) de\u011fi\u015ftirmeniz gerekebilir. Ancak Ubuntu 16.04 genellikle daha eski s\u00fcr\u00fcmlerle daha iyi uyumluluk g\u00f6sterebilir.<\/em><\/p>\n<p>3.  <strong>ProxySQL Kurulumu:<\/strong><br \/>\n    Depoyu ekledikten sonra, paket listesini tekrar g\u00fcncelleyin ve ProxySQL&#8217;i kurun:<\/p>\n<pre><code class=\"language-bash\">sudo apt update\n    sudo apt install proxysql -y<\/code><\/pre>\n<p>4.  <strong>Kurulumu Do\u011frulama ve Servis Durumu:<\/strong><br \/>\n    Kurulum tamamland\u0131ktan sonra, ProxySQL servisinin durumunu kontrol edebilirsiniz:<\/p>\n<pre><code class=\"language-bash\">sudo systemctl status proxysql<\/code><\/pre>\n<p>    Servis \u00e7al\u0131\u015fm\u0131yorsa, ba\u015flatmak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">sudo systemctl start proxysql<\/code><\/pre>\n<p>    Sistemin ba\u015flang\u0131c\u0131nda otomatik olarak ba\u015flamas\u0131n\u0131 sa\u011flamak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">sudo systemctl enable proxysql<\/code><\/pre>\n<p>ProxySQL varsay\u0131lan olarak 6032 portunda y\u00f6netim aray\u00fcz\u00fcn\u00fc (admin interface) ve 6033 portunda uygulama ba\u011flant\u0131lar\u0131n\u0131 (client interface) dinler.<\/p>\n<h3>ProxySQL Temel Yap\u0131land\u0131rmas\u0131<\/h3>\n<p>ProxySQL&#8217;in yap\u0131land\u0131rmas\u0131, \u00f6zel bir MySQL istemcisi arac\u0131l\u0131\u011f\u0131yla yap\u0131lan SQL komutlar\u0131 ile ger\u00e7ekle\u015ftirilir. ProxySQL&#8217;in kendi i\u00e7 veritaban\u0131 vard\u0131r ve t\u00fcm yap\u0131land\u0131rma bu veritaban\u0131ndaki tablolar arac\u0131l\u0131\u011f\u0131yla y\u00f6netilir.<\/p>\n<p>1.  <strong>ProxySQL Y\u00f6netim Aray\u00fcz\u00fcne Ba\u011flanma:<\/strong><br \/>\n    ProxySQL y\u00f6netim aray\u00fcz\u00fcne, herhangi bir MySQL istemcisi (\u00f6rne\u011fin <code>mysql<\/code> komut sat\u0131r\u0131 arac\u0131) ile ba\u011flanabilirsiniz. Varsay\u0131lan kullan\u0131c\u0131 <code>admin<\/code> ve \u015fifre <code>admin<\/code>&#8216;dir.<\/p>\n<pre><code class=\"language-bash\">mysql -u admin -padmin -h 127.0.0.1 -P 6032<\/code><\/pre>\n<p>    Ba\u011fland\u0131ktan sonra, <code>ProxySQL><\/code> komut istemini g\u00f6rmelisiniz.<\/p>\n<p>2.  <strong>Yap\u0131land\u0131rma Tablolar\u0131na Genel Bak\u0131\u015f:<\/strong><br \/>\n    ProxySQL&#8217;in temel yap\u0131land\u0131rmas\u0131 \u00fc\u00e7 ana tablo etraf\u0131nda d\u00f6ner:<br \/>\n    *   <code>mysql_users<\/code>: ProxySQL&#8217;e ba\u011flanacak uygulama kullan\u0131c\u0131lar\u0131n\u0131 ve ProxySQL&#8217;in arka u\u00e7 MySQL sunucular\u0131na ba\u011flanmak i\u00e7in kullanaca\u011f\u0131 kullan\u0131c\u0131lar\u0131 tan\u0131mlar.<br \/>\n    *   <code>mysql_servers<\/code>: Arka u\u00e7 MySQL sunucular\u0131n\u0131 (master ve slave&#8217;ler) tan\u0131mlar ve onlar\u0131 &#8220;hostgroup&#8221; ad\u0131 verilen mant\u0131ksal gruplara ay\u0131r\u0131r.<br \/>\n    *   <code>mysql_query_rules<\/code>: Gelen sorgular\u0131n hangi arka u\u00e7 sunucu grubuna y\u00f6nlendirilece\u011fini belirleyen kurallar\u0131 tan\u0131mlar.<\/p>\n<p>3.  <strong>Yap\u0131land\u0131rma De\u011fi\u015fikliklerinin Y\u00f6netimi:<\/strong><br \/>\n    ProxySQL&#8217;de yap\u0131lan de\u011fi\u015fiklikler an\u0131nda etkin olmaz. De\u011fi\u015fiklikler \u00f6nce &#8220;disk&#8221; \u00fczerindeki yap\u0131land\u0131rmaya (<code>proxysql.cnf<\/code> dosyas\u0131na) yaz\u0131l\u0131r, ard\u0131ndan &#8220;runtime&#8221; (\u00e7al\u0131\u015fan bellek) \u00fczerine y\u00fcklenerek aktif hale getirilir.<br \/>\n    *   <strong>Yap\u0131land\u0131rmay\u0131 Disk&#8217;e Kaydetme:<\/strong><br \/>\n        <code>SAVE MYSQL USERS TO DISK;<\/code><br \/>\n        <code>SAVE MYSQL SERVERS TO DISK;<\/code><br \/>\n        <code>SAVE MYSQL QUERY RULES TO DISK;<\/code><br \/>\n        <code>SAVE MONITORING TO DISK;<\/code><br \/>\n        <code>SAVE GLOBAL VARIABLES TO DISK;<\/code><br \/>\n    *   <strong>Yap\u0131land\u0131rmay\u0131 \u00c7al\u0131\u015fma Zaman\u0131na Y\u00fckleme (Aktif Etme):<\/strong><br \/>\n        <code>LOAD MYSQL USERS TO RUNTIME;<\/code><br \/>\n        <code>LOAD MYSQL SERVERS TO RUNTIME;<\/code><br \/>\n        <code>LOAD MYSQL QUERY RULES TO RUNTIME;<\/code><br \/>\n        <code>LOAD MONITORING TO RUNTIME;<\/code><br \/>\n        <code>LOAD GLOBAL VARIABLES TO RUNTIME;<\/code><br \/>\n    Genellikle, de\u011fi\u015fiklikleri \u00f6nce <code>runtime<\/code>&#8216;a y\u00fckleyip test ettikten sonra <code>disk<\/code>&#8216;e kaydetmek en iyi uygulamad\u0131r.<\/p>\n<h3>Ad\u0131m Ad\u0131m Yap\u0131land\u0131rma \u00d6rne\u011fi: Master-Slave Y\u00fck Dengeleme<\/h3>\n<p>Bu b\u00f6l\u00fcmde, bir Master-Slave MySQL replikasyon kurulumunu ProxySQL kullanarak nas\u0131l y\u00fck dengeleyece\u011fimizi ad\u0131m ad\u0131m g\u00f6sterece\u011fiz.<\/p>\n<p><strong>Senaryo:<\/strong><br \/>\n*   <strong>MySQL Master:<\/strong> <code>192.168.1.10<\/code> (Yazma i\u015flemleri i\u00e7in Hostgroup 10)<br \/>\n*   <strong>MySQL Slave:<\/strong> <code>192.168.1.11<\/code> (Okuma i\u015flemleri i\u00e7in Hostgroup 20)<br \/>\n*   <strong>ProxySQL:<\/strong> <code>192.168.1.12<\/code><\/p>\n<h4>1. MySQL Backend Kullan\u0131c\u0131lar\u0131n\u0131 Olu\u015fturma<\/h4>\n<p>\u00d6ncelikle, ProxySQL&#8217;in arka u\u00e7 MySQL sunucular\u0131na ba\u011flanabilmesi i\u00e7in her MySQL sunucusunda (hem master hem de slave) bir kullan\u0131c\u0131 olu\u015fturmal\u0131y\u0131z. Bu kullan\u0131c\u0131, ProxySQL&#8217;in sunucular\u0131n sa\u011fl\u0131\u011f\u0131n\u0131 izlemesi ve sorgular\u0131 y\u00f6nlendirmesi i\u00e7in gerekli yetkilere sahip olmal\u0131d\u0131r.<\/p>\n<p>MySQL Master (<code>192.168.1.10<\/code>) ve MySQL Slave (<code>192.168.1.11<\/code>) sunucular\u0131na ayr\u0131 ayr\u0131 ba\u011flan\u0131n ve a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre><code class=\"language-sql\">-- ProxySQL'in sunucular\u0131 izlemesi i\u00e7in kullan\u0131c\u0131\nCREATE USER 'proxysql_monitor'@'192.168.1.12' IDENTIFIED BY 'monitor_password';\nGRANT USAGE ON <em>.<\/em> TO 'proxysql_monitor'@'192.168.1.12';\nGRANT SELECT ON sys.* TO 'proxysql_monitor'@'192.168.1.12'; -- MySQL 5.7+ i\u00e7in gerekli olabilir\nGRANT REPLICATION CLIENT ON <em>.<\/em> TO 'proxysql_monitor'@'192.168.1.12'; -- Replikasyon durumunu izlemek i\u00e7in\n\n-- ProxySQL'in arka u\u00e7lara ba\u011flan\u0131p sorgu y\u00f6nlendirmesi i\u00e7in kullan\u0131c\u0131\nCREATE USER 'proxysql_backend_user'@'192.168.1.12' IDENTIFIED BY 'backend_password';\nGRANT ALL PRIVILEGES ON your_database.* TO 'proxysql_backend_user'@'192.168.1.12'; -- Uygulaman\u0131z\u0131n kullanaca\u011f\u0131 veritaban\u0131 \u00fczerinde gerekli yetkiler\nFLUSH PRIVILEGES;<\/code><\/pre>\n<p><em><code>192.168.1.12<\/code> yerine ProxySQL sunucunuzun IP adresini yazmay\u0131 unutmay\u0131n. <code>your_database<\/code> yerine uygulaman\u0131z\u0131n kulland\u0131\u011f\u0131 veritaban\u0131 ad\u0131n\u0131 yaz\u0131n.<\/em><\/p>\n<h4>2. ProxySQL Kullan\u0131c\u0131lar\u0131n\u0131 Yap\u0131land\u0131rma<\/h4>\n<p>\u015eimdi ProxySQL y\u00f6netim aray\u00fcz\u00fcne ba\u011flanarak (<code>mysql -u admin -padmin -h 127.0.0.1 -P 6032<\/code>), <code>mysql_users<\/code> tablosunu yap\u0131land\u0131ral\u0131m. Bu tabloda iki t\u00fcr kullan\u0131c\u0131 tan\u0131mlayaca\u011f\u0131z:<br \/>\n*   ProxySQL&#8217;in arka u\u00e7 MySQL sunucular\u0131na ba\u011flanmak i\u00e7in kullanaca\u011f\u0131 kullan\u0131c\u0131 (<code>proxysql_backend_user<\/code>).<br \/>\n*   Uygulamalar\u0131n ProxySQL&#8217;e ba\u011flanmak i\u00e7in kullanaca\u011f\u0131 kullan\u0131c\u0131 (\u00f6rne\u011fin <code>app_user<\/code>).<\/p>\n<pre><code class=\"language-sql\">-- ProxySQL'in arka u\u00e7 MySQL sunucular\u0131na ba\u011flanmak i\u00e7in kullanaca\u011f\u0131 kullan\u0131c\u0131y\u0131 ekle\nINSERT INTO mysql_users (username, password, default_hostgroup, active, backend) VALUES ('proxysql_backend_user', 'backend_password', 0, 1, 1);\n\n-- Uygulamalar\u0131n ProxySQL'e ba\u011flanmak i\u00e7in kullanaca\u011f\u0131 kullan\u0131c\u0131y\u0131 ekle\n-- Bu kullan\u0131c\u0131, sorgu y\u00f6nlendirme kurallar\u0131na g\u00f6re do\u011fru hostgroup'a y\u00f6nlendirilecektir.\nINSERT INTO mysql_users (username, password, default_hostgroup, active, backend) VALUES ('app_user', 'app_password', 0, 1, 0);\n\n-- De\u011fi\u015fiklikleri \u00e7al\u0131\u015fma zaman\u0131na y\u00fckle ve diske kaydet\nLOAD MYSQL USERS TO RUNTIME;\nSAVE MYSQL USERS TO DISK;<\/code><\/pre>\n<h4>3. MySQL Backend Sunucular\u0131n\u0131 Tan\u0131mlama<\/h4>\n<p><code>mysql_servers<\/code> tablosuna Master ve Slave sunucular\u0131m\u0131z\u0131 ekleyece\u011fiz. Master sunucuyu yazma i\u015flemleri i\u00e7in Hostgroup 10&#8217;a, Slave sunucuyu ise okuma i\u015flemleri i\u00e7in Hostgroup 20&#8217;ye atayaca\u011f\u0131z.<\/p>\n<pre><code class=\"language-sql\">-- Master sunucuyu (yazma i\u015flemleri i\u00e7in) Hostgroup 10'a ekle\nINSERT INTO mysql_servers (hostgroup_id, hostname, port) VALUES (10, '192.168.1.10', 3306);\n\n-- Slave sunucuyu (okuma i\u015flemleri i\u00e7in) Hostgroup 20'ye ekle\nINSERT INTO mysql_servers (hostgroup_id, hostname, port) VALUES (20, '192.168.1.11', 3306);\n\n-- De\u011fi\u015fiklikleri \u00e7al\u0131\u015fma zaman\u0131na y\u00fckle ve diske kaydet\nLOAD MYSQL SERVERS TO RUNTIME;\nSAVE MYSQL SERVERS TO DISK;<\/code><\/pre>\n<p><strong>\u00d6nemli:<\/strong> ProxySQL, arka u\u00e7 sunucular\u0131n\u0131n sa\u011fl\u0131\u011f\u0131n\u0131 izlemek i\u00e7in <code>monitor<\/code> mod\u00fcl\u00fcn\u00fc kullan\u0131r. Bu mod\u00fcl\u00fcn do\u011fru yap\u0131land\u0131r\u0131lmas\u0131 gerekir.<br \/>\nVarsay\u0131lan olarak, ProxySQL <code>mysql_servers<\/code> tablosuna eklenen sunucular\u0131 izlemek i\u00e7in <code>monitor<\/code> mod\u00fcl\u00fcn\u00fc kullan\u0131r. <code>mysql_servers<\/code> tablosuna eklenen sunuculara <code>proxysql_monitor<\/code> kullan\u0131c\u0131s\u0131 ile ba\u011flanarak replikasyon durumunu kontrol eder.<br \/>\nE\u011fer monitor mod\u00fcl\u00fc i\u00e7in \u00f6zel bir kullan\u0131c\u0131 tan\u0131mlamak isterseniz, <code>mysql_monitor_username<\/code> ve <code>mysql_monitor_password<\/code> global de\u011fi\u015fkenlerini ayarlayabilirsiniz:<\/p>\n<pre><code class=\"language-sql\">UPDATE global_variables SET variable_value='proxysql_monitor' WHERE variable_name='mysql-monitor_username';\nUPDATE global_variables SET variable_value='monitor_password' WHERE variable_name='mysql-monitor_password';\nLOAD GLOBAL VARIABLES TO RUNTIME;\nSAVE GLOBAL VARIABLES TO DISK;<\/code><\/pre>\n<h4>4. Sorgu Y\u00f6nlendirme Kurallar\u0131 Olu\u015fturma<\/h4>\n<p><code>mysql_query_rules<\/code> tablosu, gelen sorgular\u0131 analiz etmek ve onlar\u0131 do\u011fru hostgroup&#8217;a y\u00f6nlendirmek i\u00e7in kullan\u0131l\u0131r. <code>regex<\/code> (d\u00fczenli ifade) kullanarak sorgu desenlerini e\u015fle\u015ftirebiliriz.<\/p>\n<pre><code class=\"language-sql\">-- T\u00fcm SELECT sorgular\u0131n\u0131 Hostgroup 20'ye (Slave) y\u00f6nlendir\nINSERT INTO mysql_query_rules (rule_id, active, match_digest, destination_hostgroup, apply) VALUES (10, 1, '^SELECT', 20, 1);\n\n-- T\u00fcm INSERT, UPDATE, DELETE sorgular\u0131n\u0131 Hostgroup 10'a (Master) y\u00f6nlendir\nINSERT INTO mysql_query_rules (rule_id, active, match_digest, destination_hostgroup, apply) VALUES (20, 1, '^(INSERT|UPDATE|DELETE)', 10, 1);\n\n-- De\u011fi\u015fiklikleri \u00e7al\u0131\u015fma zaman\u0131na y\u00fckle ve diske kaydet\nLOAD MYSQL QUERY RULES TO RUNTIME;\nSAVE MYSQL QUERY RULES TO DISK;<\/code><\/pre>\n<p><em><code>rule_id<\/code> de\u011feri benzersiz olmal\u0131d\u0131r ve kurallar <code>rule_id<\/code>&#8216;ye g\u00f6re artan s\u0131rada de\u011ferlendirilir. <code>apply=1<\/code> kural e\u015fle\u015fti\u011finde ba\u015fka kural uygulanmamas\u0131n\u0131 sa\u011flar.<\/em><\/p>\n<h4>5. Global De\u011fi\u015fkenleri Yap\u0131land\u0131rma (\u0130ste\u011fe Ba\u011fl\u0131 ama \u00d6nemli)<\/h4>\n<p>ProxySQL&#8217;in davran\u0131\u015f\u0131n\u0131 etkileyen baz\u0131 global de\u011fi\u015fkenler vard\u0131r. \u00d6rne\u011fin, client aray\u00fcz\u00fc portu, admin aray\u00fcz\u00fc portu vb. Varsay\u0131lan de\u011ferler genellikle yeterli olsa da, ihtiyaca g\u00f6re de\u011fi\u015ftirebilirsiniz.<\/p>\n<pre><code class=\"language-sql\">-- Client aray\u00fcz portunu kontrol etmek (varsay\u0131lan 6033)\nSELECT variable_value FROM global_variables WHERE variable_name='mysql-client_port';\n\n-- Admin aray\u00fcz portunu kontrol etmek (varsay\u0131lan 6032)\nSELECT variable_value FROM global_variables WHERE variable_name='mysql-admin_port';\n\n-- De\u011fi\u015fiklik yapmak i\u00e7in (\u00f6rne\u011fin client portunu 3306 yapmak)\n-- UPDATE global_variables SET variable_value='3306' WHERE variable_name='mysql-client_port';\n-- LOAD GLOBAL VARIABLES TO RUNTIME;\n-- SAVE GLOBAL VARIABLES TO DISK;<\/code><\/pre>\n<p><em>E\u011fer <code>mysql-client_port<\/code>&#8216;u 3306 yaparsan\u0131z, ProxySQL&#8217;i 3306 portunda dinleyecektir ve uygulamalar\u0131n\u0131z\u0131n do\u011frudan MySQL sunucular\u0131na ba\u011flan\u0131yormu\u015f gibi hissetmesini sa\u011flayacakt\u0131r. Ancak bu durumda, ProxySQL sunucusunda ba\u015fka bir MySQL sunucusu \u00e7al\u0131\u015fm\u0131yor olmal\u0131d\u0131r.<\/em><\/p>\n<h3>Kurulumu Test Etme<\/h3>\n<p>T\u00fcm yap\u0131land\u0131rmalar\u0131 yapt\u0131ktan sonra, kurulumun d\u00fczg\u00fcn \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulamak \u00f6nemlidir.<\/p>\n<p>1.  <strong>Uygulama Ba\u011flant\u0131s\u0131:<\/strong><br \/>\n    Uygulaman\u0131zdan veya basit bir MySQL istemcisinden, <code>app_user<\/code> kullan\u0131c\u0131s\u0131 ile ProxySQL sunucusuna (IP: <code>192.168.1.12<\/code>, Port: <code>6033<\/code>) ba\u011flan\u0131n.<\/p>\n<pre><code class=\"language-bash\">mysql -u app_user -papp_password -h 192.168.1.12 -P 6033<\/code><\/pre>\n<p>2.  <strong>Okuma ve Yazma \u0130\u015flemlerini Test Etme:<\/strong><br \/>\n    Ba\u011fland\u0131ktan sonra, veritaban\u0131n\u0131zda okuma ve yazma i\u015flemleri ger\u00e7ekle\u015ftirin.<\/p>\n<pre><code class=\"language-sql\">-- Yazma i\u015flemi (Master'a y\u00f6nlendirilmeli)\n    CREATE DATABASE IF NOT EXISTS test_db;\n    USE test_db;\n    CREATE TABLE IF NOT EXISTS test_table (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100));\n    INSERT INTO test_table (name) VALUES ('ProxySQL Test 1');\n\n    -- Okuma i\u015flemi (Slave'e y\u00f6nlendirilmeli)\n    SELECT * FROM test_table;<\/code><\/pre>\n<p>3.  <strong>ProxySQL \u0130statistiklerini Kontrol Etme:<\/strong><br \/>\n    ProxySQL y\u00f6netim aray\u00fcz\u00fcne geri d\u00f6nerek (<code>mysql -u admin -padmin -h 127.0.0.1 -P 6032<\/code>), istatistik tablolar\u0131n\u0131 kontrol edin:<\/p>\n<pre><code class=\"language-sql\">-- Hangi sorgular\u0131n hangi kurallarla e\u015fle\u015fti\u011fini g\u00f6sterir\n    SELECT rule_id, hits FROM stats_mysql_query_rules WHERE hits > 0;\n\n    -- Ba\u011flant\u0131 havuzu durumunu g\u00f6sterir (hangi hostgroup'a ka\u00e7 ba\u011flant\u0131 var)\n    SELECT hostgroup_id, srv_host, srv_port, status, ConnUsed, ConnFree, ConnOK, ConnERR FROM stats_mysql_connection_pool;<\/code><\/pre>\n<p>    <code>stats_mysql_query_rules<\/code> tablosunda <code>rule_id<\/code> 10 ve 20 i\u00e7in <code>hits<\/code> say\u0131s\u0131n\u0131n artt\u0131\u011f\u0131n\u0131 g\u00f6rmelisiniz. <code>stats_mysql_connection_pool<\/code> tablosunda ise Hostgroup 10 ve 20&#8217;deki sunuculara ba\u011flant\u0131lar\u0131n a\u00e7\u0131ld\u0131\u011f\u0131n\u0131 ve durumlar\u0131n\u0131n <code>ONLINE<\/code> oldu\u011funu kontrol edin.<\/p>\n<p>4.  <strong>ProxySQL Loglar\u0131n\u0131 Kontrol Etme:<\/strong><br \/>\n    ProxySQL&#8217;in log dosyalar\u0131n\u0131 inceleyerek herhangi bir hata veya uyar\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edin:<\/p>\n<pre><code class=\"language-bash\">sudo tail -f \/var\/log\/proxysql.log<\/code><\/pre>\n<p>    Sorgular\u0131n hangi hostgroup&#8217;a y\u00f6nlendirildi\u011fini, ba\u011flant\u0131lar\u0131n nas\u0131l y\u00f6netildi\u011fini ve monitor mod\u00fcl\u00fcn\u00fcn sunucular\u0131 nas\u0131l izledi\u011fini bu loglarda g\u00f6rebilirsiniz.<\/p>\n<p>5.  <strong>Failover Testi (\u0130ste\u011fe Ba\u011fl\u0131):<\/strong><br \/>\n    Master sunucunuzu ge\u00e7ici olarak durdurarak (\u00f6rn: <code>sudo systemctl stop mysql<\/code>), ProxySQL&#8217;in nas\u0131l tepki verdi\u011fini g\u00f6zlemleyebilirsiniz. ProxySQL, Master sunucuyu <code>OFFLINE_SOFT<\/code> veya <code>OFFLINE_HARD<\/code> olarak i\u015faretlemeli ve t\u00fcm yazma sorgular\u0131n\u0131 bekletmeli veya hata d\u00f6nd\u00fcrmelidir (e\u011fer ba\u015fka bir Master yoksa). Master sunucuyu tekrar ba\u015flatt\u0131\u011f\u0131n\u0131zda, ProxySQL onu otomatik olarak havuza geri eklemelidir.<\/p>\n<h3>Geli\u015fmi\u015f \u00d6zellikler ve En \u0130yi Uygulamalar<\/h3>\n<p>ProxySQL, temel y\u00fck dengelemenin \u00f6tesinde bir\u00e7ok geli\u015fmi\u015f \u00f6zellik sunar:<\/p>\n<p>*   <strong>Sorgu \u00d6nbellekleme (Query Caching):<\/strong><br \/>\n    S\u0131k\u00e7a okunan ve nadiren de\u011fi\u015fen veriler i\u00e7in sorgu \u00f6nbellekleme kullanmak performans\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir. <code>mysql_query_rules<\/code> tablosunda <code>cache_ttl<\/code> (time-to-live) parametresini kullanarak belirli sorgular\u0131n sonu\u00e7lar\u0131n\u0131 \u00f6nbelle\u011fe alabilirsiniz.<\/p>\n<pre><code class=\"language-sql\">INSERT INTO mysql_query_rules (rule_id, active, match_digest, destination_hostgroup, cache_ttl, apply) VALUES (30, 1, '^SELECT name FROM products WHERE id=([0-9]+)', 20, 3600000, 1);\n    LOAD MYSQL QUERY RULES TO RUNTIME;\n    SAVE MYSQL QUERY RULES TO DISK;<\/code><\/pre>\n<p>    Bu kural, <code>products<\/code> tablosundaki <code>id<\/code>&#8216;ye g\u00f6re <code>name<\/code> sorgular\u0131n\u0131 1 saat (3600000 ms) boyunca \u00f6nbelle\u011fe al\u0131r.<\/p>\n<p>*   <strong>Geli\u015fmi\u015f Monitor Yap\u0131land\u0131rmas\u0131:<\/strong><br \/>\n    <code>mysql_replication_hostgroups<\/code> tablosu, master-slave replikasyonunu izlemek ve otomatik failover\/switchover senaryolar\u0131n\u0131 y\u00f6netmek i\u00e7in kullan\u0131l\u0131r. ProxySQL, replikasyon durumuna g\u00f6re dinamik olarak hostgroup&#8217;lar\u0131 de\u011fi\u015ftirebilir.<\/p>\n<pre><code class=\"language-sql\">INSERT INTO mysql_replication_hostgroups (writer_hostgroup, reader_hostgroup, check_type, max_replication_lag) VALUES (10, 20, 'replication', 60);\n    LOAD MYSQL SERVERS TO RUNTIME; -- Bu kural\u0131 y\u00fcklemek i\u00e7in mysql_servers y\u00fcklenir\n    SAVE MYSQL SERVERS TO DISK;<\/code><\/pre>\n<p>    Bu kural, Hostgroup 10&#8217;daki yaz\u0131c\u0131y\u0131 ve Hostgroup 20&#8217;deki okuyucuyu izler. E\u011fer replikasyon gecikmesi 60 saniyeyi a\u015farsa, ProxySQL Hostgroup 20&#8217;deki sunucuyu okuma havuzundan \u00e7\u0131karabilir.<\/p>\n<p>*   <strong>ProxySQL \u0130\u00e7in Y\u00fcksek Eri\u015filebilirlik:<\/strong><br \/>\n    ProxySQL tek bir hata noktas\u0131 (Single Point of Failure) olabilir. Bunu \u00f6nlemek i\u00e7in, birden fazla ProxySQL sunucusunu HAProxy veya Keepalived gibi ara\u00e7larla birle\u015ftirerek y\u00fcksek eri\u015filebilir bir ProxySQL k\u00fcmesi olu\u015fturabilirsiniz. Bu sayede, bir ProxySQL sunucusu \u00e7\u00f6kerse, trafik otomatik olarak di\u011ferine y\u00f6nlendirilir.<\/p>\n<p>*   <strong>G\u00fcvenlik:<\/strong><br \/>\n    *   <code>mysql_users<\/code> tablosundaki \u015fifreleri asla d\u00fcz metin olarak saklamay\u0131n. <code>PASSWORD()<\/code> fonksiyonunu kullanarak \u015fifreleri hash&#8217;leyin.<br \/>\n    *   <code>mysql_query_rules<\/code> kullanarak belirli IP adreslerinden veya kullan\u0131c\u0131 adlar\u0131ndan gelen tehlikeli sorgular\u0131 engelleyebilirsiniz.<br \/>\n    *   ProxySQL&#8217;in y\u00f6netim aray\u00fcz\u00fcn\u00fc sadece g\u00fcvenilir IP adreslerinden eri\u015filebilir k\u0131lmak i\u00e7in g\u00fcvenlik duvar\u0131 kurallar\u0131n\u0131 s\u0131k\u0131la\u015ft\u0131r\u0131n.<\/p>\n<p>*   <strong>\u0130zleme ve Alarm:<\/strong><br \/>\n    ProxySQL&#8217;in sa\u011flad\u0131\u011f\u0131 istatistik tablolar\u0131n\u0131 (\u00f6rn. <code>stats_mysql_query_rules<\/code>, <code>stats_mysql_connection_pool<\/code>) d\u00fczenli olarak izleyin. Prometheus, Grafana gibi izleme ara\u00e7lar\u0131 ile entegre ederek ProxySQL&#8217;in performans\u0131n\u0131 ve arka u\u00e7 sunucular\u0131n\u0131n durumunu g\u00f6rselle\u015ftirebilir ve anormallikler durumunda alarm kurabilirsiniz.<\/p>\n<p>*   <strong>S\u00fcr\u00fcm Uyumlulu\u011fu:<\/strong><br \/>\n    ProxySQL&#8217;in farkl\u0131 s\u00fcr\u00fcmleri, farkl\u0131 MySQL s\u00fcr\u00fcmleriyle daha iyi uyumluluk g\u00f6sterebilir. Kurulumdan \u00f6nce ProxySQL&#8217;in resmi dok\u00fcmantasyonunu kontrol ederek, kulland\u0131\u011f\u0131n\u0131z MySQL s\u00fcr\u00fcm\u00fc i\u00e7in \u00f6nerilen ProxySQL s\u00fcr\u00fcm\u00fcn\u00fc \u00f6\u011frenmek \u00f6nemlidir. Ubuntu 16.04 ile birlikte genellikle MySQL 5.7 veya daha eski s\u00fcr\u00fcmler kullan\u0131l\u0131r.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>ProxySQL, MySQL tabanl\u0131 uygulamalar i\u00e7in \u00f6l\u00e7eklenebilirlik, y\u00fcksek eri\u015filebilirlik ve performans sa\u011flamak isteyen sistem y\u00f6neticileri ve veritaban\u0131 y\u00f6neticileri i\u00e7in vazge\u00e7ilmez bir ara\u00e7t\u0131r. Ubuntu 16.04 \u00fczerinde kurulumu ve yap\u0131land\u0131rmas\u0131 nispeten kolayd\u0131r ve dinamik yap\u0131s\u0131 sayesinde kesintisiz operasyonlar sunar.<\/p>\n<p>Bu makalede, ProxySQL&#8217;in temel kavramlar\u0131ndan, kurulum ad\u0131mlar\u0131ndan ve bir Master-Slave MySQL mimarisinde nas\u0131l y\u00fck dengeleyici olarak yap\u0131land\u0131r\u0131laca\u011f\u0131ndan bahsettik. Sorgu y\u00f6nlendirme, ba\u011flant\u0131 havuzlama, otomatik hata tolerans\u0131 ve sorgu \u00f6nbellekleme gibi \u00f6zellikleriyle ProxySQL, veritaban\u0131 altyap\u0131n\u0131z\u0131 daha sa\u011flam, h\u0131zl\u0131 ve y\u00f6netilebilir hale getirir. Geli\u015fmi\u015f \u00f6zelliklerini kullanarak ve en iyi uygulamalar\u0131 takip ederek, uygulaman\u0131z\u0131n veritaban\u0131 katman\u0131n\u0131 optimize edebilir ve kullan\u0131c\u0131lar\u0131n\u0131za kesintisiz bir deneyim sunabilirsiniz.<\/p>\n<p>Unutmay\u0131n ki, herhangi bir \u00fcretim ortam\u0131nda ProxySQL&#8217;i devreye almadan \u00f6nce kapsaml\u0131 testler yapmak ve olas\u0131 senaryolar\u0131 (failover, performans d\u00fc\u015f\u00fc\u015f\u00fc vb.) sim\u00fcle etmek kritik \u00f6neme sahiptir. Do\u011fru yap\u0131land\u0131rma ve s\u00fcrekli izleme ile ProxySQL, MySQL altyap\u0131n\u0131z\u0131n omurgas\u0131 haline gelebilir.<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma\nMySQL veritaban\u0131, modern web uygulamalar\u0131n\u0131n ve kurumsal sistemler","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":[1468],"tags":[],"class_list":{"0":"post-31684","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ubuntu","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>ProxySQL&#039;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\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\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ProxySQL&#039;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma\" \/>\n<meta property=\"og:description\" content=\"ProxySQL&#039;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma MySQL veritaban\u0131, modern web uygulamalar\u0131n\u0131n ve kurumsal sistemler\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-12T17:41:04+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=\"18 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma\",\"datePublished\":\"2025-10-12T17:41:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\"},\"wordCount\":2816,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"Ubuntu\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\",\"name\":\"ProxySQL'i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-10-12T17:41:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma\"}]},{\"@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":"ProxySQL'i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","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\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/","og_locale":"tr_TR","og_type":"article","og_title":"ProxySQL'i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma","og_description":"ProxySQL'i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma MySQL veritaban\u0131, modern web uygulamalar\u0131n\u0131n ve kurumsal sistemler","og_url":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-10-12T17:41:04+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"18 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma","datePublished":"2025-10-12T17:41:04+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/"},"wordCount":2816,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["Ubuntu"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/","url":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/","name":"ProxySQL'i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-10-12T17:41:04+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/proxysqli-mysql-icin-yuk-dengeleyici-olarak-ubuntu-16-04-uzerinde-kullanma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ProxySQL&#8217;i MySQL \u0130\u00e7in Y\u00fck Dengeleyici Olarak Ubuntu 16.04 \u00dczerinde Kullanma"}]},{"@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\/31684","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=31684"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31684\/revisions"}],"predecessor-version":[{"id":31685,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31684\/revisions\/31685"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=31684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=31684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=31684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}