Overview

MongoDB database storing board configurations, columns, layouts, and real-time board state with flexible schema for custom workflows.

Collections

Technical Details

Specifications:

• Version: MongoDB 7.x
• Storage: 100 GB
• Replication: 3-node replica set
• Sharding: Not enabled (moderate dataset)
• Encryption: Encrypted at rest

Performance:

• Query Latency: P95 < 50ms
• Write Throughput: 1,000 writes/second
• Connections: Max 500
• Uptime SLA: 99.95%

Schema Design

Boards Document

{
  "_id": "board_123",
  "workspace_id": "ws_456",
  "name": "Sprint 24 Board",
  "type": "kanban",
  "columns": [
    {
      "id": "col_1",
      "name": "To Do",
      "wip_limit": 10,
      "order": 0
    },
    {
      "id": "col_2",
      "name": "In Progress",
      "wip_limit": 5,
      "order": 1
    }
  ],
  "created_at": "2024-01-15T10:30:00Z",
  "updated_at": "2024-01-20T14:22:00Z"
}

Access Patterns

• Board Service: Full read/write access
• Task Service: Read board configurations
• WebSocket Server: Real-time board updates
• Analytics: Read board metrics

Disaster Recovery

• RPO: 1 hour
• RTO: 2 hours
• Backup Retention: 30 days
• Point-in-Time Recovery: 24 hours