Coder Insights

Blogs by Others: http://www.sqlpronews.com/2010/0511.html http://mossiso.com/2012/07/24/backing-up-mysql-with-replication-and-incremental-files-part-1.html http://clean-clouds.com/2012/03/22/1785/ Leading Authority on MYSQL backups: http://www.xaprb.com/blog/?s=incremental+backup Different Methods: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html QUESTIONS TO ASK BEFORE ADOPTING A TECHNIQUE: http://www.mysqlperformanceblog.com/2009/03/03/10-things-you-need-to-know-about-backup-solutions-for-mysql/ Questions on stackoverflow: http://stackoverflow.com/questions/4411057/how-to-do-a-incremental-backup-in-mysql Example Implementation: http://standish.home3.org/mysql-backup Cautions and Dangers: http://www.mysqlperformanceblog.com/2009/05/14/why-mysqls-binlog-do-db-option-is-dangerous/ Commands: http://linuxcommand.org/man_pages/mysqldump1.html http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog.html Must Knows: http://dev.mysql.com/doc/r...

Resources: Wikipedia has a good article on design patterns. The C2 Wiki is another good place to look for information about design patterns like observer , singleton , and more. The original Design Patterns book is a must-read for any engineer. O'Reilly's Head First Design Patterns is a lighter-weight way to get into design patterns. The book PHP Hacks has several hacks for design patterns that extend beyond the examples shown here. See the developerWorks article " Five more PHP design patterns " to learn about five additional design patterns that you

Install Phing The best way to download and install phing is using PEAR . This can be done on Linux or Windows assuming you have the pear script in your PATH with three shell commands. shell> pear channel-discover pear.phing.info shell> pear config-set preferred_state beta shell> pear install [--alldeps] phing/phing Example Application structure As an example, we’re going to develop a simple application with the following directory structure. example/ |-- db/ | `-- deltas/ |-- deploy/ | `-- scripts/ |-- library/ `-- public/ The db directory contains sql files for using and manipulating our database and the deploy directory contains our build scripts that set the migrations in motion. The library directory contains our application code and the public folder will contain scripts and files accessible directly from the web, but will not be the focus of this article. Build scripts This section shows you how to develop the build scripts that will run ...

As a Dev, Every day we come across some interesting links. I will be jotting down such interesting links every week with the tag " Useful Links " 15 surefire ways to speed up your website CSS3 vs CSS HTML5 standards 8 Current Technologies That Will Shape Our Future Making Facebook Self Healing Scribe - server for aggregating streaming log data   HTTrack - Website Copier

Nginx is a high performance HTTP server. It provides very fast speed of delivering web pages, and uses fewer resources at the same time. With Nginx (Pronounced Engine X) A server with low resources will be able to serve many more clients, due to this, many popular websites use this (To conserve their resources, of course). In this blog post, I am going to discuss how to install Nginx, along with PHP, and MYSQL. You will need to follow very close attention to this article, else, one mistake and you may need to restart all over again. The first thing you will need to do of course is own a VPS/Dedicated server. You will also need to have an SSH Client (Putty), and your username and password. If you have all of this, the first thing you need to do is login to your panel, and rebuild the server with some version of CentOS (it does not matter what version, really). Once you have done so, login to your SSH client, supplying the required information. Next, we are going to begin the actu...

Speed is Essential for a Great Web Experience (Canvas Conf Version) from Andy Davies