On 9 May 2016 at 23:12, Ricky Elrod <codeblock(a)elrod.me> 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(a)lists.fedoraproject.org
http://lists.fedoraproject.org/admin/lists/infrastructure@lists.fedorapro...
--
Stephen J Smoogen.