|
||||
|
Backup in Cassandra maintain at node level , so any backup that taken in the one node does not contain other nodes data, so you must take backup of each node, cassandra maintains backups as snapshots means an entire sstables at disk level copied to a different folder with snapshot id as like below. root@wash-i-16ca26c8-prod […] ############# 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 | […] The following are various gotchas during upgrade or post upgrade to 12c collect from various sources and also few of them in my environment. 1. Change of resource_limit parameter to true by default Impact: Resource Manager will be invoked automatically and push the resource limits to the sessions and users may receive cpu/io restriction […] Consider a Typical Database Migration which contains all of this below (and if down time is not a problem) 1. Into a new Database Host (NEW SERVER) 2. Convert to Non-ASM to ASM 3. Convert to Single Instance to RAC, 4. Upgrade to Database to 12c Environment Details Source Target DB Version: […] Have got a question from one of fellow DBA that how much PGA the session will use or needed. Well to answer this, first we need to know what PGA looks like and what it used for? The follow shows the components of a PGA, the little space used for Stack, Env Variables and Private […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!