From owner-freebsd-questions@FreeBSD.ORG Wed Sep 30 04:25:08 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 82F341065672 for ; Wed, 30 Sep 2009 04:25:08 +0000 (UTC) (envelope-from gpeel@thenetnow.com) Received: from thenetnow.com (constellation.thenetnow.com [207.112.4.14]) by mx1.freebsd.org (Postfix) with ESMTP id 53DFE8FC21 for ; Wed, 30 Sep 2009 04:25:07 +0000 (UTC) Received: from hpeel.ody.ca ([216.240.12.2]:60353 helo=GRANTLAPTOP) by constellation.thenetnow.com with esmtpa (Exim 4.63 (FreeBSD)) (envelope-from ) id 1MsqkU-000Fa7-AQ; Wed, 30 Sep 2009 00:25:06 -0400 Message-ID: <21683F053F9E47459153BB4E511717FA@GRANTLAPTOP> From: "Grant Peel" To: "Mauro Rezzonico" , References: <4AC2B87A.7050407@ch23.org> In-Reply-To: <4AC2B87A.7050407@ch23.org> Date: Wed, 30 Sep 2009 00:25:04 -0400 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="UTF-8"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Windows Mail 6.0.6002.18005 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005 Cc: 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 04:25:08 -0000 ----- Original Message ----- From: "Mauro Rezzonico" To: Sent: Tuesday, September 29, 2009 9:46 PM Subject: Re: Netwroked Storage > 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 > All machines are completely autonomous. i.e they each run thier own applications and store all data to thier own disks. -Grant > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" >