I have a problem that became apparent last week. I have been using moodle since this summer and as such we have a large database (over 22meg). Last week the company I was hosting with deleted the entire server.
When I finally found new hosting and I tried to reload the dump I could not do so because of size. SO I spent significant time breaking the dump into many smaller files (almost seventy!). We have way to many courses to use the backup and restore on a whole site (over 200 courses). But a nice solution would be to run moodle on two or more sites simultaneously with regular syncronation. SO that one site serves as a operating backup copy and a mirror site in case the first server is overloaded or dies. I lost almost a month trying to relaunch moodle because of the backup dump size of the database.
Has anyone done this? If so would there be a way to have a purely circular replication of sites without crashing because of data insertion conflicts? In other words could one use site a which then replicates to site b, but if anyone uses site b it also would replicate to site a?
Reasons to do this: increased security, faster server speeds, continuous backup, and reduction of server load.