How to connect mysql and mongodb databases in yii2 at the same time?

Question

Yii

Actually, this is the whole question, except perhaps how to use them, for example, crud models and Active Record in Google, I tried to find information, but I didn’t really find it. Links and tsyki are only welcome.

Answer 1

'components' => [
    'dbMySQL' => [
        'class' => '\yii\db\Connection',
        'dsn' => 'mysql:...',
        'username' => '...',
        'password' => '...',
        'charset' => 'utf8',
    ],
    'dbMongo' => [
        'class' => '\yii\mongodb\Connection',
        'dsn' => 'mongodb://...',
    ],
],

Yii::$app->dbMySQL->...
Yii::$app->dbMongo->...

Don't forget to override getDb() in the \yii\db\ActiveRecord and \yii\mongodb\ActiveRecord classes to point to these components if you are using ActiveRecords.