Database tutorial - IT technology blog
Posted inDatabase

Apache Pinot: A Step-by-Step Guide to Setting Up a Real-Time OLAP Database for Sub-100ms Analytics Dashboards

Apache Pinot is a distributed OLAP datastore that enables analytics queries across billions of rows with sub-100ms latency, used by LinkedIn and Uber for user-facing dashboards. This guide walks you through step-by-step installation with Docker, configuring schemas and star-tree indexes, loading CSV data, and monitoring cluster health.
Database tutorial - IT technology blog
Posted inDatabase

YugabyteDB: A Guide to Setting Up PostgreSQL-Compatible Distributed SQL with Auto-Sharding and Automatic Fault Tolerance

YugabyteDB is a PostgreSQL-compatible distributed SQL database with auto-sharding, automatic fault tolerance, and multi-region deployment — no changes to your SQL or ORM required. This guide covers installation from a single-node Docker setup to a real 3-node cluster, along with practical tips for working with distributed databases.
Monitoring tutorial - IT technology blog
Posted inMonitoring

How to Install and Configure OpenObserve: A Next-Generation Logs, Metrics, and Traces Solution to Replace ELK Stack with 140x Lower Storage Costs

OpenObserve is a Rust-based observability solution that stores logs, metrics, and traces at up to 140x lower cost than ELK Stack, thanks to Parquet format and efficient data compression. This post shares hands-on experience installing OpenObserve with Docker, configuring Fluent Bit for log collection, querying with SQL, and setting up Alerts to avoid alert fatigue.