Building a LAMP system using Puppet

I have always been interested in sysadmin, however the thing that annoyed me was trying to remember the config file contents. Back in the day when I used to work for Boss Pacific Information Systems, I would find the idea of setting up servers very interesting. In the mean time, the tedious task of remembering which config file to change and what to change was a bit daunting.

Recently, I have been introduced to Puppet script which has been used in my work environment has proven its importance.

“Puppet manages your servers: you describe machine configurations in an easy-to-read declarative language, and Puppet will bring your systems into the desired state and keep them there.”

This tutorial will show you how to create a simple puppet script to build a LAMP system which is the base for any web system. The components required for a web system such as apache, mysql etc are all available as modules from Puppet Forge
Read More

Rough-it up

My mate Mushroom roughing it up at the park this morning. May be its something that comes with white fur, you just want to rough it up and get dirty.

Luckily, today was his grooming day. He had a good clip and bath and this is what he looks like now.
20130818-215444.jpg

Read More

Aww the love

We left our beloved mushroom behind at home for few days to go and explore beautiful cairns. Come back and now he is terrified that we will leave him again and will be gone for few days. So he tries to pull every trick in the book to make us stay home. Breaks my heart :(

This morning he managed to have his face dirty, mind you, this dog is a princess and do not like dirt and being dirty.

PS: we had lovely couple house sit for us and look after Mushroom while we were away.

via Mushroom | Rujuna’s Blog.

Mushroom all groomed

Mushy before his grooming. I still remember the day. He purposefully got dirty so that we would stay home with him ;)

That’s him all clean. He smelt so good but we could hardly recognize him after his make over. Hope we haven’t stolen others’ pet. We just picked which ever was the cutes ;P

PS: he can now see the world without that fur photo-bombing his every vision :)

via Mushroom all groomed | Rujuna’s Blog.

Avoiding offset on tables with high volume data

In web development, it is common to be able to perform some action on each row of a high volume table. The first thing that comes to mind in doing this is fetching rows from the table in batches using LIMIT OFFSET,BATCH statement.

SELECT * FROM `table` LIMIT OFFSET,BATCH;

The flaw of this method is as the offset goes on increasing, it takes that much longer for the database engine to return the result. The reason being the engine has to go though all the rows to find that offset and then return the batch of records.

The solution would be to use a where clause on the primary key instead of offset: Read More

Issues with having underscore in domain name

I have come across wierd hair scratching problems and this is one of them. Turns out, if there is an underscore in your domain/sub domain name, IE stops saving cookies. Which i have already mentioned in my earlier post title ‘IE Why? Why?‘.

Now another issue that I have noticed with underscore in domain is that PayPal will not accept this url as a valid url. So if your site has PayPal processing then it will error out.

All the fun with having underscore in domain names.