MySQL Forums
Forum List  »  Partitioning

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?
Posted by: Mikael Ronström
Date: April 03, 2006 01:02PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
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?
2142
April 03, 2006 01:02PM


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.