1 sitemiz var, uzerinde calisan basit php mysql script ile randevu kaydi aliyoruz.
\nAma cogu zaman alamiyoruz cunku yogun oldugu zamanlarda anlik 1000 – 1200 request geliyor.
\napache dayanmiyor, mysql sapitiyor. sonucta site erisilmez oluyor. apacheyi, phpyi tweak etmek , mysqli tweak etmek sorunu cozmuyor. Sorunun cozumu kuvvetli bir vps ve dogru duzgun hafif ve hizli bir php,mysql altyapisi.
\nUbuntu 10.10 ustunde nginx ve php-fpm olabilir — Olamaz — cunku php kodumuz php 5.3 uyumlu degil. O zaman debian lenny? Default olarak php5.2 var? Olabilir ancak Php-FPM default repo larda yok? Derleriz. Bosver standart disina cikma. Ok.
\nSonuc: Debian lenny, nginx, php 5.2 (spawn-cgi(lighthttpd)) mysql. Monitor etmek icin nginx destekli Munin. Ok kuruluma basla…<\/p>\n
1-debian lenny vpsimizi hazir edelim, guncel edelim. nano \/etc\/php5\/cgi\/php.ini<\/p>\n en altina ekle<\/p>\n cgi.fix_pathinfo = 1 hata vericek port80 kullanimda diye onemli degil kapat gitsin<\/p>\n update-rc.d -f lighttpd remove<\/p>\n Php FasCGI daemonu calistiralim<\/p>\n \/usr\/bin\/spawn-fcgi -a 127.0.0.1 -p 9000 -u www-data -g www-data -f \/usr\/bin\/php5-cgi -P \/var\/run\/fastcgi-php.pid<\/p>\n bunu \/etc\/rc.local icine ekleyelim ayni sekilde ki reboot ettigimizdede calissin<\/p>\n nano \/etc\/rc.local ve ekle yukaridaki satiri 5- nginx i konfigure edelim<\/p>\n nano \/etc\/nginx\/nginx.conf<\/p>\n onemli 3 ayarimiz var defaut nginx sitemizi konfigure edelim access_log \/var\/log\/nginx\/localhost.access.log;<\/p>\n location \/ { #error_page 404 \/404.html;<\/p>\n # redirect server error pages to the static page \/50x.html # proxy the PHP scripts to Apache listening on 127.0.0.1:80 # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000 # deny access to .htaccess files, if Apache's document root sonra<\/p>\n \/etc\/init.d\/nginx restart<\/code><\/p>\n son olarak duruma bakalim , hersey hazir 6- phpmyadmin kuralim lazim olur repodan gelen phpmyadmin sorunsuz sekilde calissin nginximizde 7- MySQL imizi azicik tweak edelim port = 3306 8- munin kuralim 9- munin nginx monitoring ayarlarini yapalim icine an alta yaz<\/p>\n [nginx_status] [nginx_connection_request] [nginx_request] kaydet cik<\/p>\n \/etc\/init.d\/munin-node restart Gule gule kullanalim olsun da bitsin masallah.<\/p>\n","protected":false},"excerpt":{"rendered":" 1 sitemiz var, uzerinde calisan basit php mysql script ile randevu kaydi aliyoruz. Ama cogu zaman alamiyoruz cunku yogun oldugu zamanlarda anlik 1000 – 1200 request geliyor. apache dayanmiyor, mysql sapitiyor. sonucta site erisilmez oluyor. apacheyi, phpyi tweak etmek , mysqli tweak etmek sorunu cozmuyor. Sorunun cozumu kuvvetli bir vps ve dogru duzgun hafif ve […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-469","post","type-post","status-publish","format-standard","hentry","category-kategerisiz"],"_links":{"self":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/comments?post=469"}],"version-history":[{"count":4,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/469\/revisions"}],"predecessor-version":[{"id":471,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/469\/revisions\/471"}],"wp:attachment":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/media?parent=469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/categories?post=469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/tags?post=469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2-mysql kuralim
\naptitude install mysql-server mysql-client
\n3-nginx kuralim,calistiralim
\naptitude install nginx
\n\/etc\/init.d\/nginx start
\n4-php 5 kuralim
\naptitude install php5-cgi php5-mysql php5-curl php5-gd php5-idn php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-ming php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl<\/p>\n
\n<\/code>
\nDebian Lenny icin FastCGI daemon paketi yok o yuzden lighttpd icindeki spawn-fcgi programini kullanicaz.
\n
\naptitude install lighttpd<\/p>\n
\n<\/code>
\nphp isimiz bitti<\/p>\n
\n
\nworker_processes 5;
\nworker_connections 4096;
\nkeepalive_timeout 2;
\n<\/code><\/p>\n
\n
\nserver {
\n listen 80;
\n server_name _;<\/p>\n
\n root \/var\/www\/nginx-default;
\n index index.php index.html index.htm;
\n }<\/p>\n
\n #
\n error_page 500 502 503 504 \/50x.html;
\n location = \/50x.html {
\n root \/var\/www\/nginx-default;
\n }<\/p>\n
\n #
\n #location ~ \\.php$ {
\n #proxy_pass http:\/\/127.0.0.1;
\n #}<\/p>\n
\n #
\n location ~ \\.php$ {
\n fastcgi_pass 127.0.0.1:9000;
\n fastcgi_index index.php;
\n fastcgi_param SCRIPT_FILENAME \/var\/www\/nginx-default$fastcgi_script_name;
\n include fastcgi_params;
\n }<\/p>\n
\n # concurs with nginx's one
\n #
\n location ~ \/\\.ht {
\n deny all;
\n }
\n location \/nginx_status {
\n stub_status on;
\n access_log off;
\n allow x.x.x.x;
\n allow 127.0.0.1;
\n allow x.x.x.x;
\n deny all;
\n }
\n}
\n<\/code>
\nNOT: burada munin ile daha sonra monitor edecegimizden nginixi uygun status kayitlarinida simdiden ekledik. Hazir olsun.
\nNginx ayari bitti yeniden baslatim bir tanede info.php atip durumuna bakalim.
\n
\nnano \/var\/www\/nginx-default\/info.php ve ekle
\n<\/p>\n
\nhttp:\/\/ip.ad.re.si\/info.php
\nhttp:\/\/ip.ad.re.si\/nginx_status<\/p>\n
\napt-get install phpmyadmin<\/p>\n
\n cd \/var\/www\/nginx-default\/
\nln -s \/usr\/share\/phpmyadmin phpmyadmin<\/p>\n
\nasagidaki my.cnf gayet guzel is goruyor.
\n
\n# The MySQL server
\n[mysqld]
\nwait_timeout=60
\nconnect_timeout=10
\ninteractive_timeout=120<\/p>\n
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\nskip-locking
\nkey_buffer = 384M
\nkey_buffer_size=64M
\nmax_allowed_packet = 1M
\ntable_cache = 1024
\nsort_buffer_size = 8M
\nread_buffer_size = 8M
\nread_rnd_buffer_size = 8M
\nmyisam_sort_buffer_size = 64M
\nthread_cache_size = 8
\nquery_cache_size = 128M
\nquery_cache_limit = 2M
\n# Try number of CPU's*2 for thread_concurrency
\nthread_concurrency = 8
\n<\/code><\/p>\n
\n
\napt-get install munin munin-node
\n\/etc\/init.d\/munin-node restart
\ncd \/var\/www\/nginx-default\/
\nln -s \/var\/www\/munin monitoring
\n<\/code>
\nhttp:\/\/ip.ad.re.si\/monitoring
\naltinda munin hazir calisiyor. 15 20 dakka beklemek gerek dogru duzgun grafikler icin sadece \ud83d\ude42<\/p>\n
\nhttps:\/\/github.com\/perusio\/nginx-munin adresine gidilir download diyip munin nginx plugin paketi indirilir. kurulumun istedigi nginx status isini halletmistik o zaman:
\npaketin icindekileri \/etc\/munin\/plugins altina atalim
\nsonra
\n
\nnano \/etc\/munin\/plugin-conf.d\/munin-node<\/p>\n
\nenv.url=http:\/\/ip.ad.re.si\/nginx_status nginx_status<\/p>\n
\nenv.url=http:\/\/ip.ad.re.si\/nginx_status nginx_status<\/p>\n
\nenv.url=http:\/\/ip.ad.re.si\/nginx_status nginx_status<\/p>\n
\n<\/code>
\ndiyip bastan calistir munini oldu bitti
\nhttp:\/\/ip.ad.re.si\/monitoring altinda nginx lerimizde geldi.<\/p>\n