How to sync database of MB to Moodle LMS hosted on AWS?

Kawaii

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!

Ratna

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.

danmcguire

Kawaii

I have a similar situation although the size of the Moodle site in the cloud is much smaller. The cloud site is a MoodleCloud site. We have three schools in the Northern Region of Ghana running MoodleBox; one of them is just beginning so they have nothing to report, yet. The other two have only one Moodle course for 25 students each. Periodically, once every two months, so far, the teachers back of their courses and send me the course file which I then upload to the 'main' Moodle site on the MoodleCloud site. So far, the uploads are individual courses.

Our current problem is determining what reports to run from each course backup so that we can compare utilization from period to period. We are primarily interested in teacher activities on the course and student activities on the course.

This is not an automated system, but I'm fine with that. After we determine which data from the courses is most useful, we can focus on making the process of collecting the data and merging it with a larger database of teacher and student activity.

Nicolas

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

Nicolas Thank you for confirming this. Very much appreciated.
🙂