Got the chance to mess around with Amazon EC2 console. And was really amazed on how fast setting up a server with AMI(Amazon Machine Image) is. Just browse from already existing thousands of AMI then launch. That simple.

One experience though that I don’t like somehow are that these LAMP AMIs seems a little flaky. I was looking into CentOS LAMP AMI. First thing I do after connecting to SSH on the instance is check if all LAMP is working and what version they are on.

First AMI I selected, apache restart doesnt work properly, I get the

apr_sockaddr_get_info() error

tried troubleshooting it then finally quit. Terminated the AMI and launched another one.

Then on the next other instances I can’t connect to MySQL but Apache and PHP are working right.

Been using WAMP for several months now and once in awhile MySQL breaks. Somehow the user tables gets corrupted. To fix the problem instead of reinstalling the whole WAMP. Just replace the corrupted files. These 3 files are always corrupted.

Digging deeper to the culprit I found out the tables for users in the mysql db has warnings, meaning they are corrupt. So to avoid doing the steps above while your MySQL and phpMyAdmin is still working. Go to phpMyAdmin, access mysql db, then select users table then click on operations then under “Table maintenance” click on Repair Table. Viola!!!