Back to results
US 10,769,023 B1Granted
Backup of structured query language server to object-based data storage service
AssigneeAmazon Technologies, Inc.
InventorSteven John Abraham, Jr.
Life of this patent
Estimating the term…
Abstract
A structured query language server may receive a command from a backup control server to provision a virtual device and perform a backup operation on the structured query language server. The structured query language server may be configured to write data to the virtual device in order to be transmitted to a data storage service. The backup and restore operations directed to the structured query language server may include a web service application programming interface request to the data storage service to cause the data written to the virtual device to be stored as a data object in the data storage service.
Claims20
A computer-implemented method, comprising:
- transmitting a first request, at a backup manager of one or more computing devices to a virtual device application programming interface, to create a virtual device to which a structured query language (SQL) server can write;
- transmitting, to the SQL server, a second request to write a backup of a database managed by the SQL server to the virtual device;
- buffering a portion of the backup written to the virtual device for the backup in a volatile memory corresponding to the virtual device, wherein the portion of the backup is compressed prior to the portion of the backup being written to the virtual device;
- as a result of a determination that a size of the portion of the backup buffered in volatile memory has not met a threshold size, looping by the backup manager such that additional data is added to the portion of the backup;
- transmitting at the backup manager, as a result of the size of the portion of the backup buffered in the volatile memory reaching the threshold size, a web service application programming interface request to an object-based data storage service to transfer the portion of the backup from the volatile memory to the object-based data storage service to be stored in a data object in the object-based data storage service;
- and
- receiving a status update related to the portion of the backup written to the virtual device.
4 more elements
A system, comprising:
- one or more processors;
- and memory storing instructions that, when executed by the one or more processors, cause the system to at least:
- transmit a first request, at least in part by a backup manager, to a virtual device application programming interface to create a virtual device to which a structured query language (SQL) server can write;
- transmit a second request, to a database management system of the SQL server, to write a backup of a database managed by the database management system to the virtual device;
- buffer a portion of the backup written to the virtual device for the backup of the database in a volatile memory corresponding to the virtual device, wherein the portion of the backup is compressed prior to the portion of the backup being written to the virtual device;
- as a result of a determination that a size of the portion of the backup buffered in the volatile memory has not met a threshold size, loop by the backup manager such that additional data is added to the portion of the backup;
- cause, as a result of the size of the portion of the backup buffered in the volatile memory reaching the threshold size, a web service application programming interface request to be transmitted to an object-based data storage service to transfer the portion of the backup from the volatile memory to the object-based data storage service to be stored in a data object in the object-based data storage service;
- and
- receive a status update related to the portion of the backup written to the virtual device.
6 more elements
A non-transitory computer-readable storage medium having stored thereon instructions that, when executed by one or more processors of a computer system, cause the computer system to at least:
- transmit a first request, at a backup manager of one or more computing devices of the computer system, to a virtual device application programming interface to create a virtual device to which a structured query language (SQL) server can write;
- transmit a second request, to a database management system of the SQL server, to write a backup of a database managed by the database management system to the virtual device;
- buffer a portion of the backup written to the virtual device for the backup of the database in a volatile memory corresponding to the virtual device, wherein the portion of the backup is compressed prior to the portion of the backup being written to the virtual device;
- as a result of a determination that a size of the portion of the backup buffered in the volatile memory has not been reached, loop by the backup manager such that additional data is added to the portion of the backup;
- transmit at the backup manager, as a result of a determination that the size of the portion of the backup buffered in the volatile memory has reached a threshold size, a web service application programming interface request as a third request to an object-based data storage service to transfer the portion of the backup from the volatile memory to the object-based data storage service to be stored in a data object in the object-based data storage service;
- and receive a status update related to the portion of the backup written to the virtual device.
3 more elements
Dependencies are inferred from the claim text.