[07:01:26] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2559882 (10jcrespo) I recommended to use utf8mb4, which is real UTF-8; I recommended against utf8. [07:02:00] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2559883 (10jcrespo) Why do you think innodb_large_prefix should not be possible? [07:18:51] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review, and 2 others: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2559933 (10matthiasmullie) The script fix has been deployed & appears to dryrun just fine. @jcrespo: can you take another backup please, before I star... [08:04:22] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review, and 2 others: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2559999 (10jcrespo) Done. ``` $ ls -lha *20160817* -rw-r--r-- 1 root root 72M Aug 17 08:02 ptwikibooks-s3-20160817T080248.sql.gz -rw-r--r-- 1 root roo... [09:39:04] 10DBA, 06Labs, 10Labs-Infrastructure: labsdb* has no automatic failover solution - https://phabricator.wikimedia.org/T141097#2560149 (10jcrespo) > can we cram them onto one new server I do not have right now exact numbers, and some may be excessively large, but yes, we can cram them in a single server, at l... [10:17:01] 10DBA: Decommission db1010 - https://phabricator.wikimedia.org/T129395#2104373 (10jcrespo) p:05Triage>03Low [10:17:51] 10DBA, 06Operations, 13Patch-For-Review: Firewall configurations for database hosts - https://phabricator.wikimedia.org/T104699#2560238 (10jcrespo) [10:29:30] 10DBA, 06Operations, 13Patch-For-Review: Firewall configurations for database hosts - https://phabricator.wikimedia.org/T104699#2560291 (10jcrespo) We should be able to do `db1009` at any time, I do not have a good candidate for failover on eqiad; but most services should be able to handle some seconds of un... [11:21:50] 10DBA, 10Flow, 03Collab-Team-Q1-July-Sep-2016, 13Patch-For-Review, and 2 others: Cleanup ptwikibooks conversion - https://phabricator.wikimedia.org/T119509#2560385 (10matthiasmullie) LQT threads have now been restored. ptwikibooks should now be in good shape again & ready for a new LQT -> Flow import. [15:32:22] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2560986 (10bd808) >>! In T142545#2559883, @jcrespo wrote: > Why do you think innodb_large_prefix should not be possible? It is not on mediawiki only... [15:35:07] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2561002 (10jcrespo) I realize that my comment may sound mean, it is not my intention. Please read them as if there was an emoticon ;-P at the start... [15:37:25] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2561005 (10bd808) [15:44:12] 10DBA, 06Operations, 10ops-codfw: es2004 has a dead disk, but it is not under warranty - https://phabricator.wikimedia.org/T143220#2561047 (10jcrespo) [15:46:59] 10DBA, 06Operations, 10ops-codfw: es2004 has a dead disk, but it is not under warranty - https://phabricator.wikimedia.org/T143220#2561079 (10jcrespo) p:05Triage>03Low [17:08:03] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2561323 (10bd808) [17:11:44] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2561332 (10bd808) @jcrespo No worries. I'm getting to be able to read your tone after following various tickets. :) Would it be reasonable to have... [18:03:43] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2561522 (10jcrespo) Yes, but check the comments on gerrit: I need a source IP and depending where it is, it may need opening "holes" at various levels. [18:58:10] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2538784 (10chasemp) >>! In T142545#2561522, @jcrespo wrote: > Yes, but check the comments on gerrit: I need a source IP and depending where it is, i... [19:14:21] 10Blocked-on-schema-change, 10DBA, 10ArchCom-RfC, 10Wikimedia-Site-requests, 06Wikisource: Schema change for page content language - https://phabricator.wikimedia.org/T69223#2000167 (10RobLa-WMF) >>! In T69223#2547054, @jcrespo wrote: > I see a point to forking mediawiki in specific cases, this could be... [20:10:50] 10DBA, 06Community-Tech-Tool-Labs, 10Striker, 13Patch-For-Review: Create production database and users for Striker - https://phabricator.wikimedia.org/T142545#2562079 (10bd808)