2022.08.02 01:54 AM
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?
Thanks
Oliver
2022.08.03 02:17 AM
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/
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.