Tag: replication

  • 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…