On 9 May 2016 at 23:12, Ricky Elrod <codeblock@xxxxxxxx> wrote: > As some of you know, some of us (mostly smooge and I) have been working > on statistics gathering for Fedora web infra as of late. > > We are working on setting up a piwik instance to be used on our > websites. However, this instance lives in the cloud and thus can't hit > the VPN. > > A question I ran into and was told to email the list about and/or bring > up at the meeting, is: What should our backups story look like for such > cases? Mostly, we have a MySQL database on this node that will get > really big fairly quickly (right now /var/lib/mysql is about 1.1GB and > piwik only has one site added, and it's only been there for a few weeks). > > Are other cloud instances backed up in any way, and if so how was it > done? If not, how do we go about coming up with a plan for doing this, > for this instance and other instances in the future that end up having > similar requirements? > I believe in the past we would do a mysqldump of the schemas and then have an rsync target that would allow only a small set of boxes (bapp01? backup02?) to get the data from the 'dump' directory. Then the server would do a regular dump of the data, bapp01 and some other box would rsync the data from that tree and then it would be part of the daily backups of bapp01. I am not sure how workable that is these days. > (Smooge can weigh in if I'm forgetting any important details here). > > -Ricky > > > _______________________________________________ > infrastructure mailing list > infrastructure@xxxxxxxxxxxxxxxxxxxxxxx > http://lists.fedoraproject.org/admin/lists/infrastructure@xxxxxxxxxxxxxxxxxxxxxxx > -- Stephen J Smoogen. _______________________________________________ infrastructure mailing list infrastructure@xxxxxxxxxxxxxxxxxxxxxxx http://lists.fedoraproject.org/admin/lists/infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
