I don't even know if it will provide any reasonable benefit. At present we use following to run cron.
A loop replaces 'Domain Name' with actual domain name and this complete scripts runs for every Moodle site (at present ~1200). On an average it takes 40 minutes for cron to complete and after that cron starts running again.
We want (if possible) to isolate this cron job from web server to a cron server.
1) Do you think it will be of an advantage?
2) What are the ways we can shift load from cron to some other server?
As per my understanding, we could use a plain server with only php installed (without apache, mysql). There are two questions about this.
1) Does cron needs access to moodledata folder as well?
2) What is the approximate ratio of select vs. update/insert operation in cron? This will help us judge if should use another database in master-master mode or we should use master db itself.
If there are many write operations in cron and we choose to use master db then the only load we will be shifting is php parsor load. How huge is this load in a web server?