[Mageia-sysadm] [Mageia-webteam] Forum VM needs

Fri Jan 14 12:21:37 CET 2011

Le 13/01/2011 13:50, Olivier Thauvin a écrit :
+> * Michael Scherer (misc at zarb.org) wrote:
+>> Le mercredi 12 janvier 2011 à 23:05 +0100, Maât a écrit :
+>>> Le 12/01/2011 22:37, nicolas vigier a écrit :
+>>>> On Wed, 12 Jan 2011, Maât wrote:
+>>>>> So phpBB needs a LAMP Stack : Apache + PHP5 + MysSQL5 (it prefers to have MySQLi extention)
+>>>> Do you know if it would be possible to use Postgresql instead of MySQL ?
+>>>> We already have a Postgresql server running on alamut that we could use.
+>>> phpBB3 is supposed to work with PostgreSQL 7.3+ though it's not as widely used as MySQL as a phpBB backend.
+>> Great, so more testing to do /o\
+> In practice, if the SQL was properly written, the SQL must work on any
+> PGSQL version, especially since it have to work on other SQL server
+> (mysql).
+>
+> But who know with php apps.
+>
+Troll™ detected ^^
+
+>>> The problem (for me) is that i just know the basic of PostgreSQL... so we'll need someone else skilled 
+>>> enough to tune it (and i'd be truly happy to learn from him/her)
+>> Nanar will be able to do it, even if hosting a small database like this
+>> may not be very appealing to him. There is just 5g, when compared to
+>> sophie, I let him give the numbers.
+> Sophie:
+> - on disk size: ~ 200GB
+> - biggers tables, rows estimated to 150 millions, next table 16 millions
+> - 1208570 rpms in it currently
+>
+> I manage 5 posgresql servers at works.
+>
+>
+\o/ Master !
+
+Teach me :)
+
+Nota : the difficult part with a forum is not really in the table size for tuning but in the complexity of requests with lots of joins mixed with the number of simultaneous read&write calls which can quickly make the server bite the dust :-/
+
+=> clever indexing, good cache and memory tuning, good storage format (to avoid pessimistic table locking and to allow quick parsing with sometimes fulltext indexes)
+
+(and database backup while users are using the forum without making it unusable can also be a challenge)
+
+cheers,
+Maât
+
+