phalcon multible mysql instances

[RaitKivinurm]

Hi,

Is it possible to use multiple MySQL instances in the Phalcon PHP framework like so if one not answering, query same from other servers?

[Jeckerson]

Hello

You will need to register several separate services, here is example:

$di->setShared('db1', function () {
   return new Mysql($db1Configs);
});

$di->setShared('db2', function () {
   return new Mysql($db2Configs);
});

And then use inside the code:

$this->db1->query('SELECT * FROM db1_table');
$this->db2->query('SELECT * FROM db2_table');

And if you want separate connection inside each model:

class User extends Model
{
   public function initialize()
   {
        $this->setSource('users');
        $this->setSchema('db1_schema');
        $this->setConnectionService('db1'); // or db2
   }
}

[quasipickle]

It is also possible to create a generic DB connection service:

$DI->set('db_other',function($host,$db,$username,$password,$charset = 'utf8'){
    return new \Phalcon\DB\Adapter\Pdo\Mysql([	
        'host'		=> $host,
        'dbname'	=> $db,
        'username'	=> $username,
        'password'	=> $password,
        'charset'	=> $charset
    ]);
});

Used with:

$DB = $this->di('db_other',['host name','db name','username','password']);

I'm not sure if this approach could be used to set the connection service for a model though.