Currently our application and database services reside on the same VM. I wish to separate them on to their own server to be more enterprise ready for HA in future. One for moodle and another for our MySQL enterprise version.
What is the minimum ram should I dedicate to the database? At least 24 and maybe even 32?
How would you set up your /moodledata platform?
Running RHEL 7.2 64-bit, PHP 7.1 + MySQL 5.5.41 community edition and will upgrade to moodle 3.4.x in a few weeks.
what ever MySQL server you might have at present could be involved in an "HA" cluster or replication.
How large is your mysqldump of the database for Moodle? How many active users in the system? Moodle used as blended?
URL above does have a chart worth viewing ... the 'trade offs' graph.
Careful what you go after ... remember that a Mercedes Benz is probably best serviced by a Mercedes Benz dealer with certified MB mechanics.
When it comes to where moodledata resides ... have never thought of that dedicated server to be one where memory was the major consideration, but, rather, one of space/speed - speed meaning how quickly large files could be accessed and shipped to client requesting.
Am certain there are true DB admins (certified) in these forums and maybe one of them will correct me if I am in-correct or clarify.
'spirit of sharing', Ken
Ram is related to the concurrent user. This formula applies for moodle activities take 1 GB for every 50 concurrent user. For an example you can check the quiz activity experience blog post that i wrote about.
As far as MySQL is concerned, you need to work out the size of your database, then figure out the optimum size for the InnoDB Buffer Pool, and allocate memory on that basis.
Essentially, you are trying to get as much of the data set in memory as you can, and let the storage engine handle flushes to disk.
Could you pl. elaborate on what "more enterprise ready" means. I understand that the single VPS server you have is already enterprise ready but you want to be more enterprise ready by separating it in two: "One for moodle and another for our MySQL enterprise version". Where does "HA in future" come to the picture? Is each of them is in turn a server cluster?
You ask for the size of RAM - no mention of the load(?) Did you read the documentation to this forum?
I went through your previous discussions https://moodle.org/mod/forum/user.php?id=1324621&mode=discussions&course=5 and must say they cover a vast set of software and architecture, anything from MS SQL-Server to Oracle, from Moodle to Canvas, from load balancing to fail-over,... That's a handfull!