Hi Aaron, On Thu, Dec 18, 2014 at 07:33:25PM -0600, Aaron Halfaker wrote: > After some digging around, I can't seem to figure out where Flow's data > lives. Can someone help me out?
At some point I heard that Flow data is in the x1 shard. But I actually never had to work with that data, so that information might be stale. Just in case ... we have a separate slave for x1: x1-analytics-slave.eqiad.wmnet . And that shard has a flowdb with (it seems) flow related tables [1] with recent timestamps [2]. We previously could connect to that slave from stat1003, but that did no longer work when I tried just now :-/ That might be related to yesterday's vlan move of stat1003, so I filed T84990 [3] to open up the firewall to the x1 slave again. Have fun, Christian [1] mysql:research@x1-analytics-slave.eqiad.wmnet [flowdb]> show tables; +--------------------+ | Tables_in_flowdb | +--------------------+ | flow_definition | | flow_ext_ref | | flow_revision | | flow_subscription | | flow_topic_list | | flow_tree_node | | flow_tree_revision | | flow_wiki_ref | | flow_workflow | +--------------------+ 9 rows in set (0.00 sec) [2] mysql:research@x1-analytics-slave.eqiad.wmnet [flowdb]> select max(workflow_last_update_timestamp) from flow_workflow; +-------------------------------------+ | max(workflow_last_update_timestamp) | +-------------------------------------+ | 20141219083453 | +-------------------------------------+ 1 row in set (0.02 sec) [3] https://phabricator.wikimedia.org/T84990 -- ---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christ...@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/ ---------------------------------------------------------------
signature.asc
Description: Digital signature
_______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics