Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For an unnamed master connection and a single slave database

No Format

$db_url = 'mysqli://user:password@master-host/database';

$db_slave_url = 'mysqli://user:password@slave-host/database';

...

Info

When multiple slave databases are available, Pressflow randomly picks one to use for each request.

No Format

$db_url = 'mysqli://user:password@master-host/database';

$db_slave_url = array();
$db_slave_url[] = 'mysqli://user:password@slave-host-1/database';
$db_slave_url[] = 'mysqli://user:password@slave-host-2/database';

...

Info

Slave databases can also be configured for the non-default connection, but they're unlikely to be used.

No Format

$db_url = array();
$db_url['default'] = 'mysqli://user:password@master-host/database';
$db_url['another'] = 'mysqli://user:password@another-host/another-database';

$db_slave_url = array();
$db_slave_url['default'] = 'mysqli://user:password@slave-host/database';

For an named master connection and multiple slave databases

No Format

$db_url = array();
$db_url['default'] = 'mysqli://user:password@master-host/database';
$db_url['another'] = 'mysqli://user:password@another-host/database';

$db_slave_url = array();
$db_slave_url['default'] = array();
$db_slave_url['default'][] 'mysqli://user:password@slave-host-1/database';
$db_slave_url['default'][] 'mysqli://user:password@slave-host-2/database';

...