The context is that we have a Moodlebox deployed in provinces to conduct flexible learning delivery-- offline. Also, we have a Moodle Site LMS with almost 4 million users.

My question is if it is possible to sync the database of these MBs from provinces to our live Moodle site?

The purpose of this is to monitor the implementation of the Institutions in the provinces.

Could this be possible? If yes, please enlighten us.

Thank you very much!

    Unfortunately, this feature (synchronize the database of several Moodle instances) is not available in Moodle. And as MoodleBox provides a standard Moodle instance, this is also not directly possible in MoodleBox.

      Kawaii As you already heard the general case is not possible. This is not limited to Moodle, it is the way the underlying (relational) databases work. When they grow independently, in different sites, they grow differently. Take auto-increment keys, for example. During merge they'll conflict with the original, the mother Moodle.

      That said, with a deep understanding of the meaning of the data, a developer could translate the data in the satellites to fit the mother ship, in theory at least. That is partly what happens in Moodle https://docs.moodle.org/en/Course_restore with user data. For details see the discussions https://discuss.moodlebox.net/d/27-a-pool-of-moodleboxes-an-idea/, https://discuss.moodlebox.net/d/243-update-and-fleet-management/, https://discuss.moodlebox.net/d/299-deploying-moodlebox-in-a-hybrid-internetlan-environment/, etc.

      But for special/limited cases, there may be simple solutions. You could experiment with full https://docs.moodle.org/en/Course_backup at the sites and full https://docs.moodle.org/en/Course_restore in the mother Moodle, always overwriting, for a one-way "merge". Just a thought, never tested.