After some digging around, I can't seem to figure out where Flow's data lives. Can someone help me out?
See https://www.mediawiki.org/wiki/Flow and https://git.wikimedia.org/tree/mediawiki%2Fextensions%2FFlow/57e8f25ac92d688...
-Aaron
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
Hi,
On Fri, Dec 19, 2014 at 12:31:50PM +0100, Christian Aistleitner wrote:
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.
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
Have fun, Christian
Yup; x1 is used for Flow/Echo/anything else that needs that kind of distributed data structure.
On 19 December 2014 at 07:06, Christian Aistleitner < christian@quelltextlich.at> wrote:
Hi,
On Fri, Dec 19, 2014 at 12:31:50PM +0100, Christian Aistleitner wrote:
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.
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
Have fun, Christian
-- ---- quelltextlich e.U. ---- \ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christian@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
:) :) Thank you!
On Dec 19, 2014, at 07:06, Christian Aistleitner christian@quelltextlich.at wrote:
Hi,
On Fri, Dec 19, 2014 at 12:31:50PM +0100, Christian Aistleitner wrote:
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.
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
Have fun, Christian
-- ---- quelltextlich e.U. ---- \ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christian@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Thanks folks! :)
On Fri, Dec 19, 2014 at 8:36 AM, Andrew Otto aotto@wikimedia.org wrote:
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
:) :) Thank you!
On Dec 19, 2014, at 07:06, Christian Aistleitner <
christian@quelltextlich.at> wrote:
Hi,
On Fri, Dec 19, 2014 at 12:31:50PM +0100, Christian Aistleitner wrote:
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.
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
Have fun, Christian
-- ---- quelltextlich e.U. ---- \ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christian@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
:) :) Thank you!
On Dec 19, 2014, at 07:06, Christian Aistleitner christian@quelltextlich.at wrote:
Hi,
On Fri, Dec 19, 2014 at 12:31:50PM +0100, Christian Aistleitner wrote:
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.
Ticket is resolved already :-D Thanks, akosiaris!
So stat1003 can again to connect to x1-analytics-slave.
Have fun, Christian
-- ---- quelltextlich e.U. ---- \ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christian@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics