QLDB Restore Backups Option?
A customer is using QLDB.
I have seen that you can export journal data from QLDB directly to S3 by submitting the journal export request: https://docs.aws.amazon.com/qldb/latest/developerguide/export-journal.html
Can this be seen as a traditional DB backup?
Secondly, is there an option of 'importing' that QLDB backup into an existing ledger or into a new ledger?
Thirdly, are there any plans to incorporate automatic QLDB backups into the AWS Backup service?
I know QLDB is relatively new, but knowing this would calm customers already using QLDB that backups are also thing with QLDB.
Thank you in advance.
There is currently no mechanism that I am aware of for restoring exports of QLDB and exactly recreating a ledger. You can build a process to take the export and import all the data to a new ledger, but the internal timestamps will reflect the time you imported the data into the copy, not the time they were added to the original ledger, and these timestamps are part of the hashes so it will not be an exact copy.
If you have your own timestamps within your data and you are using QLDB more for it's versioning capabilities than it's cryptographic integrity features then that may be sufficient.
It is my understanding that behind the scenes the data is replicated multiple times across multiple AZs (somewhat similar to Aurora) to reduce the risk of data loss within a ledger.
If you are working with a customer who is using QLDB I would recommend reaching out to their AWS Account Team and having them get you in touch with the QLDB team. They may be able to give you insight into their roadmap and whether more traditional backup/restore options are planned. QLDB is actively under development and has added some major new features in the last year, including the more fine grained access controls and the use of customer managed KMS keys for data at rest.
Ok good to know! Thanks for this great answer!
QLDB Restore Backups Option?Accepted Answerasked 7 months ago
Can I use the RDS Postgresql S3 export query to replicate changes from RDS to S3?Accepted Answerasked a year ago
Unable to change Delete Protection on QLDB Ledgerasked a year ago
QLDB - query - Getting all documents which were inserted after some document of given UUIDasked 6 months ago
encrypted db snapshot restore from S3 not working AWS RDS(mysql) console in an S3 bucket.asked 3 months ago
Migrating out of QLDB?Accepted Answerasked 2 years ago
Can we export the mongodb using the data pipeline?Accepted Answerasked 6 years ago
RDS Snapshot exportAccepted Answerasked 5 years ago
QLDB Query from Lambda Functionasked a year ago
How to see the rows of table in order by their ID with SELECT command in QLDB?asked 4 months ago