June 19, 2013

Post: Pitfall of proxying HTTP requests through Lighttpd

… a little bit. As I already mentioned it was about web servers. Each of them was running Lighttpd that handled the…. The requests asking for PHP files were passed down with proxy module to Apache listening on another TCP port. And so… will appear with much smaller data being sent through Lighttpd proxy. For example with a PHP script for handling larger file…

Post: Lighttpd as reverse proxy

… actual directory with web documents Uncomment next lines in lighttpd.conf server.modules = ( … “mod_auth”, “mod_status”, “mod_proxy“, … ) mod_status is… to protect mod_status from unauthorized access :) and mod_proxy is proxy by itself to enable status uncomment or add status.status…”] !~ “\.(js|css|gif|jpg|png|ico|txt|swf|html|htm)$” { proxy.server = ( “” => ( ( “host” => “127.0.0.1″, “port” => 8080 ) ) ) } This actually…

Post: Speedup your LAMP stack with LigHTTPD

… typically allow you to relieve Apache from serving static content – Proxy may be configured to handle only dynamic requests, serving static… IP passed by your local proxy. So now you can put reverse proxy infront of your Apache web server in 10 minutes and…: Persistent connections to FastCGI servers Keep alive from Reverse proxy to web server Async IO for serving large large files The good…

Post: State of MySQL Market and will Replication live ?

… for Market talks, my interest is market of Web Applications in general. Clearly web is not enterprise and has a lot of… MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy to help with sharding or dealing… next big innovation to happen, when it comes to Web applications. Web applications concepts operate with concepts which are not very efficiently…

Post: Announce: Front End Performance Optimization

… driven web site its properties will likely depend on a lot of factors – good web side configuration, which is about caching, proxying, using multiple data centers or CDN, serving static content reliably and efficiently. Then it comes to efficient web application architecture…

Comment: MySQL Sizing questions

… we have 6K of visits daily. This cluster include: 2 Web Servers with Port:100Mbps, i7 QuadCore- 2.93 Ghz H… of Bandwith. This servers active-active controlled by loadbalancing HA proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled by load balancing using HT proxy. MySQL installed. 2 load balancing servers Celeron 2.4 Ghz…

Comment: Slow Query Log analyzes tools

MySQL Proxy is good but it can’t give you some information – for example number of rows examined which is quite hanly to have. Plus for serious web sites I think minor patch is less intrusive then putting Proxy infront to handle your queries which has unknown overhead and potential side effects.

Comment: Why do you need many apache children ?

… – the http acceleration software (varnish, squid, oops, etc.). If a proxy server is forbidden to cache any data, it becomes nothing… performance and resources utilization. Furthermore, it takes out from the web server any need of dealing with slow clients or being… even the loopback interface, both fast enough). Thus the revese proxy becomes something of a seawall, which protects all the resources…

Post: Automation: A case for synchronous replication

… first think about properties of simple components we fail over – web servers, application servers etc. We can put these behind some… MySQL Cluster) in the same way as you work with web servers – any of them can accept and handle connection, you… case which allows to use simple solutions such as HA Proxy with these technologies – node is either part of the cluster…

Post: Are PHP persistent connections evil ?

… or possibly not willing to spend enough time to optimize Web part of configuration. Thousands of concurrent connections usually result from… spoon feeding. You can place squid in front, use apache proxy module or even use lighttpd with FastCGI all can fix… even should get fresh connection ID so if you track web requests in MySQL Logs by connection ID it would still…