Wait to sync on new inserted data

Hi!

Is there any feature available that i can wait for the insert query that all date is completely synced over the whole cluster? if i’m to fast after insert, the new data isn’t available at all on a new select query. i’m using the http interface to request and store the data.

thx and regards, volker.

1 Like

Dear Volker,

thanks for writing in. In CrateDB, to flush write operations wrt. consistency, you can use the REFRESH TABLE statement.

With kind regards,
Andreas.

1 Like

Apart from the REFRESH mechanism, for which you can find more details here, regarding the configuration of your table(s), it’s also worth taking a look at the write-wait-for-active-shards, which is orthogonal to the refresh mechanism, but lets you configure on how many replicas your data should be synced before an insert is returned as “successful” to the client.

1 Like

okay, cool ,thx for details!

1 Like