Installing Percona DB on a clean CentOS

Percona is a performance optimised fork of MySQL that has gained a lot of traction in the Magento-sphere as webmasters and sysadmins alike look to squeeze the most performance out of their hardware. If you read the Magento performance whitepaper then you will see they mention Percona DB there. To install Percona on a standard CentOS release 6.2 (Final) server you would need to run the following commands: First set up the repo: rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm This should give you output like this: Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm Preparing... Read On →

Tip: PhpStorm "Select in Projects" - Easier version

Followers of this blog will remember the Replicate Netbeans “Select in project” in phpstorm post which gave a handy key combo to select the current file in the project window. It has been brought to our attention that there’s also a button to do this with the mouse in one click! At the top of the Project window, there’s a cross-hair/target icon labelled a rather cryptic “Scroll from Source”. Click that and it does what netbeans users will be looking for as “Select in Projects” So there you have it, “Scroll from Source”, is the magic words that you want.

Tip: Have Git Branch Displayed in Bash Prompt

This is a very small tip, but one that can really save accidents in the long term. To display the current branch in git simply add the following to your .bashrc in your home directory : __git_ps1 () { local b="$(git symbolic-ref HEAD 2>/dev/null)"; if [ -n "$b" ]; then printf " (%s)" "${b##refs/heads/}"; fi } PS1="${debian_chroot:+($debian_chroot)}\[\033[01;32m\]\u@\h\[\033[01;34m\] \w\$( __git_ps1 ) \$\[\033[00m\] " This is based on the Linux Mint prompt so is nicely coloured as well.

Google Apps and Two Factor Authentication

If you are using Google apps and have two factor authentication turned on then you are probably using the convenient “Remember this PC for 30 days” feature. If you like your browser to forget every thing except a very select set of data (bookmarks, etc.) but keep the convenience of the 30 day authentication then you only need to keep the cookie called “SMSV” for the domain “www.google.com” with path “/a”. Read On →

Concrete5 Developer UK

Concrete5 is a CMS system based on Zend Framework that uses Jquery for it’s Javascript layer. Both of these are very popular and powerful frameworks that are really great to work with. The thing that users really love though is the ability to edit Concrete5 pages on the fly making it very easy to use by non techies. You can see the real ethos of the platform (from our techie point of view) here. Read On →

Rsync For Beginners

What is Rsync in general ? Rsync works like the rcp command in linux. It is used to copy files across machines. It uses efficient checksum algorithm that looks for modified files by time and size. It is used for two purposes: Backup Rsync is used to transfer file from the local to a remote machine. By default Rsync will use rsh, however you can instead use ssh for high security. Read On →