The architecture work shown here is fantastic! Seeing the exact breakdown of shard percentages and the clear explanation of the write gap during promotion makes the technical choices transparent. It feels like a great deal to get this level of detailed infrastructure design. I am really impressed by the focus on idempotency and the benchmarking approach that turns schema design into measurement. The pipeline using Compose for health-gated cutover is a solid choice for minimizing downtime. For someone considering this company, the emphasis on measurable outcomes over flashy features stands out. Is this the kind of reliable, low-latency infrastructure needed for very large, messy datasets? The evidence suggests yes, making it a compelling option for anyone needing robust data warehousing solutions without the overhead of a managed provider.
Questions about Abdullah Mazhar
What is Abdullah Mazhar?
Abdullah Mazhar is a data infrastructure engineer based in Karachi who designs, deploys, and operates infrastructure for querying very large datasets. His work centers on Postgres and ClickHouse systems deployed across multiple blockchain networks. He maintains a personal portfolio website that showcases an interactive architecture diagram and cluster shard metrics.
Who is this infrastructure designed for?
The business serves clients who need to query very large, messy datasets quickly. It specifically targets users working with blockchain networks who require high-performance data infrastructure solutions.
What technologies and platforms are integrated into the system?
The platform uses Postgres and ClickHouse systems deployed across multiple blockchain networks. It also integrates with TypeScript, Redis, Docker, and Prometheus for various operational tasks.
How does the interactive architecture diagram work?
The architecture diagram allows users to hover over components for details and click to kill them to test blast radius. This interactive feature helps visualize how traffic reroutes around single points of failure.
How does the multi-chain indexer handle blockchain reorganizations?
The multi-chain indexer ingests events from several networks into one columnar schema. It uses idempotent batch inserts keyed on chain_id and block_number to handle reorgs without double-counting.
How does the partition strategy harness evaluate performance?
The partition strategy harness replays a real query workload against candidate partition keys. It measures p50, p95, and p99 latencies for the same 200 queries across five different partitioning schemes.
How does the reorg guard detect and handle chain reorganizations?
The reorg guard watchdog detects chain reorganisations and rewinds affected partitions. It keeps a rolling window of 256 blocks and compares block hashes against the head to identify divergences.
What are the specifications of the Postgres HA setup?
Postgres HA on bare VPS uses streaming replication, WAL archiving, and automated failover without a managed provider. The write-gap during promotion is roughly 15 seconds.
How does the analytics warehouse process raw data?
The analytics warehouse models transform raw block and log tables into query-ready marts. These incremental models are keyed on partition to allow for backfills.
What are the current ingestion rates and network counts?
The system ingests events at a rate of 6 events per second with an ingest lag of 41.2k blocks. It processes data from 6 different networks.
How does the benchmark rig convert schema design into measurements?
The benchmark rig replays a real query workload against candidate partition keys. It turns schema design decisions into measurable outcomes using p50/p95/p99 metrics.
How many nodes are used for the Postgres HA setup?
The Postgres HA setup runs on three small boxes using Patroni plus etcd. The write-gap during promotion is approximately 15 seconds.
What is the official website of Abdullah Mazhar?
The official website of Abdullah Mazhar is abdullahmazhar.xyz.
AI-generated from reviews on this page. Verify anything important with the company directly.
The website lists several current roles at Beenco Labs and Realcore Solutions. The technical details regarding Oracle APEX and ClickHouse are clear. However, the specific dates overlap significantly. It is not entirely clear if these are concurrent roles or a timeline of rapid transitions. The information is precise but raises questions about capacity.
The portfolio clearly demonstrates a deep understanding of data infrastructure. The use of ClickHouse and Postgres across multiple chains is exactly what is needed for modern analytics. I like that the entries lead with technical decisions rather than just listing features. The benchmarking approach that turns schema design into measurement is particularly smart. The reorg guard and the HA setup on bare VPS show attention to reliability and cost. It is refreshing to see such detailed architecture diagrams with hover details and cluster states. The focus on idempotency and partitioning strategies indicates a mature engineering mindset. The pipeline using Compose for health-gated cutover is a solid choice for minimizing downtime. Overall, the work presented feels practical and well-tested, not just theoretical. This level of detail gives confidence in the engineer’s ability to handle complex data loads effectively.
The architecture breakdown is genuinely useful. Seeing the specific shard percentages and the clear explanation of the write gap during promotion makes the technical choices transparent and easy to trust.
Looking at Abdullah Mazhar’s portfolio, it is clear that he understands the nuances of managing very large datasets. The approach to using Postgres alongside ClickHouse across multiple chains seems robust for anyone dealing with messy data. I appreciate how the architecture diagrams show a real-world deployment rather than just theoretical models. The inclusion of specific details about shard ranges and replica counts suggests a hands-on engineer who actually runs these systems daily. The decision to route traffic rather than animate it, ensuring every packet picks a live node, points to a mature understanding of reliability. While the site lists several roles from Beenco Labs to Realcore Solutions, the technical depth remains consistent across the board. It is reassuring to see a focus on idempotent batch inserts and reorg guards, which are critical for data integrity. The overall impression is of someone who prioritizes measurable outcomes over flashy feature lists. For anyone needing someone to design and deploy infrastructure that actually works under pressure, this profile offers strong evidence of competence.
News
No news yet. This is where the business shares its own updates and press.
Photos
No photos yet. Photos shared by reviewers will show up here.
Widgets
Get the widget for your site →About Abdullah Mazhar
Abdullah Mazhar is a data infrastructure engineer based in Karachi who designs, deploys, and operates infrastructure for querying very large datasets. His work centers on Postgres and ClickHouse systems deployed across multiple blockchain networks. He maintains a personal portfolio website that showcases an interactive architecture diagram, cluster shard metrics, and descriptions of several technical projects such as a multi-chain indexer and a partition strategy benchmark harness. The site provides contact information and links to his GitHub.
- Website
- abdullahmazhar.xyz