How many Ignite nodes per Server + backup behavior
Since Ignite uses only one thread/CPU for SQL reads per node.
It is using only a very small part of the available Server resources.
And so it is absolutly necessary to start multiple nodes per Server to
improve read performance.
Currently we testing Ignite with 4 Server each 8core/16thread
1. What would you recommend, how many Ignite nodes to run per Server?
Currently we running 4 Ignite nodes per server = 16 nodes in total.
But with that configuration Ignite behaves little slow compared to other
2. Is backup parameter aware about the number of Servers in the grid?
How is the behavior of backup when creating tables.
If we run 4 nodes per server, does it mean we need to set backup=2.
and ignite knows that one backup needs to go to another server.
or do we need to set backup=5, because ignite is not aware about servers, it
just takes nodes into account. and to avoid that all 2 backups are on same
server, backup propperty needs to be > than number of nodes on server.
3. query parallelism
besides query parallelism has some heavy downsites, needs to be configured
at the start, cant be changed etc.
our tests also show that query parallelism=2 gives like 50% more speed,
while to just setup 2 nodes gives 90% more speed.
just wondering why, becasue this way query parallelism is basicaly useless