The method setSessionInitSql() adds to the list of SQL statements that are executed as soon as an ADOdb database connection is established and added to the connection pool. There is no limit to the number of statements that can be added to the list. The method must be called after the load balancer object is instantiated but before the ADOdb object is added to the pool. The statements are executed in the order that they are added to the list.

$db = new ADOdbLoadBalancer;
 
$db->setSessionInitSql('STATEMENT 1');
$db->setSessionInitSql('STATEMENT 2');
 
$driver   = 'mysqli';
$database = 'employees';
$user     = 'adodb';
$password = 'adodb';
$host     = '192.168.0.200';
$db_connection_obj = new ADOdbLoadBalancerConnection( 
    $driver,
    'write',
     10, 
     false, 
     $host, 
     $user, 
     $password, 
     $database ); //Master with weight of 10