Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is using IP address as primary key a good practice in scylla db?

I'm using scylla db and have a table using IP address as the primary key. The RF for the cluster is 3. I find some nodes have way more loads (take more disk space) than others even if the owns stats are close (31% ~ 35%)

I am wondering is that because I'm using the IP address as the primary key and some IP address are hotter than others (like more update on those IPs)?

like image 330
SilentCanon Avatar asked Nov 21 '19 22:11

SilentCanon


1 Answers

You're probably right, better add another field to spread the data better

like image 80
dor laor Avatar answered Oct 05 '22 18:10

dor laor