In this post the authors say that Apache Ignite supports strong consistency and they list a code sample which uses key-values. But I was unable to find a mention of the same in the docs for SQL. Does Apache Ignite support strong consistency in SQL mode? If it does, will I be able to use it's other features (transactions, ACID properties) with strong consistency turned on? What is the performance hit by having full consistency turned on?
Any pointers to the right documentation will be very helpful!
According to this reply on the Dev mailing list Apache ignite SQL is strongly consistent but is not transactional