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:

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.

# 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 (DbSet&lt;Server&gt; Servers)"]
 end

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

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

%% 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.