On Fri, May 8, 2020 at 3:01 PM Brooke Storm <bstorm(a)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.
[0]:
https://phabricator.wikimedia.org/phame/post/view/70/new_wiki_replica_serveā¦
Bryan
--
Bryan Davis Technical Engagement Wikimedia Foundation
Principal Software Engineer Boise, ID USA
[[m:User:BDavis_(WMF)]] irc: bd808