1. Quick Comparison While SQL databases are insanely useful tools, their monopoly in the last decades is coming to an end. And it’s just time: I can’t even count the things that were forced into relational databases, but never really fitted them. (That being said, relational databases will always be […]
In a MySQL Replication based system, How to migrate a master database to another server/host? Scenario in short goes: dump out master databases, import data on the new master server and point slave to the new master server. If you follow this simple steps, master migration should proceed without problems. Export databases from […]
Windows 8 isn’t just missing the Start Orb or the ability to easily restart/shut down the PC; there are certain other elements that Microsoft either decided to bury deep within the settings, or omit altogether, when compared with Windows 7 and earlier iterations of the operating system. Among them is […]
Virtualmin is a powerful and flexible web hosting control panel for Linux and UNIX systems based on the well-known Open Source web-based systems management GUI, Webmin. Popular web server associating with PHP-based application is Apache, but Nginx is also a good replacement for high-traffic websites. This article discusses about how to […]
This article discuss how to do full page cache with nginx and memcache. Since the cool kids at Google, Microsoft and Amazon researched how performance and scalability affect conversion rates, page load time has become the topic of every eCommerce store. Magento was once a resource hog that consumated everything […]
When you are using MySQL, you will (likely) have tables that can be fragmented. Fragmented tables in mysql needs to be optimized. You could simply OPTIMIZE every table in every database, but during an OPTIMIZE, the tables are locked, so writing is not possible. To minimize the time that MySQL […]
CSF (stands for ConfigServer Security & Firewall) is a Stateful Packet Inspection (SPI) firewall, Login/Intrusion Detection and Security application for Linux servers. This note mentions some snippets for configuring this software. To deny/allow incoming/outgoing ports, change the configuration file csf.conf To remove an IP from temporary ban list, remove it from csf.tempban To […]
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 […]
The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance: InnoDB is newer while MyISAM is older. InnoDB is more complex while MyISAM issimpler. InnoDB is more strict in data integrity while MyISAM is loose. InnoDB implements row-level lock for inserting and updating […]
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets. This article shows how to install Redis to work with Linux-based PHP development environment. Installation and Configuration Download and […]