Designing, Hosting, and Maintaining a High-Availability Lore Repository for the French FFXIV Community

1. Project Overview & Context

Community-driven knowledge platforms require robust, secure, and easily maintainable infrastructure to ensure smooth content delivery and seamless user collaboration. This project focused on the end-to-end design, deployment, and administration of Les Archives de Gubal (archives-de-gubal.fr), a dedicated MediaWiki platform that compiles, translates, and synthesizes complex in-game lore for the French Final Fantasy XIV community.

Operating as the Sole Infrastructure Engineer and Knowledge Manager, the challenge was twofold: building a modern, containerized architecture capable of scaling with community traffic, and managing the continuous ingestion, translation, and structured organization of massive cultural and narrative datasets.

2. Infrastructure Architecture & Technical Stack

The production platform is hosted on a Virtual Private Server (VPS) and is built upon a highly optimized, decoupled architecture using containerization to separate concerns:

[ Internet / Clients ] ──> [ Reverse Proxy (Nginx) ]
                                   │ (HTTPS)
                                   ▼
                       [ Docker Container Plane ]
         ┌─────────────────────────┼────────────────────────┐
         ▼                         ▼                         ▼
  [ MediaWiki App ]        [ Relational DB ]        [ Dedicated Services ]
  (PHP Engine)             (MySQL/MariaDB)          • File Object Storage
                                                    • Mail Transfer Agent (MTA)

Core Architecture Components

  • Containerized Deployment (Docker): To guarantee environment consistency, rapid deployment, and isolated dependencies, the entire MediaWiki application ecosystem is containerized. This allows for seamless, risk-free version upgrades of the core application without impacting the host OS.

  • Modern Web Stack Engine: Deployed using a high-performance LAMP/LEMP layout tailored for high-concurrency content management systems.

  • Decoupled Enterprise Bricks: * Dedicated File Storage Service: Implemented an isolated layer for handling heavy media assets and file uploads, optimizing core server performance.

    • Mail Transfer Agent (MTA) Integration: Integrated a dedicated mailing infrastructure to handle platform telemetry, automated user registrations, and system notifications reliably.

3. Data Engineering, Translation & Knowledge Management

Beyond the operational and system-level tasks, this project serves as a comprehensive exercise in cross-lingual documentation and content architecture:

  • Cross-Lingual Translation & Ingestion: Responsible for translating dense, multi-layered technical and narrative texts from English sources into culturally accurate and contextual French documentation.

  • Data Synthesis & Condensation: Analyzed and condensed raw, unstructured information into concise, readable, and highly informative entries, ensuring high data density without compromising clarity.

  • Knowledge Architecture: Designed the semantic taxonomy and internal linking logic of the wiki. This involved establishing clear naming conventions, category hierarchies, and relational templates to ensure the platform remains intuitive and easily searchable for end-users.

4. Operations & Maintenance Lifecycle

To maintain platform stability and data integrity over time without incurring high operational overhead, the system incorporates automated operations tailored to the platform’s publishing velocity:

  • Automated Data Persistence & Backups: Implemented a scheduled maintenance script that performs comprehensive, automated system backups every month. This routine generates snapshots of both the relational database schemas and user-uploaded media assets, ensuring a deterministic Disaster Recovery (DR) plan in case of infrastructure failure.

5. Key Engineering Competencies Demonstrated

This project serves as an active production environment demonstrating a broad spectrum of technical infrastructure capabilities paired with strong analytical soft skills:

  • Full-Stack Autonomy: Complete ownership of the platform lifecycle, from raw VPS configuration and DNS routing to network hardening and SSL/TLS certificate management.

  • Containerization & Orchestration: Practical expertise in Docker engineering, container lifecycle management, and microservice decoupling.

  • Knowledge Management & Documentation: Strong ability to synthesize data, maintain complex documentation structures, and build reliable transfer-of-knowledge tools—a vital skill for modern engineering teams.

  • Systems & Storage Administration: Experience configuring standard Linux services, automated cron jobs for backups, transactional email relays, and optimizing open-source database backends.

Portfolio Metadata

  • Role: Sole DevOps, Infrastructure Administrator & Knowledge Architect (100% Autonomous)

  • Core Technologies: Docker, MediaWiki, Linux VPS, Nginx/Apache, MySQL, Mail Gateways.

  • Primary Skills: Containerization, Decoupled Systems Architecture, Knowledge Management & Documentation, Translation & Data Synthesis, Database Administration.