[Mageia-webteam] Forum VM needs

[Dubeau, Patrick]

> Hi there,
> 
> As it seems VM creation takes a little bit of time due to people being
> under heavy load at work Anne and misc considered the option of
> creation the Xen VM on one of our servers (we could migrate the VM on
> atalante later)
> 
> For that misc asked for Forum needs...
> 
> For the beginning i'll consider that we are going to put everything on
> the same machine (DB and PHP). This is not rally brilliant to
> virtualize DB servers but i guess this will not kill the VM in the
> first monthes as the tables will not be big.
> 
> So phpBB needs a LAMP Stack : Apache + PHP5 + MysSQL5 (it prefers to
> have MySQLi extention)
> 
> And we'll need with php the optional :
> -- zlib compression (better having it)
> -- remote ftp support (well... i'm not in favor even if documentation
> asks for it)
> -- XML support (better having it)
> -- Image Magick support (better having it)
> -- GD support (same as Image magick)
> 
> For source management git will be used... so we'll need it too :)
> 
> As forum have often to face bruteforce having Fail2ban would be really
> great... for every open service like ssh but also for forums... i'd
> like to have Fail2ban parse a file of phpBB failed login to trigger a
> IP low level ban during a few hours or more...
> 
> 
> For forum management we'll need :
> -- access to sources (read/write)
> -- access to data zones (avatars and uploaded things) (read/write)
> -- access to accesslogs and errorlogs (read)
> -- hability to change php log levels
> -- access to php logs (read)
> -- console access to database(s) (i'd prefer to avoid completely
> phpMyadmin on the forum server)
> 
> For performance questions : i guess forum opening will trigger a rather
> vast amount of people coming (at least to register their nicks)... i'd
> be happy to avoid the server being loaded to death.
> 
> So i'm targetting at least one thousand simultaneous users being active
> on the forum... that will do for apache tuning.
> 
> For database that will mean 800 to 1200 requests per seconds...
> 
> We'll have 2 - 3 monthes to see the tables grow and tune the indexes
> and the memory accordingly.
> 
> But i think our needs will stabilize around 4-6 GO for RAM if the forum
> gets really used (we'll have to tune mysql to keep many requests in
> cache) apache+mysql all included... if we split later apache and mysql
> on separate machines the needs on each machine will be obviously lower.
> 
> For app disk space code is under 50 megs... and with hundred of avatars
> uploader we will not grow above 1GO
> 
> For database disk space even after years of activity we'll remain under
> 5GO
> 
> We'll need to set up some tables with havy read and write accesses with
> InnoDB (not all) : that would be great to have one file per table
> innodb option enabled
> 
> Nota : i'd like to use https (at least for admin accesses)... so that
> will mean to enable ssl and open 443 port also
> 
> That's all for system level... i think directory structures (Which
> concerns apache web root config) can be dealt with later...
> 
> Tell me if you have got everything you need for VM creation...
> 
> Cheers,
> 
> Maât

Hi Maat,

I am sincerely happy you suggest it. It could ease and speed things up a
little. xkomodor and I are under pretty heavy load of work right now and for
myself I also have technical issues in installing and connecting to the vms
right now and don't have enough time to spare on it as I would like to. Sorry
for the inconveniences...


Patrick Dubeau (alias DaaX) - Webmaster MLO
http://www.mandrivalinux-online.org