One clarification,
While everything Bryan says is right, I have to say that the main factor in not allowing writes on wikireplicas wasn't pain for administration (which was real) as much as avoiding continuous blockage of data due to other users creating long-running write queries (pain for users). As Bryan says, indeed a read only service allows automatic load balancing to spread the load, avoiding outages. Long running read queries can cause overload, but not blocking.
Creating regularly summary tables that are useful for several users is something that I would like to explore, but as I mentioned here: https://lists.wikimedia.org/pipermail/cloud/2020-April/001051.html there is a lot of programming and a list of problems to solve before that could be setup. This is right now not a priority, but like with every task on Wikimedia (see the linked task), volunteer work could help speed it up 0:-).
On Sat, May 9, 2020 at 3:01 AM Bryan Davis bd808@wikimedia.org wrote:
On Fri, May 8, 2020 at 3:01 PM Brooke Storm bstorm@wikimedia.org wrote:
No, the wikireplicas are read-only.
There is slightly more context for this restriction in the blog post that announced the "new" Wiki Replicas databases in 2017 [0].
The prior generation of Wiki Replica databases did allow arbitrary table creation by users. This was both a powerful feature and a cause of pain for system administration. User created tables were not replicated across the cluster which meant that when system maintenance was performed tables or data would mysteriously vanish from the point of view of the user if traffic was routed to a different backend server. Data would also be irretrievably lost when a server experienced major system failures. It was a difficult decision for the Cloud Services and DBA teams to make to remove this useful feature, but doing so has allowed much greater ease of administration and by extension better availability and less replication drift issues for the wiki databases than was possible with the feature in place.
Bryan
Bryan Davis Technical Engagement Wikimedia Foundation Principal Software Engineer Boise, ID USA [[m:User:BDavis_(WMF)]] irc: bd808
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud