Distributed Time-Series Database Performance Optimization

Design a horizontally scalable time-series database schema for IoT sensor data with 500+ million write operations per day. Create a sharding strategy using consistent hashing that enables dynamic node addition, handles data skew, and maintains sub-10ms write latency. Implement a compaction/retention policy that automatically archives cold data to cheaper storage while maintaining real-time query performance across 5+ years of historical metrics.