Configuration Question

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

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?

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..:)

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..:)

oh..and will virt manage quotas in the databases in sql like it normally does or not?

Virtualmin can only set quotas on MySQL databases if they're on the same filesystem as /home.

sounds like a feature request..:)

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

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..:)

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.

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...:)

What I'll look into is allowing the quota to be set independently for the MySQL databases - this would be the cleanest solution.