Bigdata

An overview of graph databases, their structure, and advantages over relational models. Covers how nodes, relationships, and the Cypher query language work together to model complex data.

Tuning Galera’s gcache size and page size can reduce disk I/O during replication and keep write-set lookups in memory. A quick configuration change that pays off on busy clusters.

Learn how to measure InnoDB table fragmentation using information_schema queries and interpret the resulting ratio to decide when a table needs optimization.

A quick bash one-liner that pulls per-user CPU time, connection counts, and active session details from MySQL’s INFORMATION_SCHEMA and processlist tables.

A practical walkthrough for dumping Kafka topic data, including a generic consumer approach and a full Atlas-specific workflow covering JAAS configuration, Kerberos authentication, and log extraction.

A quick walkthrough for dumping the ATLAS_HOOK Kafka topic to inspect Atlas hook messages locally, including Kerberos authentication setup and consumer lag checks.