MySQL Forums
Forum List  »  Partitioning

Multiple customers in a shared DB, one disk fails. Could the table still be functional for the data on the working disks, using partitioning?
Posted by: Tore Krudtaa
Date: April 03, 2006 04:08AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Multiple customers in a shared DB, one disk fails. Could the table still be functional for the data on the working disks, using partitioning?
3227
April 03, 2006 04:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.