Re: Multiple customers in a shared DB, one disk fails. Could the table still be functional for the data on the working disks, using partitioning?

[Mikael Ronström]

Hi,
Unfortunately this functionality is not available in 5.1. It could be that
it is possible that it could come into 5.2.

Rgrds Mikael

Tore Krudtaa wrote:
> Hi.
>
> With Partitioning in mind:
>
> Let say we have lots of customers in same database
> and that we have used
> partitioning to spread our customers on different
> disks.
>
> I'm assuming here that any given customer will
> have all his data and
> indexes in one partition (read on one particular
> disk).
>
> Could it be possible to make it possible for MySql
> to read from
> the table even if one of the disks stopped
> working?
>

> And if one of the disks stopped working then a
> "silent" message to
> a specific error log and/or a DBA defined file or
> whatever.
>
> If implemented then only the customers on the disk
> that failed
> would be offline.
>
> Hat tip to MySql developers for implementing
> Partitioning.
>
>
>
> Edited 6 times. Last edit at 04/03/06 09:45AM by
> Tore Krudtaa.

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com