Page MenuHomePhabricator

Create a puppet role for x2 hosts
Closed, ResolvedPublic

Description

x2 hosts are a lot more special than we thought they'd be when we first set them up.
Like parsercache, these hosts have special config on their role and we should create an specific role for them (like parsercache has).

This role should make these hosts to have by default:

  • sync_binlog = 0
  • innodb_flush_log_at_trx_commit = 0
  • binlog = STATEMENT
  • gtid_mode=OFF

@tstarling would you have time to take a first look into this and put up an initial patch?

Related Objects

StatusSubtypeAssignedTask
Resolvedaaron
Resolvedjijiki
Resolvedaaron
ResolvedKrinkle
Resolved tstarling
Resolvedaaron
ResolvedPRODUCTION ERROR tstarling
Resolved tstarling
Resolved tstarling
Resolvedaaron
Resolvedaaron
ResolvedKrinkle
Resolvedaaron
ResolvedEevans
Resolvedaaron
ResolvedKrinkle
ResolvedPapaul
Resolved Marostegui
Resolvedaaron
ResolvedKrinkle
Resolved tstarling
Resolved tstarling
Resolved tstarling
Resolved tstarling
ResolvedKrinkle
ResolvedEevans
Resolved tstarling
ResolvedLadsgroup
Resolved tstarling
ResolvedVgutierrez
Resolved tstarling
Resolvedaaron
Resolvedjcrespo
Resolvedjcrespo
Resolved Cmjohnson
ResolvedGehel
Resolvedjcrespo
Resolvedjcrespo
Resolvedjcrespo
Resolved Marostegui
DuplicateNone
Resolvedjcrespo
Resolvedaaron
Resolvedjcrespo
Resolved tstarling
Resolved tstarling
Resolvedaaron
ResolvedKrinkle

Event Timeline

Change 824579 had a related patch set uploaded (by Tim Starling; author: Tim Starling):

[operations/puppet@production] Factor out x2 per-host hieradata into an objectstash role

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

gtid_mode=OFF is a mysql only variable. By default if not specified during the replication setup, GTID would be disabled anyways.

gtid_mode=OFF is a mysql only variable. By default if not specified during the replication setup, GTID would be disabled anyways.

Maybe a separate ticket could be setup to change the read_only icinga check (which I think already also monitors events being enabled) to also monitor GTID replication status- doesn't have to happen now but it would be a nice to have, and it is not a super complex project+other dbs would benefit from making sure it is enabled.

I actually thought we had a ticket to monitor GTID status, but I cannot find it now. I will create one if I keep without having success in finding that one

Change 824579 merged by Marostegui:

[operations/puppet@production] Factor out x2 per-host hieradata into an objectstash role

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