Databases: Moodle Cluster

Databases: Moodle Cluster

by emanuele della torre -
Number of replies: 4

Hello, finally my moodle now, is workin ..... quite good wink

My target now is to have two specular sites, to increase business continuity, like disaster recovery..

i did an exact copy of the site to another on. It's simpl, just change config.php, how to take DB(1) and DB(2) automaticaly exuals...to have  better recovery points?

In my mind that would be nice to have an agent such as cron that starts a script to match DB(1)-->DB(2) on the different sites.

May i'm speaking about nonsense......

any idea?

EDT

Average of ratings: -
In reply to emanuele della torre

Re: Databases: Moodle Cluster

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Look into database replication, that's the best way:

http://dev.mysql.com/doc/refman/5.0/en/replication.html
Average of ratings: -
In reply to Martin Dougiamas

Re: Databases: Moodle Cluster

by emanuele della torre -

yes, thanks for the answer. i have read it. also if i'm not an expert in mysql, i may understand, reading,i need some settings to do on mysql server machine for EX: "For replication to work you must enable binary logging on the master...." 

"i think" may in error, that such settings cannot be done on a hosted site. (now i'm gonna check).

So, i was thinking about some php code to read by the net the two db, and make a refresh of the second with information of the first. with cron, make it happen scheduled.

I want to try (i think will be a hard thing) to search information on how to ... and if possible with php. if yes  i try to do it using my free time.

EDT

Average of ratings: -
In reply to emanuele della torre

Re: Databases: Moodle Cluster

by emanuele della torre -

The only feature that isn't in the current release of phpMyAdmin is replication management.

:-|

Average of ratings: -