[Labs-l] [Toolserver-l] TS and/vs. Labs

[Platonides]

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...).