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

[Tore Krudtaa]

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 time(s). Last edit at 04/03/2006 07:45AM by Tore Krudtaa.