Cassandra Database 1.2x

Intro to Clustered - Distributed - NoSQL - Database - Cassandra DB

• Introduction - Cassandra DB - Features - Discussion
  • NoSQL Discussion
  • Features and Benefits of Cassandra DB
  • Data Distribution - Peer-to-Peer
  • Data replication strategies
  • Scalability implementation
  • Data-Center fault-tolerance
  • Various features
  • Explore Cassandra Cluster Topology (CCT)
•  
• Single-Node - Implementation
  • Identify and obtain sources
  • Prep cluster nodes with Java environments
  • Ensure cross-platform support
  • Peruse configuration hierarchy
  • Tweak initial settings - ante-cluster invocation
  • Identify key network sockets
  • Start instance of Cassandra
  • Evaluate footprint
  • Evaluate results
•  
• Cassandra CLI
  • Discuss applicability - Legacy support - et cetera
  • Reveal cluster details using CLI
  • Define sample key space
  • Discuss data-types supported
  • Set | Get | Delete simple records
  • Evaluate data representation
  • Drop key space accordingly
  • Evaluate results
•  
• Cassandra Query Language (CQL) Client
  • Contrast with Legacy Cassandra CLI client
  • Reveal cluster details via CQL
  • Create | Drop key spaces
  • Create Column Families (CF)
  • Populate CF with rudimentary values for general usage
  • Query CF using standard CQL lingo
  • Explore Indices
  • Update data as needed
  • [Dis]Connect as needed
  • Evaluate environment and prepare for usage
•  
• Multi-Node - Cluster - Configuration - Deployment
  • Highlight benefits of distributed | peer-to-peer environment
  • Identify other nodes for inclusion
  • Discuss data replication strategies
  • Discuss tokenizationa and virtual nodes support
  • Peruse and update primary Cassandra configuration for multi-node support
  • Restart services and confirm data-availability
  • Introduce new nodes to Cassandra cluster
  • Query data accordingly
  • Update data replication to target an ideal number of nodes
  • Confirm availability of data across nodes
  • Prep configuration for other nodes
  • Distribute configuration using parallel SSH (pssh) as needed
  • Add remaining nodes to cluster
  • Evaluate current configuration
  • Fail nodes arbitrarily and confirm data-survival
•  
• Cassandra Node Management
  • Discuss available tools: Commercial | Open Source
  • Expose Cassandra Cluster configuration
  • Reveal cluster network details
  • Abbreviate cluster data and evaluate
  • Decommission node as desired for hypothetical scenario
  • Discuss various Cassandra protocols
•  
• Consistency Levels - Affirmatives | Negatives
  • Highlight default configuration
  • Contrast various approaches with respect to risk-tolerance
  • Discuss tunable consistency levels
  • Set Client Read | Write consistency levels
  • Evaluate data access post-consistency tweak
  • Repair data consistency across nodes
  • Confirm QUORUM-level consistency on ALL nodes of cluster
  • Evaluate results
•  
• Node Issues
  • Introduce Hypotheticals
  • Identify current data repositories
  • Fail redundant nodes and access data
  • Vary consistency level to reflect shifts in cluster dynamics
  • Confirm data-accessibility
  • Discuss tradeoffs of relegated stance
  • Up replication of data to reflect current cluster description
  • Down ALL nodes responsible for data and evaluate
  • Recover accordingly
  • Discuss risks and evaluate
•  
• Multiple Data Centers (DCs) - Custom Replication
  • Discuss available algos
  • Define accurate topology map for Cassandra Cluster
  • Update cluster configuration and re-initialize the cluster
  • Define new - simple key space for multi-DC replication
  • Reveal current multi-DC topology
  • Ensure data are replicated accordingly
  • Update existing key space to support multiple DCs
  • Evaluate configuration
•  
• Data Snapshots - Restoration
  • Explore available tools
  • Discuss backup | restoration model
  • Snapshot single node and evaluate traces
  • Use 'pssh' to snapshot ALL nodes
  • Confirm existence of various snapshots on various nodes
  • Purposely remove data
  • Confirm cluster-wide updates reflecting lost data
  • Restore key space as needed
  • Confirm availability

Sums

• Various Tools
• Remote Confirmations
• File Metadata
• File Fragments
• Compress Content
• Archive Content
• DIR Hierarchy
• Password Sums
• Shared Secret
• Restrict History
• Downloaded Content
• Encrypt Content
• Site Credentials
• Site COOKIE
• Site COOKIE - Unique

CentOS9x Stream Administration

• Initial Environment
• ls, pwd, cd, cp, mv, rm, mkdir, rmdir, whoami
• alias, cat, file, chmod, chown, history
• STD(IN|OUT), Pipes, Redirection, Command Chaining
• ps, df, top, free
• Pagers, W-Commands
• Checksums
• Awk | Sed | Grep Usage
• BASH SHELL Environment
• Compression | Archival Tools
• SSH Equivalence
• SHELL Quoting
• Propagate Environment
• Secure Clients

• Identify Standard File Types
• Standard File Permissions
• Symbolic Links
• Transfer Permissions

• Identify SWAP environment
• Provision dedicated SWAP partitions
• Add | Remove SWAP from pool as needed
• Provision File System-based SWAP
• SWAP Share
• SWAP Persistence
• Identify default storage configuration
• Provision new storage as needed
• XFS - File System
• XFS - Grow File System
• Identify LVM defaults
• Add new partitions to LVM management
• Allocate storage to LVM Volume Groups
• Create Logical Volumes (LVs) as needed
• Overlay File System and mount where applicables
• LVM - Resize
• LVM - Mixed FS
• LVM - SWAP

• Features
• Install
• Defaults
• General Usage
• Update Accounts

• Defaults
• Shared PASS Gen
• Unique PASS Gen
• Encrypted PASS Gen
• Update Accounts
• Groups

• Discuss features | limitations
• Identify default system-wide schedule
• Peruse various default Cron Jobs
• Schedule simple job and monitor recurrence
• Evaluate results

• Peruse Default CONF
• Discuss Syslog Rules
• Explore Log Rotate defaults
• Ensure rotated logs are compressed
• Extend default retention scheme
• Force Log Rotation as needed

• Explore Default environment
• Install PKGs
• Dump important metadata from packages
• Apply Updates

• Default CONF
• Add | Confirm IPs as needed

• Install
• Copy Configuration
• SELinux - Confirm
• TLS | SSL Services
• cURL Client Tests
• Virtual Hosts
• ENC Sites Only

• SFTP Only USER
• SFTP Only USER - NOLOGIN
• SFTP Only Group - Control
• NMap Intro

SysLOG with rSysLogD

• Discuss Features
• Default Environment
• Kernel Firewall LOG
• Split LOGs by Priorities
• UDP | TCP Logging
• Dual L4 Logging
• Multiple Hosts
• Basic Queueing
• Reliable Event Logging Protocol (RELP)
• RELP - Remote Only
• RELP Only
• Traditional to RELP
• SysLOG Clear-Text - Confirm
• Property Filters
• Expression Filters
• Relay Chain

Netfilter Tables

• Features
• SSHGuard
• Ruleset Basics
• Persistence
• Sample Rules
• Inbound Filtering
• Dormant Table
• Manage Tables | Chains | Rules
• Counters
• Sets
• LOG Basics
• LOG with Sets
• Closed-Port LOGs
• LOG Options
• Re-Route LOGs
• Jump Targets
• Chain Jumping
• GoTo Chains
• Meta Selectors

Debian 12x Administration

• Features
• Download
• Graphical Install
• Text Install
• Post-Install Tweaks

• Explore usage of the following useful commands
• tty | /dev/pts | w | whoami | who
• set | env | export | unset
• cat | echo | touch | rm
• pwd | ls | cd | mkdir | alias | umask
• head | tail
• dd
• find
• history
• STDIN, STDOUT, STDERR, UNIX Pipes, Redirection, Command Chaining
• ps, df, free, top, dd
• stat, which, w, who
• tar | gzip | bzip2 | xz
• ZSH Setup

• Network Tools | IP Configuration
• Examine default IP configuration
• Extend IP configuration to facilitate additional addresses
• Static IP Config
• Dual: Dynamic | Static Config
• Multiple Interfaces
• Dual Network Services
• Confirm communications

PHP One-Liners

• General Usage
• Count Lines
• Word Count
• Count Chars
• Split Lines into ARRAY
• Count Instances of Fields
• Transform Delimiters
• Anonymize LOGs
• Extract Unique SRCs
• Lines by Error Code
• LOG By Code
• Summarize Error Codes
• Pre-Seed Error Codes
• Random Strings
• Varied Passwords
• Expose Undefined Passwords
• Outdated Passwords
• Hash | Un-Hash

Cloud Storage with GlusterFS

• Discuss Features:
• Default Volume Type
• Common Volume Types
• Transport Types
• File System Support
• Storage Model

• Features
• Provision Storage
• Allocate GlusterFS Brick
• Persistence
• Generate IO
• Multiple File Systems
• Various Sizes
• Stop | Remove Volume
• Reconstitute Volume
• Server Mount
• Evaluate

OpenPGP with GPG

• Discuss Features:
• Primary Tool
• Private | Public Keys
• Public Key Cryptography Standards (PKCS)
• Encryption | Decryption
• Signing | Verification

• Features
• General Usage
• Create Content
• Encrypt
• PassPhrase Protect
• Binary | Text Encryption
• Share
• Decrypt

SSL-TLS with OpenSSL

• Discuss Features:
• Primary Tool
• Private | Public Keys
• Certificate Signing Requests (CSRs)
• Self-Signed Certificates
• Public Key Cryptography Standards (PKCS)
• Encryption | Decryption
• Random String Generation
• Message Digests
• SSL-TLS Client

• Features
• General Usage
• Retrieve Site Certificates
• Determine OCSP Configuration
• Probe supported TLS Versions
• Extract Certificate for local usage
• Retrieve Certificate with NMap
• Retrieve Certificate Chain

• Discuss
• Generate Private Keys
• Generate Correlating CSRs
• Confirm Keys | CSRs
• Self-Signed Certificates

SSH Variables

• Discuss Features
• Bare VARs
• SSH Client
• Double Quotes
• Single Quotes
• SSH Environment

SHELL Variables

• Discuss Features
• Terminal (TTY)
• CLI Arguments
• Process ID
• Backgrounded
• SHELL Local
• Environment
• Persistence
• Aliases
• Command Substitution
• Increment | Decrement
• Dynamism