<div dir="ltr">I ended up writing a script to quiesce the database (even InnoDB, which isn't reliably done with "FLUSH TABLES WITH READ LOCK" like MyISAM is), and an LVM snapshot which then got wrapped up into a compressed tarball. It worked great - it yielded consistent snapshots and the database was only locked for a handful of seconds at most.<div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jan 27, 2016 at 1:24 PM, Michael McGlynn <span dir="ltr"><<a href="mailto:mcglynn_michael@wheatoncollege.edu" target="_blank">mcglynn_michael@wheatoncollege.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">This caught my eye:<div><br></div><div>"<span style="font-size:12.8px">enough that mysqldump would choke and die horribly if you tried to dump </span><span style="font-size:12.8px">the entire Wordpress database</span>"</div><div><br></div><div>So how, in fact, was the database backed up?</div><div><br></div><div>Thanks,</div><div>Mike</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jan 27, 2016 at 11:40 AM,  <span dir="ltr"><<a href="mailto:wp-edu-request@lists.automattic.com" target="_blank">wp-edu-request@lists.automattic.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send wp-edu mailing list submissions to<br>
        <a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
        <a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
or, via email, send a message with subject or body 'help' to<br>
        <a href="mailto:wp-edu-request@lists.automattic.com" target="_blank">wp-edu-request@lists.automattic.com</a><br>
<br>
You can reach the person managing the list at<br>
        <a href="mailto:wp-edu-owner@lists.automattic.com" target="_blank">wp-edu-owner@lists.automattic.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of wp-edu digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
   1. Re: Who has a large Wordpress network being run by central<br>
      IT? (Ben Bakelaar)<br>
   2. Re: Who has a large Wordpress network being run by central<br>
      IT? (Michael Barnard)<br>
   3. Re: Who has a large Wordpress network being run by central<br>
      IT? (Jim Doran)<br>
   4. Commons in a Box (Grogan, David)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 27 Jan 2016 11:25:57 -0500<br>
From: Ben Bakelaar <<a href="mailto:bakelaar@rutgers.edu" target="_blank">bakelaar@rutgers.edu</a>><br>
To: "Low-traffic list discussing WordPress in education."<br>
        <<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a>><br>
Subject: Re: [wp-edu] Who has a large Wordpress network being run by<br>
        central IT?<br>
Message-ID: <<a href="mailto:e5be4570a5990609070a6fe537cf4eea@mail.gmail.com" target="_blank">e5be4570a5990609070a6fe537cf4eea@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
That?s awesome, thanks!<br>
<br>
<br>
<br>
*From:* wp-edu [mailto:<a href="mailto:wp-edu-bounces@lists.automattic.com" target="_blank">wp-edu-bounces@lists.automattic.com</a>] *On Behalf<br>
Of *Jason<br>
Heffner<br>
*Sent:* Wednesday, January 27, 2016 11:16 AM<br>
*To:* Low-traffic list discussing WordPress in education.<br>
*Subject:* Re: [wp-edu] Who has a large Wordpress network being run by<br>
central IT?<br>
<br>
<br>
<br>
Hi Ben,<br>
<br>
<br>
<br>
There is an unofficial list that someone started over at<br>
<br>
<br>
<br>
<a href="https://docs.google.com/spreadsheets/d/1LZmAqDjhkn-9GfkgiwK2lbQvuuMsCmmc6zNaZNVm_kI/edit#gid=0" rel="noreferrer" target="_blank">https://docs.google.com/spreadsheets/d/1LZmAqDjhkn-9GfkgiwK2lbQvuuMsCmmc6zNaZNVm_kI/edit#gid=0</a><br>
<br>
<br>
<br>
that might help<br>
<br>
<br>
<br>
p: <a href="tel:%28814%29%20865-1840" value="+18148651840" target="_blank">(814) 865-1840</a>, c: <a href="tel:%28814%29%20777-7665" value="+18147777665" target="_blank">(814) 777-7665</a><br>
Systems Administrator<br>
Teaching and Learning with Technology, Information Technology Services<br>
The Pennsylvania State University<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
On Jan 27, 2016, at 10:44 AM, Ben Bakelaar <<a href="mailto:bakelaar@rutgers.edu" target="_blank">bakelaar@rutgers.edu</a>> wrote:<br>
<br>
<br>
<br>
I guess this is an informal survey. Feel free to respond to me off-list.<br>
Looking to build up a list of examples of university names running<br>
Wordpress-as-a-service for their constituents. If you have total number of<br>
sites, that would be cool too. Also if you are running the service<br>
internally or through a hosting company like Campuspress or WPEngine.<br>
<br>
<br>
<br>
<br>
<br>
---------------------------------<br>
BEN BAKELAAR | IT Services<br>
School of Communication and Information<br>
<br>
Rutgers, The State University of New Jersey<br>
p <a href="tel:848.932.8710" value="+18489328710" target="_blank">848.932.8710</a><br>
<br>
<br>
<br>
_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/7e76deb7/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/7e76deb7/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 27 Jan 2016 11:36:01 -0500<br>
From: Michael Barnard <<a href="mailto:mbarnard@mtholyoke.edu" target="_blank">mbarnard@mtholyoke.edu</a>><br>
To: "Low-traffic list discussing WordPress in education."<br>
        <<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a>><br>
Subject: Re: [wp-edu] Who has a large Wordpress network being run by<br>
        central IT?<br>
Message-ID:<br>
        <CAD7ia+51+L2=<a href="mailto:bRaXhRt%2Bj2kLnG9G6f-QiTJdii_jZo9U107YUg@mail.gmail.com" target="_blank">bRaXhRt+j2kLnG9G6f-QiTJdii_jZo9U107YUg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
We're running two Wordpress instances here at Mount Holyoke, both<br>
internally hosted: <a href="http://folio.mtholyoke.edu" rel="noreferrer" target="_blank">folio.mtholyoke.edu</a> (e-portfolios) and<br>
<a href="http://commons.mtholyoke.edu" rel="noreferrer" target="_blank">commons.mtholyoke.edu</a> (student blogs/sites). I don't have numbers off the<br>
top of my head, but we launched Commons last year and I seem to remember<br>
it's got a couple hundred or so blogs/sites on it so far, which is fairly<br>
substantial given that we only have a couple thousand students. Both<br>
services are growing steadily.<br>
<br>
I used to work at UMass Amherst and I know they have an internally-hosted<br>
Wordpress instance at <a href="http://blogs.umass.edu" rel="noreferrer" target="_blank">blogs.umass.edu</a>. This has a few thousand blogs on it<br>
(enough that mysqldump would choke and die horribly if you tried to dump<br>
the entire Wordpress database). Much of what's there was just built by<br>
students for various classes and immediately abandoned, but they do prune<br>
old content after the blog owners leave UMass, so it's not all a gigantic<br>
mass of abandoned content.<br>
<br>
<br>
On Wed, Jan 27, 2016 at 10:44 AM, Ben Bakelaar <<a href="mailto:bakelaar@rutgers.edu" target="_blank">bakelaar@rutgers.edu</a>> wrote:<br>
<br>
> I guess this is an informal survey. Feel free to respond to me off-list.<br>
> Looking to build up a list of examples of university names running<br>
> Wordpress-as-a-service for their constituents. If you have total number of<br>
> sites, that would be cool too. Also if you are running the service<br>
> internally or through a hosting company like Campuspress or WPEngine.<br>
><br>
><br>
><br>
><br>
><br>
> ---------------------------------<br>
> BEN BAKELAAR | IT Services<br>
> School of Communication and Information<br>
><br>
> Rutgers, The State University of New Jersey<br>
> p <a href="tel:848.932.8710" value="+18489328710" target="_blank">848.932.8710</a><br>
><br>
><br>
><br>
> _______________________________________________<br>
> wp-edu mailing list<br>
> <a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
> <a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/beb6f81d/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/beb6f81d/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Wed, 27 Jan 2016 11:39:35 -0500<br>
From: Jim Doran <<a href="mailto:jim.doran@gmail.com" target="_blank">jim.doran@gmail.com</a>><br>
To: "Low-traffic list discussing WordPress in education."<br>
        <<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a>><br>
Subject: Re: [wp-edu] Who has a large Wordpress network being run by<br>
        central IT?<br>
Message-ID:<br>
        <CAJQf7NRXEnqXq8cRqcvyNuxkjcPFkKqnVUysiNLDj=<a href="mailto:UNXNzicA@mail.gmail.com" target="_blank">UNXNzicA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
University of Maryland, Baltimore County (UMBC): <a href="http://sites.umbc.edu/" rel="noreferrer" target="_blank">http://sites.umbc.edu/</a><br>
<br>
On Wed, Jan 27, 2016 at 11:36 AM, Michael Barnard <<a href="mailto:mbarnard@mtholyoke.edu" target="_blank">mbarnard@mtholyoke.edu</a>><br>
wrote:<br>
<br>
> We're running two Wordpress instances here at Mount Holyoke, both<br>
> internally hosted: <a href="http://folio.mtholyoke.edu" rel="noreferrer" target="_blank">folio.mtholyoke.edu</a> (e-portfolios) and<br>
> <a href="http://commons.mtholyoke.edu" rel="noreferrer" target="_blank">commons.mtholyoke.edu</a> (student blogs/sites). I don't have numbers off the<br>
> top of my head, but we launched Commons last year and I seem to remember<br>
> it's got a couple hundred or so blogs/sites on it so far, which is fairly<br>
> substantial given that we only have a couple thousand students. Both<br>
> services are growing steadily.<br>
><br>
> I used to work at UMass Amherst and I know they have an internally-hosted<br>
> Wordpress instance at <a href="http://blogs.umass.edu" rel="noreferrer" target="_blank">blogs.umass.edu</a>. This has a few thousand blogs on<br>
> it (enough that mysqldump would choke and die horribly if you tried to dump<br>
> the entire Wordpress database). Much of what's there was just built by<br>
> students for various classes and immediately abandoned, but they do prune<br>
> old content after the blog owners leave UMass, so it's not all a gigantic<br>
> mass of abandoned content.<br>
><br>
><br>
> On Wed, Jan 27, 2016 at 10:44 AM, Ben Bakelaar <<a href="mailto:bakelaar@rutgers.edu" target="_blank">bakelaar@rutgers.edu</a>><br>
> wrote:<br>
><br>
>> I guess this is an informal survey. Feel free to respond to me off-list.<br>
>> Looking to build up a list of examples of university names running<br>
>> Wordpress-as-a-service for their constituents. If you have total number of<br>
>> sites, that would be cool too. Also if you are running the service<br>
>> internally or through a hosting company like Campuspress or WPEngine.<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> ---------------------------------<br>
>> BEN BAKELAAR | IT Services<br>
>> School of Communication and Information<br>
>><br>
>> Rutgers, The State University of New Jersey<br>
>> p <a href="tel:848.932.8710" value="+18489328710" target="_blank">848.932.8710</a><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> wp-edu mailing list<br>
>> <a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
>> <a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
>><br>
>><br>
><br>
> _______________________________________________<br>
> wp-edu mailing list<br>
> <a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
> <a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/902b5b9a/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/902b5b9a/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 27 Jan 2016 16:40:07 +0000<br>
From: "Grogan, David" <<a href="mailto:David.Grogan@tufts.edu" target="_blank">David.Grogan@tufts.edu</a>><br>
To: Low-traffic list discussing WordPress in education.<br>
        <<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a>><br>
Subject: [wp-edu] Commons in a Box<br>
Message-ID:<br>
        <<a href="mailto:85F05EE0D1E7E1499CCFFE9E3DFDF43C3F0C8CB2@SSVMEXDAG01MB03.tufts.ad.tufts.edu" target="_blank">85F05EE0D1E7E1499CCFFE9E3DFDF43C3F0C8CB2@SSVMEXDAG01MB03.tufts.ad.tufts.edu</a>><br>
<br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Hello folks,<br>
<br>
We are looking into standing up the WP based Commons in a Box (<a href="http://commonsinabox.org/" rel="noreferrer" target="_blank">http://commonsinabox.org/</a>) from CUNY.<br>
<br>
Has anyone else on this list done this? I'm particularly interested in how people built critical mass in terms of faculty use. How did you get faculty engaged with the site and then maintain their interest in using it?<br>
<br>
Thanks,<br>
<br>
David<br>
<br>
--------------------------------------------------------------<br>
David Grogan<br>
Senior Solutions Specialist<br>
Educational Technology Services (ETS) Tufts Technology Services (TTS) Tufts University<br>
108 Bromfield Rd<br>
Somerville, MA  02144<br>
<br>
Phone: <a href="tel:617.627.2859" value="+16176272859" target="_blank">617.627.2859</a><br>
<a href="http://sites.tufts.edu/davidgrogan" rel="noreferrer" target="_blank">http://sites.tufts.edu/davidgrogan</a><br>
<a href="http://it.tufts.edu/ets" rel="noreferrer" target="_blank">http://it.tufts.edu/ets</a><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/6ba2072c/attachment.html" rel="noreferrer" target="_blank">http://lists.automattic.com/pipermail/wp-edu/attachments/20160127/6ba2072c/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
<br>
<br>
------------------------------<br>
<br>
End of wp-edu Digest, Vol 72, Issue 3<br>
*************************************<br>
</blockquote></div><br></div>
<br>_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
<br></blockquote></div><br></div>