[IGNITE-7495] Ability to disable WAL globally for data region

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: cache
• Assignee: Unassigned
• Reporter: Vladimir Ozerov
• Created: 23/Jan/18 07:32
• Updated: 29/Aug/18 08:09

Description

Recently we introduced a set of commands to control WAL state of particular caches. I.e. using SQL API user could do the following to disable WAL in order to speedup data load:

ALTER TABLE my_table NOLOGGING

Now consider that user has a lot of tables and would like to disable WAL for the whole data region at once (e.g. to load data for the whole schema). Currently to achieve this he would have to issue a number of commands for each and every table.

Instead, we should provide tiered approach, when user could disable WAL for both cache and data region. Proposed commands:

ALTER DATA REGION my_region NOLOGGING; // Disable for region
ALTER TABLE my_table NOLOGGING;        // Disable for table

NOTE
Semantics of tiered behaviour should be designed carefully. E.g. it should be possible to have a data region with disabled WAL, while still being able to have a cache in it with enabled WAL. Please refer to Oracle's NOLOGGING handling.

Issue Links

• is related to: IGNITE-7003 Ability to disable WAL (Non recoverable case)