I'm running a 24*7 system, and I'm considering to use KDB for my systerm.
As I know the dumping from RDB to HDB occur at every EOD, however, my system won't stop or pause at EOD, and there will be live stream inserting into RDB during that time, will that cause any problem for dumping?
In the basic kdb+ tick the RDB does do the write at EOD.
No data is lost, it will buffer in the outbound queue from the TP process.
As long as you have a safe memory overhead for this buffer then the system will continue to run.
Queries will also buffer while the RDB is performing the write.
More advanced architectures avoid the RDB being blocked, such as all the KX platforms. .e.g https://code.kx.com/insights/1.1/
Tel: +44 (0)28 3025 2242
Tel: +1 (212) 447 6700
Tel: +61 (0)2 9236 5700