Submitted by richard on December 4, 2009 - 12:19am

You want to scale your Solar Framework application with minimal amount of work, one way to do this is to use Solars MysqlReplicated adapter. This adapter directs all SELECT related queries to the configured slaves, all other queries and transactions go the the master server.

You can even use this adapter during development by using different usernames for each server. This will replicate a real world setup. I think its also important to use specific "read" and "write" users with permissions to match.

This is important because it makes sure no write queries end up being performed on your slave servers even if you have a code error or run into some weird bug in Solar. NEVER, EVER, EVER connect to your Slave servers with write permissions unless you 100% have to.

Anyway on to the example configuration to make this happen.

$config['Solar_Sql']['adapter'] = 'Solar_Sql_Adapter_MysqlReplicated';

$config['Solar_Sql_Adapter_MysqlReplicated'] = array(
    'host'  => '127.0.0.1',
    'port'  => null,
    'user'  => 'writeuser',
    'pass'  => 'password',
    'name'  => 'database',
    'slaves'    => array(
        0   => array(
            'host'  => '127.0.0.1',
            'user'  => 'readuser1',

        ),
        1   => array(
            'host'  => '127.0.0.1',
            'user'  => 'readuser2',
        ),
    ),
);