From the monthly archives: July 2012

MySQL – Recover Data Using mysqlbinlog

By On 30 July 2012 · Leave a Comment

Our company just launched a new shopping cart web application and currently is under user acceptance phase. Last night, they discovered one bug which cause the payment not synchronize with the sales order data. They thought that it is a fault transaction and proceed to delete the data to synchronize the payment back.

Now they [...]

Continue Reading →

BASH: Some of My Looping Command Collections

By On 26 July 2012 · Leave a Comment

Here are several of my BASH commands collection related to looping which I frequently used. This list will be always updated for reference and knowledge base.

1. Copy .htaccess file under /home/website1/public_html to all directories and sub-directories under /home/website2/public_html excluding .svn directories:

cd /home/website2/public_html for i in $(find -type d | egrep -v .svn); do cp [...]

Continue Reading →

CentOS: Configure Piranha as Load Balancer (Direct Routing Method)

By On 20 July 2012 · 19 Comments

I am currently working on a web cluster project using CentOS. In this project, I have 2 web servers running on Apache and mounted the same document root to serve the HTTP content. I also have 2 servers in front of it to become the load balancer and failover to increase high availability of the [...]

Continue Reading →