New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Cassandra

Been a long time RDBMS DBA , its may be time to focus on other database technologies like NOSQL and the first one is the Cassandra, I tried to write the posts in the way that a traditional DBA thinks of general tasks, backup recovery, performance issues, high availability etc. Hope you will like it. 

Cassandra for Oracle DBA's Part 1 - Important Features & Tools Comparison

Cassandra for Oracle DBA's Part 2 - Three things you should know

NOSQL, Column Store & Distributed System

Cassandra for Oracle DBA's Part 3 - Architecture 

Memory Components of Cassandra

Memtables

KeyCache

RowCache

Partition Index Summary Cache

Logical Storage Components of Cassandra

Keyspace

Column Family Aka Table

Index

Physical Storage Components of Cassandra

SSTABLES

COMMITLOG & Archives 

Cassandra for Oracle DBA's Part 4: Data Distribution across nodes in Cassandra

Tokens

Replication of Data to Nodes 

Replication Factor at keyspace level

Parameter Files in Cassandra

Cassandra.yaml

Other Parameter files

Cassandra for Oracle DBA's Part 5: Read & Write Consistencies

Consistency Level for Reads

Consistency Level at table level 

How a Read Happen in Cassandra - Demonstration

How a Write Happen in Cassandra - Demonstration

Cassandra for Oracle DBA's Part 5 - High Availability

Data Centre & RACK

GOSSIP & Failure Detection

Hinted Hand offs

Cassandra for Oracle DBA's Part 6 - Installing Cassandra

Standalone

Cluster

Starting & Stopping Cassandra

Cassandra for Oracle DBA's Part 7 - Adding & Deleting Nodes

Adding a node eventually rebalance the data (aka sstables) to new nodes

Deleting a node eventually rebalance the data (aka sstables) to existing nodes

Cassandra for Oracle DBA's Part 8 - Data Dictionary Overview

SYSTEM Keypsace

SYSTEM_AUTH Keyspace

Cassandra for Oracle DBA's Part 9 - User Management

Parameters to consider

Creating User

Granting Permissions

Roles?

Cassandra for Oracle DBA's Part 10 : Commitlogs (Managing Archivelogs & Redologs)

Cassandra for Oracle DBA's Part 11: Alert logs & Tracing

Cassandra for Oracle DBA’s Part 12 : Client Connections & Timeouts 

Cassandra for Oracle DBA’s Part 13 : Memory Management

Cassandra for Oracle DBA’s Part 14: Tombstones – Undo type structures

Cassandra for Oracle DBA’s Part 15 : Partition Merging & Compacting

Cassandra for Oracle DBA’s Part 16 : Shutting Down Best Practices

Cassandra for Oracle DBA Part 17: Tracing Sessions

Cassandra for Oracle DBA’s Part 17: Backup & Recovery

Backups

Snapshots at node level

No global snapshots

Manual maintenance (no rman tool kind)

Incremental backups, actually pointers to original sstables

Recovery

Manual recovery

Replace whole set of sstables from snapshot and repair node

Cassandra for Oracle DBA’s Part 18 : Change of Replication Factor & Repair Nodes

RF=1 (no way to retrieve data)

RF=3

nodetool

Cassandra for Oracle DBA's Part 10 - Node Evictions & Node Recovery

Node evictions

Gossip Protocol and Phi-Fee Failure Detection mechanism

Instance recovery aka node recovery

Hinted Handoffs 

Node repair

Cassandra for Oracle DBA's Part 11 - Upgrading

Create New Cluster

Create Keyspaces in new cluster

Crete Tables in new cluster

Upgrade SSTABLES using ssupgradetables

Cassandra for Oracle DBA's Part 13- Health Checks

Cassandra for Oracle DBA's Part 14 - Performance Tuning

Java heap sizing (aka sga)

Replication Factors Adjustments

Consistent Level Adjustments

Understanding Latencies