Hello,
I am checking a backup operation.
The online backup worked well. However, the execution times were different every trial.
Does MemSQL support backup incrementally? or each time works full backup about whole database data?
Furthermore, Is it different backup process between rowstore and columnstore data?
Would you please share the effective backup architecture through MemSQL in the real production environment.
Best Regards,
Andrea
The 6.8 release doesn’t support incremental backup. MemSQL will support incremental backup starting in 7.0 (currently in beta). The next 7.0 beta update is expected to support the incremental backup feature. MemSQL 7.0 will do true incremental backup for columnstore data. Row store data will still be backed up using a full snapshot of the data in 7.0, as it is in 6.8.
With MemSQL 6.8 and earlier, you should do periodic backups, say every week, day, or 4 hours. If you have a need to recover data to a point in time in case you need to restore a backup, you will also need to have data stored elsewhere at the application level (in files, queues, or a source database), so you can reload it or play it back to get the data up to date.
Point-in-time restore, as well as continued enhancements to incremental backup, are priorities for us for future releases.