Coming back to this comment from Martin: how can we use temporary tables on
Labs? They don't seem to be available on a connection to wiki replica DBs:
MariaDB [fawiki_p]> create temporary table tmp(i int);
ERROR 1044 (42000): Access denied for user 's12345'@'%' to database
'fawiki_p'
On Fri, May 8, 2020 at 5:07 PM Martin Urbanec <martin.urbanec(a)wikimedia.cz>
wrote:
Hmm, does create temporary table work? If not, can
it?
Martin
On Fri, May 8, 2020, 11:04 PM Huji Lee <huji.huji(a)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(a)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 Servicesbstorm(a)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 listCloud(a)lists.wikimedia.org (formerly
labs-l@lists.wikimedia.org)https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud