slywalker/mysql_util

CakePHP MySQL Util Plugin

MySQL Util Plugin for CakePHP2

Using Replication

If action use writing model method, use master., _(*1)

Using UUID in Innodb

CakePHP ignore dammy primary. using dammy primary for mysql writhing performance, _(*2)

How to use

database.php, _(*3)

<?php
class DATABASE_CONFIG {

/**
 * Slave DB Config as defult
 *
 * driver => The name of a supported driver; valid options are as follows:
 *      MysqlUtil.Database/Innodb       - MySQL Innodb,
 *
 * master =>
 * the name that master's config
 *
 * dammy =>
 * the dammy primary field name when it uses uuid primary in innodb
 *
 * @var array
 */
    public $default = array(
        'datasource' => 'MysqlUtil.Database/Innodb',
        'persistent' => false,
        'host' => 'localhost',
        'login' => 'user',
        'password' => 'password',
        'database' => 'database_name',
        'prefix' => '',
        'encoding' => 'utf8',
        'master' => 'master',
        'dammy' => 'added_id',
    );

/**
 * Master DB Config
 *
 * master =>
 * the name that master's config
 *
 * @var array
 */
    public $master = array(
        'datasource' => 'MysqlUtil.Database/Innodb',
        'persistent' => false,
        'host' => 'localhost',
        'login' => 'user',
        'password' => 'password',
        'database' => 'database_name',
        'prefix' => '',
        'encoding' => 'utf8',
        'dammy' => 'added_id',
    );
}

AppModel.php, _(*4)

<?php
App::uses('ReplicationBaseModel', 'MysqlUtil.Model');

class AppModel extends ReplicationBaseModel {

}

Use SQL_NO_CACHE (in SomeModel), _(*5)

$this->getDataSource()->setNoCache(true);

Revert, _(*6)

$this->getDataSource()->setNoCache(false);