How to plan the cluster size

diggy · April 13, 2020, 2:07am

Moved from GitHub dgraph/5177

My current machine configuration is 8core16GB, 3node
After testing 400 million data imports, I found that the query is very slow. I am not sure whether the number of 3nodes currently used meets the requirements, or whether I use 6nodes, and then enable sharding. Could anyone give me some guidance?

diggy · April 15, 2020, 2:49pm

ashish-goswami commented :

Hi @jameswangcnbj, thanks for reaching out to us. I would like to ask to you few things before suggesting anything:

Dgraph version you are running.
Size of p directory.
Type of query you are running.
Also what are memory and CPU usage when you are running that query. You can also collect profiles if possible(https://dgraph.io/docs/howto/#profiling-information)

diggy · April 17, 2020, 6:18am

jameswangcnbj commented :

dgraph 20.03
p:20GB
cpu:50% ram:60% or higher

diggy · April 20, 2020, 1:58pm

ashish-goswami commented :

Hey @jameswangcnbj, Thanks for above information. Are you running all 3 nodes on same machine? How much queries are you serving when CPU/RAM usage are as above.
As per above information query might be slow. Please tell us the type of query you are trying to run. Also expected and actual latency.

diggy · April 22, 2020, 1:03am

jameswangcnbj commented :

no,i run 3node in 3 machine,i want to get the result in 10-500ms,the longest within 1s

diggy · April 23, 2020, 2:19pm

ashish-goswami commented :

@jameswangcnbj, if machines used for all alpha are different, this should be good enough. Please tell us the type of queries you are running. As part for query response, you can also check which part of query processing is consuming most time using debug param(https://dgraph.io/docs/query-language/#debug)