From owner-freebsd-questions@FreeBSD.ORG Wed Sep 30 01:46:37 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id DB4D01065672 for ; Wed, 30 Sep 2009 01:46:37 +0000 (UTC) (envelope-from list@ch23.org) Received: from authsmtp.register.it (paganini09-authsmtp.register.it [81.88.48.42]) by mx1.freebsd.org (Postfix) with ESMTP id 4D06E8FC0A for ; Wed, 30 Sep 2009 01:46:36 +0000 (UTC) Received: (qmail 7265 invoked from network); 30 Sep 2009 01:46:34 -0000 Received: from unknown (HELO ?192.168.2.112?) (smtp@ch23.org@82.60.234.157) by authsmtp.register.it with ESMTPA; 30 Sep 2009 01:46:34 -0000 Message-ID: <4AC2B87A.7050407@ch23.org> Date: Wed, 30 Sep 2009 03:46:34 +0200 From: Mauro Rezzonico Organization: Channel23 User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: Netwroked Storage X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 30 Sep 2009 01:46:37 -0000 Grant Peel wrote: > The intent here is to connect about 10 Web servers, each of them hosting about 200 domains, to a central storage system to house users home directories. > It might be worth noting that the Web machines host a full array of software, i.e. Mail, Web, MySQL, PHP etc. I don't have an answer, bu I have a question, probably a naive one and even slightly OT.. If the 200 domains are hosting MySQL driven web applications (let's say 200 Wordpress), then perhaps they are connecting to the very same MySQL instance, so ALL their databases are in the same mysql_dbdir, and perhaps the dbdir is /var/db/mysql... So: how do you deal things like that with MySQL driven web applications? How are you going to deal the mysql_dbdir issue? NFS perhaps is not the best filesystem for MySQL tables (performance-wise)... Are you going to 'mysqldump' the databases back in each home dir? Periodically? And keep the databases on the local disks? -- Mauro Rezzonico , Como, Italia "Maybe this world is another planet's hell" - H.Huxley