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