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

_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l

Reply via email to