README

behance/nbd.php-dbal

There are million of database adapters out there. But very few tick all (our very specific) boxes

Goals

1. Very minimal dependencies, to be used in very diverse environments
2. Make every attempt to shield connection and management logic from implementer
3. Support master + many-slave replication patterns
4. Semi-intelligent connection choices:
   • Writes automatically choose master
   • Read queries randomly choose a single replica connection per request, unless...
   • Choosing a master connection at any point in the lifecycle will always use it going forward
   • Loosely follows Doctrine's tenets @see http://www.doctrine-project.org/api/dbal/2.0/class-Doctrine.DBAL.Connections.MasterSlaveConnection.html
   • [NEW] When connection retrievals include a table, master connection rules are segmented by table, with automatic fallback behavior when not specified.
5. Out-of-the-box convenience support for CRUD operations, accessors, and fallback to raw SQL (works with other SQL generators as well).
   • Automatic conversion to prepared statements for convenience parameters
6. Automatic retries for "mysql gone away" in long-running crons, workers, scripts
7. Provide deep introspection with events

Usage

use Behance\NBD\Dbal;

$config['master'] = [
    'username' => 'admin',
    'password' => 'password',
    'host'     => 'db',
    'port'     => 3306,
    'database' => 'dbal_test',
    'driver'   => 'Pdo_Mysql'
];

$config['replicas'] = [
    [
        'username' => 'admin',
        'password' => 'password',
        'host'     => 'replica',
        'port'     => 3306,
        'database' => 'dbal_test',
        'driver'   => 'Pdo_Mysql'
    ],
    //[
    //    ...add as many slaves as necessary
    //]
];

$db = Dbal\Factory::create( $config );

Testing

Unit testing:

1. composer install
2. ./vendor/bin/phpunit

Integration testing: leveraging Docker, using actual mysql container

1. docker-compose up -d
2. docker exec -it nbdphpdbal_web_1 /bin/bash
3. cd /app
4. ./vendor/bin/phpunit

Operations