User:DKinzler (WMF)/DB

<duesen> By the way... where and how can i safely run queries against a production replica?
<marostegui> from mwmaint1002 you just need:  sql enwiki --host $hostname
<marostegui> I would recommend always using a codfw host
<marostegui> Do you know how to find one or I can explain
<duesen> i would have guessed some page on wikitech, but please tell me :)
<marostegui> oh no, wikitech is probably 50 years behind :p
<marostegui> do you have access to: https://tendril.wikimedia.org/tree ?
<duesen> I should have access, but I don't know what account that uses :P
<marostegui> ldap
<marostegui> This also works: https://noc.wikimedia.org/db.php?dc=codfw
<marostegui> From there you can see all the hosts we have in production serving queries
<marostegui> So the advice would be to pick the hosts that are configured as vslow, so they tend to have less traffic in the load balancer, you can find which ones at: https://noc.wikimedia.org/dbconfig/eqiad.json grepping by vslow

• DB clusters and aother info: MariaDB
• List of hosts per DB cluster: https://noc.wikimedia.org/dbconfig/eqiad.json