|
||||
|
############# Memory Calculation for Cassandra (kind of sga setting 🙂 will be done during environment setup with following script excerpt. if you want you can change accordingly this script and restart the cassandra. ################## geek_cluster/node1/resources/cassandra/conf/cassandra-env.sh …. half_system_memory_in_mb=`expr $system_memory_in_mb / 2` quarter_system_memory_in_mb=`expr $half_system_memory_in_mb / 2` if [ “$half_system_memory_in_mb” -gt “1024” ] then […] We also set timeouts for client side, TNSNAMES.ora or sqlnet.ora (Client Side) root@wash-i-16ca26c8-prod ~/.ccm/repository/4.5.2/resources/cassandra/conf $ vi cqlshrc.default root@wash-i-16ca26c8-prod ~/.ccm/repository/4.5.2/resources/cassandra/conf $ Set the client_timeout as like sqlnet.ora timeout setting [connection] hostname = 192.168.1.2 port = 9160 client_timeout=40 ################################### Node Communication Settings * Timeouts ################################### root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf $ root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/resources/cassandra/conf […] Alert Log and tracing Parameters in Cassandra.yaml log4j-server.properties log4j.appender.R.File=/root/.ccm/geek_cluster/node1/logs/system.log root@wash-i-16ca26c8-prod ~ $ ccm node1 nodetool getlogginglevels Logger Name Log Level root INFO org.apache.solr.core.SolrCore WARN org.apache.thrift.server.TNonblockingServer FATAL org.apache.solr.handler.component WARN org.apache.solr.search.SolrIndexSearcher WARN org.apache.solr.update WARN org.apache.solr.core.CassandraSolrConfig WARN SolrValidationLog INFO org.apache.solr.core.RequestHandlers WARN org.apache.solr.util.plugin.AbstractPluginLoader WARN root@wash-i-16ca26c8-prod ~ $ root@wash-i-16ca26c8-prod ~/.ccm/geek_cluster/node1/logs $ ls -ltr total 528 […] Archive Logs & Redologs (commit logs) Parameters that need to effect. commitlog_directory: /root/.ccm/geek_cluster/node1/commitlogs commitlog_directory: /root/.ccm/geek_cluster/node1/commitlogs commitlog_segment_size_in_mb: 32 commitlog_sync: periodic commitlog_sync_period_in_ms: 10000 /.ccm/geek_cluster/node1/resources/cassandra/conf/commitlog_archiving.properties file to keep archive_command Argument 1 will give you the path to the files you’d want to copy, while
Create User in cassandra involve to change the parameter in cassandra.yaml and authentication mode. # Authentication backend, implementing IAuthenticator; used to identify users # Out of the box, Cassandra provides org.apache.cassandra.auth.{AllowAllAuthenticator, # PasswordAuthenticator}. # DSE also provides a Kerberos authenticator for external authentication. # # – AllowAllAuthenticator performs no checks – set it […] cqlsh> select * from system.sstable_activity; keyspace_name | columnfamily_name | generation | rate_120m | rate_15m —————+——————-+————+———–+———- PortfolioDemo | StockHist | 2 | 0 | 0 PortfolioDemo | Portfolios | 5 | 0 | 0 PortfolioDemo | Stocks | 5 | 0 | 0 PortfolioDemo | StockHist | 3 | 0 | […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!