Page MenuHomePhabricator

Migrate site to Cloud VPS?
Closed, DeclinedPublic13 Estimated Story Points

Description

This may offer more flexibility than Toolforge. See the docs. We may have to migrate to this service as ToolsDB forbids maintaining idle database connection, and the site may go against that rule.

Pros:

  • Full control of system and server.
  • Able to install own database server.
    • No longer restricted to SQLite.
    • No database connection restrictions compared to ToolsDB.
  • Able to install any software.
    • JVM, gcc/gpp, etc. if needed.

Cons:

  • Have to setup/manage OS ourselves.
  • Have to setup/manage web service ourselves.

Event Timeline

Danya set the point value for this task to 5.May 5 2026, 9:47 PM
Danya renamed this task from Migrate site to Wikimedia Cloud Services? to Migrate site to Cloud VPS?.May 11 2026, 8:28 PM
Danya updated the task description. (Show Details)
Danya changed the point value for this task from 5 to 6.
Danya triaged this task as High priority.May 13 2026, 7:12 PM
Danya changed the point value for this task from 6 to 7.
Danya moved this task from Backlog to [deleted] on the Tool-wiki-gender-stats board.
Danya renamed this task from Migrate site to Cloud VPS? to Migrate site to Cloud VPS.May 13 2026, 7:14 PM
Danya added a parent task: T423012: Use dumps.
Danya changed the point value for this task from 7 to 21.May 14 2026, 8:44 AM
Danya renamed this task from Migrate site to Cloud VPS to Migrate site to Cloud VPS?.May 14 2026, 8:47 AM

The JSON dump ingester is very slow on Toolforge: it took ~25h to parse 35.5 million out of ~120 million lines. Maybe we need to migrate it from Python to a faster language like Java, C, or C++. The issue is no JVM or gcc/gpp is installed on Toolforge. So having a Cloud VPS instance is probably the best way forward. Plus it would give us better control over the behavior of Flask (see T427563).

Danya changed the point value for this task from 21 to 13.
Danya changed the task status from Open to In Progress.Jun 3 2026, 5:37 PM
Danya moved this task from Next Version to Doing on the Tool-wiki-gender-stats board.
Danya changed the status of subtask T425991: Investigate best solution between ToolsDB and self-hosted database from Open to In Progress.

Cloud VPS request can be found here: T428090

Danya moved this task from Doing to Done on the Tool-wiki-gender-stats board.

After discussions in T428090, the website will stay on Toolforge. Closing this ticket.