Hmm, does create temporary table work? If not, can it? Martin
On Fri, May 8, 2020, 11:04 PM Huji Lee <huji.h...@gmail.com> wrote: > I was thinking of running a query, temporarily store its output on > ToolsDB. Join it with some other query and then throw it away. All in small > scale and for short-term. > > On Fri, May 8, 2020 at 5:01 PM Brooke Storm <bst...@wikimedia.org> wrote: > >> No, the wikireplicas are read-only. >> >> That said, ToolsDB (Toolforge user DB) is not equipped to handle becoming >> an aggregate datamart for the wiki replicas at any thing close to large >> (wiki) scale--just small chunks that are ideally regularly cleaned up. Are >> we talking about a database on a Cloud VPS instance or ToolsDB? >> >> Brooke Storm >> SRE >> Wikimedia Cloud servicesbst...@wikimedia.org >> IRC: bstorm_ >> >> On 5/8/20 12:31 PM, Huji Lee wrote: >> >> Hi all, >> Is it possible to store data into user tables through queries on >> Wikireplica DBs? Or is it only possible by mysqldump'ing from the replica >> DB and loading into the user table in a separate step? >> I am thinking of aggregate data. >> Thanks! >> >> _______________________________________________ >> Wikimedia Cloud Services mailing listcl...@lists.wikimedia.org (formerly >> lab...@lists.wikimedia.org)https://lists.wikimedia.org/mailman/listinfo/cloud >> >> >> _______________________________________________ >> Wikimedia Cloud Services mailing list >> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) >> https://lists.wikimedia.org/mailman/listinfo/cloud > > _______________________________________________ > Wikimedia Cloud Services mailing list > Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
