Mirroring live site vs backup restore

Mirroring live site vs backup restore

Mark Fellowes發表於
Number of replies: 3

Community

What is the preferred backup method.? Script or Third Party Software.?

We currently run a Moodle 4.1.14 Build (20241011), Php 8.0.30, MySql 8.0.36 and was kindly provided a script by Ken (Thanks heaps Ken) to backup our Site which we do manually and via a Cron Job.

What I want to do is either backup the site (existing process) and send to another sever to then load into a fall back site automatically

Or

Mirror the production site to the fallback site on each update from a student or change to the environment.

I can see a overhead to the server of having the site mirrored to another site, but this gives a almost setup and forget solution. Apart from when the site goes down, and we need to redirect traffic (Students) to the new site. 

We have on average 100 - 150 Students per day (unique logins) doing their studies and uploading.

I should note that we keep "Forever all students, and course content". The size of the Database is 2.5gb, Moodle Code is 11gb, Moodledata is 11gb

Thoughts on these or another solution.

評比平均分數: -
In reply to Mark Fellowes

Re: Mirroring live site vs backup restore

Ken Task發表於
Particularly helpful Moodlers的相片

Under thoughts ...

So like a 'failover'?
One could progressive rsysnc to the failover server code + moodledata minus the config.php file for a site, but ... DB would be an issue ... don't think it wise to rsync raw DB files.

DB could be setup with source/replicant however.  (I've read about that but no first hand experience).

https://dev.mysql.com/blog-archive/mysql-terminology-updates/

There is a plugin you might explore:
https://moodle.org/plugins/tool_vault

And the 'catch 22' to this is CloudFlare ... CF is done with DNS.  Does CF have a 'failover' setup?

https://www.cloudflare.com/learning/performance/what-is-server-failover/

And, one more thought ... the more complicated one makes a step up, the less help one should expect from Community Forums as most folks wouldn't have such a setup.

'SoS', Ken

In reply to Ken Task

Re: Mirroring live site vs backup restore

James Steerpike發表於
Particularly helpful Moodlers的相片
Replicating the database to an offsite server would be a nice little project. The second server stays offline, and the transaction log is transferred across instead of being cleared when full. At least that is what I remember from something i did years ago on a Linux box running a different database.