[wp-edu] Process for pruning/retiring inactive sites?

[Joseph Ugoretz]

I've heard that, too, and it might be true in larger installs, but it just hasn't been the case for us so far.

We backup the entire MySQL database 4x a day. I admit it's many many thousands of tables (and more each semester, of course) but we're just copying the directory on the server to an evault, and it's all automated and goes quite smoothly.

But maybe you're a lot bigger than us?

(I hope I'm not jinxing myself by saying this!  Maybe someday we'll get to that promised point where those problems occur, but it hasn't happened yet).

Joe
--
Joseph Ugoretz, PhD
Associate Dean
Teaching, Learning and Technology
Macaulay Honors College, CUNY
35 West 67th St.<x-apple-data-detectors://2/1>
New York, New York 10023<x-apple-data-detectors://2/1>
212-729-2920<tel://212-729-2920>

On Jun 24, 2015, at 8:20 PM, Grogan, David <David.Grogan at tufts.edu<mailto:David.Grogan at tufts.edu>> wrote:

This is good info Joe. According to our sys admin the huge number of tables (as you know WP schema isn’t exactly normalized) starts to cause real issues with MySQL  backups. I’ll ask him to delve a bit deeper into what those issues are.

David

From: wp-edu [mailto:wp-edu-bounces at lists.automattic.com] On Behalf Of Joseph Ugoretz
Sent: Wednesday, June 24, 2015 8:10 PM
To: Low-traffic list discussing WordPress in education.
Subject: Re: [wp-edu] Process for pruning/retiring inactive sites?

We've found that students will sometimes return to a site and pick it up again even after several years of inactivity. We want to make sure never to preclude that possibility, so we don't prune old or inactive sites at all.

I don't think I could trust any automated system, and I certainly don't want that manual drudgery. And I don't want a student to ever find that her work, no matter how preliminary and initial, has disappeared--or even give her the impression that she needs to tidy it up or make it disappear.

Is it really that big a drag on the system to have some inactive sites? (We are up to over 4,000 sites now, and probably only 50-60% are "active"--depending on your definition). Enough to justify the time consuming drudgery? Why not just let them remain?

Joe

--
Joseph Ugoretz, PhD
Associate Dean
Teaching, Learning and Technology
Macaulay Honors College, CUNY
35 West 67th St.<x-apple-data-detectors://2/1>
New York, New York 10023<x-apple-data-detectors://2/1>
212-729-2920<tel://212-729-2920>

On Jun 24, 2015, at 7:29 PM, Grogan, David <David.Grogan at tufts.edu<mailto:David.Grogan at tufts.edu>> wrote:
Hello all,

What process do you have in place to clean up your WP instance of old and inactive sites? Every summer we look at this and go through a process of manual identification (e.g. sites not updated in past 6 months) and go about trying to contact site admins for permission to delete. It’s time consuming  and drudgery.

Thanks,

David

--------------------------------------------------------------
David Grogan
Senior Solutions Specialist
Educational Technology Services (ETS) Tufts Technology Services (TTS) Tufts University
108 Bromfield Rd
Somerville, MA  02144

Phone: 617.627.2859
Fax: 617.627.3082
http://it.tufts.edu/ests

_______________________________________________
wp-edu mailing list
wp-edu at lists.automattic.com<mailto:wp-edu at lists.automattic.com>
http://lists.automattic.com/mailman/listinfo/wp-edu
_______________________________________________
wp-edu mailing list
wp-edu at lists.automattic.com<mailto:wp-edu at lists.automattic.com>
http://lists.automattic.com/mailman/listinfo/wp-edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.automattic.com/pipermail/wp-edu/attachments/20150625/7be27f8a/attachment-0001.html>