You are browsing a read-only backup copy of Wikitech. The primary site can be found at wikitech.wikimedia.org

Wikimetrics

From Wikitech-static
Revision as of 18:20, 23 August 2016 by imported>Nuria
Jump to navigation Jump to search

Administration

Logs

Wikimetrics is now logging to systemd. Logs are available through journalctl

sudo journalctl -u uwsgi-wikimetrics-web --since "1 hour ago"
sudo journalctl -u wikimetrics-queue --since "1 hour ago"


Logs from uwsgi are at: /var/log/uwsgi/app

IP tables

These are not in puppet and need to be rerun everytime instance is rebooted:

iptables -t nat -I OUTPUT -p tcp --destination s1.labsdb --dport mysql -j DNAT --to-destination 10.64.20.12:3306
iptables -t nat -I OUTPUT -p tcp --destination 192.168.99.2 --dport mysql -j DNAT --to-destination 10.64.37.4:3306
iptables -t nat -I OUTPUT -p tcp --destination s3.labsdb --dport mysql -j DNAT --to-destination 10.64.37.5:3306
iptables -t nat -I OUTPUT -p tcp --destination 192.168.99.4 --dport mysql -j DNAT --to-destination 10.64.37.4:3307
iptables -t nat -I OUTPUT -p tcp --destination 192.168.99.5 --dport mysql -j DNAT --to-destination 10.64.37.4:3308
iptables -t nat -I OUTPUT -p tcp --destination s6.labsdb --dport mysql -j DNAT --to-destination 10.64.37.5:3307
iptables -t nat -I OUTPUT -p tcp --destination s7.labsdb --dport mysql -j DNAT --to-destination 10.64.37.5:3308
iptables -t nat -I OUTPUT -p tcp --destination c1.labsdb --dport mysql -j DNAT --to-destination 10.64.37.4:3309
iptables -t nat -I OUTPUT -p tcp --destination s2.labsdb --dport mysql -j DNAT --to-destination 10.64.37.4:3309
iptables -t nat -I OUTPUT -p tcp --destination c3.labsdb --dport mysql -j DNAT --to-destination 10.64.37.4:3309