Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P7504
Spicerack core DB masters
Active
Public
Actions
Authored by
Volans
on Aug 31 2018, 11:05 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F25556804: Spicerack core DB masters
Aug 31 2018, 11:05 AM
2018-08-31 11:05:58 (UTC+0)
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'
}
Event Timeline
Volans
created this paste.
Aug 31 2018, 11:05 AM
2018-08-31 11:05:58 (UTC+0)
Log In to Comment