Fixing High I/O usage on Amazon EBS

This humble wordpress blog is running on an AWS micro instance. We’ve got somewhere around 1k visitors each month, which is pretty awesome. But… to my surprise, the whole system is using over 14 million I/O operations.

I suspected there was something wrong with this… so i proceeded to do a small research.
By means of the application ‘iotop’, i managed to spot the I/O hog: apache!.

Specifically, i ran iotop with the following parameters:

[cc lang=”bash”]sudo iotop -a -P[/cc]

I ran a quick search on google, and found this post.  (Thank you George, for sharing your solution!).

Long short story, Apache’s APC plugin was using a memory mapped file, and it was writing… almost all the time.
The solution?. Edit your /etc/php.d/apc.ini file, and make sure that the mmap_file_mask parameter is se to use Shared Memory, as follows:

[cc lang=”bash”]apc.mmap_file_mask=/apc.shm.XXXXXX[/cc]

That should fix it!

Installing a Webserver on AWS EC2

I’ve recently lantean.co to AWS EC2. Amazon offers a free EC2 instance for a year…. so i decided to give it a shot.

The main reason i had to migrate to a self managed hosting is simple. Shared Hostings don’t allow you to fine tune several settings, such as the PHP Memory, and you might event not be able to login using ssh. What did i need to do?. It’s simple… let’s see…

 

Setting up the Environment

  1. Signup at Amazon Web Services. You’ll need a credit card.
  2. Create a new EC2 instance. Select ‘Micro’ as the type.
  3. Select the Amazon AMI. (I don’t trust 3rd party images!).
  4. Follow the wizard, and generate the SSH private / public keys.
  5. Setup the firewall, so only IP’s in your C class can connect through SSH, and everyone can hit the port 80.
  6. Connect to your box![cc lang=”bash”]ssh -i certificate.pem ec2-user@[elastic-ip][/cc]
  7. Setup a password for your root user[cc lang=”bash”]su passwd[/cc]
  8. Install Apache[cc lang=”bash”]yum install httpd
    service httpd start
    chkconfig httpd on[/cc]
  9. Install PHP[cc lang=”bash”]yum instlal php php-mysql[/cc]
  10. Install mySQL[cc lang=”bash”]yum install mysql-server
    service mysqld start
    chkconfig mysqld on[/cc]
  11. Secure mySQL[cc lang=”bash”]mysql_secure_installation[/cc]
  12. Install APC[cc lang=”bash”]yum install php-pecl-alc[/cc]

 

Setting up Apache

Assuming we’re not gonna host just a single website, but a couple of them… we’re gonna need to setup Virtual Hosts. With VirtualHosts you can serve as many domains as you need, using a single apache installation. Steps!

  1. Log into your instance and type… (replace domain.com with your own domain):
    [cc lang=”bash”]
    su
    mkdir -p /var/www/domain.com/public_html
    mkdir /etc/httpd/conf.d/domain.com.conf
    nano /etc/httpd/conf.d/domain.com.conf/httpd.conf
    Add the following lines:


    ServerAdmin your-mail@domain.com
    DocumentRoot /var/www/domain.com/public_html
    ServerName www.domain.com
    ServerAlias *.domain.com
    ErrorLog /var/www/domain.com/error.log
    CustomLog /var/www/domain.com/requests.log combined

    [/cc]

  2. Enable htaccess in your virtual hosts:

    [cc lang=”bash”]nano /etc/httpd/conf/httpd.conf
    AllowOverride All[/cc]

  3. Enable logrotate:
    [cc lang=”bash”]
    nano /etc/logrotate.conf
    Add the following lines:

    /var/log/httpd/*log
    /var/www/*/*log
    {
    size 5M
    missingok
    notifempty
    sharedscripts
    delaycompress
    postrotate
    /sbin/service httpd reload > /dev/null 2>/dev/null || true
    endscript
    }
    [/cc]

 

Setting up mySQL

At last!. Let’s see how to create a mySQL database, add a new user, and how to import your mySQL dump, using nothing but bash.

  1. Create a new database and a new user
    [cc lang=”bash”]
    mysql -u root -p << You will be asked for your mySQL root-password! create database wordpress; create user 'wordpress'@'localhost' identified by 'password'; grant all privileges on wordpress.* to wordpress@localhost; flush privileges; [/cc]
  2. Import a database dump
    [cc lang=”bash”]
    mysql -p -u wordpress wordpress < database_dump.sql [/cc]

 
I hope you found this short guide helpful!

SSH SFTP Updater : “Private key incorrect for user”

If you’re using WordPress SSH SFTP Updater plugin, and you got the error “Private Key is Incorrect for use”… even when the keys are correct, check the following:

[cc lang=”bash”]nano /etc/ssh/sshd_config[/cc]

If there is a “ForceCommand internal-sftp” directive, somewhere, in sshd’s config, try disabling it. That was what was causing me issues:

I had an sftp-only user, and the WP plugin doesn’t support that!.

Dropping a MongoDB Database

I’m writing this down, riiight here, because i just got bored of searching this in google everytime i need to run an experiment.
If you need to drop a mongo database, just fire the mongo shell and type:

[cc lang=”javascript”]
use mydb;
db.dropDatabase();
[/cc]

That’s it!

%d bloggers like this: