正文

Ubuntu18.04 LTS 搭建Cassandra集群

IP云
IP云V管理员/7 阅读
06/17
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

环境需求

  • jdk8

    root@node01:~# java -version
    java version "1.8.0_202"
    Java(TM) SE Runtime Environment (build 1.8.0_202-b08)
    Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed mode)

    • 配置jdk请参考: https://www.cnblogs.com/ronnieyuan/p/11461377.html

  • python 2.7(必须是2.7版本[踩过坑], 截止本文时还没有python3版本的支持)

    • 如果你是centos7, 那么自带就有python2.7, 也没问题, centos6的话需要将python2.6升级到2.7。
    • ubuntu18.04 自带python2.7以及python3.6, 所有不用折腾python环境。

    root@node01:~# python -V
    Python 2.7.15+

集群规划

机器ip
node01192.168.180.130
node02192.168.180.131
node03192.168.180.132
node04192.168.180.133
node05192.168.180.134

安装

  • 上传二进制文件tar包, 并解压到指定目录

    tar -zxvf apache-cassandra-3.11.5-bin.tar.gz -C /opt/ronnie

  • 修改文件名

    root@node01:/home/ronnie/soft# cd /opt/ronnie/
    root@node01:/opt/ronnie# mv apache-cassandra-3.11.5/ cassandra-3.11.5

  • 修改cassandra配置文件

    • 集群名称

    10 cluster_name: 'ronnie-test'

    • 类似主节点, 所有节点都到这里的配置的ip上去获得所有其他节点的信息, 可以配置多个。

    423 # seeds is actually a comma-delimited list of addresses.
    424 # Ex: "<ip1>,<ip2>,<ip3>"
    425 - seeds: "192.168.180.130,192.168.180.131"

    • 监听地址(每台机子写对应的本机地址, 如有内外IP, 写内IP)

      612 listen_address: 192.168.180.130

    • rpc地址(每台机子写对应的本机地址, 如有内外IP, 写外IP)

      688 # For security reasons, you should not expose this port to the internet. Firewall it if needed.
      689 rpc_address: 192.168.180.130

  • 将文件目录传送给其他几台机子(传好后记得去修改监听地址及rpc地址)

    root@node01:/opt/ronnie# scp -r cassandra-3.11.5/ root@node02:`pwd`
    root@node01:/opt/ronnie# scp -r cassandra-3.11.5/ root@node03:`pwd`
    root@node01:/opt/ronnie# scp -r cassandra-3.11.5/ root@node04:`pwd`
    root@node01:/opt/ronnie# scp -r cassandra-3.11.5/ root@node05:`pwd`

  • 修改环境变量

    • vim ~/.bashrc

    # Cassandra
    export CASSANDRA_HOME=/opt/ronnie/cassandra-3.11.5
    export PATH=$CASSANDRA_HOME/bin:$PATH

    • source ~/.bashrc

启动集群

  • 在各个节点启动cassandra

    • 如果你用root启动呐会报一个和elasticSearch同类的错误:

      root@node01:/opt/ronnie# cassandra
      Running Cassandra as root user or group is not recommended - please start Cassandra using a different system user.
      If you really want to force running Cassandra as root, use -R command line option.

      • 为了安全起见, 不建议使用root启动, 但是如果一定要用root启动, 就用 -R

    • 那就强行启动吧, 反正不是生产环境(逃)

      cassandra -R

    • 简单看一下日志

      CompilerOracle: dontinline org/apache/cassandra/db/Columns$Serializer.deserializeLargeSubset (Lorg/apache/cassandra/io/util/DataInputPlus;Lorg/apache/cassandra/db/Columns;I)Lorg/apache/cassandra/db/Columns;
      CompilerOracle: dontinline org/apache/cassandra/db/Columns$Serializer.serializeLargeSubset (Ljava/util/Collection;ILorg/apache/cassandra/db/Columns;ILorg/apache/cassandra/io/util/DataOutputPlus;)V
      CompilerOracle: dontinline org/apache/cassandra/db/Columns$Serializer.serializeLargeSubsetSize (Ljava/util/Collection;ILorg/apache/cassandra/db/Columns;I)I
      CompilerOracle: dontinline org/apache/cassandra/db/commitlog/AbstractCommitLogSegmentManager.advanceAllocatingFrom (Lorg/apache/cassandra/db/commitlog/CommitLogSegment;)V
      CompilerOracle: dontinline org/apache/cassandra/db/transform/BaseIterator.tryGetMoreContents ()Z
      CompilerOracle: dontinline org/apache/cassandra/db/transform/StoppingTransformation.stop ()V
      CompilerOracle: dontinline org/apache/cassandra/db/transform/StoppingTransformation.stopInPartition ()V
      CompilerOracle: dontinline org/apache/cassandra/io/util/BufferedDataOutputStreamPlus.doFlush (I)V
      CompilerOracle: dontinline org/apache/cassandra/io/util/BufferedDataOutputStreamPlus.writeExcessSlow ()V
      CompilerOracle: dontinline org/apache/cassandra/io/util/BufferedDataOutputStreamPlus.writeSlow (JI)V
      CompilerOracle: dontinline org/apache/cassandra/io/util/RebufferingInputStream.readPrimitiveSlowly (I)J
      CompilerOracle: inline org/apache/cassandra/db/rows/UnfilteredSerializer.serializeRowBody (Lorg/apache/cassandra/db/rows/Row;ILorg/apache/cassandra/db/SerializationHeader;Lorg/apache/cassandra/io/util/DataOutputPlus;)V
      CompilerOracle: inline org/apache/cassandra/io/util/Memory.checkBounds (JJ)V
      CompilerOracle: inline org/apache/cassandra/io/util/SafeMemory.checkBounds (JJ)V
      CompilerOracle: inline org/apache/cassandra/utils/AsymmetricOrdering.selectBoundary (Lorg/apache/cassandra/utils/AsymmetricOrdering/Op;II)I
      CompilerOracle: inline org/apache/cassandra/utils/AsymmetricOrdering.strictnessOfLessThan (Lorg/apache/cassandra/utils/AsymmetricOrdering/Op;)I
      CompilerOracle: inline org/apache/cassandra/utils/BloomFilter.indexes (Lorg/apache/cassandra/utils/IFilter/FilterKey;)[J
      CompilerOracle: inline org/apache/cassandra/utils/BloomFilter.setIndexes (JJIJ[J)V
      CompilerOracle: inline org/apache/cassandra/utils/ByteBufferUtil.compare (Ljava/nio/ByteBuffer;[B)I
      CompilerOracle: inline org/apache/cassandra/utils/ByteBufferUtil.compare ([BLjava/nio/ByteBuffer;)I
      CompilerOracle: inline org/apache/cassandra/utils/ByteBufferUtil.compareUnsigned (Ljava/nio/ByteBuffer;Ljava/nio/ByteBuffer;)I
      CompilerOracle: inline org/apache/cassandra/utils/FastByteOperations$UnsafeOperations.compareTo (Ljava/lang/Object;JILjava/lang/Object;JI)I
      CompilerOracle: inline org/apache/cassandra/utils/FastByteOperations$UnsafeOperations.compareTo (Ljava/lang/Object;JILjava/nio/ByteBuffer;)I
      CompilerOracle: inline org/apache/cassandra/utils/FastByteOperations$UnsafeOperations.compareTo (Ljava/nio/ByteBuffer;Ljava/nio/ByteBuffer;)I
      CompilerOracle: inline org/apache/cassandra/utils/vint/VIntCoding.encodeVInt (JI)[B
      INFO [main] 2019-12-14 11:36:14,245 YamlConfigurationLoader.java:89 - Configuration location: file:/opt/ronnie/cassandra-3.11.5/conf/cassandra.yaml
      INFO [main] 2019-12-14 11:36:14,717 Config.java:516 - Node configuration:[allocate_tokens_for_keyspace=null; authenticator=AllowAllAuthenticator; authorizer=AllowAllAuthorizer; auto_bootstrap=true; auto_snapshot=true; back_pressure_enabled=false; back_pressure_strategy=org.apache.cassandra.net.RateBasedBackPressure{high_ratio=0.9, factor=5, flow=FAST}; batch_size_fail_threshold_in_kb=50; batch_size_warn_threshold_in_kb=5; batchlog_replay_throttle_in_kb=1024; broadcast_address=null; broadcast_rpc_address=null; buffer_pool_use_heap_if_exhausted=true; cas_contention_timeout_in_ms=1000; cdc_enabled=false; cdc_free_space_check_interval_ms=250; cdc_raw_directory=null; cdc_total_space_in_mb=0; client_encryption_options=<REDACTED>; cluster_name=ronnie-test; column_index_cache_size_in_kb=2; column_index_size_in_kb=64; commit_failure_policy=stop; commitlog_compression=null; commitlog_directory=null; commitlog_max_compression_buffers_in_pool=3; commitlog_periodic_queue_size=-1; commitlog_segment_size_in_mb=32; commitlog_sync=periodic; commitlog_sync_batch_window_in_ms=NaN; commitlog_sync_period_in_ms=10000; commitlog_total_space_in_mb=null; compaction_large_partition_warning_threshold_mb=100; compaction_throughput_mb_per_sec=16; concurrent_compactors=null; concurrent_counter_writes=32; concurrent_materialized_view_writes=32; concurrent_reads=32; concurrent_replicates=null; concurrent_writes=32; counter_cache_keys_to_save=2147483647; counter_cache_save_period=7200; counter_cache_size_in_mb=null; counter_write_request_timeout_in_ms=5000; credentials_cache_max_entries=1000; credentials_update_interval_in_ms=-1; credentials_validity_in_ms=2000; cross_node_timeout=false; data_file_directories=[Ljava.lang.String;@1460a8c0; disk_access_mode=auto; disk_failure_policy=stop; disk_optimization_estimate_percentile=0.95; disk_optimization_page_cross_chance=0.1; disk_optimization_strategy=ssd; dynamic_snitch=true; dynamic_snitch_badness_threshold=0.1; dynamic_snitch_reset_interval_in_ms=600000; dynamic_snitch_update_interval_in_ms=100; enable_materialized_views=true; enable_sasi_indexes=true; enable_scripted_user_defined_functions=false; enable_user_defined_functions=false; enable_user_defined_functions_threads=true; encryption_options=null; endpoint_snitch=SimpleSnitch; file_cache_round_up=null; file_cache_size_in_mb=null; gc_log_threshold_in_ms=200; gc_warn_threshold_in_ms=1000; hinted_handoff_disabled_datacenters=[]; hinted_handoff_enabled=true; hinted_handoff_throttle_in_kb=1024; hints_compression=null; hints_directory=null; hints_flush_period_in_ms=10000; incremental_backups=false; index_interval=null; index_summary_capacity_in_mb=null; index_summary_resize_interval_in_minutes=60; initial_token=null; inter_dc_stream_throughput_outbound_megabits_per_sec=200; inter_dc_tcp_nodelay=false; internode_authenticator=null; internode_compression=dc; internode_recv_buff_size_in_bytes=0; internode_send_buff_size_in_bytes=0; key_cache_keys_to_save=2147483647; key_cache_save_period=14400; key_cache_size_in_mb=null; listen_address=192.168.180.130; listen_interface=null; listen_interface_prefer_ipv6=false; listen_on_broadcast_address=false; max_hint_window_in_ms=10800000; max_hints_delivery_threads=2; max_hints_file_size_in_mb=128; max_mutation_size_in_kb=null; max_streaming_retries=3; max_value_size_in_mb=256; memtable_allocation_type=heap_buffers; memtable_cleanup_threshold=null; memtable_flush_writers=0; memtable_heap_space_in_mb=null; memtable_offheap_space_in_mb=null; min_free_space_per_drive_in_mb=50; native_transport_flush_in_batches_legacy=true; native_transport_max_concurrent_connections=-1; native_transport_max_concurrent_connections_per_ip=-1; native_transport_max_concurrent_requests_in_bytes=-1; native_transport_max_concurrent_requests_in_bytes_per_ip=-1; native_transport_max_frame_size_in_mb=256; native_transport_max_negotiable_protocol_version=-2147483648; native_transport_max_threads=128; native_transport_port=9042; native_transport_port_ssl=null; num_tokens=256; otc_backlog_expiration_interval_ms=200; otc_coalescing_enough_coalesced_messages=8; otc_coalescing_strategy=DISABLED; otc_coalescing_window_us=200; partitioner=org.apache.cassandra.dht.Murmur3Partitioner; permissions_cache_max_entries=1000; permissions_update_interval_in_ms=-1; permissions_validity_in_ms=2000; phi_convict_threshold=8.0; prepared_statements_cache_size_mb=null; range_request_timeout_in_ms=10000; read_request_timeout_in_ms=5000; repair_session_max_tree_depth=18; request_scheduler=org.apache.cassandra.scheduler.NoScheduler; request_scheduler_id=null; request_scheduler_options=null; request_timeout_in_ms=10000; role_manager=CassandraRoleManager; roles_cache_max_entries=1000; roles_update_interval_in_ms=-1; roles_validity_in_ms=2000; row_cache_class_name=org.apache.cassandra.cache.OHCProvider; row_cache_keys_to_save=2147483647; row_cache_save_period=0; row_cache_size_in_mb=0; rpc_address=192.168.180.130; rpc_interface=null; rpc_interface_prefer_ipv6=false; rpc_keepalive=true; rpc_listen_backlog=50; rpc_max_threads=2147483647; rpc_min_threads=16; rpc_port=9160; rpc_recv_buff_size_in_bytes=null; rpc_send_buff_size_in_bytes=null; rpc_server_type=sync; saved_caches_directory=null; seed_provider=org.apache.cassandra.locator.SimpleSeedProvider{seeds=192.168.180.130,192.168.180.131}; server_encryption_options=<REDACTED>; slow_query_log_timeout_in_ms=500; snapshot_before_compaction=false; ssl_storage_port=7001; sstable_preemptive_open_interval_in_mb=50; start_native_transport=true; start_rpc=false; storage_port=7000; stream_throughput_outbound_megabits_per_sec=200; streaming_keep_alive_period_in_secs=300; streaming_socket_timeout_in_ms=86400000; thrift_framed_transport_size_in_mb=15; thrift_max_message_length_in_mb=16; thrift_prepared_statements_cache_size_mb=null; tombstone_failure_threshold=100000; tombstone_warn_threshold=1000; tracetype_query_ttl=86400; tracetype_repair_ttl=604800; transparent_data_encryption_options=org.apache.cassandra.config.TransparentDataEncryptionOptions@4f638935; trickle_fsync=false; trickle_fsync_interval_in_kb=10240; truncate_request_timeout_in_ms=60000; unlogged_batch_across_partitions_warn_threshold=10; user_defined_function_fail_timeout=1500; user_defined_function_warn_timeout=500; user_function_timeout_policy=die; windows_timer_interval=1; write_request_timeout_in_ms=2000]
      INFO [main] 2019-12-14 11:36:14,717 DatabaseDescriptor.java:381 - DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmap
      INFO [main] 2019-12-14 11:36:14,717 DatabaseDescriptor.java:439 - Global memtable on-heap threshold is enabled at 249MB
      INFO [main] 2019-12-14 11:36:14,718 DatabaseDescriptor.java:443 - Global memtable off-heap threshold is enabled at 249MB
      WARN [main] 2019-12-14 11:36:14,830 DatabaseDescriptor.java:579 - Only 20.714GiB free across all data volumes. Consider adding more capacity to your cluster or removing obsolete snapshots
      INFO [main] 2019-12-14 11:36:14,852 RateBasedBackPressure.java:123 - Initialized back-pressure with high ratio: 0.9, factor: 5, flow: FAST, window size: 2000.
      INFO [main] 2019-12-14 11:36:14,852 DatabaseDescriptor.java:773 - Back-pressure is disabled with strategy org.apache.cassandra.net.RateBasedBackPressure{high_ratio=0.9, factor=5, flow=FAST}.
      INFO [main] 2019-12-14 11:36:15,050 JMXServerUtils.java:246 - Configured JMX server at: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:7199/jmxrmi
      INFO [main] 2019-12-14 11:36:15,057 CassandraDaemon.java:476 - Hostname: node01
      INFO [main] 2019-12-14 11:36:15,057 CassandraDaemon.java:483 - JVM vendor/version: Java HotSpot(TM) 64-Bit Server VM/1.8.0_202
      INFO [main] 2019-12-14 11:36:15,058 CassandraDaemon.java:484 - Heap size: 998.438MiB/998.438MiB
      INFO [main] 2019-12-14 11:36:15,058 CassandraDaemon.java:489 - Code Cache Non-heap memory: init = 2555904(2496K) used = 4760640(4649K) committed = 4784128(4672K) max = 251658240(245760K)
      INFO [main] 2019-12-14 11:36:15,058 CassandraDaemon.java:489 - Metaspace Non-heap memory: init = 0(0K) used = 18464472(18031K) committed = 19005440(18560K) max = -1(-1K)
      INFO [main] 2019-12-14 11:36:15,058 CassandraDaemon.java:489 - Compressed Class Space Non-heap memory: init = 0(0K) used = 2270328(2217K) committed = 2490368(2432K) max = 1073741824(1048576K)
      INFO [main] 2019-12-14 11:36:15,059 CassandraDaemon.java:489 - Par Eden Space Heap memory: init = 214827008(209792K) used = 94553760(92337K) committed = 214827008(209792K) max = 214827008(209792K)
      INFO [main] 2019-12-14 11:36:15,059 CassandraDaemon.java:489 - Par Survivor Space Heap memory: init = 26804224(26176K) used = 0(0K) committed = 26804224(26176K) max = 26804224(26176K)
      INFO [main] 2019-12-14 11:36:15,059 CassandraDaemon.java:489 - CMS Old Gen Heap memory: init = 805306368(786432K) used = 0(0K) committed = 805306368(786432K) max = 805306368(786432K)
      INFO [main] 2019-12-14 11:36:15,060 CassandraDaemon.java:491 - Classpath: /opt/ronnie/cassandra-3.11.5/conf:/opt/ronnie/cassandra-3.11.5/build/classes/main:/opt/ronnie/cassandra-3.11.5/build/classes/thrift:/opt/ronnie/cassandra-3.11.5/lib/HdrHistogram-2.1.9.jar:/opt/ronnie/cassandra-3.11.5/lib/ST4-4.0.8.jar:/opt/ronnie/cassandra-3.11.5/lib/airline-0.6.jar:/opt/ronnie/cassandra-3.11.5/lib/antlr-runtime-3.5.2.jar:/opt/ronnie/cassandra-3.11.5/lib/apache-cassandra-3.11.5.jar:/opt/ronnie/cassandra-3.11.5/lib/apache-cassandra-thrift-3.11.5.jar:/opt/ronnie/cassandra-3.11.5/lib/asm-5.0.4.jar:/opt/ronnie/cassandra-3.11.5/lib/caffeine-2.2.6.jar:/opt/ronnie/cassandra-3.11.5/lib/cassandra-driver-core-3.0.1-shaded.jar:/opt/ronnie/cassandra-3.11.5/lib/commons-cli-1.1.jar:/opt/ronnie/cassandra-3.11.5/lib/commons-codec-1.9.jar:/opt/ronnie/cassandra-3.11.5/lib/commons-lang3-3.1.jar:/opt/ronnie/cassandra-3.11.5/lib/commons-math3-3.2.jar:/opt/ronnie/cassandra-3.11.5/lib/compress-lzf-0.8.4.jar:/opt/ronnie/cassandra-3.11.5/lib/concurrent-trees-2.4.0.jar:/opt/ronnie/cassandra-3.11.5/lib/concurrentlinkedhashmap-lru-1.4.jar:/opt/ronnie/cassandra-3.11.5/lib/disruptor-3.0.1.jar:/opt/ronnie/cassandra-3.11.5/lib/ecj-4.4.2.jar:/opt/ronnie/cassandra-3.11.5/lib/guava-18.0.jar:/opt/ronnie/cassandra-3.11.5/lib/high-scale-lib-1.0.6.jar:/opt/ronnie/cassandra-3.11.5/lib/hppc-0.5.4.jar:/opt/ronnie/cassandra-3.11.5/lib/jackson-core-asl-1.9.13.jar:/opt/ronnie/cassandra-3.11.5/lib/jackson-mapper-asl-1.9.13.jar:/opt/ronnie/cassandra-3.11.5/lib/jamm-0.3.0.jar:/opt/ronnie/cassandra-3.11.5/lib/javax.inject.jar:/opt/ronnie/cassandra-3.11.5/lib/jbcrypt-0.3m.jar:/opt/ronnie/cassandra-3.11.5/lib/jcl-over-slf4j-1.7.7.jar:/opt/ronnie/cassandra-3.11.5/lib/jctools-core-1.2.1.jar:/opt/ronnie/cassandra-3.11.5/lib/jflex-1.6.0.jar:/opt/ronnie/cassandra-3.11.5/lib/jna-4.2.2.jar:/opt/ronnie/cassandra-3.11.5/lib/joda-time-2.4.jar:/opt/ronnie/cassandra-3.11.5/lib/json-simple-1.1.jar:/opt/ronnie/cassandra-3.11.5/lib/jstackjunit-0.0.1.jar:/opt/ronnie/cassandra-3.11.5/lib/libthrift-0.9.2.jar:/opt/ronnie/cassandra-3.11.5/lib/log4j-over-slf4j-1.7.7.jar:/opt/ronnie/cassandra-3.11.5/lib/logback-classic-1.1.3.jar:/opt/ronnie/cassandra-3.11.5/lib/logback-core-1.1.3.jar:/opt/ronnie/cassandra-3.11.5/lib/lz4-1.3.0.jar:/opt/ronnie/cassandra-3.11.5/lib/metrics-core-3.1.5.jar:/opt/ronnie/cassandra-3.11.5/lib/metrics-jvm-3.1.5.jar:/opt/ronnie/cassandra-3.11.5/lib/metrics-logback-3.1.5.jar:/opt/ronnie/cassandra-3.11.5/lib/netty-all-4.0.44.Final.jar:/opt/ronnie/cassandra-3.11.5/lib/ohc-core-0.4.4.jar:/opt/ronnie/cassandra-3.11.5/lib/ohc-core-j8-0.4.4.jar:/opt/ronnie/cassandra-3.11.5/lib/reporter-config-base-3.0.3.jar:/opt/ronnie/cassandra-3.11.5/lib/reporter-config3-3.0.3.jar:/opt/ronnie/cassandra-3.11.5/lib/sigar-1.6.4.jar:/opt/ronnie/cassandra-3.11.5/lib/slf4j-api-1.7.7.jar:/opt/ronnie/cassandra-3.11.5/lib/snakeyaml-1.11.jar:/opt/ronnie/cassandra-3.11.5/lib/snappy-java-1.1.1.7.jar:/opt/ronnie/cassandra-3.11.5/lib/snowball-stemmer-1.3.0.581.1.jar:/opt/ronnie/cassandra-3.11.5/lib/stream-2.5.2.jar:/opt/ronnie/cassandra-3.11.5/lib/thrift-server-0.3.7.jar:/opt/ronnie/cassandra-3.11.5/lib/jsr223/*/*.jar:/opt/ronnie/cassandra-3.11.5/lib/jamm-0.3.0.jar
      INFO [main] 2019-12-14 11:36:15,061 CassandraDaemon.java:493 - JVM Arguments: [-Xloggc:/opt/ronnie/cassandra-3.11.5/logs/gc.log, -ea, -XX:+UseThreadPriorities, -XX:ThreadPriorityPolicy=42, -XX:+HeapDumpOnOutOfMemoryError, -Xss256k, -XX:StringTableSize=1000003, -XX:+AlwaysPreTouch, -XX:-UseBiasedLocking, -XX:+UseTLAB, -XX:+ResizeTLAB, -XX:+UseNUMA, -XX:+PerfDisableSharedMem, -Djava.net.preferIPv4Stack=true, -XX:+UseParNewGC, -XX:+UseConcMarkSweepGC, -XX:+CMSParallelRemarkEnabled, -XX:SurvivorRatio=8, -XX:MaxTenuringThreshold=1, -XX:CMSInitiatingOccupancyFraction=75, -XX:+UseCMSInitiatingOccupancyOnly, -XX:CMSWaitDuration=10000, -XX:+CMSParallelInitialMarkEnabled, -XX:+CMSEdenChunksRecordAlways, -XX:+CMSClassUnloadingEnabled, -XX:+PrintGCDetails, -XX:+PrintGCDateStamps, -XX:+PrintHeapAtGC, -XX:+PrintTenuringDistribution, -XX:+PrintGCApplicationStoppedTime, -XX:+PrintPromotionFailure, -XX:+UseGCLogFileRotation, -XX:NumberOfGCLogFiles=10, -XX:GCLogFileSize=10M, -Xms1024M, -Xmx1024M, -Xmn256M, -XX:+UseCondCardMark, -XX:CompileCommandFile=/opt/ronnie/cassandra-3.11.5/conf/hotspot_compiler, -javaagent:/opt/ronnie/cassandra-3.11.5/lib/jamm-0.3.0.jar, -Dcassandra.jmx.local.port=7199, -Dcom.sun.management.jmxremote.authenticate=false, -Dcom.sun.management.jmxremote.password.file=/etc/cassandra/jmxremote.password, -Djava.library.path=/opt/ronnie/cassandra-3.11.5/lib/sigar-bin, -XX:OnOutOfMemoryError=kill -9 %p, -Dlogback.configurationFile=logback.xml, -Dcassandra.logdir=/opt/ronnie/cassandra-3.11.5/logs, -Dcassandra.storagedir=/opt/ronnie/cassandra-3.11.5/data]
      INFO [main] 2019-12-14 11:36:15,896 NativeLibrary.java:176 - JNA mlockall successful
      WARN [main] 2019-12-14 11:36:15,897 StartupChecks.java:136 - jemalloc shared library could not be preloaded to speed up memory allocations
      WARN [main] 2019-12-14 11:36:15,897 StartupChecks.java:169 - JMX is not enabled to receive remote connections. Please see cassandra-env.sh for more info.
      INFO [main] 2019-12-14 11:36:15,898 SigarLibrary.java:44 - Initializing SIGAR library
      WARN [main] 2019-12-14 11:36:15,911 SigarLibrary.java:174 - Cassandra server running in degraded mode. Is swap disabled? : false, Address space adequate? : true, nofile limit adequate? : true, nproc limit adequate? : false
      WARN [main] 2019-12-14 11:36:15,920 StartupChecks.java:311 - Maximum number of memory map areas per process (vm.max_map_count) 65530 is too low, recommended value: 1048575, you can change it with sysctl.
      WARN [main] 2019-12-14 11:36:15,924 StartupChecks.java:332 - Directory /opt/ronnie/cassandra-3.11.5/data/data doesn't exist
      WARN [main] 2019-12-14 11:36:15,927 StartupChecks.java:332 - Directory /opt/ronnie/cassandra-3.11.5/data/commitlog doesn't exist
      WARN [main] 2019-12-14 11:36:15,928 StartupChecks.java:332 - Directory /opt/ronnie/cassandra-3.11.5/data/saved_caches doesn't exist
      WARN [main] 2019-12-14 11:36:15,929 StartupChecks.java:332 - Directory /opt/ronnie/cassandra-3.11.5/data/hints doesn't exist
      INFO [main] 2019-12-14 11:36:15,977 QueryProcessor.java:116 - Initialized prepared statement caches with 10 MB (native) and 10 MB (Thrift)
      INFO [main] 2019-12-14 11:36:16,467 ColumnFamilyStore.java:426 - Initializing system.IndexInfo
      INFO [main] 2019-12-14 11:36:17,103 ColumnFamilyStore.java:426 - Initializing system.batches
      INFO [main] 2019-12-14 11:36:17,124 ColumnFamilyStore.java:426 - Initializing system.paxos
      INFO [main] 2019-12-14 11:36:17,135 ColumnFamilyStore.java:426 - Initializing system.local
      INFO [main] 2019-12-14 11:36:17,143 ColumnFamilyStore.java:426 - Initializing system.peers
      INFO [main] 2019-12-14 11:36:17,151 ColumnFamilyStore.java:426 - Initializing system.peer_events
      INFO [main] 2019-12-14 11:36:17,158 ColumnFamilyStore.java:426 - Initializing system.range_xfers
      INFO [main] 2019-12-14 11:36:17,164 ColumnFamilyStore.java:426 - Initializing system.compaction_history
      INFO [main] 2019-12-14 11:36:17,171 ColumnFamilyStore.java:426 - Initializing system.sstable_activity
      INFO [main] 2019-12-14 11:36:17,177 ColumnFamilyStore.java:426 - Initializing system.size_estimates
      INFO [main] 2019-12-14 11:36:17,188 ColumnFamilyStore.java:426 - Initializing system.available_ranges
      INFO [main] 2019-12-14 11:36:17,195 ColumnFamilyStore.java:426 - Initializing system.transferred_ranges
      INFO [main] 2019-12-14 11:36:17,202 ColumnFamilyStore.java:426 - Initializing system.views_builds_in_progress
      INFO [main] 2019-12-14 11:36:17,207 ColumnFamilyStore.java:426 - Initializing system.built_views
      INFO [main] 2019-12-14 11:36:17,214 ColumnFamilyStore.java:426 - Initializing system.hints
      INFO [main] 2019-12-14 11:36:17,218 ColumnFamilyStore.java:426 - Initializing system.batchlog
      INFO [main] 2019-12-14 11:36:17,226 ColumnFamilyStore.java:426 - Initializing system.prepared_statements
      INFO [main] 2019-12-14 11:36:17,231 ColumnFamilyStore.java:426 - Initializing system.schema_keyspaces
      INFO [main] 2019-12-14 11:36:17,269 ColumnFamilyStore.java:426 - Initializing system.schema_columnfamilies
      INFO [main] 2019-12-14 11:36:17,273 ColumnFamilyStore.java:426 - Initializing system.schema_columns
      INFO [main] 2019-12-14 11:36:17,276 ColumnFamilyStore.java:426 - Initializing system.schema_triggers
      INFO [main] 2019-12-14 11:36:17,281 ColumnFamilyStore.java:426 - Initializing system.schema_usertypes
      INFO [main] 2019-12-14 11:36:17,286 ColumnFamilyStore.java:426 - Initializing system.schema_functions
      INFO [main] 2019-12-14 11:36:17,290 ColumnFamilyStore.java:426 - Initializing system.schema_aggregates
      INFO [main] 2019-12-14 11:36:17,292 ViewManager.java:137 - Not submitting build tasks for views in keyspace system as storage service is not initialized
      INFO [main] 2019-12-14 11:36:17,363 ApproximateTime.java:44 - Scheduling approximate time-check task with a precision of 10 milliseconds
      INFO [main] 2019-12-14 11:36:17,413 ColumnFamilyStore.java:426 - Initializing system_schema.keyspaces
      INFO [main] 2019-12-14 11:36:17,418 ColumnFamilyStore.java:426 - Initializing system_schema.tables
      INFO [main] 2019-12-14 11:36:17,422 ColumnFamilyStore.java:426 - Initializing system_schema.columns
      INFO [main] 2019-12-14 11:36:17,427 ColumnFamilyStore.java:426 - Initializing system_schema.triggers
      INFO [main] 2019-12-14 11:36:17,432 ColumnFamilyStore.java:426 - Initializing system_schema.dropped_columns
      INFO [main] 2019-12-14 11:36:17,435 ColumnFamilyStore.java:426 - Initializing system_schema.views
      INFO [main] 2019-12-14 11:36:17,440 ColumnFamilyStore.java:426 - Initializing system_schema.types
      INFO [main] 2019-12-14 11:36:17,444 ColumnFamilyStore.java:426 - Initializing system_schema.functions
      INFO [main] 2019-12-14 11:36:17,449 ColumnFamilyStore.java:426 - Initializing system_schema.aggregates
      INFO [main] 2019-12-14 11:36:17,452 ColumnFamilyStore.java:426 - Initializing system_schema.indexes
      INFO [main] 2019-12-14 11:36:17,453 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_schema as storage service is not initialized
      INFO [MemtableFlushWriter:1] 2019-12-14 11:36:18,130 CacheService.java:100 - Initializing key cache with capacity of 49 MBs.
      INFO [MemtableFlushWriter:1] 2019-12-14 11:36:18,138 CacheService.java:122 - Initializing row cache with capacity of 0 MBs
      INFO [MemtableFlushWriter:1] 2019-12-14 11:36:18,142 CacheService.java:151 - Initializing counter cache with capacity of 24 MBs
      INFO [MemtableFlushWriter:1] 2019-12-14 11:36:18,143 CacheService.java:162 - Scheduling counter cache save to every 7200 seconds (going to save all keys).
      INFO [CompactionExecutor:2] 2019-12-14 11:36:18,575 BufferPool.java:234 - Global buffer pool is enabled, when pool is exhausted (max is 249.000MiB) it will allocate on heap
      INFO [main] 2019-12-14 11:36:18,668 StorageService.java:638 - Populating token metadata from system tables
      INFO [main] 2019-12-14 11:36:18,721 StorageService.java:645 - Token metadata:
      INFO [pool-3-thread-1] 2019-12-14 11:36:18,770 AutoSavingCache.java:174 - Completed loading (21 ms; 8 keys) KeyCache cache
      INFO [main] 2019-12-14 11:36:18,808 CommitLog.java:142 - No commitlog files found; skipping replay
      INFO [main] 2019-12-14 11:36:18,809 StorageService.java:638 - Populating token metadata from system tables
      INFO [main] 2019-12-14 11:36:18,834 StorageService.java:645 - Token metadata:
      INFO [main] 2019-12-14 11:36:18,926 QueryProcessor.java:163 - Preloaded 0 prepared statements
      INFO [main] 2019-12-14 11:36:18,926 StorageService.java:656 - Cassandra version: 3.11.5
      INFO [main] 2019-12-14 11:36:18,926 StorageService.java:657 - Thrift API version: 20.1.0
      INFO [main] 2019-12-14 11:36:18,926 StorageService.java:658 - CQL supported versions: 3.4.4 (default: 3.4.4)
      INFO [main] 2019-12-14 11:36:18,927 StorageService.java:660 - Native protocol supported versions: 3/v3, 4/v4, 5/v5-beta (default: 4/v4)
      INFO [main] 2019-12-14 11:36:18,970 IndexSummaryManager.java:87 - Initializing index summary manager with a memory pool size of 49 MB and a resize interval of 60 minutes
      INFO [main] 2019-12-14 11:36:18,998 MessagingService.java:750 - Starting Messaging Service on /192.168.180.130:7000 (ens33)
      WARN [main] 2019-12-14 11:36:19,007 SystemKeyspace.java:1130 - No host ID found, created 2c219fc1-d355-4c13-abb7-44945efe1271 (Note: This should happen exactly once per node).
      INFO [main] 2019-12-14 11:36:19,032 OutboundTcpConnection.java:108 - OutboundTcpConnection using coalescing strategy DISABLED
      INFO [HANDSHAKE-/192.168.180.132] 2019-12-14 11:36:22,549 OutboundTcpConnection.java:561 - Handshaking version with /192.168.180.132
      INFO [HANDSHAKE-/192.168.180.131] 2019-12-14 11:36:24,362 OutboundTcpConnection.java:561 - Handshaking version with /192.168.180.131
      INFO [main] 2019-12-14 11:36:25,057 StorageService.java:588 - Unable to gossip with any peers but continuing anyway since node is in its own seed list
      INFO [main] 2019-12-14 11:36:25,070 StorageService.java:742 - Loading persisted ring state
      INFO [main] 2019-12-14 11:36:25,071 StorageService.java:870 - Starting up server gossip
      INFO [main] 2019-12-14 11:36:25,110 StorageService.java:932 - This node will not auto bootstrap because it is configured to be a seed node.
      INFO [main] 2019-12-14 11:36:25,119 BootStrapper.java:228 - Generated random tokens. tokens are [-4630568781700417730, 3535709669028266363, -5604874675790596364, -6714537527186830953, 7975072839689811789, -7464244033958387978, 1721095369644910767, 8700482758817462252, 7656839700660022407, 1496162529844937883, -5592543454988102831, 5584514127974303898, 8124559776778328454, -8960207986503217368, 7224328515089153604, -847139670116492479, -4637022075996940342, -5825558608934353846, 4091518915059391990, -371251166084908804, 5469243702509892555, -8285290290302433087, -8420819152965034706, -7715940678381750516, -5038100221469505342, -697830371175701991, 2097240013784149966, -3063325738442443013, 135618516559119867, -7076909315753537704, 5798496892467101388, -7664331428702927370, -1570838233546146540, 7705439896894184090, -391697355578708804, 5608933484497980138, -7697634721422767218, 1212572056516022907, -2098467035025213051, 6200611690505234829, 941564465601365495, -6693159284966142407, -5012302930090692512, 6412811741034864956, -6598404009588405940, -126353486513366923, 6789131501259708594, -6062845747488861541, -2750075162571480116, 8766766408917841422, 8972886810927667399, 2130676792376454774, 23780987501911784, 6269282065395944221, -6345632569379515468, -7834348554627116407, -6191190075563961853, 4163538515085949899, 4161040419280133824, -3030715683258708086, -1696515172185186395, 1503805614210449876, -3287998695602396137, 5600406851079337895, 1171637905420775858, -2278041460016392355, -2564926496977723214, -420975624416602682, 5944865819510090419, -8808932717016323329, -317031928824608807, 6084356901283426064, 1293876469603388254, 5487006786214275418, -1098943194957736736, -7880796765685741202, -6364907219255676331, -8755040583350389925, 1273183134233612385, -1470570458893059449, 6268933415979915734, 4475018205003912565, -6341328262319108934, 1966296329784779318, -642478180598096522, 2408960365517316057, 7737039485325157998, 7581074551144738315, 2181252746874808806, 7232671711410791882, -8322422586037417371, -2631636821179266477, 6882878218818462855, -8983110993604166252, 7358289785859174844, -4045869280472324103, 8095357677208774602, -178236275007813082, -6974683984981162819, -4416505906455867778, 6349574294135787039, 2766290488095675474, -6352571246314443750, -7800061566070274963, 4499146131376244333, -2107352457493397350, 753926149292191238, -1761299243801307907, -6949881227545767817, 5918517917045596161, 4568484324193026692, -3978694659813026748, 3896512692419747088, -1051341777811312759, -1743746115827751274, 9001236444056355222, -2736164539987434191, 3946523638414465819, 3444121951925190187, -881715254073363356, -7719810066080612784, -3670225711433667916, -5860870072299833287, 9199144389795353344, 8825009411320796303, 129425397772140958, 893014325727650048, -6797248913615508098, 5660873267516897428, -7467363177879387084, 3692110957558155763, 1483018742783439615, 4332356870736720639, -7015478245026972743, 2569398663340756509, -4164771740318300499, 780549512589715967, 7600973036759069084, 2543609922139333050, -6801307008872474101, -6774367110511544270, 585242772032900191, -326247935729849012, -7772270536629432352, 5419380637176189532, -4416697140062190870, 616875779014940265, 8957202261750544987, 8565194868775565818, 649232451884020840, 6251837779764961527, -7396276795608825781, -7359116391901481553, -7003626056693798970, 7606221442084561625, 4854032597347168157, 5556052049252844699, -6192514522263435786, 7601332858058259381, -6268530322985475997, -3884595017957046234, -8214560598871520313, 3864105590138662854, 2794976934889103418, -8596451189657667131, -4544809343957934636, -6410007702646267395, 8054024173762527568, 5912717249476191262, 9185725240098105888, -3969801619001368207, 6660081776767580024, 8773375032242530956, 8564543824964727035, 7297235158336007102, -7890584362121456883, -7512978492888647929, 6516007943520125092, -3564782224544343356, 5031765364927085266, -6549869980506418842, 3872873049071177550, -6892595384533519782, -4803974604808333610, -2014771445525803848, -3755222151743547024, -780165134680096115, 2604770032021923302, 4427869320514011837, 1419909858928741433, -78274491793575434, 4691799131775268580, 7033401128248591353, -1463815657956668056, 3279540098835979619, 2515152227144515838, -4604163545949311014, 5880546247684348354, 4395565010396211793, 1528660679303333769, -3607126972975110827, -702115388025182337, 4667550368199707342, -878141284835356765, -6232272954441290341, -7933088212936005081, -6790815463628006859, -7642648330826877839, -6768619221633400395, -6029416785125437623, 1875992437403726415, -7258476138404848837, 275453438247061485, -1644829799140759364, 4533212938287898023, 5986703923647877025, -7696405511679808124, 3825341310445945544, -5509336518455941427, 567657728015051706, -7536350260368168926, 195045960806162057, -2521943753243529438, -5615049048535921940, 6250395341369475609, -2968355457779996012, -8809923023846733630, -4312867510714094421, -1117335828931391241, 6582689135161974865, 7640402144464216425, 3368875595712776057, 4405948739850694278, -7443716097068723301, -7409000032191885540, -1806108250464467454, -8075007817068744699, -3067241126805234035, 5423718119331428057, 3123082651809349855, -382205217398516070, -4500283740060246884, -192551375623781420, -2086005545084855723, 8336787771700210714, 9010007936067901008, -1185655466392234628, -9115177954699796431, 6201181919630266067, 3112464140662196540, -7050116108857674427, 447580932599865471, -6810273627184929072, -5831594105802002559, 5957795065191740175, 5669687821258587936]
      INFO [main] 2019-12-14 11:36:25,122 MigrationManager.java:337 - Create new Keyspace: KeyspaceMetadata{name=system_traces, params=KeyspaceParams{durable_writes=true, replication=ReplicationParams{class=org.apache.cassandra.locator.SimpleStrategy, replication_factor=2}}, tables=[org.apache.cassandra.config.CFMetaData@18789e16[cfId=c5e99f16-8677-3914-b17e-960613512345,ksName=system_traces,cfName=sessions,flags=[COMPOUND],params=TableParams{comment=tracing sessions, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=0, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(),partitionColumns=[[] | [client command coordinator duration request started_at parameters]],partitionKeyColumns=[session_id],clusteringColumns=[],keyValidator=org.apache.cassandra.db.marshal.UUIDType,columnMetadata=[client, command, session_id, coordinator, request, started_at, duration, parameters],droppedColumns={},triggers=[],indexes=[]], org.apache.cassandra.config.CFMetaData@44f95a86[cfId=8826e8e9-e16a-3728-8753-3bc1fc713c25,ksName=system_traces,cfName=events,flags=[COMPOUND],params=TableParams{comment=tracing events, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=0, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(org.apache.cassandra.db.marshal.TimeUUIDType),partitionColumns=[[] | [activity source source_elapsed thread]],partitionKeyColumns=[session_id],clusteringColumns=[event_id],keyValidator=org.apache.cassandra.db.marshal.UUIDType,columnMetadata=[activity, event_id, session_id, source, thread, source_elapsed],droppedColumns={},triggers=[],indexes=[]]], views=[], functions=[], types=[]}
      INFO [MigrationStage:1] 2019-12-14 11:36:25,299 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_traces as storage service is not initialized
      INFO [MigrationStage:1] 2019-12-14 11:36:25,302 ColumnFamilyStore.java:426 - Initializing system_traces.events
      INFO [MigrationStage:1] 2019-12-14 11:36:25,307 ColumnFamilyStore.java:426 - Initializing system_traces.sessions
      INFO [main] 2019-12-14 11:36:25,321 MigrationManager.java:337 - Create new Keyspace: KeyspaceMetadata{name=system_distributed, params=KeyspaceParams{durable_writes=true, replication=ReplicationParams{class=org.apache.cassandra.locator.SimpleStrategy, replication_factor=3}}, tables=[org.apache.cassandra.config.CFMetaData@42b9c296[cfId=759fffad-624b-3181-80ee-fa9a52d1f627,ksName=system_distributed,cfName=repair_history,flags=[COMPOUND],params=TableParams{comment=Repair history, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=864000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(org.apache.cassandra.db.marshal.TimeUUIDType),partitionColumns=[[] | [coordinator exception_message exception_stacktrace finished_at parent_id range_begin range_end started_at status participants]],partitionKeyColumns=[keyspace_name, columnfamily_name],clusteringColumns=[id],keyValidator=org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type),columnMetadata=[status, id, coordinator, finished_at, participants, exception_stacktrace, parent_id, range_end, range_begin, exception_message, keyspace_name, started_at, columnfamily_name],droppedColumns={},triggers=[],indexes=[]], org.apache.cassandra.config.CFMetaData@312396b0[cfId=deabd734-b99d-3b9c-92e5-fd92eb5abf14,ksName=system_distributed,cfName=parent_repair_history,flags=[COMPOUND],params=TableParams{comment=Repair history, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=864000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(),partitionColumns=[[] | [exception_message exception_stacktrace finished_at keyspace_name started_at columnfamily_names options requested_ranges successful_ranges]],partitionKeyColumns=[parent_id],clusteringColumns=[],keyValidator=org.apache.cassandra.db.marshal.TimeUUIDType,columnMetadata=[requested_ranges, exception_message, keyspace_name, successful_ranges, started_at, finished_at, options, exception_stacktrace, parent_id, columnfamily_names],droppedColumns={},triggers=[],indexes=[]], org.apache.cassandra.config.CFMetaData@3cf8a2d6[cfId=5582b59f-8e4e-35e1-b913-3acada51eb04,ksName=system_distributed,cfName=view_build_status,flags=[COMPOUND],params=TableParams{comment=Materialized View build status, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=864000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(org.apache.cassandra.db.marshal.UUIDType),partitionColumns=[[] | [status]],partitionKeyColumns=[keyspace_name, view_name],clusteringColumns=[host_id],keyValidator=org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type),columnMetadata=[view_name, status, keyspace_name, host_id],droppedColumns={},triggers=[],indexes=[]]], views=[], functions=[], types=[]}
      INFO [MigrationStage:1] 2019-12-14 11:36:25,375 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_distributed as storage service is not initialized
      INFO [MigrationStage:1] 2019-12-14 11:36:25,378 ColumnFamilyStore.java:426 - Initializing system_distributed.parent_repair_history
      INFO [MigrationStage:1] 2019-12-14 11:36:25,382 ColumnFamilyStore.java:426 - Initializing system_distributed.repair_history
      INFO [MigrationStage:1] 2019-12-14 11:36:25,387 ColumnFamilyStore.java:426 - Initializing system_distributed.view_build_status
      INFO [main] 2019-12-14 11:36:25,401 StorageService.java:1521 - JOINING: Finish joining ring
      INFO [main] 2019-12-14 11:36:25,513 MigrationManager.java:337 - Create new Keyspace: KeyspaceMetadata{name=system_auth, params=KeyspaceParams{durable_writes=true, replication=ReplicationParams{class=org.apache.cassandra.locator.SimpleStrategy, replication_factor=1}}, tables=[org.apache.cassandra.config.CFMetaData@5daceefe[cfId=5bc52802-de25-35ed-aeab-188eecebb090,ksName=system_auth,cfName=roles,flags=[COMPOUND],params=TableParams{comment=role definitions, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=7776000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(),partitionColumns=[[] | [can_login is_superuser salted_hash member_of]],partitionKeyColumns=[role],clusteringColumns=[],keyValidator=org.apache.cassandra.db.marshal.UTF8Type,columnMetadata=[salted_hash, member_of, role, can_login, is_superuser],droppedColumns={},triggers=[],indexes=[]], org.apache.cassandra.config.CFMetaData@15ca5cef[cfId=0ecdaa87-f8fb-3e60-88d1-74fb36fe5c0d,ksName=system_auth,cfName=role_members,flags=[COMPOUND],params=TableParams{comment=role memberships lookup table, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=7776000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(org.apache.cassandra.db.marshal.UTF8Type),partitionColumns=[[] | []],partitionKeyColumns=[role],clusteringColumns=[member],keyValidator=org.apache.cassandra.db.marshal.UTF8Type,columnMetadata=[role, member],droppedColumns={},triggers=[],indexes=[]], org.apache.cassandra.config.CFMetaData@5561218c[cfId=3afbe79f-2194-31a7-add7-f5ab90d8ec9c,ksName=system_auth,cfName=role_permissions,flags=[COMPOUND],params=TableParams{comment=permissions granted to db roles, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=7776000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(org.apache.cassandra.db.marshal.UTF8Type),partitionColumns=[[] | [permissions]],partitionKeyColumns=[role],clusteringColumns=[resource],keyValidator=org.apache.cassandra.db.marshal.UTF8Type,columnMetadata=[role, resource, permissions],droppedColumns={},triggers=[],indexes=[]], org.apache.cassandra.config.CFMetaData@6c3fa4cc[cfId=5f2fbdad-91f1-3946-bd25-d5da3a5c35ec,ksName=system_auth,cfName=resource_role_permissons_index,flags=[COMPOUND],params=TableParams{comment=index of db roles with permissions granted on a resource, read_repair_chance=0.0, dclocal_read_repair_chance=0.0, bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=7776000, default_time_to_live=0, memtable_flush_period_in_ms=3600000, min_index_interval=128, max_index_interval=2048, speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class=org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassandra.schema.CompressionParams@fd033638, extensions={}, cdc=false},comparator=comparator(org.apache.cassandra.db.marshal.UTF8Type),partitionColumns=[[] | []],partitionKeyColumns=[resource],clusteringColumns=[role],keyValidator=org.apache.cassandra.db.marshal.UTF8Type,columnMetadata=[resource, role],droppedColumns={},triggers=[],indexes=[]]], views=[], functions=[], types=[]}
      INFO [MigrationStage:1] 2019-12-14 11:36:25,615 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_auth as storage service is not initialized
      INFO [MigrationStage:1] 2019-12-14 11:36:25,618 ColumnFamilyStore.java:426 - Initializing system_auth.resource_role_permissons_index
      INFO [MigrationStage:1] 2019-12-14 11:36:25,627 ColumnFamilyStore.java:426 - Initializing system_auth.role_members
      INFO [MigrationStage:1] 2019-12-14 11:36:25,637 ColumnFamilyStore.java:426 - Initializing system_auth.role_permissions
      INFO [MigrationStage:1] 2019-12-14 11:36:25,645 ColumnFamilyStore.java:426 - Initializing system_auth.roles
      INFO [main] 2019-12-14 11:36:25,665 Gossiper.java:1780 - Waiting for gossip to settle...
      INFO [HANDSHAKE-/192.168.180.131] 2019-12-14 11:36:26,112 OutboundTcpConnection.java:561 - Handshaking version with /192.168.180.131
      INFO [GossipStage:1] 2019-12-14 11:36:26,452 Gossiper.java:1127 - Node /192.168.180.132 is now part of the cluster
      INFO [GossipStage:1] 2019-12-14 11:36:26,455 Gossiper.java:1127 - Node /192.168.180.131 is now part of the cluster
      INFO [GossipStage:1] 2019-12-14 11:36:26,485 TokenMetadata.java:497 - Updating topology for /192.168.180.131
      INFO [GossipStage:1] 2019-12-14 11:36:26,485 TokenMetadata.java:497 - Updating topology for /192.168.180.131
      INFO [GossipStage:1] 2019-12-14 11:36:26,506 Gossiper.java:1089 - InetAddress /192.168.180.131 is now UP
      INFO [HANDSHAKE-/192.168.180.132] 2019-12-14 11:36:26,530 OutboundTcpConnection.java:561 - Handshaking version with /192.168.180.132
      INFO [GossipStage:1] 2019-12-14 11:36:26,550 Gossiper.java:1089 - InetAddress /192.168.180.132 is now UP
      WARN [GossipTasks:1] 2019-12-14 11:36:27,094 FailureDetector.java:278 - Not marking nodes down due to local pause of 8357110294 > 5000000000
      INFO [HANDSHAKE-/192.168.180.133] 2019-12-14 11:36:28,393 OutboundTcpConnection.java:561 - Handshaking version with /192.168.180.133
      INFO [HANDSHAKE-/192.168.180.134] 2019-12-14 11:36:29,401 OutboundTcpConnection.java:561 - Handshaking version with /192.168.180.134
      INFO [main] 2019-12-14 11:36:33,668 Gossiper.java:1811 - No gossip backlog; proceeding

  • 检查集群运行情况

    • 在任意一个节点上运行

      root@node02:~# nodetool status
      Datacenter: datacenter1
      =======================
      Status=Up/Down
      |/ State=Normal/Leaving/Joining/Moving
      -- Address Load Tokens Owns (effective) Host ID Rack
      UN 192.168.180.130 103.66 KiB 256 38.5% 2c219fc1-d355-4c13-abb7-44945efe1271 rack1
      UN 192.168.180.131 74.86 KiB 256 42.7% d1fc9fa0-bbdd-432e-b6aa-04a7f04f5079 rack1
      UN 192.168.180.132 69.95 KiB 256 40.3% 60b8d769-809d-4613-8bc3-332dc7dd075a rack1
      UN 192.168.180.133 114.49 KiB 256 37.8% 8eed4e3a-dd77-4334-8bfd-44c5314d2602 rack1
      UN 192.168.180.134 144.45 KiB 256 40.7% 08ff4aa3-5598-4b08-babb-8f4206031055 rack1

    • 连接到指定cassandra数据库

      root@node02:~# cqlsh 192.168.180.131
      Connected to ronnie-test at 192.168.180.131:9042.
      [cqlsh 5.0.1 | Cassandra 3.11.5 | CQL spec 3.4.4 | Native protocol v4]
      Use HELP for help.

    • 帮助说明

      cqlsh> helpDocumented shell commands:
      ===========================
      CAPTURE CLS COPY DESCRIBE EXPAND LOGIN SERIAL SOURCE UNICODE
      CLEAR CONSISTENCY DESC EXIT HELP PAGING SHOW TRACINGCQL help topics:
      ================
      AGGREGATES CREATE_KEYSPACE DROP_TRIGGER TEXT
      ALTER_KEYSPACE CREATE_MATERIALIZED_VIEW DROP_TYPE TIME
      ALTER_MATERIALIZED_VIEW CREATE_ROLE DROP_USER TIMESTAMP
      ALTER_TABLE CREATE_TABLE FUNCTIONS TRUNCATE
      ALTER_TYPE CREATE_TRIGGER GRANT TYPES
      ALTER_USER CREATE_TYPE INSERT UPDATE
      APPLY CREATE_USER INSERT_JSON USE
      ASCII DATE INT UUID
      BATCH DELETE JSON
      BEGIN DROP_AGGREGATE KEYWORDS
      BLOB DROP_COLUMNFAMILY LIST_PERMISSIONS
      BOOLEAN DROP_FUNCTION LIST_ROLES
      COUNTER DROP_INDEX LIST_USERS
      CREATE_AGGREGATE DROP_KEYSPACE PERMISSIONS
      CREATE_COLUMNFAMILY DROP_MATERIALIZED_VIEW REVOKE
      CREATE_FUNCTION DROP_ROLE SELECT
      CREATE_INDEX DROP_TABLE SELECT_JSON

    • cqlsh> describe cluster;Cluster: ronnie-test
      Partitioner: Murmur3Partitioner