I have a client with a LAMP website mainly using video. Currently, it is on the same server with all components. He has problems with scaling. What are some of the methods that can be used to help.
I used to split the database to another server with GB Ethernet between it and the web server. Perhaps adding more web servers with some load balancing and additional MySQL servers with replication?
I would like some medium, large, super-large examples of how to scale, if possible.
The video actually comes in as jpg images. Compatible with this site:
http://www.webcams.travel/webcam/1170170095
And add some details. I believe that the maximum number of visitors per hour will be 1000, and I think it would be lucky to have this. Maybe closer to 1000 per day.
Tips on CloudFront and MemCache, etc. - All this is good, if we assume that they determine the root of your performance problems.
On the database side: Profile, profile, profile. Transferring the database to a separate server was (probably) a good step, but if you did not profile the queries running on this database instance, you do not know what you need to improve.
Start with EXPLAIN for the most common queries and check by making unnecessary sequential scans on large or growing tables. Indicate the index if necessary.
- , , ?
, , / ? .
MyISAM? , InnoDB, - ( MyISAM).
, - , , - .
, , , , . , :
. , .
, HTML/ . , , HTTP.
- Memcahce HTML- .
" ", CDN. , .
.
, : .
-, . .
- ( ), , .
, MySQL - , .
, , .
, - (, , ...) .
- , - , memcached, - ..
, Amazon CloudFront, . , .
, Livejournal Facebook , , , .
, - PHP, - xdebug, . , , memcached .
-, MySQL, MySQL (log_slow_queries my.cnf); , , , , EXPLAIN < > , . , , . my.cnf, . log , .
-, , Firefox Firefox - (, , , , , .. ..). , , - ( JS, , flash...).
, , -, , (.. - , ?).
, , ...