Hi there :)
This request could also be applicable to other supported databases that support master/slave replication.
Basically, codegen would be modified to allow definition of master and slave db connections. Codegen is performed on the master db only and then slave connection used for the Load() methods (check for records on slave first, then master if not found). Save() and Delete() methods would then only use the master db connection for queries.
Any comments on this?
Cheers :)
V57
PS: slave definition(s) could also be a weighted array within the master db connection containing locations and credentials:
<?php
// snippet...
define('DB_CONNECTION_1', serialize(array(
'adapter' => 'MySqli5',
'server' => 'masterserver',
'port' => null,
'database' => 'database',
'username' => 'user',
'password' => '******',
'profiling' => false,
'slaves' => array())));
// end...
?>
.bc