cancel
Showing results for 
Search instead for 
Did you mean: 

Is KDB suitable for 24*7 system?

Oliver
New Contributor

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

1 REPLY 1

rocuinneagain
Contributor II
Contributor II

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/