Month: August 2011

  • CodeIgniter/ActiveRecord setup to use master + slave db replication

    This is how you can set up CodeIgniter to direct mysql queries to different read/write hosts in your db replicated environment, using a db_slave for your SELECT’s, and a db_master for the INSERT/UPDATE/DELETE queries. File: application/config/database.php Specify the different database hosts in the database config file: < ?php if ( ! defined(‘BASEPATH’)) exit(‘No direct script…

  • Fetching WordPress content from CodeIgniter

    In a few recent projects we’ve used the excellent WordPress admin for content entry, but built the public facing stuff in CodeIgniter. Making these platforms talk to each other is fairly simple, and this is what we’ve learnt along the way. – Do not, ever, initialize WordPress to fetch the data. WordPress is quite the…