Hi all, 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 usual RDMBs. 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 thx for you help -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
