{"id":38781,"date":"2026-02-07T15:40:45","date_gmt":"2026-02-07T12:40:45","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=38781"},"modified":"2026-02-07T15:40:45","modified_gmt":"2026-02-07T12:40:45","slug":"saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/","title":{"rendered":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma"},"content":{"rendered":"<p><body><\/p>\n<h2>SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma<\/h2>\n<p>SaltStack, modern IT altyap\u0131lar\u0131nda yap\u0131land\u0131rma y\u00f6netimi, otomasyon ve orkestrasyon i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc, a\u00e7\u0131k kaynakl\u0131 bir ara\u00e7t\u0131r. Geleneksel olarak manuel ve hataya a\u00e7\u0131k olan sunucu yap\u0131land\u0131rma s\u00fcre\u00e7lerini otomatikle\u015ftirerek, sistem y\u00f6neticilerine ve DevOps m\u00fchendislerine b\u00fcy\u00fck kolayl\u0131klar sa\u011flar. Bu makalede, SaltStack&#8217;in temel prensiplerini ve \u00f6zellikle MySQL veritaban\u0131 sunucular\u0131n\u0131n kurulumu, yap\u0131land\u0131rmas\u0131 ve y\u00f6netimi i\u00e7in Salt State&#8217;lerinin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 detayl\u0131 bir \u015fekilde inceleyece\u011fiz. SaltStack&#8217;in deklaratif yap\u0131s\u0131 sayesinde, veritaban\u0131 sunucular\u0131n\u0131z\u0131 tutarl\u0131, \u00f6l\u00e7eklenebilir ve g\u00fcvenli bir \u015fekilde y\u00f6netmenin yollar\u0131n\u0131 ke\u015ffedece\u011fiz.<\/p>\n<h3>Giri\u015f: SaltStack ve Otomatik Veritaban\u0131 Y\u00f6netimi<\/h3>\n<p>Veritabanlar\u0131, her uygulaman\u0131n kalbinde yer al\u0131r ve bunlar\u0131n istikrarl\u0131, g\u00fcvenli ve performansl\u0131 \u00e7al\u0131\u015fmas\u0131 kritik \u00f6neme sahiptir. Manuel olarak bir MySQL sunucusunu kurmak, yap\u0131land\u0131rmak, kullan\u0131c\u0131lar olu\u015fturmak ve yetkiler atamak, \u00f6zellikle b\u00fcy\u00fck \u00f6l\u00e7ekli altyap\u0131larda zaman al\u0131c\u0131, tekrarlay\u0131c\u0131 ve hataya a\u00e7\u0131k bir s\u00fcre\u00e7tir. Farkl\u0131 ortamlar (geli\u015ftirme, test, \u00fcretim) veya birden fazla sunucu aras\u0131nda tutarl\u0131l\u0131\u011f\u0131 sa\u011flamak neredeyse imkans\u0131z hale gelebilir. \u0130\u015fte tam bu noktada SaltStack gibi yap\u0131land\u0131rma y\u00f6netimi ara\u00e7lar\u0131 devreye girer.<\/p>\n<p>SaltStack, altyap\u0131n\u0131z\u0131 kod olarak tan\u0131mlaman\u0131za olanak tan\u0131r. Bu &#8220;altyap\u0131 kodu&#8221;, Salt State&#8217;leri (SLS dosyalar\u0131) arac\u0131l\u0131\u011f\u0131yla ifade edilir. Bir Salt State, bir sistemin istenen durumunu tan\u0131mlayan YAML tabanl\u0131 bir dosyad\u0131r. \u00d6rne\u011fin, bir MySQL sunucusunun kurulu olmas\u0131, belirli bir yap\u0131land\u0131rma dosyas\u0131na sahip olmas\u0131, belirli bir porttan dinlemesi ve belirli kullan\u0131c\u0131lar\u0131n tan\u0131mlanm\u0131\u015f olmas\u0131 gibi durumlar\u0131 Salt State&#8217;leri ile ifade edebiliriz. SaltStack&#8217;in idempotent (tekrarlanabilir) yap\u0131s\u0131 sayesinde, bir state&#8217;i birden fazla kez \u00e7al\u0131\u015ft\u0131rmak her zaman ayn\u0131 sonuca ula\u015f\u0131r; yani, sistem zaten istenen durumdaysa herhangi bir de\u011fi\u015fiklik yapmaz. Bu \u00f6zellik, veritaban\u0131 gibi hassas sistemlerin y\u00f6netiminde b\u00fcy\u00fck bir g\u00fcvence sa\u011flar.<\/p>\n<p>Bu makalenin amac\u0131, SaltStack kullanarak MySQL veritaban\u0131 sunucular\u0131n\u0131 ba\u015ftan sona nas\u0131l y\u00f6netece\u011finizi g\u00f6stermektir. Konular aras\u0131nda temel SaltStack bile\u015fenleri, MySQL kurulumu, yap\u0131land\u0131rma dosyalar\u0131n\u0131n y\u00f6netimi, kullan\u0131c\u0131 ve veritaban\u0131 olu\u015fturma, g\u00fcvenlik ayarlar\u0131 ve geli\u015fmi\u015f senaryolar yer alacakt\u0131r.<\/p>\n<h3>SaltStack Temelleri ve MySQL Y\u00f6netiminde Otomasyonun \u00d6nemi<\/h3>\n<p>SaltStack, bir master-minion mimarisi \u00fczerinde \u00e7al\u0131\u015f\u0131r. Salt Master, yap\u0131land\u0131rma talimatlar\u0131n\u0131 (State&#8217;ler) ve komutlar\u0131 g\u00f6nderen merkezi sunucudur. Salt Minion&#8217;lar ise bu talimatlar\u0131 al\u0131p uygulayan istemci sunuculard\u0131r.<\/p>\n<h4>SaltStack&#8217;in Temel Bile\u015fenleri<\/h4>\n<p>*   <strong>Salt Master:<\/strong> T\u00fcm yap\u0131land\u0131rma dosyalar\u0131n\u0131, state&#8217;leri ve pillar verilerini bar\u0131nd\u0131ran merkezi sunucu. Minion&#8217;lar master&#8217;a ba\u011flanarak talimatlar\u0131 al\u0131r.<br \/>\n*   <strong>Salt Minion:<\/strong> Master&#8217;dan gelen komutlar\u0131 ve state&#8217;leri \u00e7al\u0131\u015ft\u0131ran istemci sunucular. Her y\u00f6netilen sunucu bir minion&#8217;a sahiptir.<br \/>\n*   <strong>States (SLS Dosyalar\u0131):<\/strong> Bir sistemin istenen durumunu tan\u0131mlayan YAML dosyalar\u0131d\u0131r. \u00d6rne\u011fin, bir paketin kurulu olmas\u0131, bir servisin \u00e7al\u0131\u015fmas\u0131, bir dosyan\u0131n i\u00e7eri\u011fi gibi.<br \/>\n*   <strong>Pillars:<\/strong> Hassas verileri (\u015fifreler, API anahtarlar\u0131 vb.) veya minion&#8217;a \u00f6zel yap\u0131land\u0131rma verilerini g\u00fcvenli bir \u015fekilde depolamak ve da\u011f\u0131tmak i\u00e7in kullan\u0131l\u0131r. Minion&#8217;lar yaln\u0131zca kendilerine ait pillar verilerini g\u00f6rebilir.<br \/>\n*   <strong>Grains:<\/strong> Minion&#8217;lar hakk\u0131nda statik bilgileri (i\u015fletim sistemi, IP adresi, CPU say\u0131s\u0131 vb.) i\u00e7eren verilerdir. Bu bilgiler minion taraf\u0131ndan otomatik olarak toplan\u0131r ve master taraf\u0131ndan sorgulanabilir.<br \/>\n*   <strong>Top File (<code>top.sls<\/code>):<\/strong> Hangi minion&#8217;lara hangi state&#8217;lerin uygulanaca\u011f\u0131n\u0131 belirleyen ana dosyad\u0131r. Genellikle ortam (dev, prod) veya role (webserver, dbserver) baz\u0131nda hedefleme yapar.<br \/>\n*   <strong>Highstate:<\/strong> <code>state.highstate<\/code> komutu ile bir minion&#8217;a <code>top.sls<\/code> dosyas\u0131nda tan\u0131mlanan t\u00fcm state&#8217;leri uygulamas\u0131n\u0131 s\u00f6ylemek.<\/p>\n<h4>MySQL Y\u00f6netiminde Otomasyonun \u00d6nemi<\/h4>\n<p>MySQL gibi kritik bir veritaban\u0131n\u0131n manuel y\u00f6netimi, bir dizi zorlu\u011fu beraberinde getirir:<\/p>\n<p>*   <strong>Hata Pay\u0131:<\/strong> \u0130nsan fakt\u00f6r\u00fc, yap\u0131land\u0131rma hatalar\u0131na, yanl\u0131\u015f yetkilendirmelere veya eksik ad\u0131mlara yol a\u00e7abilir.<br \/>\n*   <strong>Zaman Kayb\u0131:<\/strong> Her sunucuda ayn\u0131 ad\u0131mlar\u0131 tekrarlamak, \u00f6zellikle b\u00fcy\u00fck altyap\u0131larda \u00f6nemli bir zaman kayb\u0131d\u0131r.<br \/>\n*   <strong>Tutars\u0131zl\u0131k:<\/strong> Farkl\u0131 y\u00f6neticiler veya farkl\u0131 zamanlarda yap\u0131lan kurulumlar aras\u0131nda yap\u0131land\u0131rma farkl\u0131l\u0131klar\u0131 ortaya \u00e7\u0131kabilir, bu da sorun gidermeyi zorla\u015ft\u0131r\u0131r.<br \/>\n*   <strong>\u00d6l\u00e7eklenebilirlik Eksikli\u011fi:<\/strong> Yeni bir veritaban\u0131 sunucusu eklemek veya mevcutlar\u0131 g\u00fcncellemek, manuel s\u00fcre\u00e7lerle \u00e7ok yava\u015f ve verimsizdir.<\/p>\n<p>SaltStack ile otomasyon, bu sorunlar\u0131 ortadan kald\u0131r\u0131r. Deklaratif state&#8217;ler sayesinde, veritaban\u0131 sunucular\u0131n\u0131z\u0131n her zaman istenen durumda olmas\u0131n\u0131 sa\u011flars\u0131n\u0131z. Bu, kurulumdan yap\u0131land\u0131rmaya, kullan\u0131c\u0131 y\u00f6netiminden yedeklemeye kadar her ad\u0131mda tutarl\u0131l\u0131k, h\u0131z ve g\u00fcvenilirlik anlam\u0131na gelir.<\/p>\n<h3>Salt States Olu\u015fturmaya Ba\u015flang\u0131\u00e7: MySQL Kurulumu<\/h3>\n<p>Salt State&#8217;leri genellikle <code>\/srv\/salt<\/code> dizini alt\u0131nda organize edilir. Bu dizin alt\u0131nda her uygulama veya servis i\u00e7in ayr\u0131 bir dizin olu\u015fturmak iyi bir uygulamad\u0131r. MySQL i\u00e7in <code>mysql<\/code> ad\u0131nda bir dizin olu\u015fturabiliriz.<\/p>\n<h4>Dizin Yap\u0131s\u0131 \u00d6nerisi<\/h4>\n<pre><code class=\"language-\">\/srv\/salt\/\n\u251c\u2500\u2500 mysql\/\n\u2502   \u251c\u2500\u2500 init.sls             # MySQL paketlerinin kurulumu ve servis y\u00f6netimi\n\u2502   \u251c\u2500\u2500 config.sls           # my.cnf yap\u0131land\u0131rmas\u0131\n\u2502   \u251c\u2500\u2500 users.sls            # Kullan\u0131c\u0131lar\u0131n ve yetkilerinin y\u00f6netimi\n\u2502   \u251c\u2500\u2500 databases.sls        # Veritabanlar\u0131n\u0131n olu\u015fturulmas\u0131\n\u2502   \u2514\u2500\u2500 files\/\n\u2502       \u2514\u2500\u2500 my.cnf.jinja     # my.cnf i\u00e7in Jinja \u015fablonu\n\u2514\u2500\u2500 top.sls                  # Ana hedefleme dosyas\u0131<\/code><\/pre>\n<h4>Temel Bir MySQL Kurulum State&#8217;i (<code>mysql\/init.sls<\/code>)<\/h4>\n<p>\u0130lk ad\u0131m, MySQL sunucu paketini kurmak ve servisini ba\u015flatmakt\u0131r. Farkl\u0131 i\u015fletim sistemleri i\u00e7in farkl\u0131 paket isimleri olabilir (\u00f6rn. Debian\/Ubuntu i\u00e7in <code>mysql-server<\/code>, CentOS\/RHEL i\u00e7in <code>mysql-community-server<\/code> veya <code>mariadb-server<\/code>). SaltStack, <code>pkg<\/code> state mod\u00fcl\u00fc ile bunu soyutlar ve do\u011fru paket y\u00f6neticisini kullan\u0131r.<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/mysql\/init.sls\n\n{% if grains['os_family'] == 'Debian' %}\nmysql_server_package: mysql-server\nmysql_client_package: mysql-client\n{% elif grains['os_family'] == 'RedHat' %}\nmysql_server_package: mariadb-server\nmysql_client_package: mariadb\n{% else %}\n<h2>Desteklenmeyen i\u015fletim sistemleri i\u00e7in varsay\u0131lan veya hata<\/h2>\nmysql_server_package: mysql-server\nmysql_client_package: mysql-client\n{% endif %}\n\nmysql_server_installed:\n  pkg.installed:\n    - name: {{ mysql_server_package }}\n\nmysql_client_installed:\n  pkg.installed:\n    - name: {{ mysql_client_package }}\n\nmysql_service_running:\n  service.running:\n    - name: {% if grains['os_family'] == 'Debian' %}mysql{% else %}mariadb{% endif %}\n    - enable: True\n    - watch:\n      - pkg: mysql_server_installed\n      - file: \/etc\/mysql\/my.cnf # Konfig\u00fcrasyon dosyas\u0131n\u0131 izle<\/code><\/pre>\n<p>Bu <code>init.sls<\/code> dosyas\u0131 \u015funlar\u0131 yapar:<br \/>\n*   <code>grains['os_family']<\/code> kullanarak i\u015fletim sistemine g\u00f6re do\u011fru paket isimlerini belirler. Bu, state&#8217;lerinizi farkl\u0131 da\u011f\u0131t\u0131mlarda ta\u015f\u0131nabilir hale getirir.<br \/>\n*   <code>pkg.installed<\/code> state&#8217;i ile MySQL sunucu ve istemci paketlerinin kurulu olmas\u0131n\u0131 sa\u011flar.<br \/>\n*   <code>service.running<\/code> state&#8217;i ile MySQL servisinin \u00e7al\u0131\u015f\u0131r durumda olmas\u0131n\u0131 ve sistem a\u00e7\u0131l\u0131\u015f\u0131nda otomatik ba\u015flamas\u0131n\u0131 (<code>enable: True<\/code>) sa\u011flar.<br \/>\n*   <code>watch<\/code> parametresi, ilgili paket veya yap\u0131land\u0131rma dosyas\u0131nda bir de\u011fi\u015fiklik oldu\u011funda servisin yeniden ba\u015flat\u0131lmas\u0131n\u0131 tetikler. Bu, SaltStack&#8217;in idempotent yap\u0131s\u0131n\u0131n g\u00fczel bir \u00f6rne\u011fidir.<\/p>\n<h3>MySQL Yap\u0131land\u0131rmas\u0131n\u0131 Y\u00f6netme<\/h3>\n<p>MySQL&#8217;in performans\u0131n\u0131 ve davran\u0131\u015f\u0131n\u0131 ayarlamak i\u00e7in <code>my.cnf<\/code> veya da\u011f\u0131t\u0131ma \u00f6zg\u00fc yap\u0131land\u0131rma dosyalar\u0131 kullan\u0131l\u0131r. Bu dosyalar\u0131 SaltStack ile y\u00f6netmek, tutarl\u0131l\u0131k ve s\u00fcr\u00fcm kontrol\u00fc a\u00e7\u0131s\u0131ndan \u00e7ok \u00f6nemlidir.<\/p>\n<h4>Yap\u0131land\u0131rma Dosyalar\u0131 (<code>mysql\/config.sls<\/code>)<\/h4>\n<p>Yap\u0131land\u0131rma dosyalar\u0131n\u0131 y\u00f6netmek i\u00e7in <code>file.managed<\/code> state&#8217;ini kullan\u0131r\u0131z. Genellikle, yap\u0131land\u0131rma dosyas\u0131n\u0131n i\u00e7eri\u011fini do\u011frudan SLS dosyas\u0131na yazmak yerine, bir Jinja \u015fablonu kullanmak daha esnektir. Bu \u015fablonlar arac\u0131l\u0131\u011f\u0131yla Pillars&#8217;tan veya Grains&#8217;ten dinamik veriler \u00e7ekebiliriz.<\/p>\n<p>\u00d6nce <code>\/srv\/salt\/mysql\/files\/my.cnf.jinja<\/code> ad\u0131nda bir Jinja \u015fablonu olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-jinja\"># \/srv\/salt\/mysql\/files\/my.cnf.jinja\n\n[mysqld]\ndatadir=\/var\/lib\/mysql\nsocket=\/var\/run\/mysqld\/mysqld.sock\npid-file=\/var\/run\/mysqld\/mysqld.pid\n\n<h2>InnoDB Ayarlar\u0131<\/h2>\ninnodb_buffer_pool_size = {{ pillar.get('mysql:innodb_buffer_pool_size', '128M') }}\ninnodb_log_file_size = {{ pillar.get('mysql:innodb_log_file_size', '48M') }}\ninnodb_flush_log_at_trx_commit = {{ pillar.get('mysql:innodb_flush_log_at_trx_commit', 1) }}\n\n<h2>Di\u011fer Ayarlar<\/h2>\nmax_connections = {{ pillar.get('mysql:max_connections', 151) }}\nbind-address = {{ pillar.get('mysql:bind_address', '127.0.0.1') }}\n\n<h2>Replikasyon Ayarlar\u0131 (e\u011fer bir slave veya master ise)<\/h2>\n{% if pillar.get('mysql:replication_role') == 'master' or pillar.get('mysql:replication_role') == 'slave' %}\nserver-id = {{ pillar.get('mysql:server_id') }}\nlog_bin = mysql-bin\nbinlog_format = ROW\nexpire_logs_days = 7\nmax_binlog_size = 100M\n{% endif %}\n\n[client]\nport=3306\nsocket=\/var\/run\/mysqld\/mysqld.sock\n\n[mysql]\nno-auto-rehash\n\n[mysqldump]\nquick\nquote-names\nmax_allowed_packet=16M<\/code><\/pre>\n<p>\u015eimdi bu \u015fablonu kullanarak <code>my.cnf<\/code> dosyas\u0131n\u0131 y\u00f6netecek <code>mysql\/config.sls<\/code> dosyas\u0131n\u0131 olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/mysql\/config.sls\n\n{% if grains['os_family'] == 'Debian' %}\nmysql_config_path: \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\n{% elif grains['os_family'] == 'RedHat' %}\nmysql_config_path: \/etc\/my.cnf.d\/mariadb-server.cnf\n{% else %}\nmysql_config_path: \/etc\/mysql\/my.cnf\n{% endif %}\n\nmysql_config_file:\n  file.managed:\n    - name: {{ mysql_config_path }}\n    - source: salt:\/\/mysql\/files\/my.cnf.jinja\n    - template: jinja\n    - user: root\n    - group: {% if grains['os_family'] == 'Debian' %}mysql{% else %}mysql{% endif %}\n    - mode: 644\n    - require:\n      - pkg: mysql_server_installed # MySQL paketi kurulu olmadan yap\u0131land\u0131rma yapma\n    - watch_in:\n      - service: mysql_service_running # Yap\u0131land\u0131rma de\u011fi\u015fince servisi yeniden ba\u015flat<\/code><\/pre>\n<p>Bu state \u015funlar\u0131 sa\u011flar:<br \/>\n*   \u0130\u015fletim sistemine g\u00f6re do\u011fru yap\u0131land\u0131rma dosyas\u0131n\u0131n yolunu belirler.<br \/>\n*   <code>file.managed<\/code> ile <code>my.cnf.jinja<\/code> \u015fablonunu hedef yola kopyalar.<br \/>\n*   <code>template: jinja<\/code> ile Jinja \u015fablon motorunu kullan\u0131r.<br \/>\n*   Dosyan\u0131n sahibi, grubu ve izinlerini ayarlar.<br \/>\n*   <code>require<\/code> ile <code>mysql_server_installed<\/code> state&#8217;inin tamamlanmas\u0131n\u0131 bekler.<br \/>\n*   <code>watch_in<\/code> ile bu dosya de\u011fi\u015fti\u011finde <code>mysql_service_running<\/code> state&#8217;ini tetikler, bu da MySQL servisinin yeniden ba\u015flat\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n<h4>Pillars ile Hassas Veri ve Dinamik Yap\u0131land\u0131rma Y\u00f6netimi<\/h4>\n<p>\u015eifreler, port numaralar\u0131 veya sunucuya \u00f6zel performans ayarlar\u0131 gibi hassas veya dinamik verileri Salt State&#8217;lerine do\u011frudan yazmak yerine Pillars kullan\u0131r\u0131z. Pillars, Salt Master \u00fczerinde depolan\u0131r ve her minion&#8217;a yaln\u0131zca kendisiyle ilgili verileri g\u00f6sterir.<\/p>\n<p>\u00d6rnek bir Pillar yap\u0131s\u0131 (<code>\/srv\/pillar\/mysql.sls<\/code>):<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/pillar\/mysql.sls\n\nmysql:\n  root_password: '{{ salt[\"vault.read_secret\"](\"secret\/mysql\/root_password\") }}' # Vault entegrasyonu\n  app_user: 'my_app_user'\n  app_password: '{{ salt[\"vault.read_secret\"](\"secret\/mysql\/app_password\") }}'\n  bind_address: '0.0.0.0' # T\u00fcm aray\u00fczlerden dinle\n  innodb_buffer_pool_size: '2G'\n  max_connections: 500\n  server_id: 1 # Replikasyon i\u00e7in\n  replication_role: master<\/code><\/pre>\n<p>Ve Pillar <code>top.sls<\/code> dosyas\u0131 (<code>\/srv\/pillar\/top.sls<\/code>):<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/pillar\/top.sls\n\nbase:\n  '*':\n    - mysql<\/code><\/pre>\n<p>Bu \u00f6rnekte, <code>root_password<\/code> ve <code>app_password<\/code> gibi hassas verilerin SaltStack Vault entegrasyonu ile \u00e7ekildi\u011fi varsay\u0131lm\u0131\u015ft\u0131r. Bu, \u015fifrelerin d\u00fcz metin olarak depolanmamas\u0131n\u0131 sa\u011flar. <code>mysql\/files\/my.cnf.jinja<\/code> dosyas\u0131nda <code>pillar.get('mysql:innodb_buffer_pool_size', '128M')<\/code> \u015feklinde Pillars&#8217;tan verileri \u00e7ekiyorduk. Bu sayede, farkl\u0131 sunucular i\u00e7in farkl\u0131 <code>innodb_buffer_pool_size<\/code> de\u011ferleri tan\u0131mlayabiliriz.<\/p>\n<h3>MySQL Kullan\u0131c\u0131lar\u0131 ve Veritabanlar\u0131 Olu\u015fturma<\/h3>\n<p>SaltStack, MySQL veritaban\u0131 sunucular\u0131n\u0131 y\u00f6netmek i\u00e7in \u00f6zel <code>mysql_user<\/code>, <code>mysql_grants<\/code> ve <code>mysql_database<\/code> state mod\u00fcllerine sahiptir. Bu mod\u00fcller, kullan\u0131c\u0131lar\u0131, yetkileri ve veritabanlar\u0131n\u0131 deklaratif bir \u015fekilde tan\u0131mlamam\u0131z\u0131 sa\u011flar.<\/p>\n<h4>Kullan\u0131c\u0131lar ve Yetkiler (<code>mysql\/users.sls<\/code>)<\/h4>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/mysql\/users.sls\n\n{% set mysql_root_password = pillar.get('mysql:root_password') %}\n{% set mysql_app_user = pillar.get('mysql:app_user') %}\n{% set mysql_app_password = pillar.get('mysql:app_password') %}\n\n<h2>Root kullan\u0131c\u0131s\u0131n\u0131n \u015fifresini ayarla (e\u011fer ayarl\u0131 de\u011filse veya de\u011fi\u015ftirilmek isteniyorsa)<\/h2>\nmysql_root_user:\n  mysql_user.present:\n    - name: root\n    - host: localhost\n    - password: {{ mysql_root_password }}\n    - require:\n      - service: mysql_service_running\n\n<h2>Uygulama kullan\u0131c\u0131s\u0131 olu\u015ftur<\/h2>\nmysql_app_user:\n  mysql_user.present:\n    - name: {{ mysql_app_user }}\n    - host: '%' # Herhangi bir host'tan ba\u011flanabilir\n    - password: {{ mysql_app_password }}\n    - require:\n      - mysql_user: mysql_root_user\n\n<h2>Uygulama kullan\u0131c\u0131s\u0131na yetkiler ver<\/h2>\nmysql_app_user_grants:\n  mysql_grants.present:\n    - grant: ALL PRIVILEGES ON <code>my_app_db<\/code>.* TO '{{ mysql_app_user }}'@'%'\n    - database: my_app_db\n    - user: {{ mysql_app_user }}\n    - host: '%'\n    - require:\n      - mysql_user: mysql_app_user\n      - mysql_database: my_app_database_created<\/code><\/pre>\n<p>Bu <code>users.sls<\/code> dosyas\u0131:<br \/>\n*   Pillars&#8217;tan root ve uygulama kullan\u0131c\u0131s\u0131 \u015fifrelerini ve kullan\u0131c\u0131 ad\u0131n\u0131 \u00e7eker.<br \/>\n*   <code>mysql_user.present<\/code> ile <code>root@localhost<\/code> kullan\u0131c\u0131s\u0131n\u0131n \u015fifresini ayarlar.<br \/>\n*   Ayn\u0131 \u015fekilde <code>my_app_user<\/code> ad\u0131nda yeni bir kullan\u0131c\u0131 olu\u015fturur ve \u015fifresini belirler. <code>%<\/code> host&#8217;u, kullan\u0131c\u0131n\u0131n herhangi bir IP adresinden ba\u011flanabilece\u011fi anlam\u0131na gelir.<br \/>\n*   <code>mysql_grants.present<\/code> ile <code>my_app_user<\/code> kullan\u0131c\u0131s\u0131na <code>my_app_db<\/code> veritaban\u0131 \u00fczerinde t\u00fcm yetkileri verir.<br \/>\n*   <code>require<\/code> ba\u011f\u0131ml\u0131l\u0131klar\u0131, kullan\u0131c\u0131 olu\u015fturulmadan yetki verilmemesini veya servisin \u00e7al\u0131\u015f\u0131r durumda olmas\u0131n\u0131 sa\u011flar.<\/p>\n<h4>Veritabanlar\u0131 Olu\u015fturma (<code>mysql\/databases.sls<\/code>)<\/h4>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/mysql\/databases.sls\n\nmy_app_database_created:\n  mysql_database.present:\n    - name: my_app_db\n    - charset: utf8mb4\n    - collate: utf8mb4_unicode_ci\n    - require:\n      - service: mysql_service_running<\/code><\/pre>\n<p>Bu <code>databases.sls<\/code> dosyas\u0131:<br \/>\n*   <code>mysql_database.present<\/code> ile <code>my_app_db<\/code> ad\u0131nda bir veritaban\u0131 olu\u015fturur.<br \/>\n*   <code>charset<\/code> ve <code>collate<\/code> parametreleri ile karakter seti ve kolasyon ayarlar\u0131n\u0131 yapar.<br \/>\n*   Yine <code>require<\/code> ile MySQL servisinin \u00e7al\u0131\u015f\u0131r durumda olmas\u0131n\u0131 bekler.<\/p>\n<h3>Geli\u015fmi\u015f MySQL Y\u00f6netimi SaltStack ile<\/h3>\n<p>SaltStack, sadece temel kurulum ve yap\u0131land\u0131rman\u0131n \u00f6tesine ge\u00e7erek daha karma\u015f\u0131k veritaban\u0131 y\u00f6netimi g\u00f6revlerini otomatikle\u015ftirmek i\u00e7in de kullan\u0131labilir.<\/p>\n<h4>Yedekleme ve Geri Y\u00fckleme<\/h4>\n<p>SaltStack, veritaban\u0131 yedekleme ve geri y\u00fckleme i\u015flemlerini otomatikle\u015ftirmek i\u00e7in <code>cron<\/code> state&#8217;i veya <code>cmd.run<\/code> mod\u00fcl\u00fcn\u00fc kullanabilir.<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/mysql\/backup.sls\n\nmysql_backup_script:\n  file.managed:\n    - name: \/usr\/local\/bin\/mysql_backup.sh\n    - source: salt:\/\/mysql\/files\/mysql_backup.sh\n    - user: root\n    - group: root\n    - mode: 755\n\nmysql_daily_backup_cron:\n  cron.present:\n    - name: \"\/usr\/local\/bin\/mysql_backup.sh > \/var\/log\/mysql_backup.log 2>&1\"\n    - user: root\n    - minute: 0\n    - hour: 2\n    - require:\n      - file: mysql_backup_script<\/code><\/pre>\n<p>Ve <code>\/srv\/salt\/mysql\/files\/mysql_backup.sh<\/code> i\u00e7eri\u011fi:<\/p>\n<pre><code class=\"language-bash\">#!\/bin\/bash\nBACKUP_DIR=\"\/var\/backups\/mysql\"\nDATE=$(date +%Y%m%d%H%M%S)\nDB_USER=\"{{ pillar.get('mysql:backup_user', 'root') }}\"\nDB_PASS=\"{{ pillar.get('mysql:root_password') }}\" # veya \u00f6zel bir yedekleme kullan\u0131c\u0131s\u0131 \u015fifresi\n\nmkdir -p $BACKUP_DIR\nmysqldump --single-transaction -u\"$DB_USER\" -p\"$DB_PASS\" --all-databases > \"$BACKUP_DIR\/all_databases_$DATE.sql\"\n\n<h2>Eski yedekleri temizle (\u00f6rne\u011fin 7 g\u00fcnden eski)<\/h2>\nfind $BACKUP_DIR -type f -name \"*.sql\" -mtime +7 -delete<\/code><\/pre>\n<p>Bu \u00f6rnek, bir yedekleme beti\u011fini sunucuya da\u011f\u0131t\u0131r ve ard\u0131ndan bu beti\u011fi g\u00fcnl\u00fck olarak \u00e7al\u0131\u015ft\u0131racak bir cron i\u015fi olu\u015fturur.<\/p>\n<h4>Replikasyon Kurulumu<\/h4>\n<p>MySQL replikasyonu kurmak, master ve slave sunucular aras\u0131nda farkl\u0131 yap\u0131land\u0131rmalar gerektiren daha karma\u015f\u0131k bir s\u00fcre\u00e7tir. SaltStack ile bu s\u00fcre\u00e7 de otomatikle\u015ftirilebilir.<\/p>\n<p>Pillars&#8217;ta sunucunun rol\u00fcn\u00fc belirleyebiliriz:<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/pillar\/mysql_master.sls (master i\u00e7in)\nmysql:\n  replication_role: master\n  server_id: 1\n\n<h2>\/srv\/pillar\/mysql_slave.sls (slave i\u00e7in)<\/h2>\nmysql:\n  replication_role: slave\n  server_id: 2\n  master_host: '192.168.1.100' # Master sunucunun IP'si\n  master_user: 'repl_user'\n  master_password: 'repl_password'<\/code><\/pre>\n<p><code>my.cnf.jinja<\/code> dosyas\u0131nda <code>replication_role<\/code>&#8216;e g\u00f6re ayarlar yap\u0131yorduk. \u015eimdi bir slave sunucuda replikasyonu ba\u015flatmak i\u00e7in bir state olu\u015fturabiliriz:<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/mysql\/replication.sls\n\n{% if pillar.get('mysql:replication_role') == 'slave' %}\nmysql_replication_started:\n  mysql_replication.started:\n    - name: my_replication_connection\n    - master_host: {{ pillar.get('mysql:master_host') }}\n    - master_user: {{ pillar.get('mysql:master_user') }}\n    - master_password: {{ pillar.get('mysql:master_password') }}\n    - master_log_file: '' # Gerekirse buradan set edilebilir\n    - master_log_pos: 0 # Gerekirse buradan set edilebilir\n    - require:\n      - service: mysql_service_running\n{% endif %}\n\n<h2>Replikasyon kullan\u0131c\u0131s\u0131 olu\u015fturma (master \u00fczerinde \u00e7al\u0131\u015facak)<\/h2>\n{% if pillar.get('mysql:replication_role') == 'master' %}\nmysql_replication_user:\n  mysql_user.present:\n    - name: repl_user\n    - host: '%'\n    - password: {{ pillar.get('mysql:master_password') }}\n    - require:\n      - service: mysql_service_running\n\nmysql_replication_grants:\n  mysql_grants.present:\n    - grant: REPLICATION SLAVE ON <em>.<\/em> TO 'repl_user'@'%'\n    - database: '*'\n    - user: repl_user\n    - host: '%'\n    - require:\n      - mysql_user: mysql_replication_user\n{% endif %}<\/code><\/pre>\n<p>Bu state, Pillar&#8217;daki <code>replication_role<\/code>&#8216;e g\u00f6re master \u00fczerinde replikasyon kullan\u0131c\u0131s\u0131 olu\u015fturur ve slave \u00fczerinde replikasyonu ba\u015flat\u0131r. <code>mysql_replication.started<\/code> mod\u00fcl\u00fc, <code>CHANGE MASTER TO<\/code> komutunu \u00e7al\u0131\u015ft\u0131rarak replikasyonu kurar.<\/p>\n<h4>Performans Ayarlar\u0131 ve G\u00fcvenlik<\/h4>\n<p><code>my.cnf.jinja<\/code> \u015fablonu ve Pillars kullanarak, sunucuya \u00f6zel performans ayarlar\u0131n\u0131 kolayca y\u00f6netebiliriz. \u00d6rne\u011fin, daha fazla RAM&#8217;e sahip bir sunucu i\u00e7in <code>innodb_buffer_pool_size<\/code> de\u011ferini art\u0131rabiliriz.<\/p>\n<p>G\u00fcvenlik a\u00e7\u0131s\u0131ndan, SaltStack ile \u015funlar\u0131 yapabiliriz:<br \/>\n*   <strong>Firewall Kurallar\u0131:<\/strong> <code>firewalld<\/code> veya <code>iptables<\/code> state&#8217;leri ile MySQL portuna (varsay\u0131lan 3306) yaln\u0131zca belirli IP&#8217;lerden veya sunuculardan eri\u015fime izin veren kurallar tan\u0131mlayabiliriz.<br \/>\n*   <strong>MySQL Secure Installation Ad\u0131mlar\u0131:<\/strong> MySQL&#8217;in <code>mysql_secure_installation<\/code> beti\u011finin yapt\u0131\u011f\u0131 i\u015flemleri (anonim kullan\u0131c\u0131lar\u0131 kald\u0131rma, uzaktan root giri\u015fini devre d\u0131\u015f\u0131 b\u0131rakma vb.) Salt State&#8217;leri ile otomatikle\u015ftirebiliriz. \u00d6rne\u011fin, anonim kullan\u0131c\u0131lar\u0131 <code>mysql_user.absent<\/code> ile kald\u0131rabiliriz.<\/p>\n<h3>Salt Top File ve Highstate Uygulamas\u0131<\/h3>\n<p>T\u00fcm bu state&#8217;leri yazd\u0131ktan sonra, minion&#8217;lar\u0131n\u0131za hangi state&#8217;lerin uygulanaca\u011f\u0131n\u0131 <code>top.sls<\/code> dosyas\u0131 ile belirtiriz.<\/p>\n<pre><code class=\"language-yaml\"># \/srv\/salt\/top.sls\n\nbase:\n  'db_servers': # T\u00fcm minion'lar\u0131 hedefle\n    - mysql\n    - mysql.config\n    - mysql.users\n    - mysql.databases\n    - mysql.backup\n    - mysql.replication\n  'mysql_master_role': # Sadece master rol\u00fcne sahip minion'lar\u0131 hedefle (Grains\/Pillars ile belirlenebilir)\n    - match: grain\n    - mysql.replication # Master i\u00e7in gerekli replikasyon ayarlar\u0131\n  'mysql_slave_role': # Sadece slave rol\u00fcne sahip minion'lar\u0131 hedefle\n    - match: grain\n    - mysql.replication # Slave i\u00e7in gerekli replikasyon ayarlar\u0131<\/code><\/pre>\n<p>Bu <code>top.sls<\/code> dosyas\u0131, <code>db_servers<\/code> grubundaki t\u00fcm minion&#8217;lara <code>mysql<\/code> dizinindeki t\u00fcm state&#8217;leri (init.sls&#8217;i otomatik olarak i\u00e7erir) ve \u00f6zellikle belirtti\u011fimiz di\u011fer state&#8217;leri uygulamas\u0131n\u0131 s\u00f6yler. <code>match: grain<\/code> ile belirli bir Grain de\u011feri olan minion&#8217;lar\u0131 hedefleyebiliriz. \u00d6rne\u011fin, <code>roles: db-master<\/code> gibi bir Grain tan\u0131mlayabiliriz.<\/p>\n<p>State&#8217;leri uygulamak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">sudo salt 'db_servers' state.apply # Sadece db_servers grubuna uygula\nsudo salt '*' state.highstate      # T\u00fcm minion'lara top.sls'i uygula<\/code><\/pre>\n<p>State&#8217;leri test etmek i\u00e7in <code>test=True<\/code> parametresini kullanabiliriz. Bu, Salt&#8217;\u0131n ger\u00e7ek bir de\u011fi\u015fiklik yapmadan nelerin de\u011fi\u015fece\u011fini g\u00f6stermesini sa\u011flar:<\/p>\n<pre><code class=\"language-bash\">sudo salt 'db_servers' state.apply test=True<\/code><\/pre>\n<h3>Hata Ay\u0131klama ve Sorun Giderme<\/h3>\n<p>SaltStack ile \u00e7al\u0131\u015f\u0131rken hata ay\u0131klama ve sorun giderme \u00f6nemlidir:<br \/>\n*   <strong>Verbose \u00c7\u0131kt\u0131:<\/strong> Salt komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131rken <code>-l debug<\/code> veya <code>-l info<\/code> gibi log seviyeleri belirterek daha detayl\u0131 \u00e7\u0131kt\u0131 alabilirsiniz.<br \/>\n*   <strong><code>salt-call<\/code>:<\/strong> Bir minion \u00fczerinde do\u011frudan state&#8217;leri test etmek i\u00e7in <code>salt-call<\/code> komutunu kullanabilirsiniz. \u00d6rne\u011fin: <code>sudo salt-call state.apply mysql.init test=True<\/code>.<br \/>\n*   <strong>Log Dosyalar\u0131:<\/strong> Salt Master ve Minion&#8217;lar\u0131n log dosyalar\u0131n\u0131 (<code>\/var\/log\/salt\/master<\/code>, <code>\/var\/log\/salt\/minion<\/code>) inceleyerek sorunlar\u0131n k\u00f6k nedenini bulabilirsiniz.<br \/>\n*   <strong>Jinja Hatalar\u0131:<\/strong> Jinja \u015fablonlar\u0131nda yap\u0131lan hatalar genellikle a\u00e7\u0131k\u00e7a belirtilir. Syntax hatalar\u0131n\u0131 dikkatlice kontrol edin.<br \/>\n*   <strong>Pillar Verileri:<\/strong> Bir minion&#8217;a hangi Pillar verilerinin ula\u015ft\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <code>sudo salt 'minion_id' pillar.items<\/code> komutunu kullanabilirsiniz.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>SaltStack, MySQL veritaban\u0131 sunucular\u0131n\u0131 y\u00f6netmek i\u00e7in kapsaml\u0131 ve g\u00fc\u00e7l\u00fc bir \u00e7\u00f6z\u00fcm sunar. Bu makalede ele ald\u0131\u011f\u0131m\u0131z konularla, Salt State&#8217;leri kullanarak MySQL kurulumunu, yap\u0131land\u0131rmas\u0131n\u0131, kullan\u0131c\u0131 ve veritaban\u0131 y\u00f6netimini, yedeklemeyi ve hatta replikasyon kurulumunu otomatikle\u015ftirebilirsiniz. Pillars ve Jinja \u015fablonlar\u0131 sayesinde, hassas verileri g\u00fcvenli bir \u015fekilde y\u00f6netebilir ve dinamik, ortama \u00f6zel yap\u0131land\u0131rmalar olu\u015fturabilirsiniz.<\/p>\n<p>SaltStack&#8217;in deklaratif ve idempotent yap\u0131s\u0131, veritaban\u0131 altyap\u0131n\u0131z\u0131n her zaman tutarl\u0131, g\u00fcvenli ve performansl\u0131 olmas\u0131n\u0131 sa\u011flar. Manuel s\u00fcre\u00e7lerin getirdi\u011fi hatalar\u0131 ve zaman kayb\u0131n\u0131 ortadan kald\u0131rarak, operasyonel verimlili\u011fi art\u0131r\u0131r ve DevOps ekiplerinin daha stratejik g\u00f6revlere odaklanmas\u0131na olanak tan\u0131r. MySQL veritaban\u0131 y\u00f6netiminde otomasyon, g\u00fcn\u00fcm\u00fcz\u00fcn h\u0131zla de\u011fi\u015fen ve b\u00fcy\u00fcyen altyap\u0131lar\u0131nda vazge\u00e7ilmez bir ara\u00e7 haline gelmi\u015ftir ve SaltStack bu d\u00f6n\u00fc\u015f\u00fcmde kilit bir rol oynamaktad\u0131r.<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma\nSaltStack, modern IT altyap\u0131lar\u0131nda yap\u0131land\u0131rma y\u00f6netimi, otomasyo","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":[138],"tags":[],"class_list":{"0":"post-38781","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","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>SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#039;leri Olu\u015fturma - 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\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#039;leri Olu\u015fturma\" \/>\n<meta property=\"og:description\" content=\"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#039;leri Olu\u015fturma SaltStack, modern IT altyap\u0131lar\u0131nda yap\u0131land\u0131rma y\u00f6netimi, otomasyo\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-07T12:40:45+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=\"17 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma\",\"datePublished\":\"2026-02-07T12:40:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\"},\"wordCount\":2140,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\",\"name\":\"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State'leri Olu\u015fturma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-02-07T12:40:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma\"}]},{\"@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":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State'leri Olu\u015fturma - 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\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/","og_locale":"tr_TR","og_type":"article","og_title":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State'leri Olu\u015fturma","og_description":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State'leri Olu\u015fturma SaltStack, modern IT altyap\u0131lar\u0131nda yap\u0131land\u0131rma y\u00f6netimi, otomasyo","og_url":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-02-07T12:40:45+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"17 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma","datePublished":"2026-02-07T12:40:45+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/"},"wordCount":2140,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/","url":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/","name":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State'leri Olu\u015fturma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-02-07T12:40:45+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/saltstack-ile-mysql-veritabani-sunuculari-icin-salt-stateleri-olusturma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SaltStack ile MySQL Veritaban\u0131 Sunucular\u0131 i\u00e7in Salt State&#8217;leri Olu\u015fturma"}]},{"@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\/38781","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=38781"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38781\/revisions"}],"predecessor-version":[{"id":38782,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38781\/revisions\/38782"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=38781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=38781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=38781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}