Date: Wed, 30 Sep 2009 03:46:34 +0200 From: Mauro Rezzonico <list@ch23.org> To: freebsd-questions@freebsd.org Subject: Re: Netwroked Storage Message-ID: <4AC2B87A.7050407@ch23.org> In-Reply-To: <ADA4B9316B604F71BBBA917DB1CF9306@GRANT> References: <ADA4B9316B604F71BBBA917DB1CF9306@GRANT>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <mauro@ch23.org>, Como, Italia "Maybe this world is another planet's hell" - H.Huxley
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4AC2B87A.7050407>