How to work with 2 bases?

Question

Yii

For example, I have 1 site, it is required that when adding a new record, this record is automatically added to another database, the problem is that hosting can be different or what is an alternative solution? I need to get sales statistics for each site.

Answer 1

The easiest way is to write a rest-api, and with any change on one site, pull the api on the second. Yes, and to obtain sales statistics, this is the most reasonable option.
By means of yii it is easily implemented.