Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Tim Watts Newsgroups: comp.databases.mysql Subject: Re: Can MySql database store images? Followup-To: comp.databases.mysql Date: Mon, 25 Apr 2011 14:30:48 +0100 Organization: A noiseless patient Spider Lines: 35 Message-ID: <8l9g88-3uk.ln1@squidward.dionic.net> References: <4db54728$0$81481$e4fe514c@news.xs4all.nl> <840g88-ece.ln1@squidward.dionic.net> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7Bit Injection-Info: mx01.eternal-september.org; posting-host="6oIlEBqCjOm0MjsSUEk5CA"; logging-data="16582"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19nnL6OdYieKJE8oy1T6jFmFO2tYFSuPa0=" User-Agent: KNode/4.4.6 Cancel-Lock: sha1:4Q1PteEYKNZcWUkmmJTQDNy23tE= Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:680 Jerry Stuckle wrote: > > So what you're saying is that the same file may end up on multiple > different servers. And if any of those servers failed, a huge number of > files would potentially be unavailable - or at least parts of them > would, which is just as bad. And you have no control over what gets > stored where, so you can't, for instance, put the most accessed files on > the local disk while other, less used files, are on remote disks. > > Sounds like a total disaster just waiting to happen. You claim to have decades of experience and yet you don't know how ZFS or LVM work? Where did I say "multiple servers"??? I said "multiple block devices" ie muliple disks. If you want multiple servers, use Lustre or somesuch - in which case you have the option of replication to avoid that problem. But you're the one suddenly bringing multiple servers into the equation. I think you have run out of good points to argue so you are just muddying the waters on purpose. > OTOH, with databases, you can partition the database so that more > commonly used data is available from the local disk, while lesser-used > data can be pulled from other systems. And in no case do you have a row > split across multiple systems, so you have just limited the rows > affected by a system failure. > You are referring to Federated MySQL DBs? -- Tim Watts