[SAC] Any objections to migrating qgis.org from xblade14 to osgeo2?

Folks,

qgis.org does not seem to be working the way the qgis community wants with
the front page static, and caching off. When fully dynamic it seems to
be putting an unsustainable load on xblade14.

So Werner Macho and I are examining moving it to osgeo2, with the
understanding that it would need to move again with the migration to
osl in a few months.

Are there any objections to my giving Werner and possibly one or two other
people admin access on osgeo2 and having them set up there?

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent

Just a reminder to watch the disk space on osgeo2 - I filled it the
other day just by copying one of our wiki instances. I rolled that
back, and found a few other things to clean up, but thought I'd mention
it in case QGIS requirements exceeded it.

Tyler

On 18/01/10 8:20 AM, Frank Warmerdam wrote:

Folks,

qgis.org does not seem to be working the way the qgis community wants
with
the front page static, and caching off. When fully dynamic it seems to
be putting an unsustainable load on xblade14.

So Werner Macho and I are examining moving it to osgeo2, with the
understanding that it would need to move again with the migration to
osl in a few months.

Are there any objections to my giving Werner and possibly one or two
other
people admin access on osgeo2 and having them set up there?

Best regards,

Tyler Mitchell (OSGeo) wrote:

Just a reminder to watch the disk space on osgeo2 - I filled it the
other day just by copying one of our wiki instances. I rolled that
back, and found a few other things to clean up, but thought I'd mention
it in case QGIS requirements exceeded it.

Tyler,

Good point!

I've discovered that the rsync backups of download.osgeo.org were being done
in such a way that old stuff was not being deleted. That meant it had
captured and kept every nightly snapshot of GDAL for instance (23GB!).

I'm fixing that up, which should help.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent

Tyler Mitchell (OSGeo) wrote:

Just a reminder to watch the disk space on osgeo2 - I filled it the
other day just by copying one of our wiki instances. I rolled that
back, and found a few other things to clean up, but thought I'd mention
it in case QGIS requirements exceeded it.

Tyler,

I cleaned up the /home/other_backups/download area and freed roughly 120GB
of space. Whew, junk really accumulates!

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent

Frank,

On Mon, Jan 18, 2010 at 11:20:17AM -0500, Frank Warmerdam wrote:

Are there any objections to my giving Werner and possibly one or two other
people admin access on osgeo2 and having them set up there?

If you're going to add yet another dynamic site onto the MySQL DB on
'osgeo2', I feel tempted to move the entire Wiki off the current MySQL
instance into the PostgreSQL DB, which is already living there anyway.

Cheers,
  Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------

Martin Spott wrote:

Frank,

On Mon, Jan 18, 2010 at 11:20:17AM -0500, Frank Warmerdam wrote:

Are there any objections to my giving Werner and possibly one or two other
people admin access on osgeo2 and having them set up there?

If you're going to add yet another dynamic site onto the MySQL DB on
'osgeo2', I feel tempted to move the entire Wiki off the current MySQL
instance into the PostgreSQL DB, which is already living there anyway.

Martin,

Are you concerned about interference between the two uses of mysql?
I'm assuming that distinct database instances are pretty cleanly
separated.

Or is this a performance/locking issue?

Would you like Werner Macho to hold off for a bit?

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent

Hi Frank,

On Mon, Jan 18, 2010 at 03:23:43PM -0500, Frank Warmerdam wrote:

Martin Spott wrote:

On Mon, Jan 18, 2010 at 11:20:17AM -0500, Frank Warmerdam wrote:

If you're going to add yet another dynamic site onto the MySQL DB on
'osgeo2', I feel tempted to move the entire Wiki off the current MySQL
instance into the PostgreSQL DB, which is already living there anyway.

Are you concerned about interference between the two uses of mysql?

Let me put it this way: I don't consider managing permissons on a MySQL
server as being one of the favourite jobs in IT - and things don't get
better if you're adding more databases to an instance :wink:

BUT, if the QGIS guys are in serious trouble and therefore in need for
a fast solution, I certainly don't want to get into their way.
Nevertheless I'd be in favour of not running more than one primary task
on a MySQL instance and therefore would like to take the next chance
for moving the Wiki over to the PostgreSQL database.

Would you like Werner Macho to hold off for a bit?

No, please have a 'fix' for their trouble first. We just should make
sure to have a dump of the MySQL master database before anyone's going
to make changes. I'm going to pull a dump pretty soon ....

Cheers,
  Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------