# Server Load Polling Map

To support horizontal farm scaling safely, the application load balancer monitors real-time system performance telemetry. **Asterisk 2** tracks physical cluster health rows inside the proxy storage module to route dynamic sessions accurately.

---

## Cluster Health Ledger Mapping

The layout below traces how persistent database records map out individual server system loads:

```mermaid
graph LR
    %% Primary Table
    subgraph ProxyDbSet["Mapped EF Core Proxy"]
        ServerDbSet["Servers Collection<br/>(DbSet&lt;Server&gt; Servers)"]
    end

    %% Target Schema Columns
    subgraph DatabaseColumns["External Operational Engine"]
        ColId["id Column<br/>(PK Auto-Increment)"]
        ColIp["ip Column<br/>(Cluster IP String)"]
        ColCpu["cpu_load Column<br/>(Floating Point Float)"]
        ColMem["mem_load Column<br/>(Floating Point Float)"]
        ColStamp["last_updated Column<br/>(Heartbeat Epoch Timestamp)"]
        ColActive["is_active Column<br/>(Boolean Lock Flag)"]
    end

    %% Routing
    subgraph CoreConsumer["Load Balancing Engine"]
        EvalLogic["Select Target Node where<br/>IsActive == True & Cpu &lt; 80%"]
    end

    %% Flows
    ServerDbSet ==>|"Resolves Attribute"| ColId
    ServerDbSet ==>|"Resolves Attribute"| ColIp
    ServerDbSet ==>|"Resolves Attribute"| ColCpu
    ServerDbSet ==>|"Resolves Attribute"| ColMem
    ServerDbSet ==>|"Resolves Attribute"| ColStamp
    ServerDbSet ==>|"Resolves Attribute"| ColActive
    
    ColCpu --> EvalLogic
    ColActive --> EvalLogic

    %% Premium Palette Design
    classDef proxyClass fill:#0f172a,stroke:#38bdf8,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef colClass fill:#1e293b,stroke:#a855f7,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef coreClass fill:#312e81,stroke:#ec4899,stroke-width:2px,color:#fff,rx:6px,ry:6px;

    class ProxyDbSet,ServerDbSet proxyClass;
    class DatabaseColumns,ColId,ColIp,ColCpu,ColMem,ColStamp,ColActive colClass;
    class CoreConsumer,EvalLogic coreClass;
```

---

## Technical Attribute Guidelines

### 1. Polling Safeties
Database connections querying cluster metrics disable connection concurrency tracking entirely. This lets background logic sweep stale rows reliably without causing database index read deadlocks.

### 2. Operational Logic Mapping
When physical server CPU loads spike over configured alert boundaries, background management modules update the `is_active` flag directly, completely dropping incoming least-loaded proxy assignments.