0 Replies Latest reply on Nov 30, 2012 4:52 PM by safetytrick

    Infinispan Cassandra Cache Loader Keyspace/Column Family Definition

    safetytrick

      I'm evaluating the Cassandra CacheStore: https://docs.jboss.org/author/display/ISPN/Cassandra+CacheStore

       

      I'm pretty new to Cassandra but I think I've adapted the keyspace and column family definitions to a format that works with Cassandra 1.1.6 (I could not find a way to use the xml in the Cassandra CacheStore documentation).

       

      I've pasted the output of 'show schema;' below, is this correct? It seems to work but I'm not positive?

       

      create keyspace Infinispan

        with placement_strategy = 'SimpleStrategy'

        and strategy_options = {replication_factor : 2}

        and durable_writes = true;

       

      use Infinispan;

       

      create column family InfinispanEntries

        with column_type = 'Standard'

        and comparator = 'BytesType'

        and default_validation_class = 'BytesType'

        and key_validation_class = 'BytesType'

        and read_repair_chance = 0.1

        and dclocal_read_repair_chance = 0.0

        and gc_grace = 864000

        and min_compaction_threshold = 4

        and max_compaction_threshold = 32

        and replicate_on_write = true

        and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'

        and caching = 'KEYS_ONLY'

        and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};

       

      create column family InfinispanExpiration

        with column_type = 'Super'

        and comparator = 'LongType'

        and subcomparator = 'BytesType'

        and default_validation_class = 'BytesType'

        and key_validation_class = 'BytesType'

        and read_repair_chance = 0.1

        and dclocal_read_repair_chance = 0.0

        and gc_grace = 864000

        and min_compaction_threshold = 4

        and max_compaction_threshold = 32

        and replicate_on_write = true

        and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'

        and caching = 'KEYS_ONLY'

        and compression_options = {'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'};