Page MenuHomePhabricator
Paste P7504

Spicerack core DB masters
ActivePublic

Authored by Volans on Aug 31 2018, 11:05 AM.
Tags
None
Referenced Files
F25556804: Spicerack core DB masters
Aug 31 2018, 11:05 AM
Subscribers
None
>>> from spicerack import Spicerack
>>> from spicerack.constants import CORE_DATACENTERS
>>> from spicerack.mysql import CORE_SECTIONS
>>> s = Spicerack(dry_run=False)
>>> m = s.mysql()
>>> for dc in CORE_DATACENTERS:
... print({'dc': dc, 'role': 'master', 'hosts': str(m.get_core_dbs(datacenter=dc, replication_role='master').hosts)})
...
{'role': 'master', 'dc': 'eqiad', 'hosts': 'db[1061-1062,1066-1071,1075].eqiad.wmnet,es[1015,1017].eqiad.wmnet'}
{'role': 'master', 'dc': 'codfw', 'hosts': 'db[2034-2035,2039-2040,2043,2045,2048,2051-2052].codfw.wmnet,es[2016-2017].codfw.wmnet'}
>>> for dc in CORE_DATACENTERS:
... for section in CORE_SECTIONS:
... print({'dc': dc, 'role': 'master', 'section': section, 'hosts': str(m.get_core_dbs(datacenter=dc, replication_role='master', section=section).hosts)})
...
{'section': 's1', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1067.eqiad.wmnet'}
{'section': 's2', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1066.eqiad.wmnet'}
{'section': 's3', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1075.eqiad.wmnet'}
{'section': 's4', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1068.eqiad.wmnet'}
{'section': 's5', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1070.eqiad.wmnet'}
{'section': 's6', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1061.eqiad.wmnet'}
{'section': 's7', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1062.eqiad.wmnet'}
{'section': 's8', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1071.eqiad.wmnet'}
{'section': 'x1', 'role': 'master', 'dc': 'eqiad', 'hosts': 'db1069.eqiad.wmnet'}
{'section': 'es2', 'role': 'master', 'dc': 'eqiad', 'hosts': 'es1015.eqiad.wmnet'}
{'section': 'es3', 'role': 'master', 'dc': 'eqiad', 'hosts': 'es1017.eqiad.wmnet'}
{'section': 's1', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2048.codfw.wmnet'}
{'section': 's2', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2035.codfw.wmnet'}
{'section': 's3', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2043.codfw.wmnet'}
{'section': 's4', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2051.codfw.wmnet'}
{'section': 's5', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2052.codfw.wmnet'}
{'section': 's6', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2039.codfw.wmnet'}
{'section': 's7', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2040.codfw.wmnet'}
{'section': 's8', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2045.codfw.wmnet'}
{'section': 'x1', 'role': 'master', 'dc': 'codfw', 'hosts': 'db2034.codfw.wmnet'}
{'section': 'es2', 'role': 'master', 'dc': 'codfw', 'hosts': 'es2016.codfw.wmnet'}
{'section': 'es3', 'role': 'master', 'dc': 'codfw', 'hosts': 'es2017.codfw.wmnet'}