[jira] [Created] (IGNITE-6843) SQL: optionally do not use WAL when executing CREATE INDEX

[Anton Vinogradov (Jira)]

Vladimir Ozerov created IGNITE-6843:
---------------------------------------

             Summary: SQL: optionally do not use WAL when executing CREATE INDEX
                 Key: IGNITE-6843
                 URL: https://issues.apache.org/jira/browse/IGNITE-6843
             Project: Ignite
          Issue Type: Task
      Security Level: Public (Viewable by anyone)
          Components: sql
    Affects Versions: 2.3
            Reporter: Vladimir Ozerov
             Fix For: 2.4


When index is being created through {{CREATE INDEX}} command, every single index update is written to WAL. Let's introduce special mode where updates are not written to WAL:
1) Index updates are not written to WAL
2) When index is ready, force checkpoint and wait for it to happen
3) Purge index data if node crashed before checkpoint

Alternatively, we may even not trigger a checkpoint, hoping that that node will not crash before the nearest checkpoint is finished. If node crashed during this time window, index should be marked as "invalid", and not used for queries. Then user should either re-create or rebuild it.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)