This site is no longer actively maintained. It exists for historical purposes as an example of Phabricator integration and Lua scripting.

Tasks By Project

From cpt

Project: DBA

Switch to Active Tasks 187 Phabricator task(s).

Phabricator Link Wiki Link Status Priority Author Assignee Projects Subtasks Parent Tasks
T107610 T107610: Setup separate logical External Store for Flow in production declined High (red)
T111266 T111266: Make LoadBalancer slave lag check and read-only mode more robust (for example, using pt-heartbeat) resolved High (red)
T111654 T111654: Set up TLS for MariaDB replication resolved Medium (orange)
T116557 T116557: AFComputedVariable::compute query timeouts resolved High (red)
    T119567 T119567: Run Flow External Store migration in dry-run mode on Beta resolved High (red)
    T119642 T119642: Create a Master-master topology between datacenters for easier failover (setup circular replication dallas -> eqiad for mysql databases) resolved High (red)
      T119648 T119648: Fix getLagFromPtHeartbeat() to use the pt entry for the root master, not the immediate one resolved Low (yellow)
        T120122 T120122: Perform a rolling restart of all MySQL slaves (masters too for those services with low traffic) resolved High (red)
        T120242 T120242: Consistent MediaWiki state change events | MediaWiki events as source of truth open Medium (orange)
        T124795 T124795: codfw is in read only according to mediawiki resolved High (red)
          T129093 T129093: SHOW SLAVE STATUS as a health check should have a low timeout open Low (yellow)
          T133385 T133385: Implement GTID replication on MariaDB 10 servers resolved Medium (orange)
            T133523 T133523: Decide how to improve parsercache replication, sharding and HA open Medium (orange)
            T134809 T134809: Apache <=> mariadb SSL/TLS for cross-datacenter writes stalled Medium (orange)
            T135027 T135027: MASTER_POS_WAIT() alternative that works cross-DC resolved Medium (orange)
            T138778 T138778: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10 resolved Medium (orange)
            T149077 T149077: Certain ApiQueryRecentChanges::run api query is too slow, slowing down dewiki declined Medium (orange)
              T151995 T151995: Rolling restart of external storage servers for TLS certificate update resolved High (red)
                T152029 T152029: Rolling restart of parsercache servers for TLS certificate update resolved High (red)
                  T152188 T152188: Restart pending mysql hosts with old TLS cert resolved Low (yellow)
                  T152364 T152364: db1047 out of disk space, eventlogging_sync spam resolved Needs Triage (violet)
                    T152427 T152427: Create a check/calendar alert for MariaDB TLS certs open Medium (orange)
                      T152595 T152595: Implement TLS expiration/validation checking for MariaDB certificates duplicate Needs Triage (violet)
                        T153440 T153440: Create a full backup of all external storage records that would be easy to restore/setup a temporary delayed slave resolved High (red)
                          T156005 T156005: Reimage db1065 and db1066 resolved High (red)
                            T157702 T157702: Followup for TLS MariaDB server roll-out open Medium (orange)
                            T160984 T160984: Reduce max execution time of interactive queries or a better detection and killing of bad query patterns resolved High (red)
                              T162138 T162138: How many revision comments are exactly the same? Get some stats. resolved Medium (orange)
                                T163351 T163351: codfw API slaves overloaded during the 2017-04-19 codfw switch resolved High (red)
                                T163413 T163413: Pool new server db2071 resolved Medium (orange)
                                  T164382 T164382: Evaluate the need for FORCE INDEX (ls_field_val) [now IGNORE INDEX (ls_log_id)], delete the index hint if not needed anymore open Low (yellow)
                                    T166184 T166184: Run updateRestrictions.php on WMF wikis resolved Medium (orange)
                                      T166798 T166798: Decide whether back-compat views for upcoming major schema changes will be provided in the Labs replicas resolved Low (yellow)
                                        T171071 T171071: Perform testing for TLS effect on connection rate resolved Medium (orange)
                                        T172497 T172497: Fix mediawiki heartbeat model, change pt-heartbeat model to not use super-user, avoid SPOF and switch automatically to the real master without puppet dependency open Medium (orange)
                                          T174044 T174044: Deploy MCR storage layer resolved Medium (orange)
                                          T174569 T174569: Schema change for refactored comment storage resolved Medium (orange)
                                          T175672 T175672: Make apache/maintenance hosts TLS connections to mariadb work open Medium (orange)
                                            T177778 T177778: Improve database application performance monitoring visibility resolved Low (yellow)
                                              T183419 T183419: Determine how to update old compressed ExternalStore entries for T181555 resolved Medium (orange)
                                                T183469 T183469: Setup newer machines and replace all old misc (m*) and x1 eqiad machines resolved Medium (orange)
                                                T183470 T183470: Setup newer machines and replace all old misc (m*) and x1 codfw machines resolved Medium (orange)
                                                T183486 T183486: MCR schema migration stage 0: create tables resolved Medium (orange)
                                                  T184054 T184054: Decommission db1029 and db1031 resolved Medium (orange)
                                                    T184446 T184446: Configure Toolforge replica views and dumps for the new MCR tables resolved Medium (orange)
                                                      T184703 T184703: Decommission db1011 resolved Medium (orange)
                                                      T184704 T184704: Setup tendril database monitoring on 2 new hosts, one on eqiad and one on codfw resolved Medium (orange)
                                                        T187089 T187089: Fix WMF schemas to not break when comment store goes WRITE_NEW resolved High (red)
                                                          T187542 T187542: Decommission db1043 resolved Medium (orange)
                                                            T187543 T187543: Decommission db2012 resolved Medium (orange)
                                                              T187722 T187722: Replace db2030 from m5 with another host (WAS: Degraded RAID on db2030) resolved Medium (orange)
                                                              T187768 T187768: Decommission db2030 resolved Medium (orange)
                                                                T187886 T187886: Decommission db2011 resolved Medium (orange)
                                                                  T188299 T188299: Schema change for refactored actor storage resolved Medium (orange)
                                                                  T189005 T189005: Failover m5 master from db1009 to db1073 resolved Medium (orange)
                                                                  T189216 T189216: Decommission db1009 resolved Medium (orange)
                                                                    T189655 T189655: Switchover m1 master from db1016 to db1063 resolved Medium (orange)
                                                                    T189656 T189656: Switchover m2 master from db1020 to db1051 resolved Medium (orange)
                                                                      T189773 T189773: Decommission db1020 resolved Medium (orange)
                                                                      T190148 T190148: Change DEFAULT 0 for rev_text_id on production DBs resolved Medium (orange)
                                                                        T190153 T190153: DROP unused 'slots' table (WAS: In the slots table, replace slot_inherited with slot_origin) resolved Medium (orange)
                                                                          T190179 T190179: Decommission db1016 resolved Medium (orange)
                                                                            T190262 T190262: Decommission db1001 resolved Medium (orange)
                                                                              T195792 T195792: Add support for setting individual query timeout in wikimedia/rdbms resolved Medium (orange)
                                                                                T196378 T196378: Investigate solutions for MySQL connection pooling open Medium (orange)
                                                                                  T196547 T196547: [Epic] Extension:JADE scalability concerns resolved Medium (orange)
                                                                                  T197616 T197616: Create a production test wiki in group0 to parallel Wikimedia Commons resolved Medium (orange)
                                                                                    T200297 T200297: Review Jade data storage and architecture proposal [RFC] resolved Medium (orange)
                                                                                    T202596 T202596: Write our anticipated "phase two" schemas and submit for review resolved Medium (orange)
                                                                                      T209031 T209031: Not able to scoop comment table in labs for mediawiki reconstruction process [EPIC} resolved High (red)
                                                                                      T209591 T209591: Drop table image_comment_temp on all wikis resolved Medium (orange)
                                                                                      • DBA (In progress)
                                                                                        T210693 T210693: Create materialized views on Wiki Replica hosts for better query performance resolved High (red)
                                                                                          T210725 T210725: Replace parsercache keys to something more meaningful on db-XXXX.php resolved Medium (orange)
                                                                                            T211613 T211613: rack/setup/install db11[26-38].eqiad.wmnet resolved High (red)
                                                                                            T211804 T211804: A huge spike on read rows for commonswiki resolved High (red)
                                                                                              T212154 T212154: Recommendation API exceeds max_user_connections in MySQL resolved Needs Triage (violet)
                                                                                                T216656 T216656: API problem with usercontribs using `rev_user_text` rather than `rev_user`: Only use 'contributions' replica if querying by user ID resolved Medium (orange)
                                                                                                  T218692 T218692: read only on mediawiki generates "LoadBalancer.php: Cannot access the database: Unknown error" resolved Medium (orange)
                                                                                                    T219374 T219374: Prepare and check storage layer for hi.wikisource resolved Medium (orange)
                                                                                                      T219493 T219493: Prepare to decommission 2 codfw x1 hosts db2033 and db2034 resolved Medium (orange)
                                                                                                      • DBA (In progress)
                                                                                                      T220170 T220170: Address Database hardware infrastructure blockers on datacenter switchover & multi-dc deployment resolved Medium (orange)
                                                                                                      T221159 T221159: FY18/19 TEC1.6 Q4: Improve or replace the usage of GTID_WAIT with pt-heartbeat in MW declined High (red)
                                                                                                      T221458 T221458: Special:Log on commons -- entire web request took longer than 60 seconds and timed out resolved Unbreak Now! (pink)
                                                                                                        T221533 T221533: Decommission old coredb machines (<=db2042) resolved Medium (orange)
                                                                                                        • DBA (In progress)
                                                                                                        T222224 T222224: RFC: Normalize MediaWiki link tables open Medium (orange)
                                                                                                          T222682 T222682: Productionize db11[26-38] resolved Medium (orange)
                                                                                                            T223151 T223151: Review special replica partitioning of certain tables by `xx_user` resolved Medium (orange)
                                                                                                            T224017 T224017: Slow query ApiQueryRevisions on enwiki resolved High (red)
                                                                                                              T224852 T224852: Failover s4 primary master: db1068 to db1081 resolved Medium (orange)
                                                                                                              • DBA (In progress)
                                                                                                              • SRE (Backlog)
                                                                                                              T226358 T226358: Failover x1 master: db1069 to db1120 3rd July at 06:00 UTC resolved Medium (orange)
                                                                                                                T226952 T226952: Failover m2 master db1065 to db1132 resolved Medium (orange)
                                                                                                                  T227062 T227062: Failover s8 (wikidatawiki) db primary master db1071 to db1104 (read-only required) resolved Medium (orange)
                                                                                                                  • DBA (In progress)
                                                                                                                  T228243 T228243: Switchover m3 (phabricator) master db1072 to db1128 resolved Medium (orange)
                                                                                                                  T229657 T229657: Switchover m5 primary master: db1073 to db1133: Tuesday 3rd Sept at 13:00 UTC resolved Medium (orange)
                                                                                                                    T230106 T230106: Switchover codfw primary database masters to new hosts resolved Medium (orange)
                                                                                                                      T230459 T230459: Replace db2044 with db2063 declined Medium (orange)
                                                                                                                      • DBA (In progress)
                                                                                                                        T231598 T231598: Compose Count Queries resolved Medium (orange)
                                                                                                                          T231599 T231599: Compose New History Queries resolved Medium (orange)
                                                                                                                            T233135 T233135: Schema change for refactored actor and comment storage resolved Medium (orange)
                                                                                                                            T233579 T233579: Tracking task for mariadb optimizer misbehaviours declined Medium (orange)

                                                                                                                            ... further results

                                                                                                                            Retrieved from "https://wikifarm.wmflabs.org/cpt/index.php?title=Tasks_By_Project&oldid=58235"
                                                                                                                            Powered by MediaWiki
                                                                                                                            Powered by Semantic MediaWiki