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

[Jeremy Baron]

On Sep 16, 2013 7:06 PM, "Platonides" <platonides at gmail.com> wrote:
> labs db server do contain the non-public data. It's just not viewable. So
there aren't bin logs for just the non-public data.
> You *could* make a dump of the database (probably creating a new tool, as
mysqldump would simply dump the view definition)... assuming you that in
doing that you don't kill labs filesystem. ;)

I think maybe percona-toolkit has relevant tools to sync between 2 versions
of the same table (e.g. update a snapshot from yesterday from a current
copy) but that probably relies on having primary keys on the tables and not
all of our tables have primary keys. (I think external links was the one I
was looking at recently which had no primary key)

-Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20130916/7e090576/attachment.html>