Okay, thanks everybody! I've filed the task <https://phabricator.wikimedia.org/T115275>.
Aaron, I just filed the task for the Echo databases, because I *think *Flow uses Cassandra, which couldn't be replicated to a MariaDB instance. On Sat, Oct 10, 2015 at 8:30 AM, Aaron Halfaker <[email protected]> wrote: > IMO we should have echo and flow databases on analytics-store even if this > use case is served by Event Logging data. The whole point of having so > many databases replicated on that machine is to make for easy to do cross > DB joins. > > Neil, If you file a DBA task, please CC me. :) > > On Fri, Oct 9, 2015 at 4:40 PM, Leila Zia <[email protected]> wrote: > >> >> On Fri, Oct 9, 2015 at 1:26 PM, Neil P. Quinn <[email protected]> >> wrote: >> >>> I'm trying to gather some stats on the use of Echo notifications across >>> wikis, and I'd like to join the `echo_events` table with the `user` table >>> for a given wiki. >>> >> >> I'm not sure what kind of information you need but there is a chance that >> they are captured via schema in which case you can get them from Echo >> schema in log database and then join that with enwiki.user. I'm also not >> sure what info you need from enwiki.user, you may be able to get more >> global info from centralauth.globaluser. >> >> Leila >> >> >>> >>> -- >>> Neil P. Quinn <https://meta.wikimedia.org/wiki/User:Neil_P._Quinn-WMF>, >>> product analyst >>> Wikimedia Foundation >>> >>> _______________________________________________ >>> Analytics mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/analytics >>> >>> >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > > -- Neil P. Quinn <https://meta.wikimedia.org/wiki/User:Neil_P._Quinn-WMF>, product analyst Wikimedia Foundation
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
