What is the best way to organize work with two databases?

Question

PHP

Good afternoon!
So here's my problem.
There was one database, so they made two of it!
One stores logs and stuff, the other stores more important data.
How to organize work better? What patterns to use? What to read?
Thank you all for your attention

Answer 1

You can try to abstract at the ORM level, if there is one - i.e. objects of some classes are retrieved through one connection to the database, others - through another. If you write SQL queries yourself, then there is nothing to think about - you structure the code as you think natural, and somewhere in some class or controller (for example, Logger) store the necessary connection to the database in the field. In another module/class, it's different.

Answer 2

You create two classes responsible for connecting to the database, depending on which database you need - use one or the other. The specific implementation depends on the used database, PL, framework, etc.)