cassandra大表读写timeout的配置解决

本文主要是介绍cassandra大表读写timeout的配置解决，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

 

程序异常如下：Caused by: com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra timeout during write query at consistency LOCAL_ONE (1 replica were required but only 0 acknowledged the write)

原因很显然是coordinator，就是node没有及时响应写完成

解决方法无外乎，减少数据量，提高超时时间

在cassandra.yaml里

1 2 3 4

# How long the coordinator should wait for writes to complete write_request_timeout_in_ms: 2000 # How long the coordinator should wait for counter writes to complete counter_write_request_timeout_in_ms: 5000

将这2项都调大，默认是2s和5s

调整后，重启节点生效

1 2 3

ps auwx | grep cassandra sudo kill pid bin/cassandra

 

sort of, I have some experience in the domain of database(MySQL/mongo), java, python, front-end, etc. I'll willing to give and accept bits of help from others. now base in Singapore.

这篇关于cassandra大表读写timeout的配置解决的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---