server

I’ve Operated Petabyte-scale ClickHouse® Clusters for 5 Years

Operated ClickHouse® clusters for 5 years, focusing on architecture, storage, upgrades, config, costs, and ingestion challenges. ClickHouse uses replicas and shards for data management, though cloud storage is preferred for cost efficiency. Ingestion is critical, often causing data loss or corruption. Upgrades are complex but manageable with careful planning. Efficient cluster operation requires understanding source code and using CI/CD for testing. Balancing cost, performance, and configuration is essential, and effective ingestion is key to stability.

https://www.tinybird.co/blog-posts/what-i-learned-operating-clickhouse

One File Linux

One File Linux: ~20MB live Linux distro, no installation needed. Copy one file to EFI partition to boot on any UEFI computer. Advantages include no USB required, direct UEFI boot, no boot manager, and compatibility with disk encryption. Useful for Linux on bare metal without USB. Run on Mac by copying to EFI and setting boot option; on PC, use efibootmgr to add NVRAM boot option. Can also run from formatted USB. Build your own version based on Alpine Linux.

https://hub.zhovner.com/geek/one-file-linux/

Linux Routing Fundamentals

Linux networking supports multiple routing tables and advanced features like policy-based routing (PBR), VRFs, and network namespaces. This summary covers basics of routing tables, explaining their structure, routing lookups, source address selection, and special route types. Linux systems come with default tables: local, main, and default, which are checked in sequence for routing decisions. Users interact with routing tables via the ip command. The article also discusses handling ICMP errors and interface link states. Further articles will expand on advanced routing techniques.

https://blog.sdn.clinic/2025/01/linux-routing-fundamentals/

XPipe

XPipe Overview
XPipe is a centralized connection hub for managing remote server infrastructures. It offers SSH support, container and hypervisor integrations, and a remote file browser, enabling users to control multiple systems from their desktop. Key features include flexible terminal integration, a powerful scripting system, customizable shell environments, and a focus on security and privacy through local storage and password manager integration. XPipe supports collaboration through git synchronization and is compatible with various operating systems. Users can also run it in a web-based environment via Docker.

https://xpipe.io/

Patterns for Building Realtime Features

Realtime features in apps enhance collaboration by sharing user-triggered changes instantly. Key patterns include:

  1. Poke/Pull: Server notifies clients (poke) to fetch new data (pull). Easy integration but causes simultaneous requests (fan-out), which can be mitigated with caching.

  2. Push State: Server sends entire updated state immediately. Reduces fan-out but can overwhelm clients with data and doesn't scale well for large states.

  3. Push Ops: Server sends specific operations instead of full state, enabling clients to update efficiently. Requires initial state fetching.

  4. Event Sourcing: Server sends events instead of state, requiring client-side logic to apply changes. Promotes reusable business logic but adds complexity.

  5. Transports: Options include websockets, SSE, and polling. Challenges arise in horizontally scaled systems regarding server-client coordination, solvable via Pub/Sub infrastructures.

https://zknill.io/posts/patterns-for-building-realtime/

VitoDeploy

VitoDeploy: Open-source, free self-hosted server management tool. Features include server provisioning, database management (MySQL, MariaDB, PostgreSQL), PHP app deployment, firewall control, SSL support, queue handling, service management, SSH key deployment, cron job management, headless console for SSH commands, and server monitoring. Offers project management and user invitation.

https://vitodeploy.com/

Scroll to Top