On Sun, 6 Oct 2019 at 23:27, Kadirk wrote:
> How to do online backup of an in memory database (to disk)?
>
> Planning to use in memory database with 10 gb+ data, there are queries
> continuously so stopping application is not an option. Looks like for on
> disk databases it is possible with a
On 06.10.2019 22:02 Keith Medcalf wrote:
> On Sunday, 6 October, 2019 13:03, Kadirk wrote:
>
>> We already have an application specific WAL file, sqlite updates +
>> application data is in this WAL file. We are taking snapshot of sqlite +
>> application data to the disk to truncate WAL file, then
On Sunday, 6 October, 2019 13:03, Kadirk wrote:
>We already have an application specific WAL file, sqlite updates +
>application data is in this WAL file. We are taking snapshot of sqlite +
>application data to the disk to truncate WAL file, then we can rebuild
>latest state whenever needed
On 6 Oct 2019, at 8:03pm, Kadirk wrote:
> I expect there might be a way to take backup of sqlite in memory while
> updates are still being processed (as in on disk online backup). Maybe
> something like copy on write memory for that?
You can't clone something which is changing. Obviously.
Simon, Keith thanks for the answers, let me give some more details.
We already have an application specific WAL file, sqlite updates +
application data is in this WAL file. We are taking snapshot of sqlite +
application data to the disk to truncate WAL file, then we can rebuild
latest state
On Saturday, 5 October, 2019 15:44, Kadirk wrote:
>How to do online backup of an in memory database (to disk)?
An in memory database is a transient object. Why would you want to back it up?
>Planning to use in memory database with 10 gb+ data, there are queries
>continuously so stopping
On 5 Oct 2019, at 10:43pm, Kadirk wrote:
> Whenever an update comes in,
> backup process starts over so it won't finish. Any idea how to solve this?
How do you expect to take a perfect copy of something which is constantly
changing ? Do you expect the changes to stop affecting the database
How to do online backup of an in memory database (to disk)?
Planning to use in memory database with 10 gb+ data, there are queries
continuously so stopping application is not an option. Looks like for on
disk databases it is possible with a non-blocking fashion but I couldn't
find a way to do it
8 matches
Mail list logo