As you may know, I started working with high load MySQL servers in 2010 (and then there are several entries that were noted in 2012 after I purchased back this domain :-D) and I mostly go with multi-slaves replications. These might be true in many practical cases where most of […]
Website Performance
These days I have been working with scaling solutions for a PHP framework. Previously I came with Nginx as load balancers, however, with the requirement of health check and failover, I need to come to HAProxy this time. So I write this entry as a note for installing HAProxy with SSL […]
First, we must keep in mind that the SaaS application architecture must support multi-tenant from beginning, otherwise we will struggle with scaling the application in the future. Application architecture level We must consider careful which is needed to separate: application, database, or what other else? It should use the same […]
When designing the scalable systems which can run on multiple nodes, one common problem to face is how to deal with scheduled tasks which must be run on one instance, not in multiple instances. When checking the AWS architecture for a team working on AWS, I found a problem of […]
This article was original written by By Eli White and was published at http://www.oracle.com/technetwork/articles/dsl/white-php-part2-355138.html. This includes tips for scaling your PHP-MySQL Web app based on real-world experiences at Digg, TripAdvisor, and other high-traffic sites. In Part 1 of this article, I explained the basic steps to move your application from a single server to […]
This article was original written by By Eli White and was published at http://www.oracle.com/technetwork/articles/dsl/white-php-part1-355135.html. This includes tips for scaling your PHP-MySQL Web app based on real-world experiences at Digg, TripAdvisor, and other high-traffic sites. Creating a Web application – actually writing the core code – is often the initial focus of a project. […]
APC stands for “Alternative PHP Cache”. APC is a free, open, and robust framework for caching and optimizing PHP intermediate code. This article shows common problems when installing APC and how to fix them. Installing is as simple as [root@search ~]# pecl install apc [root@search ~]# echo “extension=apc.so” > /etc/php.d/apc.ini […]
Whenever analysts or journalists assemble lists of the top trends for this year, “big data” is almost certain to be on the list. While the catchphrase is fairly new, in one sense, big data isn’t really a new concept. Computers have always worked with large and growing sets of data, […]
According to the book High Performance Web Sites: Essential Knowledge for Front-End Engineers by Steve Sonders, and at BEST PRACTICES FOR SPEEDING UP YOUR WEB SITE, there is a best practice for boosting front-end performance as follows: The problem caused by scripts is that they block parallel downloads. The HTTP/1.1 specification suggests […]
This post explains how to add a new slave to the existing MySQL replication. New slave server can be added to the MySQL replication without stopping master or shutting down existing slave server. You will have to temporarily stop replication on the slave server in order to take the current […]