Github user vinaykumarchella commented on a diff in the pull request:
https://github.com/apache/cassandra/pull/277#discussion_r225629052
--- Diff: doc/source/operating/blacklisting_partitions.rst ---
@@ -0,0 +1,67 @@
+.. Licensed to the Apache Software Foundation (ASF) under one
+.. or more contributor license agreements. See the NOTICE file
+.. distributed with this work for additional information
+.. regarding copyright ownership. The ASF licenses this file
+.. to you under the Apache License, Version 2.0 (the
+.. "License"); you may not use this file except in compliance
+.. with the License. You may obtain a copy of the License at
+..
+.. http://www.apache.org/licenses/LICENSE-2.0
+..
+.. Unless required by applicable law or agreed to in writing, software
+.. distributed under the License is distributed on an "AS IS" BASIS,
+.. WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+.. See the License for the specific language governing permissions and
+.. limitations under the License.
+
+.. highlight:: none
+
+
+Blacklisting Partitions (CASSANDRA-12106)
+-----------------------------------------
+
+This feature allows partition keys to be blacklisted i.e. Cassandra would
not process following operations on those
+blacklisted partitions.
+
+- Point READs
+
+Response would be InvalidQueryException.
+
+It is important to note that, this would not have any effect on range
reads or write operations.
+
+How to blacklist a partition key
+^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+``system_distributed.blacklisted_partitions`` table can be used to
blacklist partitions. Essentially, you will have to
+insert a new row into the table with the following details:
+
+- Keyspace name
+- Table name
+- Partition key
+
+The way partition key needs to be mentioned is exactly similar to how
``nodetool getendpoints`` works.
+Following are several examples for blacklisting partition keys in
keyspace, say ks, and table, say table1 for different
+possibilities of table1 partition key:
+- For a single column partition key, say Id,
+ Id is a simple type - insert into
system_distributed.blacklisted_partitions (keyspace_name ,columnfamily_name
,partition_key) VALUES ('ks','table1','1');
+ Id is a blob - insert into
system_distributed.blacklisted_partitions (keyspace_name ,columnfamily_name
,partition_key) VALUES ('ks','table1','12345f');
+ Id has a colon - insert into
system_distributed.blacklisted_partitions (keyspace_name ,columnfamily_name
,partition_key) VALUES ('ks','table1','1\:2');
+
+- For a composite column partition key, say (Key1, Key2),
+ insert into system_distributed.blacklisted_partitions (keyspace_name
,columnfamily_name, partition_key) VALUES ('ks','table1','k11:k21');
+
+BlacklistedPartitions Cache
+^^^^^^^^^^^^^^^^^^^^^^^^^^^
+Cassandra internally maintains an on-heap cache that loads partition keys
from ``system_distributed.blacklisted_partitions``.
+Any partition key mentioned against a non-existent keyspace name and table
name will not be cached.
+
+Cache gets refreshed in following ways
+- During Cassandra start up
+- Scheduled cache refresh at a default interval of 10 minutes (can be
overridden using ``blacklisted_partitions_cache_refresh_period_in_sec`` yaml
property)
+- Using ``nodetool blacklistedpartitions --refresh-cache``
+
+Cache size is bounded, set by
``blacklisted_partitions_cache_size_limit_in_mb`` yaml property (defaulted to
100 MB).
+As cache loads blacklisted partitions from
``system_distributed.blacklisted_partitions``, it checks if cache size exceeds
the size limit.
+The moment cache size exceeeds the size limit, no more partitions are
loaded into the cache, and only those partitions that have been loaded so far
would be blacklisted.
+A warning would be logged to indicate the same.
+Size limit on the cache can be changed using the yaml property, or
dynamically using below nodetool command
+``nodetool blacklistedpartitions --cache-size-limit-in-mb=150
--refreshcache``
--- End diff --
Can you also add `Limitations/ Gotchas` section explaining that it will not
block range reads and mutations etc.,
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
