[mirror-admin] rsync ACLs for tier1s

[Matt Domsch]

On Mon, Apr 14, 2008 at 08:31:00AM -0400, Brian Long wrote:
> 
> On Sun, 2008-04-13 at 07:29 -0500, Matt Domsch wrote:
> > On Sun, Apr 13, 2008 at 09:52:34AM +0300, Axel Thimm wrote:
> > > On Sat, Apr 12, 2008 at 04:00:30PM -0500, Matt Domsch wrote:
> > > > > https://admin.fedoraproject.org/mirrormanager/rsync_acl
> >
> > I submitted a proposed patch to fedora-infrastructure-list last night
> > to update the rsync_acl query, so you can get back the list of all
> > mirrors, only those on internet2 (or peers), only those that are
> > public, or a combination thereof.  We're in freeze, but it'll help
> > reduce the query load on the database (1 query instead of several
> > hundred for each person hitting that URL) so I want to see it in.
> 
> Matt,
> 
> I also visited this URL to see if my private mirror was in the list (it
> isn't) and it took almost one minute for the page to draw.  Would it
> make sense to cache this page (and the parametrized results) every 15-30
> minutes instead of using a live DB query each time?

I've got a patch awaiting f-i review and ack that will reduce this to
~1s.  I hope to have that deployed today.  If performance is still a
problem I can look to cache it in the mirrorlist CGI like I cache all
the other data, which is updated hourly.

-- 
Matt Domsch
Linux Technology Strategist, Dell Office of the CTO
linux.dell.com & www.dell.com/linux

--