Migrated from: https://wikimedia.mingle.thoughtworks.com/projects/language_engineering/cards/4118

Context

We had set up a database replication lag environment some time ago. Given the labs migration to eqiad, those instances are no longer running, so we need to restore or recreate them.

Replication testing environment consists of MediaWiki and at least two sql databases: one master and one slave. The replication is delayed by constant amount (10 seconds) to make replication issues happen more reliably.

There are a handful of bugs in Translate extension, mainly in the page translation feature, which only happen in the Wikimedia cluster, but not at translatewiki.net for example. Because we have not been able to reproduce those bugs, it is very hard to fix them, as we do not understand what is going on. It is hoped that the replication environment will make it possible to fix these bugs.

Example bug:https://bugzilla.wikimedia.org/show_bug.cgi?id=54579

Narrative

As a MediaWiki developer, I can test database replication lag, so that I can fix my code.

Acceptance Criteria

Replication lag environment is set up.

Deliverables

• Enter link to actually done tangible deliverable(s)

Open tasks

{{
table query: SELECT Number, Name, Owner, 'Hours Remaining', 'Task Status' WHERE Type = Task and 'Schedule - Story' = THIS CARD and 'Task Status' < 'Done' ORDER BY 'Task Status', Owner, Name
}}

Completed tasks

{{
table query: SELECT Number, Name, Owner, 'Hours Remaining', 'Task Status' WHERE Type = Task and 'Schedule - Story' = THIS CARD and 'Task Status' = 'Done' ORDER BY 'Task Status', Owner, Name
}}

Defects

{{
table query: SELECT Number, Name, Owner, 'Defect Status' WHERE Type = Defect and 'Schedule - Story' = THIS CARD
}}