Reinstate innodb_large_prefix on ToolsDB (clouddb1001)
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	fnegri
	Dec 9 2022, 2:21 PM

Description

After a reboot of clouddb1001 earlier this week, the value for innodb_large_prefix changed to "false", and innodb_file_format changed to "Antelope", because those variables (introduced in [1]) were removed recently from the tools.my.cnf.erb file in [2] and [3], as they are set by default in MariaDB >=10.2.2, but we are still running 10.1.39 on clouddb1001.

I re-instated the values innodb_file_format=Barracuda and innodb_large_prefix=1 by manually running SET GLOBAL on clouddb1001:

SET GLOBAL innodb_large_prefix=1;
SET GLOBAL innodb_file_format = 'Barracuda';

I think it's worth re-adding those to tools.my.cnf.erb, with a comment specifying that those variables will no longer be needed after we upgrade ToolsDB to MariaDB 10.4 in T301949.

[1] https://gerrit.wikimedia.org/r/c/operations/puppet/+/389477/
[2] https://gerrit.wikimedia.org/r/c/operations/puppet/+/837490/
[3] https://gerrit.wikimedia.org/r/c/operations/puppet/+/769025/

Details

	Project	Branch	Lines +/-	Subject
	operations/puppet	production	+5 -0	Reinstate innodb_large_prefix on ToolsDB

Customize query in gerrit

Related Objects

Mentioned Here: T301949: ToolsDB upgrade => Bullseye, MariaDB 10.4

Event Timeline

fnegri created this task.Dec 9 2022, 2:21 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 9 2022, 2:21 PM

Change 866598 had a related patch set uploaded (by FNegri; author: FNegri):

[operations/puppet@production] Reinstate innodb_large_prefix on ToolsDB

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

gerritbot added a project: Patch-For-Review.Dec 9 2022, 2:29 PM

fnegri changed the task status from Open to In Progress.Dec 9 2022, 2:30 PM

fnegri triaged this task as Medium priority.

fnegri moved this task from Inbox to Doing on the cloud-services-team (Kanban) board.

Change 866598 merged by FNegri: