761798 - Pull metrics data off the server into MySQL

Status: RESOLVED WONTFIX

(Marketplace Graveyard :: Statistics, defect)

Description

[Andy McKay]

Metrics is going to start placing data on their server as noted in bug 753195.

This bug is to write a cron to pull data off the metrics server and insert into the relevant tables described in bug 753195. We'll also need to create those tables to allow this to happen.

Comment 1

[Wil Clouser [:clouserw]]

Can you break down the specifics of this bug?  What data are we extracting and what tables are we injecting into?  I assume we need to tell metrics to stop injecting into our tables before we turn the cron job on?

Comment 2

[Andy McKay]

The tables were specified in https://bugzilla.mozilla.org/show_bug.cgi?id=753195#c0. There is currently no cron job started by metrics that will need turning off. 

If those tables work for the metrics, then its a matter of grabbing the data at:

https://metrics.mozilla.com/protected/marketplace/

And inserting into those tables. So this bug has two parts:

1) review said tables, see if they work and if so create them
2) go to the above URL in a cron job and insert into those tables

The indexing of that data was noted in seperate bugs.