1) H2 server should be started as a part of storage node. No clustering mode is used.
2) Each Hazelcast node copies all the data to its own in-memory H2 database instance (probably backup-count should be equal to the total number of nodes in cluster).
3) When an SQL request arrives storage simply proxies request to its H2 instance.
1) H2 server should be started as a part of storage node. No clustering mode is used. 2) Each Hazelcast node copies all the data to its own in-memory H2 database instance (probably backup-count should be equal to the total number of nodes in cluster). 3) When an SQL request arrives storage simply proxies request to its H2 instance.