On 17/09/13 01:22, Marc A. Pelletier wrote:
On 09/16/2013 04:13 PM, Platonides wrote:
labs db server do contain the non-public data.
Just to clarify things, here, that's a necessary artifact of the way
mediawiki works: many of the bits of data that should be made
unavailable are done so conditionally on /live data/. It is not possible
to replicate the visible contents of the views and have it not break as
column values may be nulled or *come back* depending on actions on the
projects (supression, deletion, etc).
While some of the more sensitive data never hits the replica (like IP
addresses), It is not /possible/ to create a replica without
transferring data that can be unsupressed or undeleted -- but might
never be.
-- Marc
I guess there could be a labs replica with triggers that deleted data at
the point it became private, which could then serve as replication
master providing public binlogs. The problem which breaks the idea
completely are the restores, ie. non-public data coming back (the server
would receive ‘show this again’, but it would need a full insert...).