Handling server and client operations uninterruptedly during pack and audit processes
A solution for maintaining the operation of a server and allowing the transfer of data from client devices to a database without locking the database during an audit and pack process is realized that reduces the amount of time lost due to backup file storage transfer. When a file is backed up to a first storage trail through the audit process, the trail may eventually become filled to capacity. Upon the first storage trail filling to capacity, a pack process is initiated, and a backup storage trail is created to store the data during this process. Upon completion of the pack process, the data from the backup storage trail is transferred to another active storage trail.
1. A method, comprising:
receiving, at an information server, a query for a database in communication with the information server;
executing, by the information server, the query against the database;
storing, by the information server, a record of the query in a first audit trail;
determining, by the information server, that a size of the first audit trail has reached a predetermined threshold size; and
when the size has reached the predetermined threshold size executing the steps comprising:
initiating, by the information server, a pack process on the first audit trail to switch from the first audit trail to a second audit trail;
receiving, by the information server, a second query for the database while the pack process is executing; and
storing, by the information server, a record of the second query in a third audit trail while the pack process is executing.
2. The method of claim 1 , wherein the pack process comprises a first phase during which the information server is transitioned from the first audit trail to the second audit trail and comprises a second phase during which records stored in the third audit trail are copied to the second audit trail.
3. The method of claim 2 , further comprising:
detecting, by the information server, the pack process is ready to enter the second phase; and
locking, by the information sever, the database during the second phase of the pack process.
4. The method of claim 3 , further comprising unlocking, by the information server, the database after the records of the third audit trail are copied to the second audit trail.
5. The method of claim 1 , wherein the step of determining whether the size of the first audit trail has reached the predetermined threshold size comprises determining whether the size of the first audit trail has reached approximately eighty-ninety percent of a storage capacity of the first audit trail.
6. The method of claim 1 , further comprising, after the pack process has completed, executing the steps comprising:
receiving, by the information server, a third query against the database;
executing, by the information server, the third query against the database; and
storing, by the information server, a record of the third query in a second audit trail.
7. An apparatus, comprising:
a processor; and
a memory coupled to the processor, in which the processor is configured to perform the steps of:
receiving, at an information server, a query for a database in communication with the information server;
executing, by the information server, the query against the database;
storing, by the information server, a record of the query in a first audit trail;
determining, by the information server, that a size of the first audit trail has reached a predetermined threshold size; and
when the size has reached the predetermined threshold size, the processor is further configured to perform the steps of:
initiating, by the information server, a pack process on the first audit trail to switch from the first audit trail to a second audit trail;
receiving, by the information server, a second query for the database while the pack process is executing; and
storing, by the information server, a record of the second query in a third audit trail while the pack process is executing.
8. The apparatus of claim 7 , wherein the pack process comprises a first phase during which the information server is transitioned from the first audit trail to the second audit trail and comprises a second phase during which records stored in the third audit trail are copied to the second audit trail.
9. The apparatus of claim 8 , in which the processor is further configured to perform the steps of:
detecting, by the information server, the pack process is ready to enter the second phase; and
locking, by the information sever, the database during the second phase of the pack process.
10. The apparatus of claim 9 , in which the processor is further configured to perform the step of unlocking, by the information server, the database after the records of the third audit trail are copied to the second audit trail.
11. The apparatus of claim 7 , wherein the step of determining whether the size of the first audit trail has reached the predetermined threshold size comprises determining whether the size of the first audit trail has reached approximately eighty-ninety percent of a storage capacity of the first audit trail.
12. The apparatus of claim 7 , in which, after the pack process has completed, the processor is further configured to perform the steps of:
receiving, by the information server, a third query against the database;
executing, by the information server, the third query against the database; and
storing, by the information server, a record of the third query in a second audit trail.
13. A computer program product, comprising:
a non-transitory medium comprising:
code to receive, at an information server, a query for a database in communication with the information server;
code to execute, by the information server, the query against the database;
code to store, by the information server, a record of the query in a first audit trail;
code to determine, by the information server, that a size of the first audit trail has reached a predetermined threshold size; and
when the size has reached the predetermined threshold size, the computer program product further comprising:
code to initiate, by the information server, a pack process on the first audit trail to switch from the first audit trail to a second audit trail;
code to receive, by the information server, a second query for the database while the pack process is executing; and
code to store, by the information server, a record of the second query in a third audit trail while the pack process is executing.
14. The computer program product of claim 13 , wherein the pack process comprises a first phase during which the information server is transitioned from the first audit trail to the second audit trail and comprises a second phase during which records stored in the third audit trail are copied to the second audit trail.
15. The computer program product of claim 14 , further comprising:
code to detect, by the information server, the pack process is ready to enter the second phase; and
code to lock, by the information sever, the database during the second phase of the pack process.
16. The computer program product of claim 15 , further comprising code to unlock, by the information server, the database after the records of the third audit trail are copied to the second audit trail.
17. The computer program product of claim 13 , wherein the code to determine whether the size of the first audit trail has reached the predetermined threshold size comprises code to determine whether the size of the first audit trail has reached approximately eighty-ninety percent of a storage capacity of the first audit trail.
18. The computer program product of claim 13 , further comprising, after the pack process has completed:
code to receive, by the information server, a third query against the database;
code to execute, by the information server, the third query against the database; and
code to store, by the information server, a record of the third query in a second audit trail.