Database Conversion From Single Monolithic File Mode To One Table Per File And One File Per Table Mode

摘要

Methods, apparatus, and other embodiments facilitate transitioning a database between two modes. The two modes include a mode where table information for separate tables in the database is stored in a single monolithic file and a mode where the table information for separate tables is stored in separate files. Conventional attempts to make this type of transition lock the database for an unacceptable amount of time. Example methods and apparatus make a copy of a database that is to be transitioned, lock the copy, make a second instance of the copy, and then perform the work necessary for the transition in the second instance. This allows the original database to remain running. When the second instance is complete, the second instance is synchronized to the original database and then the transition is completed by copying the second instance to the original or failing the original over to the second instance.

主权项

1. A method for transitioning a master database operating in a first mode to a database operating in a second mode, comprising:
while the master database is unlocked, populating a slave database for the master database from the master database using a backup tool; enabling replication for the master database; producing a dump of the slave database while the master database is unlocked; building, in the second mode, from the dump of the slave database, while the master database is unlocked, a second slave database; synchronizing the second slave database with the master database from the point where replication was started; and transitioning the master database to the second slave database, where the first mode and the second mode include a single monolithic file mode where table information for separate tables in a database is stored in a single monolithic file and a one table per file and one file per table mode where table information for separate tables in a database is stored in separate files.