Patent ID: 7330860

Claim:
A method of loading data into a new table copy, the new table copy to be added to a database replication group including a plurality of pre-existing table copies, the method comprising: loading data from a source table copy into the new table copy, the source table copy being one of the plurality of pre-existing table copies in the database replication group; concurrent to the loading of the data into the new table copy, simultaneously applying changes of a user application received during the loading of the data to the plurality of pre-existing table copies in the database replication group including the source table copy; and creating a spill storage area at the new table copy and storing the changes of the user application in the storage spill area without applying the changes of the user application to the new table copy; and upon completion of the loading of the data into the new table copy, applying the changes stored in the spill storage area to the new table copy, wherein applying the changes of the user application stored in the spill storage area to the new table copy comprises, receiving a load done message at the new table copy; starting a spill agent thread at the new table copy; changing a state of the subscription of the new table copy at the new table copy to “load finishing”; and the spill tread agent processing the changes of the user application stored in the spill storage area.