What is the best way to organize database synchronization?

Question

CMS

Hello. There is a task to make several stores that will have the same database of goods (the stores will have one cms) so what do you think is better? Make one database and connect the necessary sites to it, or make, for example, a bot that will check if there are changes in the main database, and if so, then you need to go through the necessary databases and make changes there? and I also ask you to tell me which cms is more suitable for this, the main task is the ease of change and scaling, I think about opencart, but there are some doubts about the ease of working with it)

Answer 1

one db.
crap with bots - not needed.
for example, Drupal can do this - some of the tables in the database are common, and some of the tables so that each site has its own