Submitted by hescominsoon on Mon, 01/11/2021 - 21:13 Pro Licensee
I am going to be building a server for a client. It is going to be a very fast machine for a large community. i am going to be putting /home on one mirrored array and /sql on another mirrored array. / will be on the final mirrored array. How do i get virt to put things where i want them to go?
Status:
Active
Virtualmin version:
n/a
Webmin version:
n/a
Comments
Submitted by JamieCameron on Mon, 01/11/2021 - 23:52 Comment #1
Virtualmin will use /home by default for domain's home directories - so just make sure you have quotas enabled on that filesystem.
For /sql , is your plan to put MySQL databases there?
Submitted by hescominsoon on Mon, 01/18/2021 - 15:31 Pro Licensee Comment #2
yes..home will be on one disk array and sql will be on a different disk array. This site is going to be quite large and i want to separate things to get maximum i/o's for each section..:)
Submitted by hescominsoon on Mon, 01/18/2021 - 15:32 Pro Licensee Comment #2
yes..home will be on one disk array and sql will be on a different disk array. This site is going to be quite large and i want to separate things to get maximum i/o's for each section..:)
Submitted by hescominsoon on Mon, 01/18/2021 - 15:33 Pro Licensee Comment #3
oh..and will virt manage quotas in the databases in sql like it normally does or not?
Submitted by JamieCameron on Wed, 01/20/2021 - 20:30 Comment #4
Virtualmin can only set quotas on MySQL databases if they're on the same filesystem as /home.
Submitted by hescominsoon on Thu, 02/11/2021 - 20:24 Pro Licensee Comment #5
sounds like a feature request..:)
Submitted by JamieCameron on Sat, 02/13/2021 - 14:22 Comment #6
Unfortunately Linux quotas are separate for each filesystem - so if MySQL is a on a different filesystem, usage couldn't be combined with what's on /home
Submitted by hescominsoon on Sun, 02/14/2021 - 14:30 Pro Licensee Comment #7
so it's two qutoas..it's managemeable then with virt.. I do not doubt it's more work but it seems tob e somehting virt could do..take the qutoa used by the /home side and add it to the sql manged side...the sum is then compared to the assigned quota. I am not a coder..but i understand concepts and i can see it would be a pain to do this dynamically. About the only way I could see doing it is 50% on each filesystem..it wouldn't cover every situation..but would be much easier to manage.
I also know I am probably the only one asking for something like this...:) I'll work around it..i might just put the sql on it's own filesystem and just manually assign a disk quota to it equal to the /home quota..actually that's something you could do as well..:)
Submitted by JamieCameron on Sun, 02/14/2021 - 15:01 Comment #8
So we could report when a user is exceeding their total quota in a setup like this, or even have two separate quotas. However, the user could still potentially use more disk space than expected as running out of quota on one filesystem won't prevent writes to the other filesystem.
Submitted by hescominsoon on Mon, 03/01/2021 - 19:03 Pro Licensee Comment #9
could you split the quota 50-50 between the two filessytems? because then if one got full the site would go offline if either of them were unable to be written to..for my hosting i only do wordpress so this would be an equitable solution for me....:) Eventually i am going to be splitting the filesystems/servers..one for the files and a second server for the sql databases. As the sql load goes up the first server could easily handle the load but I am going to need to build a much better system that's designed specifically for handling sql loads...:)
Submitted by JamieCameron on Mon, 03/01/2021 - 23:01 Comment #10
What I'll look into is allowing the quota to be set independently for the MySQL databases - this would be the cleanest solution.