Page MenuHomePhabricator
Create Task
Maniphest T91816

Add code to enable setting sticky DC cookies for POST requests
Closed, ResolvedPublic
Actions

Description

This will keep the user in the same DC on change-inducing requests for a few seconds for consistency (per the RfC).

Details

SubjectRepoBranchLines +/-
Added $wgDataCenterId/$wgDataCenterRolesmediawiki/coremaster+74 -2
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedaaronT252951 ResourceLoader DepStore lock acquired twice?
 ResolvedaaronT88445 MediaWiki active/active datacenter investigation and work (tracking)
 ResolvedKrinkleT270223 FY2021-2022: Enable basic Multi-DC operations for read traffic (tracking)
 ResolvedtstarlingT267270 Determine multi-dc strategy for CentralAuth
 ResolvedaaronT278392 Storage solution for cross-datacenter tokens
 ResolvedPRODUCTION ERRORtstarlingT311590 ApiEchoUnreadNotificationPages::getUnreadNotificationPagesFromForeign: Unexpected API response from {wiki}
 ResolvedtstarlingT313496 Harmonize CentralAuth and core session TTL and migrate CentralAuth sessions to Kask
 ResolvedtstarlingT91820 Create HTTP verb and sticky cookie DC routing in VCL
ResolvedaaronT91816 Add code to enable setting sticky DC cookies for POST requests
 ResolvedKrinkleT113916 Switch ResourceLoader file dependency tracking to MultiDC-friendly backend
 ResolvedaaronT247028 Database 'INSERT' query rate doubled (module_deps regression?)
 ResolvedtstarlingT253433 Web installer CSS fails with ServiceDisabledException
 DeclinedaaronT253697 Support hash-based deduplication in KeyValueDependencyStore
 ResolvedaaronT212129 Move MainStash out of Redis to a simpler multi-dc aware solution
 ResolvedEevansT222851 Improve Echo seentime code for multi-DC access
 ResolvedaaronT229062 Look into a simple way to have global keys with db-replicated
 ResolvedKrinkleT254634 Determine and implement multi-dc strategy for ChronologyProtector
Unknown Object (Task)
 ResolvedPapaulT267041 (Need By: 2020-11-29) rack/setup/install db214[234]
 Resolved• MarosteguiT269324 Productionize x2 databases
 ResolvedaaronT274174 Add modtoken field and flags to objectcache table
 ResolvedKrinkleT288998 Significant ParserCache space increase after 2021-08-12 (1.37.0-wmf.18 regression)
 ResolvedtstarlingT306118 Notify DBA prior to sending db traffic to x2
 ResolvedtstarlingT315271 db1151, db2144 X2 masters error: Could not execute Delete_rows_v1 event on table mainstash.objectstash
 ResolvedPRODUCTION ERROR• jcrespoT315274 Wikimedia\Rdbms\DBTransactionError: Explicit transaction still active; a caller might have failed to call endAtomic() or cancelAtomic().
 ResolvedtstarlingT315427 Create a puppet role for x2 hosts
 Resolved• MarosteguiT315853 reclone x2 codfw hosts
 ResolvedtstarlingT315995 Document how to disable x2 per DC
 ResolvedKrinkleT270225 Finish session storage to actually meet multi-DC requirements
 ResolvedEevansT222990 Audit session storage to determine max age of un-GC'd sessions
 ResolvedtstarlingT279664 Progressive Multi-DC roll out
 ResolvedLadsgroupT314486 Add support for multidc to auto_schema
 ResolvedtstarlingT314750 Clean up testwiki experiments (Aug 2022)
 ResolvedVgutierrezT315434 multi-dc.lua ATS script failing in production
 ResolvedtstarlingT134809 App servers <=> mariadb SSL/TLS for cross-datacenter writes
 ResolvedaaronT136218 Audit mysql database class and hhvm binding support of SSL
 Resolved• jcrespoT111654 Set up TLS for MariaDB replication
 Resolved• jcrespoT120122 Perform a rolling restart of all MySQL slaves (masters too for those services with low traffic)
 Resolved• CmjohnsonT120689 es1019 and its management interface are unresponsive
 ResolvedGehelT128077 Create a PKI that can be used by Puppet and for general purpose certificates
 Resolved• jcrespoT151995 Rolling restart of external storage servers for TLS certificate update
 Resolved• jcrespoT152029 Rolling restart of parsercache servers for TLS certificate update
 Resolved• jcrespoT152188 Restart pending mysql hosts with old TLS cert
 Resolved• MarosteguiT152364 db1047 out of disk space, eventlogging_sync spam
 DuplicateNoneT152595 Implement TLS expiration/validation checking for MariaDB certificates
 Resolved• jcrespoT156005 Reimage db1065 and db1066
 ResolvedaaronT171071 Perform testing for TLS effect on connection rate
 Resolved• jcrespoT175672 Evaluate proxysql and native php-mysql client for TLS connection between Apache and mariadb
ResolvedtstarlingT196378 Investigate solutions for MySQL connection pooling
 ResolvedtstarlingT313578 Make OAuth work in Multi-DC active/active mode
 ResolvedaaronT320995 Create blog entry about multi-dc
 ResolvedKrinkleT329692 Story idea for Blog: Around the world: how we serve traffic from multiple data centers

Event Timeline

aaron created this task.Mar 6 2015, 9:09 PM
aaron claimed this task.
aaron raised the priority of this task from to Medium.
aaron updated the task description. (Show Details)
aaron added projects: Patch-For-Review, Epic, MediaWiki-Core-Team.
aaron added subscribers: PleaseStand, gerritbot, bd808 and 2 others.
• RobLa-WMF removed a project: Epic.Mar 12 2015, 7:23 PM
• Gilles removed a project: Patch-For-Review.Apr 1 2015, 8:54 AM
• Gilles set Security to None.
• Gilles subscribed.Apr 2 2015, 12:25 PM
• Gilles edited projects, added Sustainability; removed MediaWiki-Core-Team.Apr 7 2015, 7:30 AM
Krinkle added a project: MediaWiki-General.Jun 23 2015, 7:05 AM
Krinkle added a parent task: T91820: Create HTTP verb and sticky cookie DC routing in VCL .
gerritbot added a comment.Aug 30 2015, 9:30 PM

Change 232661 had a related patch set uploaded (by Aaron Schulz):
[WIP] Added $wgDataCenterId/$wgDataCenterRoles

https://gerrit.wikimedia.org/r/232661

gerritbot added a project: Patch-For-Review.Aug 30 2015, 9:30 PM
aaron added a project: Performance-Team.Sep 28 2015, 7:41 PM
gerritbot added a comment.Oct 1 2015, 11:10 AM

Change 232661 merged by jenkins-bot:
Added $wgDataCenterId/$wgDataCenterRoles

https://gerrit.wikimedia.org/r/232661

aaron mentioned this in rMW0a1c04beae41: Added $wgDataCenterId/$wgDataCenterRoles.Oct 1 2015, 11:11 AM
ReleaseTaggerBot added projects: MW-1.27-release (WMF-deploy-2015-10-06_(1.27.0-wmf.2)), MW-1.27-release-notes.Oct 1 2015, 6:01 PM
aaron closed this task as Resolved.Oct 2 2015, 7:04 AM
Anomie mentioned this in T151770: Frequent loss of session data in Firefox (since around 2016-11-28).Jan 7 2017, 10:26 PM
Tgr mentioned this in T110353: Audit use of cookies.Jan 8 2017, 8:32 AM
Krinkle mentioned this in T274724: Add support for "Max-Age" to WebResponse::setCookie (more reliable than "Expires").Feb 14 2021, 7:03 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits