Re: Recommended HW on AWS EC2 - vertical vs horizontal scaling

2018-09-19 Thread aealexsandrov
Hi, Left the list with some useful articles links here http://apache-ignite-users.70518.x6.nabble.com/Slow-SQL-query-uses-only-a-single-CPU-td23553.html BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Recommended HW on AWS EC2 - vertical vs horizontal scaling

2018-08-24 Thread eugene miretsky
Thanks Andrei, For user case, please see my email ("Data modeling for segmenting a huge data set: precomputing vs real time computations"). I think our main confusion right now is trying to understand how exactly SQL queries work (when memory is moved to heap, when/how is H2 used, how the reduce

Re: Recommended HW on AWS EC2 - vertical vs horizontal scaling

2018-08-24 Thread aealexsandrov
Hi, Ignite doesn't have such kind of benchmarks because they are very specific for every case and setup. However, exists several common tips: 1)In case if you will use EBS then try to avoid the NVMe. It is fast but looks like doesn't provide the guarantees for saving your data. We face the corru

Recommended HW on AWS EC2 - vertical vs horizontal scaling

2018-08-21 Thread eugene miretsky
Hello, We are looking to set up a fairly large (a few TB) cluster in AWS for OLAP and transactional use cases. 1. Are there any Ignite benchmarks on horizontally vs vertical scaling? 2. What EC2 instances are other people using in prod? (I am assuming that one of the memory optimized