Hmm, does create temporary table work? If not, can it? 

Martin

On Fri, May 8, 2020, 11:04 PM Huji Lee <huji.huji@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 <bstorm@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 Services
bstorm@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 list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud