database - 如何将不同的 Cassandra 表存储在不同的存储介质上？

Question

阅读 this somewhat old page about Cassandra 1.1 features ，似乎可以将表配置为转到某个存储介质。在尝试搜索文档后，我找不到任何关于它的信息。

Cassandra 的存储配置应该如何支持这种设置？

非常感谢!

Answer 1

Cassandra 1.1 and later releases provide fine-grained control of table storage on disk, writing tables to disk
using separate table directories within each keyspace directory. Data files are stored using this directory
and file naming format:
/var/lib/cassandra/data/ks1/cf1/ks1-cf1-hc-1-Data.db
The new file name format includes the keyspace name to distinguish which keyspace and table the file
contains when streaming or bulk loading data. Cassandra creates a subdirectory for each table, which
allows you to symlink a table to a chosen physical drive or data volume. This provides the capability to
move very active tables to faster media, such as SSD’s for better performance, and also divvy up tables
across all attached storage devices for better I/O balance at the storage layer.

有了这个，希望你能明白他们的意思。您应创建指向将包含媒体或任何其他数据的表的符号链接(symbolic link)。由于 cassandra 以特定方式存储所有列族信息，这是可以预测的。这有助于这种用法。