<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body dir="auto">
<div>D'Arcy, what numbers are you at now? We aren't seeing performance problems yet at 4,000 sites but I expect to go to hyperdb soon. </div>
<div><br>
</div>
<div>I think my colleague Luke at Baruch College (10,000 or so sites) is using SharDB. <br>
<br>
<div><span style="background-color: rgba(255, 255, 255, 0);">-- <br>
Joseph Ugoretz, PhD</span></div>
<span style="background-color: rgba(255, 255, 255, 0);">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
<a href="x-apple-data-detectors://2/1" x-apple-data-detectors="true" x-apple-data-detectors-type="address" x-apple-data-detectors-result="2/1">35 West 67th St.</a><br>
<a href="x-apple-data-detectors://2/1" x-apple-data-detectors="true" x-apple-data-detectors-type="address" x-apple-data-detectors-result="2/1">New York, New York 10023</a><br>
<a href="tel://212-729-2920">212-729-2920</a></span></div>
<div><br>
On Mar 13, 2015, at 9:26 AM, D'Arcy L Norman <<a href="mailto:dlnorman@ucalgary.ca">dlnorman@ucalgary.ca</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div><style type="text/css"></style>
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">The biggest tweak you can do is add database scaling, so you don't hit the max-tables limit in a single database. HyperDB or MultiDB would do that - I use MultiDB on
<a href="http://UCalgaryBlogs.ca">UCalgaryBlogs.ca</a> and it works great. Spreads the tables across several databases (16, 256 or 4096), which can hold up to "millions" of blog sites. Haven't had enough to test that claim, though. The 16 database config scales
to 50,000 blogs. That should hold us for a few years.
<div><br>
</div>
<div>Multi-DB: <a href="https://premium.wpmudev.org/project/multi-db/" target="_blank">https://premium.wpmudev.org/project/multi-db/</a></div>
<div><br>
</div>
<div>HyperDB: <a href="https://wordpress.org/plugins/hyperdb/" target="_blank">https://wordpress.org/plugins/hyperdb/</a></div>
<div><br>
</div>
<div>I started with MultiDB, back before HyperDB was a thing. If I was starting fresh, I'd go with HyperDB because it's free, maintained by Automattic, and basically what's used on
<a href="http://WordPress.com">WordPress.com</a>. MultiDB woks find, but requires a subscription fee. I haven't had the energy to migrate UCalgaryBlogs to it, because it works.</div>
<div><br>
</div>
<div>- D</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF691229" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> wp-edu [<a href="mailto:wp-edu-bounces@lists.automattic.com">wp-edu-bounces@lists.automattic.com</a>] on behalf of Joseph Ugoretz [<a href="mailto:joseph.ugoretz@mhc.cuny.edu">joseph.ugoretz@mhc.cuny.edu</a>]<br>
<b>Sent:</b> March 13, 2015 06:48 AM<br>
<b>To:</b> Low-traffic list discussing WordPress in education.<br>
<b>Subject:</b> Re: [wp-edu] How do you manage a site with 100+ sub sites with WordPress?<br>
</font><br>
</div>
<div></div>
<div>
<div>These are class sites and student eportfolios, so we do not ever retire or purge sites. </div>
<div><br>
</div>
<div>Students do return to old sites and take them up again even if they have been inactive for a long time, even years. </div>
<div><br>
</div>
<div>Part of our policy and what we guarantee to students is that these sites will remain available until and unless the students themselves delete them (except in the case of serious violations of our community guidelines...has not happened yet). </div>
<div><br>
</div>
<div>Joe<br>
<div><span style="">-- <br>
Joseph Ugoretz, PhD</span></div>
<span style="">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
<a href="UrlBlockedError.aspx" target="_blank">35 West 67th St.</a><br>
<a href="UrlBlockedError.aspx" target="_blank">New York, New York 10023</a><br>
<a href="tel://212-729-2920" target="_blank">212-729-2920</a></span></div>
<div><br>
On Mar 13, 2015, at 1:47 AM, Hugh Paterson III <<a href="mailto:hugh@thejourneyler.org" target="_blank">hugh@thejourneyler.org</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>What sort of site retirement policy do you maintain? How do admin know when to purge a site from a set of 4,000?
<div><br>
</div>
<div>- Hugh Paterson III<br>
<div><br>
</div>
<div><br>
</div>
<div><br>
<div>
<div>On Mar 12, 2015, at 4:37 PM, Joseph Ugoretz <<a href="mailto:joseph.ugoretz@mhc.cuny.edu" target="_blank">joseph.ugoretz@mhc.cuny.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div dir="auto" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px">
<div>WordPress multisite works very well for this. We currently have, on our big multisite install, over 4,000 sites, with many different themes. We aren't currently using domain mapping but may soon. </div>
<div><br>
</div>
<div>My CUNY colleagues at Baruch College have a similar set up with far more sites. <br>
<br>
<div><span style="">-- <br>
Joseph Ugoretz, PhD</span></div>
<span style="">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
<a href="UrlBlockedError.aspx" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">35 West 67th St.</a><br>
<a href="UrlBlockedError.aspx" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">New York, New York 10023</a><br>
<a href="tel://212-729-2920" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">212-729-2920</a></span></div>
<div><br>
On Mar 12, 2015, at 7:26 PM, Mcmillan, Scott <<a href="mailto:scott.mcmillan@ubc.ca" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">scott.mcmillan@ubc.ca</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div style="direction:ltr; font-family:Tahoma; font-size:10pt">Hi Ryan,
<div><br>
</div>
<div>On the UBC CMS we have just over 900 domain mapped sites.</div>
<div>We run one Network within multi site and <span style="font-size:10pt">have one central theme and allow users to map their domains using the Domain Mapping Plugin. </span></div>
<div><span style="font-size:10pt"><br>
</span></div>
<div>It's worked well for users so far. </div>
<div><br>
</div>
<div><span style="font-size:10pt">-Scott</span></div>
<div>
<div style="font-family:'Times New Roman'; font-size:16px">
<hr tabindex="-1">
<div id="divRpF656001" style="direction:ltr"><font face="Tahoma" size="2"><b>From:</b><span class="Apple-converted-space"> </span>wp-edu [<a href="mailto:wp-edu-bounces@lists.automattic.com" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">wp-edu-bounces@lists.automattic.com</a>]
on behalf of Ryan Kite [<a href="mailto:rkite@yvcc.edu" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">rkite@yvcc.edu</a>]<br>
<b>Sent:</b><span class="Apple-converted-space"> </span>Thursday, March 12, 2015 3:46 PM<br>
<b>To:</b><span class="Apple-converted-space"> </span><a href="mailto:wp-edu@lists.automattic.com" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">wp-edu@lists.automattic.com</a><br>
<b>Subject:</b><span class="Apple-converted-space"> </span>[wp-edu] How do you manage a site with 100+ sub sites with WordPress?<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
We are looking at going with WordPress with at our college, currently have about 100+ sub sites under one master, each with unique navigation and content.</div>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<div style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
How do you manage this in WordPress?</div>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p class="MsoNormal" style="margin:0in 0in 12pt; font-size:11pt; font-family:Calibri,sans-serif; background-color:white">
<b><span style="font-size:10pt; font-family:'Segoe UI',sans-serif">Ryan Kite<br>
</span></b><span style="font-size:10pt; font-family:'Segoe UI',sans-serif">Web Designer<br>
509.574.4788 |<span class="Apple-converted-space"> </span><a href="mailto:rkite@yvcc.edu" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">rkite@yvcc.edu</a><br>
Yakima Valley Community College<br>
<span style=""><a href="http://www.linkedin.com/in/ryankite/" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">http://www.linkedin.com/in/ryankite/</a></span></span></p>
<p class="MsoNormal" style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite"><span>_______________________________________________</span><br>
<span>wp-edu mailing list</span><br>
<span><a href="mailto:wp-edu@lists.automattic.com" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">wp-edu@lists.automattic.com</a></span><br>
<span><a href="http://lists.automattic.com/mailman/listinfo/wp-edu" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a></span><br>
</blockquote>
_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" style="color:rgb(149,79,114); text-decoration:underline" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>wp-edu mailing list</span><br>
<span><a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a></span><br>
<span><a href="http://lists.automattic.com/mailman/listinfo/wp-edu" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a></span><br>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>wp-edu mailing list</span><br>
<span><a href="mailto:wp-edu@lists.automattic.com">wp-edu@lists.automattic.com</a></span><br>
<span><a href="http://lists.automattic.com/mailman/listinfo/wp-edu">http://lists.automattic.com/mailman/listinfo/wp-edu</a></span><br>
</div>
</blockquote>
</body>
</html>