Working with two databases?

Question

MySQL

We use 2 databases, one is spinning on mysql, the second on postgre.
Now I began to bring all the writings to the mvc model, I would like to see successful implementations of working with 2 different databases in other people's projects. Submit links.

Answer 1

The same yii works with at least a dozen.

Answer 2

Take a look at Doctrine. There on each connection there is entity manager. We take out the logic for working with the database in the service layer (any data providers or a record manager) and that's it. Depending on what is needed, the service uses its own connection.

Answer 3

I wonder what the downside is? If the answer to the question is obvious, it is necessary to share, for this the questions section was created. And so - childishness.

Answer 4

Fesor, you are right. In mysql, subscribers and payments, in postgre - equipment database, geodata, zabbix