ONLINE REDISTRIBUTION

摘要

Methods and systems are disclosed to perform online disk data redistribution in a database environment. The methods and systems disclosed herein provide for the redistribution of data across multiple physical disks of a database while when a new physical storage device is added to the database. In embodiments, online redistribution of the data may include creating a temporary file, copying live database from a first physical storage to the temporary file, creating a checkpoint for the database, writing the temporary file to a second physical storage device that is added to the database, and purging the live database file and the temporary database file.

主权项

1. A method for performing online disk redistribution of a database, the method comprising:
receiving, at a database manager operating on a computing system, a redistribution command associated with a database distributed across a plurality of physical storage devices; creating a temporary file; copying a live database file from a first physical storage device included among the plurality of physical storage devices to the temporary file; creating a checkpoint; writing the temporary file to a second physical storage device included among the plurality of physical storage devices, the second physical storage device different from the first physical storage device; and purging the live database file and the temporary file.