如何使用Gocql优化Scylla数据库的跨分片查询

我正在使用具有9个节点且复制因子为3的scylla群集。
一个应用程序打开了一个连接 </ p>

但是,我注意到在scylla CQL优化监控仪表板中,交叉分片的百分比非常高,大约为150%。</ p>
\ n

是正常的还是我该如何优化呢?</ p>
</ div>

展开原文

原文

I'm using a scylla cluster with 9 nodes and replication factor to be 3. One application opens one connections to it, reading and writing data.

However, I notice in the scylla CQL optimization monitoring dashboard, the percentage for cross shard is very high, around 150%.

Is that normal or how can I optimize it.

1个回答



首先,此指标存在问题,并且已在最新的信息中心中将其删除
https://github.com/scylladb/scylla-monitoring/issues/659 </ p>

第二,减少交叉信息的方法是使用令牌感知驱动程序。 目前有两种令牌识别驱动程序:Go和Java
https://docs.scylladb .com / using-scylla / scylla_drivers / </ p>
</ div>

展开原文

原文

First, there is an issue with this metric, and it was removed in the latest dashboard https://github.com/scylladb/scylla-monitoring/issues/659

Second, the way to reduce cross-shard messages is using Token Aware drivers, if you can. There are two Token Aware drivers at the moment: Go and Java https://docs.scylladb.com/using-scylla/scylla_drivers/

duanjianxu4288
duanjianxu4288 您应该使用令牌感知和dcaware策略github.com/gocql/gocql/blob/…
大约一年之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐