You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by "Dennis E. Hamilton" <de...@acm.org> on 2011/09/07 04:56:10 UTC

[wiki] Migration - A TerryE Clipping Collection [LONG]

I compiled a LONG chronological clipping set of notes from Terry on from conception to when he stopped posting on the issues and thinking around Wiki migration.  

I'm breaking a thread here. There is no need to comment on any of this, it is for reference and mining for things to not overlook, collate onto the wiki, etc. 

The selections are mine, the list is long, and it probably works better distilled onto a wiki.  This is the collection phase.

I am staying as close to the architectural and technical considerations that I can, and not follow into areas where there were policy spats of one kind or another.  I thought I might have to look at others posts too, but generally, I could find enough in what Terry was responding to to provide continuity.

It is interesting that we are now re-hashing some of the things that Terry covered at least one starting over a month ago.

NOTE: Terry also provided OOOUSER Material

*** 2011-07-31-13:53 All times PDT (UTC-0700), TerryE - Wiki Size

The OOo wiki contains 10,521 content pages and  
11.338 uploaded files.  These form a critical service to the end-user 
community.  Note that the cwiki markup format doesn't support many of 
the MediaWiki specific markups in this content.

*** 2011-07-31-14:36 TerryE - Concerns for Conversion to CWiki

[T]he challenge here is that the cwiki markup 
grammer is different to that of mediawiki and largely a functional 
subset.  Worse, mediawiki supports extensions to allow you to extend 
this. The OOo implementation currently uses *42* such extensions.  One 
of these was custom-developed by the German OOo team.  With over 10,000 
pages of content, sentencing this lot and even if we establish a 
migration ruleset to map 90% of the non-conformities, we still looking 
at a MAJOR project.

*** 2011-07-31-15:07 Terry Ellison - Formulating the Hardware/Software Stack

Both the OOo forums and the OOo wiki can run on a standard LAMP stack.  
[ ... ]

The wiki is a bit more of a hog and need 4-cores, but it currently 
doesn't use a PHP opcode cache and this would halve this load.  Most of 
the access is guest, so using a squid or varnish front-end will drop 
this significantly.

The simplest way to provide this service would be to use VMs and AFAIK 
this is a model that the a.o infrastructure guys understand.

*** 2011-07-31-16:02 TerryE - Migrating the Wiki, Concerns not to Overlook

As far as the wiki goes, this template has been more heavily customised 
again using standard MediaWiki hooks and facilities.  Switching logos 
and banners would be reasonably straight forward, but alas the guys that 
did the bulk of the content management are history.

> (3) Legal - IP, Copyright and Licensing
> We will need to make sure that we have clear documentation of the copyright and license for the content on the wiki and user forums. We'll need to make sure that the Migration does not infringe on anyone's copyright and/or inadvertently change any licenses. If we are clear about what we are planning for these sites on an openoffice.org domain then it *might* be possible to take everything.

The forum content was all under the Sun then Oracle terms which roughly 
mirror CCA but with OOo retaining full rights to use.  All bar a few 
dozen of the wiki pages likewise.  

*** 2011-08-01-07:42 Terry Ellison - Server Capacity Considerations, Confirming Operation

> [C]an you give me some Ubuntu VM specs so I can create them for the Forums
> and the Wiki -- we can then get them setup and working as a test and ready for a final dump/load
> when we switch over, in the meantime we can check the loads of the VM hosts etc to be sure
> all will be ok.
>
> Just amount of RAM and disk  space required should be all I need - and 1 or 2 cpu , then I'll get an
> Ubuntu VM up for each. We try and stick to LTS releases so will get it to 10.04.3 LTS version unless
> you have a reason we should use a later Ubuntu release.

I track Ubuntu current for my laptop and home server, and use Ubuntu LTS 
by preference for my LAMP VMs.  I use a 2 disk split with a common 
immutable system image and an app-specific /var (with callback hooks in 
the startup so the app can tailor the system).  I've just rebaseline my 
VMs from 10.04-1 LTS to 10.03-1 LTS.  If you guys have already developed 
an Ubuntu VM template then I can always pick up that. If not then I'll 
write up my template and make sure the licensing of my IPR / content is 
OK, so you have the option to reuse it.

I would prefer to stick with Ubuntu VMs for now because I like to keep 
local mirrors of any prod system for release development/rehearsal and 
hunting down live problems.  I currently use VirtualBox, but I can 
reinstall VMserver on my local server so that I can switch my VMs from 
VBox Guest Utils to VMware Tools.  (I like to exactly mirror any prod 
systems locally.)

Installing and getting to grips with the bowels of FreeBSD server is 
just another learning curve that I would like to avoid at the moment.  
I've already got a learning curve on compliance with your own 
infrastructure standards on Identification & Access Control, Backup, 
Logging, Intrusion Detection, Status Report, ....


*** 2011-08-01-09:53 TerryE - More on Confluence Migration

*I* have looked at [migration to Confluence] 
and it *will* be hard. I didn't say impossible.  
 ... Just look at

*  http://wiki.services.openoffice.org/wiki/Special:Statistics
*  http://wiki.services.openoffice.org/wiki/Special:Version

for the volumetrics and MediaWiki extensions used.  If you google 
"mediawiki confluence migration" then you will see that isn't a trivial 
exercise even for wiki using standard MW with no extensions: it would 
involve person-years of effort.  I have suggested ... rehosting but on a 
sustain basis for the wiki.  I can set all of this up, if agreeable to 
the project.  It doesn't need further material resources from the Apache 
team.  This would at least buy us the time to do a proper migration plan 
and resource it.

*** 2011-08-01-20:03 TerryE - Working to Have Confirmable Configurations, Trial Operation

> I'd like to get going so am going to create 2 x VMs of 50GB space and 2GB RAM each, both
> with Ubuntu 10.04.3. One for the mediawiki and one for the forums.

The wiki might struggle 
without tuning, since the current config isn't and the MediaWiki engine 
is a D/B hog unless you stick a cache such as Squid or Varnish in front 
of it. ...

I'll want to mirror 
them exactly for my dev, so can you mail me the dpkg -l listing together 
with the etc tarball and details of any not debian installs.

I'll shout if there's anything missing.  We'll need a PHP accelerator -- 
Xcache or APC, and php5-cli.

*** 2011-08-03-08:07 Terry Ellison - Reaching the Wiki Users, Legal Concerns
> [...] Is there a announcement list or some other mechanism
> to send an email to every registered wiki user?

At a technical level, it's simple to run a query dumping all of the mail 
addresses of contributors to the wiki.  I've just done a few on my local 
VM which has a snapshot of  the prod wiki as at Thursday/Fri night IIRC.

    * There are 34,969 registered users.  Of which
    * 3,675 have made contributions.  There is no need to contact those
      who haven't
    * 3,623 have registered email addresses and have made 182,677
      contributions
    * 52 have no registered email addresses and have made 153
      contributions (prob dating back to the early days when email
      registration and confirmation wasn't mandatory

It is trivial to dump this list of user / email addr / post count.

However giving this to Apache and the project making use of it is a more 
complex issue.  The server is current located in Oracle's Hamburg 
facility under German / EU legislation.  We have data protection 
legislation and Anti-Spam guidelines / legislation to bear in mind 
here.  Moving email addresses across national and organisational 
boundary might trigger these.  Also one can't send out mailshot emails 
in the EU unless the recipients have first agreed in principle to accept 
these.

What I can do is to provide this data to Andrew via the internal Oracle 
email, and let him figure out the legal / compliance issues and terms of 
use before him making it available to the project.  ...

*** 2011-08-04-01:36 Terry Ellison - Moving the WIki "As-Is" for Now

I am working with the rest of the project to 
migrate the forums and the wiki "as-is" for now.

.  As far as the wiki goes in the medium to longer term, the project may 
decide to move some material to cwiki, but this is work in progress.

*** 2011-08-04-02:05 Terry E - Registering and Authorizing Users and Their Edits

> 1) People must ask for an account; they can't self-subscribe. Nothing is
> required except a few words about who you are and why you want an
> account. Any one of several people authorised to approve or reject these
> requests can deal with them expeditiously. Very few spammers, in my
> experience, take the trouble to actually request accounts.
We need to implement this in a way which sits within MediaWiki 
functionality and complies with the goals.

One way would be

    * to allow the normal self-registration and optional email address
      with email verification
    * and have a new wiki role, say "contributor" (or is this
      contributer in US-speak?).
    * guest have no write access
    * registered users can write to User and User_talk namespaces but to
      no others
    * registered users can request to become a Contributor, but the must
      have completed their User page, verified their email address and
      confirmed that all future edits to the Main or Talk namespaces are
      made under licence (CCA AL2 or whatever we decide.
    * the granting of Contributor is done by the bureaucrats.
    * The Main and Talk pages contain "reference" content.
    * There is a standard disclaimer that user/user talk is user content
      is user content
    * We would still need main and user namespace guidelines TOUs.

This might seem a little convolved, but this can be configured with std 
MW/extension functionality.

> 2) Alternatively, or in addition, the first X edits/ contributions/
> whatever are moderated by a group of people, any one of whom can approve
> or reject the items. After X acceptable contributions, the person is
> then allowed to edit the wiki without further supervision [ ... ]
We could add another committer layer so that contributer (but not 
committer) edits are moderated

However, I suspect that a trust-but-verify attitude is easier for 
everyone.  When we catch contributers deliberately abusing the rules, 
then we can always back out their changes and remove contributer 
status.  This is similar to our forum model and works well there.

*** 2011-08-04-04:30 TerryE - Wiki Extension to Require Review-then-Commit

> You probably know more about this than I do, but my understanding is that the current OOo wiki has an extension installed that does what I was suggesting in option 2, but the extension has not been implemented.  See:
> http://www.mediawiki.org/wiki/Extension:FlaggedRevs and specifically:
> http://www.mediawiki.org/wiki/Extension:FlaggedRevs#Automatic_user_promotion
>
Yes, you are correct.  This extension can do this and more, but with 
a grey issue like this I feel that a DL based dialogue isn't the best 
way to work out what to do here.  Better we work up a position 
paper/page within the OOOUSERS cwiki laying down the options, their pros 
and cons and then agree a consensus or vote either on the paper itself.  
Use the DL to note the consensus and get wider feedback.

What concerns me is the moderation load involved with such an active 
intervention of review-before-publish.  Perhaps others with moderator 
experience might care to comment?

My worry is that review-before-publish also ignores the reality of how 
people edit wikis.  In general they don't prepare and proof draft 
offline then paste their best and final into the article.  Most do it 
section by section or end up correcting / rewording when they see the 
final version, so one logical edit can comprise half a dozen posts.  I 
am not sure how this would work if you've got to wait for approval 
before the next edit.

*** 2011-08-05-15:18 Terry Ellison - Migration Systems Setting Up

> Gav, the Admin from the ASF has setup the VM for the MediaWiki. It's a 
> Ubuntu 10.4.3 LTS VM. At the Moment Gav and I has admin access to this 
> machine. First we have to install all the needed software, Then we 
> will make a test migration with a older Dump, then we can make 
> testings and finaly the final migration.
>
> Greetings Raphael

Raphael, great news.   I've my dev shadow VM up as well, and just logged 
onto minotaur for the first time with my new apache ID.  I'll ping the 
config detail over to you and Gavin and take it from there.  Regards Terry


*** 2011-08-07-10:49 TerryE - Questions About the Wiki and Customizing Pages

> It should be possible to alter the login page to show any important 
> information we want to share about the migrated site, correct? With 
> possibly a survey?
>
> Also, what is the purpose of the Bots group?
 The WikiEditor group is the default group for a MediaWiki extension, 
 FlaggedRevisions, which facilitates some of the control functionality 
 that Rob, you and other have been asking for.  If you look at 
 Clayton's status page, this extension isn't yet put to use.  A job for 
 post transition, I think. But that's why Clayton is the only current 
 member.

 Yes, the Main_Page is a restricted page, but anyone can take a copy 
 and work on it in their User page hierarchy.  When we have a consensus 
 that it's OK then I can move it back into main.

 The bots group is for a  function supported by MediaWiki  where it 
 provides an [XMLRPC] to all batch process to  work on the wiki.  In this 
 case Clayton and co used the PyWikipediabot (I think) to carry out 
 bulk transactions. This needs an account with special privileges.

*** 2011-08-07-15:38 Terry Ellison - WORK ITEMS AND ISSUES - FIRST CUT

I've just finished a 1st cut of outstanding tasks and issues for the Wiki.

See 
https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services 


Comments gratefully received on this DL and/or on the page itself.

*** 2011-08-08-02:22 Terry Ellison - Derisking Migration/Staging - Separating Infrastructure/Platform and Content

Thank-you all for your replies so far.  I will work through and respond 
to individual points in thread at the appropriate branch, but here I 
just wanted to propose that we divide the Wiki migration into two 
separate but task areas:

    * Migration of the infrastructure service.  What drives this is if
      Oracle decides, say, that the current hardware is being turned off
      on the XXth of Aug, then we need to move the service to a box in
      Apache.org.  The issues here are largely technical heavily involve
      the infrastructure team.  We need to be able to move quickly on
      this and few of the DL contributors have strong opinions here. 
      They just want the 'magic to happen'.  Yes, there are a few
      decisions to be made, but the questions are a little esoteric for
      most DL members.  I offer to continue to lead this work area.

    * Migration of the wiki content / policy.  Here we have a range of
      widely and strongly held views and the DL seems to be acting as a
      debating shop without convergence to consensus on some points. 
      This debate could still be continuing in 3 months time as far as I
      can see.  I don't want it to get in the way of infrastructure
      migration -- except when /absolutely/ necessary.  It also makes
      sense to break this task area further if this means that we can
      make progress in some areas, even if stalled in others.

but from an infrastructure 
viewpoint I don't really care this branding process can be encapsulated 
and detached.

    * We make the pre-prod wiki available to the "branding team"
    * The branding team agree and implement the branding changes that
      the project wants to have in place for cut-over day.  In practice
      this could involve the creation or modification of content in the
      Main, File, MediaWiki, OpenOffice.org Wiki and Template Namespaces
    * I can use standard MW audit functionality to capture a list of all
      such pages, and then standard MW export functionality to create an
      XML.GZ dump of this work.
    * We then import the "live" wiki as part of cut-over.
    * I then reimport the above XML.GZ to reapply the branding changes
      to the migrated wiki.

... [M]y suggestion is to keep the infrastructure and content issues 
separate.  I can lead on the first.  We need someone who can lead on the 
second. His or her strengths should be that he/she has experience of 
delivery -- that is can make things happen -- and has a good working 
knowledge of more advance MW features such as templates, etc.  I would 
think that either Drew or TJ would be well qualified, but that is only 
my personal suggestion.

*** 2011-08-08-01:41 Terry Ellison - Getting Help on the Content Side

> I can submit an iCLA if it would help (it's on my WIGATI list).

[W]e need someone has sound MediaWiki skills to lead on doing these 
[content]  I've suggest that you are 
qualified.  I don't know if anyone on the DL other than you or I knows 
enough about MW content editing, so could you consider my suggestion?

*** 2011-08-08-02:39 TerryE - More on Content Migration

> I assuming that under the name "branding changes" we include:
>
> 1) OpenOffice.org ->  Apache OpenOffice.org and associated logo changes
>
> 2) Removal of Oracle logos and name
>
> 3) Replacement of privacy policy and disclaimer
>
> 4) Update of page edit license text to require Apache 2.0 for new contributions
Yes, good points, though such content changes are functionally separate 
from the (infrastructure) migration.  I have suggested in a separate 
branch that we set up separate task area with its own leader to work 
these issues.

*** 2011-08-08-03:16 Terry Ellison - Wanting to Walk through It At Home

To be honest I'm not comfortable with any solution unless 
I've used myself, ... This {??] option is simple to 
implement and try in pre-prod, unlike a migration to PostgreSQL which 
will involve quite a bit of work.

(An example of where I am comfortable is with the use of PHP-APC).

What I had hoped to get feedback/from the wider ooo-dev DL/ was on the 
least technical risk, but which also had the business impact, and that 
is to stop the service for ~30 mins a day to do the backup.

Is this acceptable?  Historically, the lowest transaction rates occur at 
~04:00 UTC, so this is when I'd do it if we go this way.

*** 2011-08-08-03:33 Terry Ellison - Risks of Changing DBMS along with Migration

There are two factors against an early move to PostgreSQL:  (i) The 
MediaWiki cavaets on its use (here 
<http://www.mediawiki.org/wiki/Manual:PostgreSQL> and as all experienced 
Wikipedian's do look at the associated talk page here 
<http://www.mediawiki.org/wiki/Manual_talk:PostgreSQL>; this has a 
couple of interesting references which cookbook the conversion).  (ii) 
The extra work involved. This is not only the D/B migration, but also a 
MW version upgrade 15.1 -> 17.

To be honest I am uncomfortable doing this as part of this immediate 
"continuity of service" migration.  My suggestion is that if the wiki 
looks as if it is going to have a long term place within  the project 
then we should revisit this as part of an in-service improvement program 
in, say, 6-12 months.

*** 2011-08-08-04:14 Terry Ellison - Migrating Static Web Projects to Wiki

> I strongly suggest that all the native 
> language projects front-facing pages be migrated to the "new" wiki.
[ ... ]
> This would of course, give them URLS of the form
> somewikiname.openoffice.org/"nl_code"
> rather than "nl_code".openoffice.org
[ ... ]
> Naturally, we should confirm acceptance with them for this.

... I see this as part of the content migration / transformation 
task area.  What I want to go is to get the current content over with 
loss of content, formatting or change history.

... I assume by your refrence to the "new" wiki 
... you mean the ooo-dev cwiki.  As we've discussed before, the current 
migration from MediaWiki to Confluence can be highly lossy unless there 
is per-page content editor intervention: we [lose] all  change history, 
some content formatting (1) and some even content (2).  It therefore 
makes sense, even if we migrate the publicly viewed copy to cwiki, to 
keep a master copy of the old content online in ... this wiki, albeit 
moving the page into an "Archive" namespace which is private and 
read-only to committers.

*** 2011-08-08-05:03 Terry Ellison - Migration Isn't Just Moving a System Dump

> If Oracle decides, say, that the current hardware is being turned off
> on the XXth of Aug, then we need to grab a backup of the content to a 
> box in Apache.org.

It's a big more complicated than just grabbing the content :)  I already 
routine off-site the current forum and wiki system content for dev 
support and [Disaster Recovery], but that's within current working 
practices that date back to Sun days.  It's putting content to new use 
with a.o that requires clearing the hurdles.

*** 2011-08-09-02:16 Terry Ellison - LOOKING AT WORK-ITEM ISSUES FEEDBACK, STEPS BEING TAKEN

[Re 2011-08-07-15:38, https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services]

Thanks to everyone for this constructive feedback.  I hope that I have 
given replies in thread fork where you needed then, but I will up 
integrate them and update the document and move forward to complete task 
6 in the next couple of days.  There are two further points that I would 
like to raise for comment / feedback.

(1) This bulk of this page content relates to technical details and 
issues, rather than content / branding / licensing, etc..  As I 
mentioned in a reply to RobW, I would like to decouple the 
infrastructure aspects from the content-relate aspects as much as 
practical to keep the momentum on the platform move.  I therefore 
propose to move the bulk of the infrastructure content into a 
supplementary page which focuses on this content.

(2) I will be making the snapshot version accessible to the project, 
however:

    * I will be overwriting all passwords (except mine and Drew's) thus
      disabling existing account use.  I will also replace all email
      addresses by dummies to prevent existing users resetting their
      passwords, and user page-watch information to stop bad emails
      being generated.
    * Anyone who one who wishes to work on the wiki will need to create
      a new account and apply to Drew or myself for temporary elevated
      privileges if needed.  Just remember that new content will be
      blown away at cut-over, so individual new users must use the
      standard export functionality prior to cut-over to save it if they
      want to restore it post live-transfer.
    * As step one removes the private data elements that could be viewed
      as falling within the purview of EU data protection legislation,
      this means that we could in principle make a copy of this D/B to
      any committers for data analysis. All they need is MySQL installed
      and 3Gb space the D/B.  The data model is pretty straight forward
      :-) (*)

(*) a quick example here is that the edit profile is a classic near 
log-lin relationship: 33% of edits where made by 10 editors, 73% by 100, 
90% by 315.

*** 2011-08-10 15:12 Terry Ellison TEST/PRE-PRODUCTION WIKI INSTANCE PROGRESS

Just a quick update on progress on the wiki instance.  This is now up in 
preprod mode  on the subdomain ooo-wiki.  This is based on a snapshot 
taken at 4am yesterday morning.  The server needs further tuning, but 
functionally its there.  We do have some outstanding code issues (due to 
a change in the functionality of the PHP routine*call_user_func* between 
Version 5.3 and 5.2 which is not backwards compatible.  I'll sort this 
out tomorrow).

Also note as per my previous email, all existing account have had there 
passwords mangled, so access is guest-mode only at the moment. Feel free 
to have a look, but updates and no service commitments yet.

*** 2011-08-11-01:18 Terry Ellison - Rig for Silent Running (robots.txt)

>> <http://ooo-wiki.apache.org>
>>
> Hmmm... if this is just a temporary URL, I wonder if we should try to
> exclude search engine indexing via robots.txt ?
>
> Otherwise, now that the URL is known, we're going to get spidered but
> then all those links will soon be dead.
> <snip>

Thanks Rob for pointing this out, and for Raphael and Gavin fixing it.  
This was incidentally on my bucket list for today.  I didn't think it 
that urgent as it would take a day or so for Google et al to acquire the 
site, but you correct.  Better sooner.

*** 2011-08-11-01:38 Terry Ellison, BREAKAGE IN SEPARATING WIKI FROM OO.O
> I found one bug:
> On the wiki left side lowest frame where store links for other 
> languages main pages,
> the links points to http://wiki.services.openoffice.org, not to the 
> http://ooo-wiki.apache.org/.

You are correct, and in fact there are a lot of references to 
*.OpenOffice.org in the content.  However, there isn't a production 
instance and there little point in changing these until (1) we agree 
what such "dirty" references are going to be changed to, and (2) we cut 
over for real.  Remember that any changes that we made on this instance 
will be lost when we bring over the live [database].

2011-08-12-04:53 Terry Ellison, OO.O WIKI ERROR LOGS BUMP

As part of my takeover of SysAdmin on wiki.services.openoffice.org, I've 
been reviewing the error logs and noticed that last week there's been 
quite a rise in reported errors by clients trying to enumerate the wiki 
incorrectly.  This may just be a coincidence and nothing to do with our 
work, but if anyone on this DL is trying to suck material down, there 
are right ways to do this.  I also understand the MediaWiki webAPI if 
any of you want to write a bot to do this. ... Please contact me to discuss.

*** 2011-08-23-20:30 Terry Ellison, SPEEDING UP WIKI ACCESS, REDUCING LOAD

I've now finished the upgrade to add the Apache Traffic Server front end 
to the community MediaWiki service at http://ooo-wiki.apache.org/ and 
the service is back online.

We need to do some further tuning of the system cache optimisation, but 
even with the first-cut settings that I prepared on my own test-bed VM, 
the system already looks as if it it is hitting the performance targets 
needed to sustain a full production transaction rate.  It certainly 
feels extremely snappy compared to the existing OOo community wiki or 
the Apache cwiki, and the Google pagespeed benchmarks are significantly 
better than both of these systems. So:

    * We are good to go for production migration of the community wiki.
    * We are the first Apache project adopter of another Apache project,
      Apache Traffic Server (ATS)
    * We have laid the foundation for an ATS template for MediaWiki
      hosting that can be used to promote the use of ATS for the wider
      MediaWiki systems community.

It's been a hard few days work, and still some finishing to do, but my 
thanks to the Infrstructure and ATS guys that have supported me in 
making this happen.

*** 2011-08-25-08:59 Terry Ellison, REQUEST FOR BASELINE AGREEMENTS TO MOVE AHEAD

I can't execute any plan without a baseline requirement and set of 
assumptions, so what this note attempts is to lay down such a set, and 
the decisions that need to be made to go forward.  So PLEASE, I don't 
want any flames about my use of DECISION below.  What I simply mean is 
the if the PPMC as a body accepts these, then I will try my best to move 
this work forward.  Of course you are free to challenge / change any of 
this if that is a PPMC voted decision, but in this case I need to move 
into a different mode; to suspend work and stop the clock until we have 
an PPMC-endorsed baseline to replan on. ...


*    The infrastructure stack is base on a standard Ubuntu server LAMP 
stack as at current LTS (Ubuntu 10.04-3 LTS) which included PHP 5.3.2

*    The prod wiki is v1.15.1 that at an N-3 major release level (that's 
30 months old: two major and 10 minor revisions behind the current 
supported).  This also runs on PHP 5.2.0.

*    We need an reverse-proxy HTTP cache for performance reasons on the 
wiki.  One of the four market leaders in this niche is another Apache 
project: Apache Traffic Server (ATS).  It makes sense to stay "in-house" 
here for both support and referenceability reasons

* *DECISION*: Adopt ATS v3.0.1 as the HTTP cache for the wiki.  (BTW, 
this work has been done and the product is excellent).

The PHP 5.3 introduced extra checking to remove an area of tolerance the 
PHP 5.x<3 allowed.  This was to do with when and how parameters can be 
passed by reference under curtain circumstances.  So moving a code base 
from 5.2 to 5.3 involved a lot of work identifying and eliminating this 
mis-codings.  This was done by the MediaWiki team in MW v1.16.  I had 
planned to move to MW v1.15.5 (the last stable 1.15.x) as our baseline 
and I've done this work integrating it with Apache Traffic Server (ATS) 
and our LAMP stack.  This is stable and performant enough to show that 
we are good.  However, I have only identified and bug-fixed the main 
path 5.2->5.3 coding issues.  During my testing I have subsequently 
discovered others and there are undoubtedly more to find.  I've also 
discussed this with the MW devs on the MW IRC channel.  Given this, the 
consensus in the @infra team (me included) is that we should bite the 
bullet now and move to current MW 1.17.0 even given the extra work.  
There are some performance risks associated with MW 1.17.0 which we need 
to mitigate.  However, given that we've already got a complete 
LAMP+ATS+MV in an ESX hosted VM performing like a dingbat, we really 
only face the 1.15.5 -> 1.17.0 issues in this step.

* *DECISION*: Upgrade the ooo-wiki MediaWiki(MV) + all extensions to MW 
v1.17.0.

* *DECISION*: I have agreed with infrastructure that we will keep 1 core 
on "standby" so we can up the VM to a 2-core VM if we are seeing 
unacceptable performance problems with one-core.

* *DECISION*: We will cut over the wiki and the forums with the content 
as-is and implement branding and access control changes within the a.o 
infrastructure when volunteers come on-stream to resource this.  This is 
the standard "transfer then clean-up" approach adopted when a migration 
is time critical.

*CUT-OVER*

There are two facets to cut-over: content move and DNS-based IP 
reassignment.  Clearly we need to freeze update access to the services 
prior to start of content move and continue update-freeze on the legacy 
service.  Bringing the content across involves a backup, copy restore 
which can be rehearsed and scripted, but in the case of the wiki, this 
will be a few hours even if fully automated.

*    There are many way "to skin the cat" of the migration process.  All 
will involve some service loss, but the complexity of the rehearsal and 
planning come explode as we reduce this outage to a zero.  Complex plans 
can also go wrong so my instinct is to keep it simple: halt the service 
at a pre-notified time, transfer and start new service at  a 
pre-notified time.

* *DECISION*: Halt the wiki service for a notified (24hr) window during 
cutover.  The migration uses fixed IPs, so  DNP IP reassignment is 
co-incident with service stop.

* *GOAL*: Cut over [wiki] within 14 days from today.  Date TBD by PM.  I 
can do the content move.

*     We have some further caching tweaks on the interaction of the 
MediaWiki [application] with the ATS HTTP reverse proxy cache, but these 
are probably nice-to-have than essential.  More to the point these need 
to be done on a system will production load patterns.

* *DECISION*. We will defer such tuning until post go-live.

*** END OF THE WIKI NOTES ***


Re: [wiki] Migration : how to get a MW data dump was: - A TerryE Clipping Collection [LONG]

Posted by Kay Schenk <ka...@gmail.com>.

On 09/08/2011 02:34 PM, Matt Richards wrote:
> Sure, I can set up Confluence on my own hardware. But what about getting the
> MW data dump to work with?

my question also...how is this done???? I'm assuming you need admin 
rights on the current incarnation at:
http://ooo-wiki.apache.org/wiki/Main_Page

And once done, what then? assuming we want to do a port into Confluence.

I don't think it should be necessary to setup individual Confluence 
servers -- can't we just get a dump and then work with the Apache infra 
people.

Again, I understand the arguments for staying with MW...but the question 
still remains -- who will administer it?


>
> On Thu, Sep 8, 2011 at 4:21 PM, Dave Fisher<da...@comcast.net>  wrote:
>
>> If you have a server, then you can always setup your own confluence for
>> free, or buy a personal limited license for $10 for 10 users.
>>
>> Apache CWiki is on a version 3.4 while the current version is 3.5.
>>
>> See http://www.atlassian.com/software/confluence/try.jsp
>>
>> Atlassian has a sandbox as well:
>> http://sandbox.onconfluence.com/display/ds/Plugins+Installed+on+this+Confluence+Site
>>
>> This link might help: http://www.atlassian.com/search/?query=mediawiki
>>
>> HTH,
>> Dave
>>
>> On Sep 8, 2011, at 12:29 PM, Matt Richards wrote:
>>
>>> Yeah, I've kinda ran into a similar problems when I originally
>> volunteered
>>> to help. I don't know how to go about it, without access to various data
>>> dumps and such that it appears only Contributors/PPMC members have access
>>> to.
>>>
>>> On Thu, Sep 8, 2011 at 2:25 PM, Pedro F. Giffuni<giffunip@tutopia.com
>>> wrote:
>>>
>>>> --- On Thu, 9/8/11, Dennis E. Hamilton wrote:
>>>> ...
>>>>> I see you closed INFRA-3917.
>>>>>
>>>>
>>>> I like to clean my own mess, yes.
>>>>
>>>>> Keep in mind that there appear to be others willing to
>>>>> struggle with Confluence migration (CWiki?).
>>>>>
>>>>
>>>> That makes me very happy!
>>>>
>>>> Anyone can reopen the issue: the problem I see is that
>>>> it's basically only infra@ that can do this conversion:
>>>> I have no idea if/how someone else can mirror the original
>>>> information and assuming we can get a dump (which will
>>>> likely be big) after running the conversion it has to
>>>> be uploaded in the CWiki server for review.
>>>>
>>>>> A problem to consider in contingency planning: What it
>>>>> means to lock down the current wiki during conversion.
>>>>> And is the MW kept running for read-only viewing while
>>>>> conversion takes place, either bit by bit or
>>>>> wholesale?   Parallel live operation does not
>>>>> appear practical.
>>>>>
>>>>
>>>> It depends: if the conversion script is fast and we are
>>>> not really editing our MW VM, I wouldn't worry about
>>>> locking, specially just for a test conversion. If
>>>> we see the test conversion could produce some
>>>> workable result we could use a snapshot.
>>>>
>>>> I agree it will be tough but if we could rescue say
>>>> 60% of the information, it would certainly be worth it.
>>>>
>>>>> I think Confluence migration remains as a
>>>>> potentially-necessary Plan B or a potential following Plan A
>>>>> if needed for the long run.  The analysis TerryE
>>>>> provided suggests that it won't be easy whenever it is
>>>>> done.  I'm thinking it should not be done first if MW
>>>>> can be operated in the short term.
>>>>>
>>>>
>>>> I agree, there's just not anything I can personally do
>>>> about it and this being about *doing* and not just
>>>> proposing I felt it was a matter of honesty to close
>>>> the issue :(.
>>>>
>>>> Pedro.
>>>>
>>>
>>>
>>>
>>> --
>>> --Matt
>>
>>
>
>

-- 
------------------------------------------------------------------------
MzK

"There's something about the sound of a train
  that's very romantic and nostalgic and hopeful."
                                -- Paul Simon

Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Matt Richards <mr...@gmail.com>.
Sure, I can set up Confluence on my own hardware. But what about getting the
MW data dump to work with?

On Thu, Sep 8, 2011 at 4:21 PM, Dave Fisher <da...@comcast.net> wrote:

> If you have a server, then you can always setup your own confluence for
> free, or buy a personal limited license for $10 for 10 users.
>
> Apache CWiki is on a version 3.4 while the current version is 3.5.
>
> See http://www.atlassian.com/software/confluence/try.jsp
>
> Atlassian has a sandbox as well:
> http://sandbox.onconfluence.com/display/ds/Plugins+Installed+on+this+Confluence+Site
>
> This link might help: http://www.atlassian.com/search/?query=mediawiki
>
> HTH,
> Dave
>
> On Sep 8, 2011, at 12:29 PM, Matt Richards wrote:
>
> > Yeah, I've kinda ran into a similar problems when I originally
> volunteered
> > to help. I don't know how to go about it, without access to various data
> > dumps and such that it appears only Contributors/PPMC members have access
> > to.
> >
> > On Thu, Sep 8, 2011 at 2:25 PM, Pedro F. Giffuni <giffunip@tutopia.com
> >wrote:
> >
> >> --- On Thu, 9/8/11, Dennis E. Hamilton wrote:
> >> ...
> >>> I see you closed INFRA-3917.
> >>>
> >>
> >> I like to clean my own mess, yes.
> >>
> >>> Keep in mind that there appear to be others willing to
> >>> struggle with Confluence migration (CWiki?).
> >>>
> >>
> >> That makes me very happy!
> >>
> >> Anyone can reopen the issue: the problem I see is that
> >> it's basically only infra@ that can do this conversion:
> >> I have no idea if/how someone else can mirror the original
> >> information and assuming we can get a dump (which will
> >> likely be big) after running the conversion it has to
> >> be uploaded in the CWiki server for review.
> >>
> >>> A problem to consider in contingency planning: What it
> >>> means to lock down the current wiki during conversion.
> >>> And is the MW kept running for read-only viewing while
> >>> conversion takes place, either bit by bit or
> >>> wholesale?   Parallel live operation does not
> >>> appear practical.
> >>>
> >>
> >> It depends: if the conversion script is fast and we are
> >> not really editing our MW VM, I wouldn't worry about
> >> locking, specially just for a test conversion. If
> >> we see the test conversion could produce some
> >> workable result we could use a snapshot.
> >>
> >> I agree it will be tough but if we could rescue say
> >> 60% of the information, it would certainly be worth it.
> >>
> >>> I think Confluence migration remains as a
> >>> potentially-necessary Plan B or a potential following Plan A
> >>> if needed for the long run.  The analysis TerryE
> >>> provided suggests that it won't be easy whenever it is
> >>> done.  I'm thinking it should not be done first if MW
> >>> can be operated in the short term.
> >>>
> >>
> >> I agree, there's just not anything I can personally do
> >> about it and this being about *doing* and not just
> >> proposing I felt it was a matter of honesty to close
> >> the issue :(.
> >>
> >> Pedro.
> >>
> >
> >
> >
> > --
> > --Matt
>
>


-- 
--Matt

Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Dave Fisher <da...@comcast.net>.
If you have a server, then you can always setup your own confluence for free, or buy a personal limited license for $10 for 10 users.

Apache CWiki is on a version 3.4 while the current version is 3.5.

See http://www.atlassian.com/software/confluence/try.jsp

Atlassian has a sandbox as well: http://sandbox.onconfluence.com/display/ds/Plugins+Installed+on+this+Confluence+Site

This link might help: http://www.atlassian.com/search/?query=mediawiki

HTH,
Dave

On Sep 8, 2011, at 12:29 PM, Matt Richards wrote:

> Yeah, I've kinda ran into a similar problems when I originally volunteered
> to help. I don't know how to go about it, without access to various data
> dumps and such that it appears only Contributors/PPMC members have access
> to.
> 
> On Thu, Sep 8, 2011 at 2:25 PM, Pedro F. Giffuni <gi...@tutopia.com>wrote:
> 
>> --- On Thu, 9/8/11, Dennis E. Hamilton wrote:
>> ...
>>> I see you closed INFRA-3917.
>>> 
>> 
>> I like to clean my own mess, yes.
>> 
>>> Keep in mind that there appear to be others willing to
>>> struggle with Confluence migration (CWiki?).
>>> 
>> 
>> That makes me very happy!
>> 
>> Anyone can reopen the issue: the problem I see is that
>> it's basically only infra@ that can do this conversion:
>> I have no idea if/how someone else can mirror the original
>> information and assuming we can get a dump (which will
>> likely be big) after running the conversion it has to
>> be uploaded in the CWiki server for review.
>> 
>>> A problem to consider in contingency planning: What it
>>> means to lock down the current wiki during conversion.
>>> And is the MW kept running for read-only viewing while
>>> conversion takes place, either bit by bit or
>>> wholesale?   Parallel live operation does not
>>> appear practical.
>>> 
>> 
>> It depends: if the conversion script is fast and we are
>> not really editing our MW VM, I wouldn't worry about
>> locking, specially just for a test conversion. If
>> we see the test conversion could produce some
>> workable result we could use a snapshot.
>> 
>> I agree it will be tough but if we could rescue say
>> 60% of the information, it would certainly be worth it.
>> 
>>> I think Confluence migration remains as a
>>> potentially-necessary Plan B or a potential following Plan A
>>> if needed for the long run.  The analysis TerryE
>>> provided suggests that it won't be easy whenever it is
>>> done.  I'm thinking it should not be done first if MW
>>> can be operated in the short term.
>>> 
>> 
>> I agree, there's just not anything I can personally do
>> about it and this being about *doing* and not just
>> proposing I felt it was a matter of honesty to close
>> the issue :(.
>> 
>> Pedro.
>> 
> 
> 
> 
> -- 
> --Matt


Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Matt Richards <mr...@gmail.com>.
Yeah, I've kinda ran into a similar problems when I originally volunteered
to help. I don't know how to go about it, without access to various data
dumps and such that it appears only Contributors/PPMC members have access
to.

On Thu, Sep 8, 2011 at 2:25 PM, Pedro F. Giffuni <gi...@tutopia.com>wrote:

> --- On Thu, 9/8/11, Dennis E. Hamilton wrote:
> ...
> > I see you closed INFRA-3917.
> >
>
> I like to clean my own mess, yes.
>
> > Keep in mind that there appear to be others willing to
> > struggle with Confluence migration (CWiki?).
> >
>
> That makes me very happy!
>
> Anyone can reopen the issue: the problem I see is that
> it's basically only infra@ that can do this conversion:
> I have no idea if/how someone else can mirror the original
> information and assuming we can get a dump (which will
> likely be big) after running the conversion it has to
> be uploaded in the CWiki server for review.
>
> > A problem to consider in contingency planning: What it
> > means to lock down the current wiki during conversion.
> > And is the MW kept running for read-only viewing while
> > conversion takes place, either bit by bit or
> > wholesale?   Parallel live operation does not
> > appear practical.
> >
>
> It depends: if the conversion script is fast and we are
> not really editing our MW VM, I wouldn't worry about
> locking, specially just for a test conversion. If
> we see the test conversion could produce some
> workable result we could use a snapshot.
>
> I agree it will be tough but if we could rescue say
> 60% of the information, it would certainly be worth it.
>
> > I think Confluence migration remains as a
> > potentially-necessary Plan B or a potential following Plan A
> > if needed for the long run.  The analysis TerryE
> > provided suggests that it won't be easy whenever it is
> > done.  I'm thinking it should not be done first if MW
> > can be operated in the short term.
> >
>
> I agree, there's just not anything I can personally do
> about it and this being about *doing* and not just
> proposing I felt it was a matter of honesty to close
> the issue :(.
>
> Pedro.
>



-- 
--Matt

RE: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Pedro F. Giffuni" <gi...@tutopia.com>.
--- On Thu, 9/8/11, Dennis E. Hamilton wrote:
...
> I see you closed INFRA-3917.
>

I like to clean my own mess, yes.
 
> Keep in mind that there appear to be others willing to
> struggle with Confluence migration (CWiki?).
>

That makes me very happy!

Anyone can reopen the issue: the problem I see is that
it's basically only infra@ that can do this conversion:
I have no idea if/how someone else can mirror the original
information and assuming we can get a dump (which will
likely be big) after running the conversion it has to
be uploaded in the CWiki server for review.
 
> A problem to consider in contingency planning: What it
> means to lock down the current wiki during conversion. 
> And is the MW kept running for read-only viewing while
> conversion takes place, either bit by bit or
> wholesale?   Parallel live operation does not
> appear practical.
>

It depends: if the conversion script is fast and we are
not really editing our MW VM, I wouldn't worry about
locking, specially just for a test conversion. If
we see the test conversion could produce some
workable result we could use a snapshot.

I agree it will be tough but if we could rescue say
60% of the information, it would certainly be worth it.

> I think Confluence migration remains as a
> potentially-necessary Plan B or a potential following Plan A
> if needed for the long run.  The analysis TerryE
> provided suggests that it won't be easy whenever it is
> done.  I'm thinking it should not be done first if MW
> can be operated in the short term.
>

I agree, there's just not anything I can personally do
about it and this being about *doing* and not just
proposing I felt it was a matter of honesty to close
the issue :(.

Pedro.

RE: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Dennis E. Hamilton" <de...@acm.org>.
I see you closed INFRA-3917.

Keep in mind that there appear to be others willing to struggle with Confluence migration (CWiki?).

A problem to consider in contingency planning: What it means to lock down the current wiki during conversion.  And is the MW kept running for read-only viewing while conversion takes place, either bit by bit or wholesale?   Parallel live operation does not appear practical.

I think Confluence migration remains as a potentially-necessary Plan B or a potential following Plan A if needed for the long run.  The analysis TerryE provided suggests that it won't be easy whenever it is done.  I'm thinking it should not be done first if MW can be operated in the short term.

 - Dennis


-----Original Message-----
From: Pedro F. Giffuni [mailto:giffunip@tutopia.com] 
Sent: Thursday, September 08, 2011 09:10
To: ooo-dev@incubator.apache.org; dennis.hamilton@acm.org
Subject: RE: [wiki] Migration - A TerryE Clipping Collection [LONG]


--- On Thu, 9/8/11, Dennis E. Hamilton <de...@acm.org> wrote:
...
> Pedro, just a quick clarification,
> 
> My understanding is that Infra doesn't do content
> conversions of the kind we are talking about.
> 
> It is all volunteer work and it is up to the PPMC to
> resource such things. Infrastructure provided the gear and
> the platform/stack. 
>

OK, I am afraid it simply impossible then: I don't have
the resources nor it would be easy for me to get all the
MediaWiki content.

If someone from infra@ is listening, please just
close INFRA-3917.

Pedro.


RE: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Pedro F. Giffuni" <gi...@tutopia.com>.
--- On Thu, 9/8/11, Dennis E. Hamilton <de...@acm.org> wrote:
...
> Pedro, just a quick clarification,
> 
> My understanding is that Infra doesn't do content
> conversions of the kind we are talking about.
> 
> It is all volunteer work and it is up to the PPMC to
> resource such things. Infrastructure provided the gear and
> the platform/stack. 
>

OK, I am afraid it simply impossible then: I don't have
the resources nor it would be easy for me to get all the
MediaWiki content.

If someone from infra@ is listening, please just
close INFRA-3917.

Pedro.


RE: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Dennis E. Hamilton" <de...@acm.org>.
Pedro, just a quick clarification,

My understanding is that Infra doesn't do content conversions of the kind we are talking about.

It is all volunteer work and it is up to the PPMC to resource such things. Infrastructure provided the gear and the platform/stack. 

Oh, and I read Alexandro's question differently.  When he asked "how will you," I answered with "how would I".  I didn't take the question as one for the PPMC.  Sorry.

My response is in the context "Were it up to me, I would ..." and "How I see it is ...".

Sorry about that.

 - Dennis

-----Original Message-----
From: Pedro F. Giffuni [mailto:giffunip@tutopia.com] 
Sent: Wednesday, September 07, 2011 20:48
To: ooo-dev@incubator.apache.org
Subject: Re: [wiki] Migration - A TerryE Clipping Collection [LONG]


--- On Wed, 9/7/11, Alexandro Colorado wrote:
..
> 
> I also have not kept up with the discussion but reading
> Terry's comments there seem to be a very huge task to
> migrate out of Mediawiki. However then I see that "due
> to lack of Mediawiki support - we are moving to
> Confluence".
> Isnt this exactly what Terry describe why would this be
> difficult to do?
> I also don't see any support for confluence products to
> match what mediawiki had. At least any solutions to
> keep the functionality for their content.
> 
> Can you please explain how will you migrate addressing
> Terry's issues on migration?
>

Please hold your horses. Terry is not here, he is in his
way to Greece, and we are just exploring the few options
that are left.

Conversion from MW to confluence may be painful for
us but hopefully would be much easier for infra@.
(they haven't said anything about it yet but I am
pretty sure exploring this will take time).

Updating MW (which must be done for many good reasons,
including security) would seem more logical but still
has pain for both us and infra@.

Pedro.


RE: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Dennis E. Hamilton" <de...@acm.org>.
Alexandro,

I would follow Terry's advice and bring over the MediaWiki as close to as-is as we can make it, when we are ready to substitute for the one running beneath OpenOffice.org.  What works for me is that the attention to risk management and especially removing front-loading from the project appeals to me.  It is the agile principle of first doing the least that could possibly work.

Terry indicated that installing MediaWiki could be a stopgap.  Having brought over the platform and the content secures ease for review and migration to Confluence in a careful way without concern for the lights going out underneath OpenOffice.org.

Anything that can help to simply rehost OpenOffice.org and have it on operating sites that the Apache OOo Podling can maintain and transform seems best.  That is when all of us can breathe easier.  And the users of OpenOffice.org will be served and disrupted as little as possible.  Then we incubate the site and its services along with all other incubation.

The key difficulty in bringing up the wiki completely is the need to upgrade to MW 1.17.  I'm hoping that there is no rush.  A volunteer able to work through that is needed. 

 - Dennis

PS: I clipped out relevant Terry Notes below:

-----Original Message-----
From: acolorado@gmail.com [mailto:acolorado@gmail.com] On Behalf Of Alexandro Colorado
Sent: Wednesday, September 07, 2011 17:12
To: ooo-dev@incubator.apache.org
Subject: Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

On Wed, Sep 7, 2011 at 6:02 PM, Kay Schenk <ka...@gmail.com> wrote:

> Dennis--
>
> Thanks very much for sending this. I discovered that Terry had actually
> done a great job of documenting what had already occurred and some thoughts
> on what needed to be done on this wiki page...
>
>
>
> https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services
>
> So, I took the liberty of documenting where we are now -- also exploring
> Confluence.
>

I also have not kept up with the discussion but reading Terry's comments
there seem to be a very huge task to migrate out of Mediawiki. However then
I see that "due to lack of Mediawiki support - we are moving to Confluence".
Isnt this exactly what Terry describe why would this be difficult to do?
I also don't see any support for confluence products to match what mediawiki
had. At least any solutions to keep the functionality for their content.

Can you please explain how will you migrate addressing Terry's issues on
migration?



>> *** 2011-07-31-13:53 All times PDT (UTC-0700), TerryE - Wiki Size
>>
>> The OOo wiki contains 10,521 content pages and 11.338 uploaded files.
>> These form a critical service to the end-user community.  Note that
>> the cwiki markup format doesn't support many of the MediaWiki
>> specific markups in this content.
>>
>> *** 2011-07-31-14:36 TerryE - Concerns for Conversion to CWiki
>>
>> [T]he challenge here is that the cwiki markup grammer is different to
>> that of mediawiki and largely a functional subset.  Worse, mediawiki
>> supports extensions to allow you to extend this. The OOo
>> implementation currently uses *42* such extensions.  One of these was
>> custom-developed by the German OOo team.  With over 10,000 pages of
>> content, sentencing this lot and even if we establish a migration
>> ruleset to map 90% of the non-conformities, we still looking at a
>> MAJOR project.
>>
[ ... ]

>> *** 2011-08-01-09:53 TerryE - More on Confluence Migration
>>
>> *I* have looked at [migration to Confluence] and it *will* be hard. I
>> didn't say impossible. ... Just look at
>>
>> *  http://wiki.services.openoffice.org/wiki/Special:Statistics *
>> http://wiki.services.openoffice.org/wiki/Special:Version
>>
>> for the volumetrics and MediaWiki extensions used.  If you google
>> "mediawiki confluence migration" then you will see that isn't a
>> trivial exercise even for wiki using standard MW with no extensions:
>> it would involve person-years of effort.  I have suggested ...
>> rehosting but on a sustain basis for the wiki.  I can set all of this
>> up, if agreeable to the project.  It doesn't need further material
>> resources from the Apache team.  This would at least buy us the time
>> to do a proper migration plan and resource it.
>>
[ ... ]

>> *** 2011-08-03-08:07 Terry Ellison - Reaching the Wiki Users, Legal
>> Concerns
>>
>>> [...] Is there a announcement list or some other mechanism to send
>>> an email to every registered wiki user?
>>>
>>
>> At a technical level, it's simple to run a query dumping all of the
>> mail addresses of contributors to the wiki.  I've just done a few on
>> my local VM which has a snapshot of  the prod wiki as at Thursday/Fri
>> night IIRC.
>>
>> * There are 34,969 registered users.  Of which * 3,675 have made
>> contributions.  There is no need to contact those who haven't * 3,623
>> have registered email addresses and have made 182,677 contributions *
>> 52 have no registered email addresses and have made 153 contributions
>> (prob dating back to the early days when email registration and
>> confirmation wasn't mandatory
>>
[ ... ]

>> *** 2011-08-04-01:36 Terry Ellison - Moving the WIki "As-Is" for Now
>>
>> I am working with the rest of the project to migrate the forums and
>> the wiki "as-is" for now.
>>
>> .  As far as the wiki goes in the medium to longer term, the project
>> may decide to move some material to cwiki, but this is work in
>> progress.
 [ ... ]

>> *** 2011-08-08-02:22 Terry Ellison - Derisking Migration/Staging -
>> Separating Infrastructure/Platform and Content
>>
>> Thank-you all for your replies so far.  I will work through and
>> respond to individual points in thread at the appropriate branch, but
>> here I just wanted to propose that we divide the Wiki migration into
>> two separate but task areas:
>>
>> * Migration of the infrastructure service.  What drives this is if
>> Oracle decides, say, that the current hardware is being turned off on
>> the XXth of Aug, then we need to move the service to a box in
>> Apache.org.  The issues here are largely technical heavily involve
>> the infrastructure team.  We need to be able to move quickly on this
>> and few of the DL contributors have strong opinions here. They just
>> want the 'magic to happen'.  Yes, there are a few decisions to be
>> made, but the questions are a little esoteric for most DL members.  I
>> offer to continue to lead this work area.
>>
>> * Migration of the wiki content / policy.  Here we have a range of
>> widely and strongly held views and the DL seems to be acting as a
>> debating shop without convergence to consensus on some points. This
>> debate could still be continuing in 3 months time as far as I can
>> see.  I don't want it to get in the way of infrastructure migration
>> -- except when /absolutely/ necessary.  It also makes sense to break
>> this task area further if this means that we can make progress in
>> some areas, even if stalled in others.
>>
>> but from an infrastructure viewpoint I don't really care this
>> branding process can be encapsulated and detached.
>>
>> * We make the pre-prod wiki available to the "branding team" * The
>> branding team agree and implement the branding changes that the
>> project wants to have in place for cut-over day.  In practice this
>> could involve the creation or modification of content in the Main,
>> File, MediaWiki, OpenOffice.org Wiki and Template Namespaces * I can
>> use standard MW audit functionality to capture a list of all such
>> pages, and then standard MW export functionality to create an XML.GZ
>> dump of this work. * We then import the "live" wiki as part of
>> cut-over. * I then reimport the above XML.GZ to reapply the branding
>> changes to the migrated wiki.
>>
>> ... [M]y suggestion is to keep the infrastructure and content issues
>> separate.  I can lead on the first.  We need someone who can lead on
>> the second. His or her strengths should be that he/she has experience
>> of delivery -- that is can make things happen -- and has a good
>> working knowledge of more advance MW features such as templates, etc.
>> I would think that either Drew or TJ would be well qualified, but
>> that is only my personal suggestion.
[ ... ]

>> *** 2011-08-08-03:33 Terry Ellison - Risks of Changing DBMS along
>> with Migration
>>
>> There are two factors against an early move to PostgreSQL:  (i) The
>> MediaWiki cavaets on its use (here
>> <http://www.mediawiki.org/wiki/Manual:PostgreSQL>  and as all
>> experienced Wikipedian's do look at the associated talk page here
>> <http://www.mediawiki.org/wiki/Manual_talk:PostgreSQL>; this has a
>> couple of interesting references which cookbook the conversion).
>> (ii) The extra work involved. This is not only the D/B migration, but
>> also a MW version upgrade 15.1 ->  17.
>>
>> To be honest I am uncomfortable doing this as part of this immediate
>> "continuity of service" migration.  My suggestion is that if the
>> wiki looks as if it is going to have a long term place within  the
>> project then we should revisit this as part of an in-service
>> improvement program in, say, 6-12 months.
[ ... ]

>> *** 2011-08-10 15:12 Terry Ellison TEST/PRE-PRODUCTION WIKI INSTANCE
>> PROGRESS
>>
>> Just a quick update on progress on the wiki instance.  This is now up
>> in preprod mode  on the subdomain ooo-wiki.  This is based on a
>> snapshot taken at 4am yesterday morning.  The server needs further
>> tuning, but functionally its there.  We do have some outstanding code
>> issues (due to a change in the functionality of the PHP
>> routine*call_user_func* between Version 5.3 and 5.2 which is not
>> backwards compatible.  I'll sort this out tomorrow).
>>
>> Also note as per my previous email, all existing account have had
>> there passwords mangled, so access is guest-mode only at the moment.
>> Feel free to have a look, but updates and no service commitments
>> yet.
[ ... ]

>> *** 2011-08-11-01:38 Terry Ellison, BREAKAGE IN SEPARATING WIKI FROM
>> OO.O
>>
>>> I found one bug: On the wiki left side lowest frame where store
>>> links for other languages main pages, the links points to
>>> http://wiki.services.openoffice.org, not to the
>>> http://ooo-wiki.apache.org/.
>>>
>>
>> You are correct, and in fact there are a lot of references to
>> *.OpenOffice.org in the content.  However, there isn't a production
>> instance and there little point in changing these until (1) we agree
>> what such "dirty" references are going to be changed to, and (2) we
>> cut over for real.  Remember that any changes that we made on this
>> instance will be lost when we bring over the live [database].
[ ... ]

>> *** 2011-08-25-08:59 Terry Ellison, REQUEST FOR BASELINE AGREEMENTS
>> TO MOVE AHEAD [abridged 2011-09-08T02:33Z by dh]
>>
>> *    The prod wiki is v1.15.1 that at an N-3 major release level
>> (that's 30 months old: two major and 10 minor revisions behind the
>> current supported).  This also runs on PHP 5.2.0.
>> [...]
>> The PHP 5.3 introduced extra checking to remove an area of tolerance
>> the PHP 5.x<3 allowed.  This was to do with when and how parameters
>> can be passed by reference under curtain circumstances.  So moving a
>> code base from 5.2 to 5.3 involved a lot of work identifying and
>> eliminating this mis-codings.  This was done by the MediaWiki team in
>> MW v1.16.  I had planned to move to MW v1.15.5 (the last stable
>> 1.15.x) as our baseline and I've done this work integrating it with
>> Apache Traffic Server (ATS) and our LAMP stack.  This is stable and
>> performant enough to show that we are good.  However, I have only
>> identified and bug-fixed the main path 5.2->5.3 coding issues.
>> During my testing I have subsequently discovered others and there are
>> undoubtedly more to find.  I've also discussed this with the MW devs
>> on the MW IRC channel.  Given this, the consensus in the @infra team
>> (me included) is that we should bite the bullet now and move to
>> current MW 1.17.0 even given the extra work. There are some
>> performance risks associated with MW 1.17.0 which we need to
>> mitigate.  However, given that we've already got a complete
>> LAMP+ATS+MV in an ESX hosted VM performing like a dingbat, we really
>> only face the 1.15.5 ->  1.17.0 issues in this step.
>>
>> * *DECISION*: Upgrade the ooo-wiki MediaWiki(MV) + all extensions to
>> MW v1.17.0.
>>
>> * *DECISION*: I have agreed with infrastructure that we will keep 1
>> core on "standby" so we can up the VM to a 2-core VM if we are
>> seeing unacceptable performance problems with one-core.
>>
>> * *DECISION*: We will cut over the wiki and the forums with the
>> content as-is and implement branding and access control changes
>> within the a.o infrastructure when volunteers come on-stream to
>> resource this.  This is the standard "transfer then clean-up"
>> approach adopted when a migration is time critical.
>> [ ... ]
>> *     We have some further caching tweaks on the interaction of the
>> MediaWiki [application] with the ATS HTTP reverse proxy cache, but
>> these are probably nice-to-have than essential.  More to the point
>> these need to be done on a system will production load patterns.
>>
>> * *DECISION*. We will defer such tuning until post go-live.
>>
>> *** END OF THE WIKI NOTES ***
>>
>>
> --
> ------------------------------------------------------------------------
> MzK
>
> "There's something about the sound of a train
>  that's very romantic and nostalgic and hopeful."
>                               -- Paul Simon
>



-- 
*Alexandro Colorado*
*OpenOffice.org* Español
http://es.openoffice.org
fingerprint: E62B CF77 1BEA 0749 C0B8 50B9 3DE6 A84A 68D0 72E6


Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Matt Richards <mr...@gmail.com>.
Well, whatever direction this goes.. Getting a the information on Apache
grear is a great step.

On Wed, Sep 7, 2011 at 11:05 PM, Dave Fisher <da...@comcast.net> wrote:

>
> On Sep 7, 2011, at 8:47 PM, Pedro F. Giffuni wrote:
>
> >
> > --- On Wed, 9/7/11, Alexandro Colorado wrote:
> > ..
> >>
> >> I also have not kept up with the discussion but reading
> >> Terry's comments there seem to be a very huge task to
> >> migrate out of Mediawiki. However then I see that "due
> >> to lack of Mediawiki support - we are moving to
> >> Confluence".
> >> Isnt this exactly what Terry describe why would this be
> >> difficult to do?
> >> I also don't see any support for confluence products to
> >> match what mediawiki had. At least any solutions to
> >> keep the functionality for their content.
> >>
> >> Can you please explain how will you migrate addressing
> >> Terry's issues on migration?
> >>
> >
> > Please hold your horses. Terry is not here, he is in his
> > way to Greece, and we are just exploring the few options
> > that are left.
> >
> > Conversion from MW to confluence may be painful for
> > us but hopefully would be much easier for infra@.
> > (they haven't said anything about it yet but I am
> > pretty sure exploring this will take time).
> >
> > Updating MW (which must be done for many good reasons,
> > including security) would seem more logical but still
> > has pain for both us and infra@.
>
> But Drew is still here and he is being coached. That said, please go ahead
> with your experiment. I recall your mentioning this idea in June.
>
> Regards,
> Dave
>
> >
> > Pedro.
> >
>
>


-- 
--Matt

Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Pedro F. Giffuni" <gi...@tutopia.com>.
--- On Wed, 9/7/11, Dave Fisher wrote:
...
> > 
> > Please hold your horses. Terry is not here, he is in
> > his way to Greece, and we are just exploring the few
> > options that are left.
> > 
> > Conversion from MW to confluence may be painful for
> > us but hopefully would be much easier for infra@.
> > (they haven't said anything about it yet but I am
> > pretty sure exploring this will take time).
> > 
> > Updating MW (which must be done for many good
> > reasons, including security) would seem more logical
> > but still has pain for both us and infra@.
> 
> But Drew is still here and he is being coached. That said,
> please go ahead with your experiment. I recall your
> mentioning this idea in June.
>

Indeed, I think the MW is plan A, but we can always
have a plan B.

I created JIRA INFRA-3917 (hope I did it right) and
estimated 2 weeks, but I am sure the infra guys
will correct that or will just let us know if
it's not possible (if they can't I doubt anyone
else does).
 
cheers,

Pedro.

Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Dave Fisher <da...@comcast.net>.
On Sep 7, 2011, at 8:47 PM, Pedro F. Giffuni wrote:

> 
> --- On Wed, 9/7/11, Alexandro Colorado wrote:
> ..
>> 
>> I also have not kept up with the discussion but reading
>> Terry's comments there seem to be a very huge task to
>> migrate out of Mediawiki. However then I see that "due
>> to lack of Mediawiki support - we are moving to
>> Confluence".
>> Isnt this exactly what Terry describe why would this be
>> difficult to do?
>> I also don't see any support for confluence products to
>> match what mediawiki had. At least any solutions to
>> keep the functionality for their content.
>> 
>> Can you please explain how will you migrate addressing
>> Terry's issues on migration?
>> 
> 
> Please hold your horses. Terry is not here, he is in his
> way to Greece, and we are just exploring the few options
> that are left.
> 
> Conversion from MW to confluence may be painful for
> us but hopefully would be much easier for infra@.
> (they haven't said anything about it yet but I am
> pretty sure exploring this will take time).
> 
> Updating MW (which must be done for many good reasons,
> including security) would seem more logical but still
> has pain for both us and infra@.

But Drew is still here and he is being coached. That said, please go ahead with your experiment. I recall your mentioning this idea in June.

Regards,
Dave

> 
> Pedro.
> 


Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by "Pedro F. Giffuni" <gi...@tutopia.com>.
--- On Wed, 9/7/11, Alexandro Colorado wrote:
..
> 
> I also have not kept up with the discussion but reading
> Terry's comments there seem to be a very huge task to
> migrate out of Mediawiki. However then I see that "due
> to lack of Mediawiki support - we are moving to
> Confluence".
> Isnt this exactly what Terry describe why would this be
> difficult to do?
> I also don't see any support for confluence products to
> match what mediawiki had. At least any solutions to
> keep the functionality for their content.
> 
> Can you please explain how will you migrate addressing
> Terry's issues on migration?
>

Please hold your horses. Terry is not here, he is in his
way to Greece, and we are just exploring the few options
that are left.

Conversion from MW to confluence may be painful for
us but hopefully would be much easier for infra@.
(they haven't said anything about it yet but I am
pretty sure exploring this will take time).

Updating MW (which must be done for many good reasons,
including security) would seem more logical but still
has pain for both us and infra@.

Pedro.


Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Alexandro Colorado <jz...@openoffice.org>.
On Wed, Sep 7, 2011 at 6:02 PM, Kay Schenk <ka...@gmail.com> wrote:

> Dennis--
>
> Thanks very much for sending this. I discovered that Terry had actually
> done a great job of documenting what had already occurred and some thoughts
> on what needed to be done on this wiki page...
>
>
>
> https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services
>
> So, I took the liberty of documenting where we are now -- also exploring
> Confluence.
>

I also have not kept up with the discussion but reading Terry's comments
there seem to be a very huge task to migrate out of Mediawiki. However then
I see that "due to lack of Mediawiki support - we are moving to Confluence".
Isnt this exactly what Terry describe why would this be difficult to do?
I also don't see any support for confluence products to match what mediawiki
had. At least any solutions to keep the functionality for their content.

Can you please explain how will you migrate addressing Terry's issues on
migration?



>
> I have NOT kept up with discussion on ultimate use -- who will have update
> access, so if someone knows this, or ultimately what was decided, please add
> to the existing page.
>
> Thanks.
>
>
> On 09/06/2011 07:56 PM, Dennis E. Hamilton wrote:
>
>> I compiled a LONG chronological clipping set of notes from Terry on
>> from conception to when he stopped posting on the issues and thinking
>> around Wiki migration.
>>
>> I'm breaking a thread here. There is no need to comment on any of
>> this, it is for reference and mining for things to not overlook,
>> collate onto the wiki, etc.
>>
>> The selections are mine, the list is long, and it probably works
>> better distilled onto a wiki.  This is the collection phase.
>>
>> I am staying as close to the architectural and technical
>> considerations that I can, and not follow into areas where there were
>> policy spats of one kind or another.  I thought I might have to look
>> at others posts too, but generally, I could find enough in what Terry
>> was responding to to provide continuity.
>>
>> It is interesting that we are now re-hashing some of the things that
>> Terry covered at least one starting over a month ago.
>>
>> NOTE: Terry also provided OOOUSER Material
>>
>> *** 2011-07-31-13:53 All times PDT (UTC-0700), TerryE - Wiki Size
>>
>> The OOo wiki contains 10,521 content pages and 11.338 uploaded files.
>> These form a critical service to the end-user community.  Note that
>> the cwiki markup format doesn't support many of the MediaWiki
>> specific markups in this content.
>>
>> *** 2011-07-31-14:36 TerryE - Concerns for Conversion to CWiki
>>
>> [T]he challenge here is that the cwiki markup grammer is different to
>> that of mediawiki and largely a functional subset.  Worse, mediawiki
>> supports extensions to allow you to extend this. The OOo
>> implementation currently uses *42* such extensions.  One of these was
>> custom-developed by the German OOo team.  With over 10,000 pages of
>> content, sentencing this lot and even if we establish a migration
>> ruleset to map 90% of the non-conformities, we still looking at a
>> MAJOR project.
>>
>> *** 2011-07-31-15:07 Terry Ellison - Formulating the
>> Hardware/Software Stack
>>
>> Both the OOo forums and the OOo wiki can run on a standard LAMP
>> stack. [ ... ]
>>
>> The wiki is a bit more of a hog and need 4-cores, but it currently
>> doesn't use a PHP opcode cache and this would halve this load.  Most
>> of the access is guest, so using a squid or varnish front-end will
>> drop this significantly.
>>
>> The simplest way to provide this service would be to use VMs and
>> AFAIK this is a model that the a.o infrastructure guys understand.
>>
>> *** 2011-07-31-16:02 TerryE - Migrating the Wiki, Concerns not to
>> Overlook
>>
>> As far as the wiki goes, this template has been more heavily
>> customised again using standard MediaWiki hooks and facilities.
>> Switching logos and banners would be reasonably straight forward, but
>> alas the guys that did the bulk of the content management are
>> history.
>>
>>  (3) Legal - IP, Copyright and Licensing We will need to make sure
>>> that we have clear documentation of the copyright and license for
>>> the content on the wiki and user forums. We'll need to make sure
>>> that the Migration does not infringe on anyone's copyright and/or
>>> inadvertently change any licenses. If we are clear about what we
>>> are planning for these sites on an openoffice.org domain then it
>>> *might* be possible to take everything.
>>>
>>
>> The forum content was all under the Sun then Oracle terms which
>> roughly mirror CCA but with OOo retaining full rights to use.  All
>> bar a few dozen of the wiki pages likewise.
>>
>> *** 2011-08-01-07:42 Terry Ellison - Server Capacity Considerations,
>> Confirming Operation
>>
>>  [C]an you give me some Ubuntu VM specs so I can create them for the
>>> Forums and the Wiki -- we can then get them setup and working as a
>>> test and ready for a final dump/load when we switch over, in the
>>> meantime we can check the loads of the VM hosts etc to be sure all
>>> will be ok.
>>>
>>> Just amount of RAM and disk  space required should be all I need -
>>> and 1 or 2 cpu , then I'll get an Ubuntu VM up for each. We try and
>>> stick to LTS releases so will get it to 10.04.3 LTS version unless
>>> you have a reason we should use a later Ubuntu release.
>>>
>>
>> I track Ubuntu current for my laptop and home server, and use Ubuntu
>> LTS by preference for my LAMP VMs.  I use a 2 disk split with a
>> common immutable system image and an app-specific /var (with callback
>> hooks in the startup so the app can tailor the system).  I've just
>> rebaseline my VMs from 10.04-1 LTS to 10.03-1 LTS.  If you guys have
>> already developed an Ubuntu VM template then I can always pick up
>> that. If not then I'll write up my template and make sure the
>> licensing of my IPR / content is OK, so you have the option to reuse
>> it.
>>
>> I would prefer to stick with Ubuntu VMs for now because I like to
>> keep local mirrors of any prod system for release
>> development/rehearsal and hunting down live problems.  I currently
>> use VirtualBox, but I can reinstall VMserver on my local server so
>> that I can switch my VMs from VBox Guest Utils to VMware Tools.  (I
>> like to exactly mirror any prod systems locally.)
>>
>> Installing and getting to grips with the bowels of FreeBSD server is
>> just another learning curve that I would like to avoid at the
>> moment. I've already got a learning curve on compliance with your
>> own infrastructure standards on Identification&  Access Control,
>> Backup, Logging, Intrusion Detection, Status Report, ....
>>
>>
>> *** 2011-08-01-09:53 TerryE - More on Confluence Migration
>>
>> *I* have looked at [migration to Confluence] and it *will* be hard. I
>> didn't say impossible. ... Just look at
>>
>> *  http://wiki.services.openoffice.org/wiki/Special:Statistics *
>> http://wiki.services.openoffice.org/wiki/Special:Version
>>
>> for the volumetrics and MediaWiki extensions used.  If you google
>> "mediawiki confluence migration" then you will see that isn't a
>> trivial exercise even for wiki using standard MW with no extensions:
>> it would involve person-years of effort.  I have suggested ...
>> rehosting but on a sustain basis for the wiki.  I can set all of this
>> up, if agreeable to the project.  It doesn't need further material
>> resources from the Apache team.  This would at least buy us the time
>> to do a proper migration plan and resource it.
>>
>> *** 2011-08-01-20:03 TerryE - Working to Have Confirmable
>> Configurations, Trial Operation
>>
>>  I'd like to get going so am going to create 2 x VMs of 50GB space
>>> and 2GB RAM each, both with Ubuntu 10.04.3. One for the mediawiki
>>> and one for the forums.
>>>
>>
>> The wiki might struggle without tuning, since the current config
>> isn't and the MediaWiki engine is a D/B hog unless you stick a cache
>> such as Squid or Varnish in front of it. ...
>>
>> I'll want to mirror them exactly for my dev, so can you mail me the
>> dpkg -l listing together with the etc tarball and details of any not
>> debian installs.
>>
>> I'll shout if there's anything missing.  We'll need a PHP accelerator
>> -- Xcache or APC, and php5-cli.
>>
>> *** 2011-08-03-08:07 Terry Ellison - Reaching the Wiki Users, Legal
>> Concerns
>>
>>> [...] Is there a announcement list or some other mechanism to send
>>> an email to every registered wiki user?
>>>
>>
>> At a technical level, it's simple to run a query dumping all of the
>> mail addresses of contributors to the wiki.  I've just done a few on
>> my local VM which has a snapshot of  the prod wiki as at Thursday/Fri
>> night IIRC.
>>
>> * There are 34,969 registered users.  Of which * 3,675 have made
>> contributions.  There is no need to contact those who haven't * 3,623
>> have registered email addresses and have made 182,677 contributions *
>> 52 have no registered email addresses and have made 153 contributions
>> (prob dating back to the early days when email registration and
>> confirmation wasn't mandatory
>>
>> It is trivial to dump this list of user / email addr / post count.
>>
>> However giving this to Apache and the project making use of it is a
>> more complex issue.  The server is current located in Oracle's
>> Hamburg facility under German / EU legislation.  We have data
>> protection legislation and Anti-Spam guidelines / legislation to bear
>> in mind here.  Moving email addresses across national and
>> organisational boundary might trigger these.  Also one can't send out
>> mailshot emails in the EU unless the recipients have first agreed in
>> principle to accept these.
>>
>> What I can do is to provide this data to Andrew via the internal
>> Oracle email, and let him figure out the legal / compliance issues
>> and terms of use before him making it available to the project.  ...
>>
>> *** 2011-08-04-01:36 Terry Ellison - Moving the WIki "As-Is" for Now
>>
>> I am working with the rest of the project to migrate the forums and
>> the wiki "as-is" for now.
>>
>> .  As far as the wiki goes in the medium to longer term, the project
>> may decide to move some material to cwiki, but this is work in
>> progress.
>>
>> *** 2011-08-04-02:05 Terry E - Registering and Authorizing Users and
>> Their Edits
>>
>>  1) People must ask for an account; they can't self-subscribe.
>>> Nothing is required except a few words about who you are and why
>>> you want an account. Any one of several people authorised to
>>> approve or reject these requests can deal with them expeditiously.
>>> Very few spammers, in my experience, take the trouble to actually
>>> request accounts.
>>>
>> We need to implement this in a way which sits within MediaWiki
>> functionality and complies with the goals.
>>
>> One way would be
>>
>> * to allow the normal self-registration and optional email address
>> with email verification * and have a new wiki role, say "contributor"
>> (or is this contributer in US-speak?). * guest have no write access *
>> registered users can write to User and User_talk namespaces but to no
>> others * registered users can request to become a Contributor, but
>> the must have completed their User page, verified their email address
>> and confirmed that all future edits to the Main or Talk namespaces
>> are made under licence (CCA AL2 or whatever we decide. * the granting
>> of Contributor is done by the bureaucrats. * The Main and Talk pages
>> contain "reference" content. * There is a standard disclaimer that
>> user/user talk is user content is user content * We would still need
>> main and user namespace guidelines TOUs.
>>
>> This might seem a little convolved, but this can be configured with
>> std MW/extension functionality.
>>
>>  2) Alternatively, or in addition, the first X edits/
>>> contributions/ whatever are moderated by a group of people, any one
>>> of whom can approve or reject the items. After X acceptable
>>> contributions, the person is then allowed to edit the wiki without
>>> further supervision [ ... ]
>>>
>> We could add another committer layer so that contributer (but not
>> committer) edits are moderated
>>
>> However, I suspect that a trust-but-verify attitude is easier for
>> everyone.  When we catch contributers deliberately abusing the
>> rules, then we can always back out their changes and remove
>> contributer status.  This is similar to our forum model and works
>> well there.
>>
>> *** 2011-08-04-04:30 TerryE - Wiki Extension to Require
>> Review-then-Commit
>>
>>  You probably know more about this than I do, but my understanding
>>> is that the current OOo wiki has an extension installed that does
>>> what I was suggesting in option 2, but the extension has not been
>>> implemented.  See:
>>> http://www.mediawiki.org/wiki/Extension:FlaggedRevs and
>>> specifically:
>>>
>>> http://www.mediawiki.org/wiki/Extension:FlaggedRevs#Automatic_user_promotion
>>>
>>>
>>
>>>  Yes, you are correct.  This extension can do this and more, but with
>
>> a grey issue like this I feel that a DL based dialogue isn't the
>> best way to work out what to do here.  Better we work up a position
>> paper/page within the OOOUSERS cwiki laying down the options, their
>> pros and cons and then agree a consensus or vote either on the paper
>> itself. Use the DL to note the consensus and get wider feedback.
>>
>> What concerns me is the moderation load involved with such an active
>> intervention of review-before-publish.  Perhaps others with
>> moderator experience might care to comment?
>>
>> My worry is that review-before-publish also ignores the reality of
>> how people edit wikis.  In general they don't prepare and proof
>> draft offline then paste their best and final into the article.  Most
>> do it section by section or end up correcting / rewording when they
>> see the final version, so one logical edit can comprise half a dozen
>> posts.  I am not sure how this would work if you've got to wait for
>> approval before the next edit.
>>
>> *** 2011-08-05-15:18 Terry Ellison - Migration Systems Setting Up
>>
>>  Gav, the Admin from the ASF has setup the VM for the MediaWiki.
>>> It's a Ubuntu 10.4.3 LTS VM. At the Moment Gav and I has admin
>>> access to this machine. First we have to install all the needed
>>> software, Then we will make a test migration with a older Dump,
>>> then we can make testings and finaly the final migration.
>>>
>>> Greetings Raphael
>>>
>>
>> Raphael, great news.   I've my dev shadow VM up as well, and just
>> logged onto minotaur for the first time with my new apache ID.  I'll
>> ping the config detail over to you and Gavin and take it from there.
>> Regards Terry
>>
>>
>> *** 2011-08-07-10:49 TerryE - Questions About the Wiki and
>> Customizing Pages
>>
>>  It should be possible to alter the login page to show any
>>> important information we want to share about the migrated site,
>>> correct? With possibly a survey?
>>>
>>> Also, what is the purpose of the Bots group?
>>>
>> The WikiEditor group is the default group for a MediaWiki extension,
>> FlaggedRevisions, which facilitates some of the control
>> functionality that Rob, you and other have been asking for.  If you
>> look at Clayton's status page, this extension isn't yet put to use.
>> A job for post transition, I think. But that's why Clayton is the
>> only current member.
>>
>> Yes, the Main_Page is a restricted page, but anyone can take a copy
>> and work on it in their User page hierarchy.  When we have a
>> consensus that it's OK then I can move it back into main.
>>
>> The bots group is for a  function supported by MediaWiki  where it
>> provides an [XMLRPC] to all batch process to  work on the wiki.  In
>> this case Clayton and co used the PyWikipediabot (I think) to carry
>> out bulk transactions. This needs an account with special
>> privileges.
>>
>> *** 2011-08-07-15:38 Terry Ellison - WORK ITEMS AND ISSUES - FIRST
>> CUT
>>
>> I've just finished a 1st cut of outstanding tasks and issues for the
>> Wiki.
>>
>> See
>>
>> https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services
>>
>>
>>
>> Comments gratefully received on this DL and/or on the page itself.
>>
>> *** 2011-08-08-02:22 Terry Ellison - Derisking Migration/Staging -
>> Separating Infrastructure/Platform and Content
>>
>> Thank-you all for your replies so far.  I will work through and
>> respond to individual points in thread at the appropriate branch, but
>> here I just wanted to propose that we divide the Wiki migration into
>> two separate but task areas:
>>
>> * Migration of the infrastructure service.  What drives this is if
>> Oracle decides, say, that the current hardware is being turned off on
>> the XXth of Aug, then we need to move the service to a box in
>> Apache.org.  The issues here are largely technical heavily involve
>> the infrastructure team.  We need to be able to move quickly on this
>> and few of the DL contributors have strong opinions here. They just
>> want the 'magic to happen'.  Yes, there are a few decisions to be
>> made, but the questions are a little esoteric for most DL members.  I
>> offer to continue to lead this work area.
>>
>> * Migration of the wiki content / policy.  Here we have a range of
>> widely and strongly held views and the DL seems to be acting as a
>> debating shop without convergence to consensus on some points. This
>> debate could still be continuing in 3 months time as far as I can
>> see.  I don't want it to get in the way of infrastructure migration
>> -- except when /absolutely/ necessary.  It also makes sense to break
>> this task area further if this means that we can make progress in
>> some areas, even if stalled in others.
>>
>> but from an infrastructure viewpoint I don't really care this
>> branding process can be encapsulated and detached.
>>
>> * We make the pre-prod wiki available to the "branding team" * The
>> branding team agree and implement the branding changes that the
>> project wants to have in place for cut-over day.  In practice this
>> could involve the creation or modification of content in the Main,
>> File, MediaWiki, OpenOffice.org Wiki and Template Namespaces * I can
>> use standard MW audit functionality to capture a list of all such
>> pages, and then standard MW export functionality to create an XML.GZ
>> dump of this work. * We then import the "live" wiki as part of
>> cut-over. * I then reimport the above XML.GZ to reapply the branding
>> changes to the migrated wiki.
>>
>> ... [M]y suggestion is to keep the infrastructure and content issues
>> separate.  I can lead on the first.  We need someone who can lead on
>> the second. His or her strengths should be that he/she has experience
>> of delivery -- that is can make things happen -- and has a good
>> working knowledge of more advance MW features such as templates, etc.
>> I would think that either Drew or TJ would be well qualified, but
>> that is only my personal suggestion.
>>
>> *** 2011-08-08-01:41 Terry Ellison - Getting Help on the Content
>> Side
>>
>>  I can submit an iCLA if it would help (it's on my WIGATI list).
>>>
>>
>> [W]e need someone has sound MediaWiki skills to lead on doing these
>> [content]  I've suggest that you are qualified.  I don't know if
>> anyone on the DL other than you or I knows enough about MW content
>> editing, so could you consider my suggestion?
>>
>> *** 2011-08-08-02:39 TerryE - More on Content Migration
>>
>>  I assuming that under the name "branding changes" we include:
>>>
>>> 1) OpenOffice.org ->   Apache OpenOffice.org and associated logo
>>> changes
>>>
>>> 2) Removal of Oracle logos and name
>>>
>>> 3) Replacement of privacy policy and disclaimer
>>>
>>> 4) Update of page edit license text to require Apache 2.0 for new
>>> contributions
>>>
>> Yes, good points, though such content changes are functionally
>> separate from the (infrastructure) migration.  I have suggested in a
>> separate branch that we set up separate task area with its own leader
>> to work these issues.
>>
>> *** 2011-08-08-03:16 Terry Ellison - Wanting to Walk through It At
>> Home
>>
>> To be honest I'm not comfortable with any solution unless I've used
>> myself, ... This {??] option is simple to implement and try in
>> pre-prod, unlike a migration to PostgreSQL which will involve quite a
>> bit of work.
>>
>> (An example of where I am comfortable is with the use of PHP-APC).
>>
>> What I had hoped to get feedback/from the wider ooo-dev DL/ was on
>> the least technical risk, but which also had the business impact, and
>> that is to stop the service for ~30 mins a day to do the backup.
>>
>> Is this acceptable?  Historically, the lowest transaction rates occur
>> at ~04:00 UTC, so this is when I'd do it if we go this way.
>>
>> *** 2011-08-08-03:33 Terry Ellison - Risks of Changing DBMS along
>> with Migration
>>
>> There are two factors against an early move to PostgreSQL:  (i) The
>> MediaWiki cavaets on its use (here
>> <http://www.mediawiki.org/wiki/Manual:PostgreSQL>  and as all
>> experienced Wikipedian's do look at the associated talk page here
>> <http://www.mediawiki.org/wiki/Manual_talk:PostgreSQL>; this has a
>> couple of interesting references which cookbook the conversion).
>> (ii) The extra work involved. This is not only the D/B migration, but
>> also a MW version upgrade 15.1 ->  17.
>>
>> To be honest I am uncomfortable doing this as part of this immediate
>> "continuity of service" migration.  My suggestion is that if the
>> wiki looks as if it is going to have a long term place within  the
>> project then we should revisit this as part of an in-service
>> improvement program in, say, 6-12 months.
>>
>> *** 2011-08-08-04:14 Terry Ellison - Migrating Static Web Projects to
>> Wiki
>>
>>  I strongly suggest that all the native language projects
>>> front-facing pages be migrated to the "new" wiki.
>>>
>> [ ... ]
>>
>>> This would of course, give them URLS of the form
>>> somewikiname.openoffice.org/"nl_code" rather than
>>> "nl_code".openoffice.org
>>>
>> [ ... ]
>>
>>> Naturally, we should confirm acceptance with them for this.
>>>
>>
>> ... I see this as part of the content migration / transformation task
>> area.  What I want to go is to get the current content over with loss
>> of content, formatting or change history.
>>
>> ... I assume by your refrence to the "new" wiki ... you mean the
>> ooo-dev cwiki.  As we've discussed before, the current migration from
>> MediaWiki to Confluence can be highly lossy unless there is per-page
>> content editor intervention: we [lose] all  change history, some
>> content formatting (1) and some even content (2).  It therefore makes
>> sense, even if we migrate the publicly viewed copy to cwiki, to keep
>> a master copy of the old content online in ... this wiki, albeit
>> moving the page into an "Archive" namespace which is private and
>> read-only to committers.
>>
>> *** 2011-08-08-05:03 Terry Ellison - Migration Isn't Just Moving a
>> System Dump
>>
>>  If Oracle decides, say, that the current hardware is being turned
>>> off on the XXth of Aug, then we need to grab a backup of the
>>> content to a box in Apache.org.
>>>
>>
>> It's a big more complicated than just grabbing the content :)  I
>> already routine off-site the current forum and wiki system content
>> for dev support and [Disaster Recovery], but that's within current
>> working practices that date back to Sun days.  It's putting content
>> to new use with a.o that requires clearing the hurdles.
>>
>> *** 2011-08-09-02:16 Terry Ellison - LOOKING AT WORK-ITEM ISSUES
>> FEEDBACK, STEPS BEING TAKEN
>>
>> [Re 2011-08-07-15:38,
>>
>> https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services
>> ]
>>
>>  Thanks to everyone for this constructive feedback.  I hope that I
>> have given replies in thread fork where you needed then, but I will
>> up integrate them and update the document and move forward to
>> complete task 6 in the next couple of days.  There are two further
>> points that I would like to raise for comment / feedback.
>>
>> (1) This bulk of this page content relates to technical details and
>> issues, rather than content / branding / licensing, etc..  As I
>> mentioned in a reply to RobW, I would like to decouple the
>> infrastructure aspects from the content-relate aspects as much as
>> practical to keep the momentum on the platform move.  I therefore
>> propose to move the bulk of the infrastructure content into a
>> supplementary page which focuses on this content.
>>
>> (2) I will be making the snapshot version accessible to the project,
>> however:
>>
>> * I will be overwriting all passwords (except mine and Drew's) thus
>> disabling existing account use.  I will also replace all email
>> addresses by dummies to prevent existing users resetting their
>> passwords, and user page-watch information to stop bad emails being
>> generated. * Anyone who one who wishes to work on the wiki will need
>> to create a new account and apply to Drew or myself for temporary
>> elevated privileges if needed.  Just remember that new content will
>> be blown away at cut-over, so individual new users must use the
>> standard export functionality prior to cut-over to save it if they
>> want to restore it post live-transfer. * As step one removes the
>> private data elements that could be viewed as falling within the
>> purview of EU data protection legislation, this means that we could
>> in principle make a copy of this D/B to any committers for data
>> analysis. All they need is MySQL installed and 3Gb space the D/B.
>> The data model is pretty straight forward :-) (*)
>>
>> (*) a quick example here is that the edit profile is a classic near
>> log-lin relationship: 33% of edits where made by 10 editors, 73% by
>> 100, 90% by 315.
>>
>> *** 2011-08-10 15:12 Terry Ellison TEST/PRE-PRODUCTION WIKI INSTANCE
>> PROGRESS
>>
>> Just a quick update on progress on the wiki instance.  This is now up
>> in preprod mode  on the subdomain ooo-wiki.  This is based on a
>> snapshot taken at 4am yesterday morning.  The server needs further
>> tuning, but functionally its there.  We do have some outstanding code
>> issues (due to a change in the functionality of the PHP
>> routine*call_user_func* between Version 5.3 and 5.2 which is not
>> backwards compatible.  I'll sort this out tomorrow).
>>
>> Also note as per my previous email, all existing account have had
>> there passwords mangled, so access is guest-mode only at the moment.
>> Feel free to have a look, but updates and no service commitments
>> yet.
>>
>> *** 2011-08-11-01:18 Terry Ellison - Rig for Silent Running
>> (robots.txt)
>>
>>  <http://ooo-wiki.apache.org>
>>>>
>>>>  Hmmm... if this is just a temporary URL, I wonder if we should try
>>> to exclude search engine indexing via robots.txt ?
>>>
>>> Otherwise, now that the URL is known, we're going to get spidered
>>> but then all those links will soon be dead. <snip>
>>>
>>
>> Thanks Rob for pointing this out, and for Raphael and Gavin fixing
>> it. This was incidentally on my bucket list for today.  I didn't
>> think it that urgent as it would take a day or so for Google et al to
>> acquire the site, but you correct.  Better sooner.
>>
>> *** 2011-08-11-01:38 Terry Ellison, BREAKAGE IN SEPARATING WIKI FROM
>> OO.O
>>
>>> I found one bug: On the wiki left side lowest frame where store
>>> links for other languages main pages, the links points to
>>> http://wiki.services.openoffice.org, not to the
>>> http://ooo-wiki.apache.org/.
>>>
>>
>> You are correct, and in fact there are a lot of references to
>> *.OpenOffice.org in the content.  However, there isn't a production
>> instance and there little point in changing these until (1) we agree
>> what such "dirty" references are going to be changed to, and (2) we
>> cut over for real.  Remember that any changes that we made on this
>> instance will be lost when we bring over the live [database].
>>
>> 2011-08-12-04:53 Terry Ellison, OO.O WIKI ERROR LOGS BUMP
>>
>> As part of my takeover of SysAdmin on wiki.services.openoffice.org,
>> I've been reviewing the error logs and noticed that last week there's
>> been quite a rise in reported errors by clients trying to enumerate
>> the wiki incorrectly.  This may just be a coincidence and nothing to
>> do with our work, but if anyone on this DL is trying to suck material
>> down, there are right ways to do this.  I also understand the
>> MediaWiki webAPI if any of you want to write a bot to do this. ...
>> Please contact me to discuss.
>>
>> *** 2011-08-23-20:30 Terry Ellison, SPEEDING UP WIKI ACCESS, REDUCING
>> LOAD
>>
>> I've now finished the upgrade to add the Apache Traffic Server front
>> end to the community MediaWiki service at http://ooo-wiki.apache.org/
>> and the service is back online.
>>
>> We need to do some further tuning of the system cache optimisation,
>> but even with the first-cut settings that I prepared on my own
>> test-bed VM, the system already looks as if it it is hitting the
>> performance targets needed to sustain a full production transaction
>> rate.  It certainly feels extremely snappy compared to the existing
>> OOo community wiki or the Apache cwiki, and the Google pagespeed
>> benchmarks are significantly better than both of these systems. So:
>>
>> * We are good to go for production migration of the community wiki. *
>> We are the first Apache project adopter of another Apache project,
>> Apache Traffic Server (ATS) * We have laid the foundation for an ATS
>> template for MediaWiki hosting that can be used to promote the use of
>> ATS for the wider MediaWiki systems community.
>>
>> It's been a hard few days work, and still some finishing to do, but
>> my thanks to the Infrstructure and ATS guys that have supported me
>> in making this happen.
>>
>> *** 2011-08-25-08:59 Terry Ellison, REQUEST FOR BASELINE AGREEMENTS
>> TO MOVE AHEAD
>>
>> I can't execute any plan without a baseline requirement and set of
>> assumptions, so what this note attempts is to lay down such a set,
>> and the decisions that need to be made to go forward.  So PLEASE, I
>> don't want any flames about my use of DECISION below.  What I simply
>> mean is the if the PPMC as a body accepts these, then I will try my
>> best to move this work forward.  Of course you are free to challenge
>> / change any of this if that is a PPMC voted decision, but in this
>> case I need to move into a different mode; to suspend work and stop
>> the clock until we have an PPMC-endorsed baseline to replan on. ...
>>
>>
>> *    The infrastructure stack is base on a standard Ubuntu server
>> LAMP stack as at current LTS (Ubuntu 10.04-3 LTS) which included PHP
>> 5.3.2
>>
>> *    The prod wiki is v1.15.1 that at an N-3 major release level
>> (that's 30 months old: two major and 10 minor revisions behind the
>> current supported).  This also runs on PHP 5.2.0.
>>
>> *    We need an reverse-proxy HTTP cache for performance reasons on
>> the wiki.  One of the four market leaders in this niche is another
>> Apache project: Apache Traffic Server (ATS).  It makes sense to stay
>> "in-house" here for both support and referenceability reasons
>>
>> * *DECISION*: Adopt ATS v3.0.1 as the HTTP cache for the wiki.
>> (BTW, this work has been done and the product is excellent).
>>
>> The PHP 5.3 introduced extra checking to remove an area of tolerance
>> the PHP 5.x<3 allowed.  This was to do with when and how parameters
>> can be passed by reference under curtain circumstances.  So moving a
>> code base from 5.2 to 5.3 involved a lot of work identifying and
>> eliminating this mis-codings.  This was done by the MediaWiki team in
>> MW v1.16.  I had planned to move to MW v1.15.5 (the last stable
>> 1.15.x) as our baseline and I've done this work integrating it with
>> Apache Traffic Server (ATS) and our LAMP stack.  This is stable and
>> performant enough to show that we are good.  However, I have only
>> identified and bug-fixed the main path 5.2->5.3 coding issues.
>> During my testing I have subsequently discovered others and there are
>> undoubtedly more to find.  I've also discussed this with the MW devs
>> on the MW IRC channel.  Given this, the consensus in the @infra team
>> (me included) is that we should bite the bullet now and move to
>> current MW 1.17.0 even given the extra work. There are some
>> performance risks associated with MW 1.17.0 which we need to
>> mitigate.  However, given that we've already got a complete
>> LAMP+ATS+MV in an ESX hosted VM performing like a dingbat, we really
>> only face the 1.15.5 ->  1.17.0 issues in this step.
>>
>> * *DECISION*: Upgrade the ooo-wiki MediaWiki(MV) + all extensions to
>> MW v1.17.0.
>>
>> * *DECISION*: I have agreed with infrastructure that we will keep 1
>> core on "standby" so we can up the VM to a 2-core VM if we are
>> seeing unacceptable performance problems with one-core.
>>
>> * *DECISION*: We will cut over the wiki and the forums with the
>> content as-is and implement branding and access control changes
>> within the a.o infrastructure when volunteers come on-stream to
>> resource this.  This is the standard "transfer then clean-up"
>> approach adopted when a migration is time critical.
>>
>> *CUT-OVER*
>>
>> There are two facets to cut-over: content move and DNS-based IP
>> reassignment.  Clearly we need to freeze update access to the
>> services prior to start of content move and continue update-freeze on
>> the legacy service.  Bringing the content across involves a backup,
>> copy restore which can be rehearsed and scripted, but in the case of
>> the wiki, this will be a few hours even if fully automated.
>>
>> *    There are many way "to skin the cat" of the migration process.
>> All will involve some service loss, but the complexity of the
>> rehearsal and planning come explode as we reduce this outage to a
>> zero.  Complex plans can also go wrong so my instinct is to keep it
>> simple: halt the service at a pre-notified time, transfer and start
>> new service at  a pre-notified time.
>>
>> * *DECISION*: Halt the wiki service for a notified (24hr) window
>> during cutover.  The migration uses fixed IPs, so  DNP IP
>> reassignment is co-incident with service stop.
>>
>> * *GOAL*: Cut over [wiki] within 14 days from today.  Date TBD by PM.
>> I can do the content move.
>>
>> *     We have some further caching tweaks on the interaction of the
>> MediaWiki [application] with the ATS HTTP reverse proxy cache, but
>> these are probably nice-to-have than essential.  More to the point
>> these need to be done on a system will production load patterns.
>>
>> * *DECISION*. We will defer such tuning until post go-live.
>>
>> *** END OF THE WIKI NOTES ***
>>
>>
> --
> ------------------------------------------------------------------------
> MzK
>
> "There's something about the sound of a train
>  that's very romantic and nostalgic and hopeful."
>                               -- Paul Simon
>



-- 
*Alexandro Colorado*
*OpenOffice.org* Español
http://es.openoffice.org
fingerprint: E62B CF77 1BEA 0749 C0B8 50B9 3DE6 A84A 68D0 72E6

Re: [wiki] Migration - A TerryE Clipping Collection [LONG]

Posted by Kay Schenk <ka...@gmail.com>.
Dennis--

Thanks very much for sending this. I discovered that Terry had actually 
done a great job of documenting what had already occurred and some 
thoughts on what needed to be done on this wiki page...

https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services

So, I took the liberty of documenting where we are now -- also exploring 
Confluence.

I have NOT kept up with discussion on ultimate use -- who will have 
update access, so if someone knows this, or ultimately what was decided, 
please add to the existing page.

Thanks.

On 09/06/2011 07:56 PM, Dennis E. Hamilton wrote:
> I compiled a LONG chronological clipping set of notes from Terry on
> from conception to when he stopped posting on the issues and thinking
> around Wiki migration.
>
> I'm breaking a thread here. There is no need to comment on any of
> this, it is for reference and mining for things to not overlook,
> collate onto the wiki, etc.
>
> The selections are mine, the list is long, and it probably works
> better distilled onto a wiki.  This is the collection phase.
>
> I am staying as close to the architectural and technical
> considerations that I can, and not follow into areas where there were
> policy spats of one kind or another.  I thought I might have to look
> at others posts too, but generally, I could find enough in what Terry
> was responding to to provide continuity.
>
> It is interesting that we are now re-hashing some of the things that
> Terry covered at least one starting over a month ago.
>
> NOTE: Terry also provided OOOUSER Material
>
> *** 2011-07-31-13:53 All times PDT (UTC-0700), TerryE - Wiki Size
>
> The OOo wiki contains 10,521 content pages and 11.338 uploaded files.
> These form a critical service to the end-user community.  Note that
> the cwiki markup format doesn't support many of the MediaWiki
> specific markups in this content.
>
> *** 2011-07-31-14:36 TerryE - Concerns for Conversion to CWiki
>
> [T]he challenge here is that the cwiki markup grammer is different to
> that of mediawiki and largely a functional subset.  Worse, mediawiki
> supports extensions to allow you to extend this. The OOo
> implementation currently uses *42* such extensions.  One of these was
> custom-developed by the German OOo team.  With over 10,000 pages of
> content, sentencing this lot and even if we establish a migration
> ruleset to map 90% of the non-conformities, we still looking at a
> MAJOR project.
>
> *** 2011-07-31-15:07 Terry Ellison - Formulating the
> Hardware/Software Stack
>
> Both the OOo forums and the OOo wiki can run on a standard LAMP
> stack. [ ... ]
>
> The wiki is a bit more of a hog and need 4-cores, but it currently
> doesn't use a PHP opcode cache and this would halve this load.  Most
> of the access is guest, so using a squid or varnish front-end will
> drop this significantly.
>
> The simplest way to provide this service would be to use VMs and
> AFAIK this is a model that the a.o infrastructure guys understand.
>
> *** 2011-07-31-16:02 TerryE - Migrating the Wiki, Concerns not to
> Overlook
>
> As far as the wiki goes, this template has been more heavily
> customised again using standard MediaWiki hooks and facilities.
> Switching logos and banners would be reasonably straight forward, but
> alas the guys that did the bulk of the content management are
> history.
>
>> (3) Legal - IP, Copyright and Licensing We will need to make sure
>> that we have clear documentation of the copyright and license for
>> the content on the wiki and user forums. We'll need to make sure
>> that the Migration does not infringe on anyone's copyright and/or
>> inadvertently change any licenses. If we are clear about what we
>> are planning for these sites on an openoffice.org domain then it
>> *might* be possible to take everything.
>
> The forum content was all under the Sun then Oracle terms which
> roughly mirror CCA but with OOo retaining full rights to use.  All
> bar a few dozen of the wiki pages likewise.
>
> *** 2011-08-01-07:42 Terry Ellison - Server Capacity Considerations,
> Confirming Operation
>
>> [C]an you give me some Ubuntu VM specs so I can create them for the
>> Forums and the Wiki -- we can then get them setup and working as a
>> test and ready for a final dump/load when we switch over, in the
>> meantime we can check the loads of the VM hosts etc to be sure all
>> will be ok.
>>
>> Just amount of RAM and disk  space required should be all I need -
>> and 1 or 2 cpu , then I'll get an Ubuntu VM up for each. We try and
>> stick to LTS releases so will get it to 10.04.3 LTS version unless
>> you have a reason we should use a later Ubuntu release.
>
> I track Ubuntu current for my laptop and home server, and use Ubuntu
> LTS by preference for my LAMP VMs.  I use a 2 disk split with a
> common immutable system image and an app-specific /var (with callback
> hooks in the startup so the app can tailor the system).  I've just
> rebaseline my VMs from 10.04-1 LTS to 10.03-1 LTS.  If you guys have
> already developed an Ubuntu VM template then I can always pick up
> that. If not then I'll write up my template and make sure the
> licensing of my IPR / content is OK, so you have the option to reuse
> it.
>
> I would prefer to stick with Ubuntu VMs for now because I like to
> keep local mirrors of any prod system for release
> development/rehearsal and hunting down live problems.  I currently
> use VirtualBox, but I can reinstall VMserver on my local server so
> that I can switch my VMs from VBox Guest Utils to VMware Tools.  (I
> like to exactly mirror any prod systems locally.)
>
> Installing and getting to grips with the bowels of FreeBSD server is
> just another learning curve that I would like to avoid at the
> moment. I've already got a learning curve on compliance with your
> own infrastructure standards on Identification&  Access Control,
> Backup, Logging, Intrusion Detection, Status Report, ....
>
>
> *** 2011-08-01-09:53 TerryE - More on Confluence Migration
>
> *I* have looked at [migration to Confluence] and it *will* be hard. I
> didn't say impossible. ... Just look at
>
> *  http://wiki.services.openoffice.org/wiki/Special:Statistics *
> http://wiki.services.openoffice.org/wiki/Special:Version
>
> for the volumetrics and MediaWiki extensions used.  If you google
> "mediawiki confluence migration" then you will see that isn't a
> trivial exercise even for wiki using standard MW with no extensions:
> it would involve person-years of effort.  I have suggested ...
> rehosting but on a sustain basis for the wiki.  I can set all of this
> up, if agreeable to the project.  It doesn't need further material
> resources from the Apache team.  This would at least buy us the time
> to do a proper migration plan and resource it.
>
> *** 2011-08-01-20:03 TerryE - Working to Have Confirmable
> Configurations, Trial Operation
>
>> I'd like to get going so am going to create 2 x VMs of 50GB space
>> and 2GB RAM each, both with Ubuntu 10.04.3. One for the mediawiki
>> and one for the forums.
>
> The wiki might struggle without tuning, since the current config
> isn't and the MediaWiki engine is a D/B hog unless you stick a cache
> such as Squid or Varnish in front of it. ...
>
> I'll want to mirror them exactly for my dev, so can you mail me the
> dpkg -l listing together with the etc tarball and details of any not
> debian installs.
>
> I'll shout if there's anything missing.  We'll need a PHP accelerator
> -- Xcache or APC, and php5-cli.
>
> *** 2011-08-03-08:07 Terry Ellison - Reaching the Wiki Users, Legal
> Concerns
>> [...] Is there a announcement list or some other mechanism to send
>> an email to every registered wiki user?
>
> At a technical level, it's simple to run a query dumping all of the
> mail addresses of contributors to the wiki.  I've just done a few on
> my local VM which has a snapshot of  the prod wiki as at Thursday/Fri
> night IIRC.
>
> * There are 34,969 registered users.  Of which * 3,675 have made
> contributions.  There is no need to contact those who haven't * 3,623
> have registered email addresses and have made 182,677 contributions *
> 52 have no registered email addresses and have made 153 contributions
> (prob dating back to the early days when email registration and
> confirmation wasn't mandatory
>
> It is trivial to dump this list of user / email addr / post count.
>
> However giving this to Apache and the project making use of it is a
> more complex issue.  The server is current located in Oracle's
> Hamburg facility under German / EU legislation.  We have data
> protection legislation and Anti-Spam guidelines / legislation to bear
> in mind here.  Moving email addresses across national and
> organisational boundary might trigger these.  Also one can't send out
> mailshot emails in the EU unless the recipients have first agreed in
> principle to accept these.
>
> What I can do is to provide this data to Andrew via the internal
> Oracle email, and let him figure out the legal / compliance issues
> and terms of use before him making it available to the project.  ...
>
> *** 2011-08-04-01:36 Terry Ellison - Moving the WIki "As-Is" for Now
>
> I am working with the rest of the project to migrate the forums and
> the wiki "as-is" for now.
>
> .  As far as the wiki goes in the medium to longer term, the project
> may decide to move some material to cwiki, but this is work in
> progress.
>
> *** 2011-08-04-02:05 Terry E - Registering and Authorizing Users and
> Their Edits
>
>> 1) People must ask for an account; they can't self-subscribe.
>> Nothing is required except a few words about who you are and why
>> you want an account. Any one of several people authorised to
>> approve or reject these requests can deal with them expeditiously.
>> Very few spammers, in my experience, take the trouble to actually
>> request accounts.
> We need to implement this in a way which sits within MediaWiki
> functionality and complies with the goals.
>
> One way would be
>
> * to allow the normal self-registration and optional email address
> with email verification * and have a new wiki role, say "contributor"
> (or is this contributer in US-speak?). * guest have no write access *
> registered users can write to User and User_talk namespaces but to no
> others * registered users can request to become a Contributor, but
> the must have completed their User page, verified their email address
> and confirmed that all future edits to the Main or Talk namespaces
> are made under licence (CCA AL2 or whatever we decide. * the granting
> of Contributor is done by the bureaucrats. * The Main and Talk pages
> contain "reference" content. * There is a standard disclaimer that
> user/user talk is user content is user content * We would still need
> main and user namespace guidelines TOUs.
>
> This might seem a little convolved, but this can be configured with
> std MW/extension functionality.
>
>> 2) Alternatively, or in addition, the first X edits/
>> contributions/ whatever are moderated by a group of people, any one
>> of whom can approve or reject the items. After X acceptable
>> contributions, the person is then allowed to edit the wiki without
>> further supervision [ ... ]
> We could add another committer layer so that contributer (but not
> committer) edits are moderated
>
> However, I suspect that a trust-but-verify attitude is easier for
> everyone.  When we catch contributers deliberately abusing the
> rules, then we can always back out their changes and remove
> contributer status.  This is similar to our forum model and works
> well there.
>
> *** 2011-08-04-04:30 TerryE - Wiki Extension to Require
> Review-then-Commit
>
>> You probably know more about this than I do, but my understanding
>> is that the current OOo wiki has an extension installed that does
>> what I was suggesting in option 2, but the extension has not been
>> implemented.  See:
>> http://www.mediawiki.org/wiki/Extension:FlaggedRevs and
>> specifically:
>> http://www.mediawiki.org/wiki/Extension:FlaggedRevs#Automatic_user_promotion
>>
>
>>
Yes, you are correct.  This extension can do this and more, but with
> a grey issue like this I feel that a DL based dialogue isn't the
> best way to work out what to do here.  Better we work up a position
> paper/page within the OOOUSERS cwiki laying down the options, their
> pros and cons and then agree a consensus or vote either on the paper
> itself. Use the DL to note the consensus and get wider feedback.
>
> What concerns me is the moderation load involved with such an active
> intervention of review-before-publish.  Perhaps others with
> moderator experience might care to comment?
>
> My worry is that review-before-publish also ignores the reality of
> how people edit wikis.  In general they don't prepare and proof
> draft offline then paste their best and final into the article.  Most
> do it section by section or end up correcting / rewording when they
> see the final version, so one logical edit can comprise half a dozen
> posts.  I am not sure how this would work if you've got to wait for
> approval before the next edit.
>
> *** 2011-08-05-15:18 Terry Ellison - Migration Systems Setting Up
>
>> Gav, the Admin from the ASF has setup the VM for the MediaWiki.
>> It's a Ubuntu 10.4.3 LTS VM. At the Moment Gav and I has admin
>> access to this machine. First we have to install all the needed
>> software, Then we will make a test migration with a older Dump,
>> then we can make testings and finaly the final migration.
>>
>> Greetings Raphael
>
> Raphael, great news.   I've my dev shadow VM up as well, and just
> logged onto minotaur for the first time with my new apache ID.  I'll
> ping the config detail over to you and Gavin and take it from there.
> Regards Terry
>
>
> *** 2011-08-07-10:49 TerryE - Questions About the Wiki and
> Customizing Pages
>
>> It should be possible to alter the login page to show any
>> important information we want to share about the migrated site,
>> correct? With possibly a survey?
>>
>> Also, what is the purpose of the Bots group?
> The WikiEditor group is the default group for a MediaWiki extension,
> FlaggedRevisions, which facilitates some of the control
> functionality that Rob, you and other have been asking for.  If you
> look at Clayton's status page, this extension isn't yet put to use.
> A job for post transition, I think. But that's why Clayton is the
> only current member.
>
> Yes, the Main_Page is a restricted page, but anyone can take a copy
> and work on it in their User page hierarchy.  When we have a
> consensus that it's OK then I can move it back into main.
>
> The bots group is for a  function supported by MediaWiki  where it
> provides an [XMLRPC] to all batch process to  work on the wiki.  In
> this case Clayton and co used the PyWikipediabot (I think) to carry
> out bulk transactions. This needs an account with special
> privileges.
>
> *** 2011-08-07-15:38 Terry Ellison - WORK ITEMS AND ISSUES - FIRST
> CUT
>
> I've just finished a 1st cut of outstanding tasks and issues for the
> Wiki.
>
> See
> https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services
>
>
>
> Comments gratefully received on this DL and/or on the page itself.
>
> *** 2011-08-08-02:22 Terry Ellison - Derisking Migration/Staging -
> Separating Infrastructure/Platform and Content
>
> Thank-you all for your replies so far.  I will work through and
> respond to individual points in thread at the appropriate branch, but
> here I just wanted to propose that we divide the Wiki migration into
> two separate but task areas:
>
> * Migration of the infrastructure service.  What drives this is if
> Oracle decides, say, that the current hardware is being turned off on
> the XXth of Aug, then we need to move the service to a box in
> Apache.org.  The issues here are largely technical heavily involve
> the infrastructure team.  We need to be able to move quickly on this
> and few of the DL contributors have strong opinions here. They just
> want the 'magic to happen'.  Yes, there are a few decisions to be
> made, but the questions are a little esoteric for most DL members.  I
> offer to continue to lead this work area.
>
> * Migration of the wiki content / policy.  Here we have a range of
> widely and strongly held views and the DL seems to be acting as a
> debating shop without convergence to consensus on some points. This
> debate could still be continuing in 3 months time as far as I can
> see.  I don't want it to get in the way of infrastructure migration
> -- except when /absolutely/ necessary.  It also makes sense to break
> this task area further if this means that we can make progress in
> some areas, even if stalled in others.
>
> but from an infrastructure viewpoint I don't really care this
> branding process can be encapsulated and detached.
>
> * We make the pre-prod wiki available to the "branding team" * The
> branding team agree and implement the branding changes that the
> project wants to have in place for cut-over day.  In practice this
> could involve the creation or modification of content in the Main,
> File, MediaWiki, OpenOffice.org Wiki and Template Namespaces * I can
> use standard MW audit functionality to capture a list of all such
> pages, and then standard MW export functionality to create an XML.GZ
> dump of this work. * We then import the "live" wiki as part of
> cut-over. * I then reimport the above XML.GZ to reapply the branding
> changes to the migrated wiki.
>
> ... [M]y suggestion is to keep the infrastructure and content issues
> separate.  I can lead on the first.  We need someone who can lead on
> the second. His or her strengths should be that he/she has experience
> of delivery -- that is can make things happen -- and has a good
> working knowledge of more advance MW features such as templates, etc.
> I would think that either Drew or TJ would be well qualified, but
> that is only my personal suggestion.
>
> *** 2011-08-08-01:41 Terry Ellison - Getting Help on the Content
> Side
>
>> I can submit an iCLA if it would help (it's on my WIGATI list).
>
> [W]e need someone has sound MediaWiki skills to lead on doing these
> [content]  I've suggest that you are qualified.  I don't know if
> anyone on the DL other than you or I knows enough about MW content
> editing, so could you consider my suggestion?
>
> *** 2011-08-08-02:39 TerryE - More on Content Migration
>
>> I assuming that under the name "branding changes" we include:
>>
>> 1) OpenOffice.org ->   Apache OpenOffice.org and associated logo
>> changes
>>
>> 2) Removal of Oracle logos and name
>>
>> 3) Replacement of privacy policy and disclaimer
>>
>> 4) Update of page edit license text to require Apache 2.0 for new
>> contributions
> Yes, good points, though such content changes are functionally
> separate from the (infrastructure) migration.  I have suggested in a
> separate branch that we set up separate task area with its own leader
> to work these issues.
>
> *** 2011-08-08-03:16 Terry Ellison - Wanting to Walk through It At
> Home
>
> To be honest I'm not comfortable with any solution unless I've used
> myself, ... This {??] option is simple to implement and try in
> pre-prod, unlike a migration to PostgreSQL which will involve quite a
> bit of work.
>
> (An example of where I am comfortable is with the use of PHP-APC).
>
> What I had hoped to get feedback/from the wider ooo-dev DL/ was on
> the least technical risk, but which also had the business impact, and
> that is to stop the service for ~30 mins a day to do the backup.
>
> Is this acceptable?  Historically, the lowest transaction rates occur
> at ~04:00 UTC, so this is when I'd do it if we go this way.
>
> *** 2011-08-08-03:33 Terry Ellison - Risks of Changing DBMS along
> with Migration
>
> There are two factors against an early move to PostgreSQL:  (i) The
> MediaWiki cavaets on its use (here
> <http://www.mediawiki.org/wiki/Manual:PostgreSQL>  and as all
> experienced Wikipedian's do look at the associated talk page here
> <http://www.mediawiki.org/wiki/Manual_talk:PostgreSQL>; this has a
> couple of interesting references which cookbook the conversion).
> (ii) The extra work involved. This is not only the D/B migration, but
> also a MW version upgrade 15.1 ->  17.
>
> To be honest I am uncomfortable doing this as part of this immediate
> "continuity of service" migration.  My suggestion is that if the
> wiki looks as if it is going to have a long term place within  the
> project then we should revisit this as part of an in-service
> improvement program in, say, 6-12 months.
>
> *** 2011-08-08-04:14 Terry Ellison - Migrating Static Web Projects to
> Wiki
>
>> I strongly suggest that all the native language projects
>> front-facing pages be migrated to the "new" wiki.
> [ ... ]
>> This would of course, give them URLS of the form
>> somewikiname.openoffice.org/"nl_code" rather than
>> "nl_code".openoffice.org
> [ ... ]
>> Naturally, we should confirm acceptance with them for this.
>
> ... I see this as part of the content migration / transformation task
> area.  What I want to go is to get the current content over with loss
> of content, formatting or change history.
>
> ... I assume by your refrence to the "new" wiki ... you mean the
> ooo-dev cwiki.  As we've discussed before, the current migration from
> MediaWiki to Confluence can be highly lossy unless there is per-page
> content editor intervention: we [lose] all  change history, some
> content formatting (1) and some even content (2).  It therefore makes
> sense, even if we migrate the publicly viewed copy to cwiki, to keep
> a master copy of the old content online in ... this wiki, albeit
> moving the page into an "Archive" namespace which is private and
> read-only to committers.
>
> *** 2011-08-08-05:03 Terry Ellison - Migration Isn't Just Moving a
> System Dump
>
>> If Oracle decides, say, that the current hardware is being turned
>> off on the XXth of Aug, then we need to grab a backup of the
>> content to a box in Apache.org.
>
> It's a big more complicated than just grabbing the content :)  I
> already routine off-site the current forum and wiki system content
> for dev support and [Disaster Recovery], but that's within current
> working practices that date back to Sun days.  It's putting content
> to new use with a.o that requires clearing the hurdles.
>
> *** 2011-08-09-02:16 Terry Ellison - LOOKING AT WORK-ITEM ISSUES
> FEEDBACK, STEPS BEING TAKEN
>
> [Re 2011-08-07-15:38,
> https://cwiki.apache.org/confluence/display/OOOUSERS/Community+Wiki+Services]
>
>  Thanks to everyone for this constructive feedback.  I hope that I
> have given replies in thread fork where you needed then, but I will
> up integrate them and update the document and move forward to
> complete task 6 in the next couple of days.  There are two further
> points that I would like to raise for comment / feedback.
>
> (1) This bulk of this page content relates to technical details and
> issues, rather than content / branding / licensing, etc..  As I
> mentioned in a reply to RobW, I would like to decouple the
> infrastructure aspects from the content-relate aspects as much as
> practical to keep the momentum on the platform move.  I therefore
> propose to move the bulk of the infrastructure content into a
> supplementary page which focuses on this content.
>
> (2) I will be making the snapshot version accessible to the project,
> however:
>
> * I will be overwriting all passwords (except mine and Drew's) thus
> disabling existing account use.  I will also replace all email
> addresses by dummies to prevent existing users resetting their
> passwords, and user page-watch information to stop bad emails being
> generated. * Anyone who one who wishes to work on the wiki will need
> to create a new account and apply to Drew or myself for temporary
> elevated privileges if needed.  Just remember that new content will
> be blown away at cut-over, so individual new users must use the
> standard export functionality prior to cut-over to save it if they
> want to restore it post live-transfer. * As step one removes the
> private data elements that could be viewed as falling within the
> purview of EU data protection legislation, this means that we could
> in principle make a copy of this D/B to any committers for data
> analysis. All they need is MySQL installed and 3Gb space the D/B.
> The data model is pretty straight forward :-) (*)
>
> (*) a quick example here is that the edit profile is a classic near
> log-lin relationship: 33% of edits where made by 10 editors, 73% by
> 100, 90% by 315.
>
> *** 2011-08-10 15:12 Terry Ellison TEST/PRE-PRODUCTION WIKI INSTANCE
> PROGRESS
>
> Just a quick update on progress on the wiki instance.  This is now up
> in preprod mode  on the subdomain ooo-wiki.  This is based on a
> snapshot taken at 4am yesterday morning.  The server needs further
> tuning, but functionally its there.  We do have some outstanding code
> issues (due to a change in the functionality of the PHP
> routine*call_user_func* between Version 5.3 and 5.2 which is not
> backwards compatible.  I'll sort this out tomorrow).
>
> Also note as per my previous email, all existing account have had
> there passwords mangled, so access is guest-mode only at the moment.
> Feel free to have a look, but updates and no service commitments
> yet.
>
> *** 2011-08-11-01:18 Terry Ellison - Rig for Silent Running
> (robots.txt)
>
>>> <http://ooo-wiki.apache.org>
>>>
>> Hmmm... if this is just a temporary URL, I wonder if we should try
>> to exclude search engine indexing via robots.txt ?
>>
>> Otherwise, now that the URL is known, we're going to get spidered
>> but then all those links will soon be dead. <snip>
>
> Thanks Rob for pointing this out, and for Raphael and Gavin fixing
> it. This was incidentally on my bucket list for today.  I didn't
> think it that urgent as it would take a day or so for Google et al to
> acquire the site, but you correct.  Better sooner.
>
> *** 2011-08-11-01:38 Terry Ellison, BREAKAGE IN SEPARATING WIKI FROM
> OO.O
>> I found one bug: On the wiki left side lowest frame where store
>> links for other languages main pages, the links points to
>> http://wiki.services.openoffice.org, not to the
>> http://ooo-wiki.apache.org/.
>
> You are correct, and in fact there are a lot of references to
> *.OpenOffice.org in the content.  However, there isn't a production
> instance and there little point in changing these until (1) we agree
> what such "dirty" references are going to be changed to, and (2) we
> cut over for real.  Remember that any changes that we made on this
> instance will be lost when we bring over the live [database].
>
> 2011-08-12-04:53 Terry Ellison, OO.O WIKI ERROR LOGS BUMP
>
> As part of my takeover of SysAdmin on wiki.services.openoffice.org,
> I've been reviewing the error logs and noticed that last week there's
> been quite a rise in reported errors by clients trying to enumerate
> the wiki incorrectly.  This may just be a coincidence and nothing to
> do with our work, but if anyone on this DL is trying to suck material
> down, there are right ways to do this.  I also understand the
> MediaWiki webAPI if any of you want to write a bot to do this. ...
> Please contact me to discuss.
>
> *** 2011-08-23-20:30 Terry Ellison, SPEEDING UP WIKI ACCESS, REDUCING
> LOAD
>
> I've now finished the upgrade to add the Apache Traffic Server front
> end to the community MediaWiki service at http://ooo-wiki.apache.org/
> and the service is back online.
>
> We need to do some further tuning of the system cache optimisation,
> but even with the first-cut settings that I prepared on my own
> test-bed VM, the system already looks as if it it is hitting the
> performance targets needed to sustain a full production transaction
> rate.  It certainly feels extremely snappy compared to the existing
> OOo community wiki or the Apache cwiki, and the Google pagespeed
> benchmarks are significantly better than both of these systems. So:
>
> * We are good to go for production migration of the community wiki. *
> We are the first Apache project adopter of another Apache project,
> Apache Traffic Server (ATS) * We have laid the foundation for an ATS
> template for MediaWiki hosting that can be used to promote the use of
> ATS for the wider MediaWiki systems community.
>
> It's been a hard few days work, and still some finishing to do, but
> my thanks to the Infrstructure and ATS guys that have supported me
> in making this happen.
>
> *** 2011-08-25-08:59 Terry Ellison, REQUEST FOR BASELINE AGREEMENTS
> TO MOVE AHEAD
>
> I can't execute any plan without a baseline requirement and set of
> assumptions, so what this note attempts is to lay down such a set,
> and the decisions that need to be made to go forward.  So PLEASE, I
> don't want any flames about my use of DECISION below.  What I simply
> mean is the if the PPMC as a body accepts these, then I will try my
> best to move this work forward.  Of course you are free to challenge
> / change any of this if that is a PPMC voted decision, but in this
> case I need to move into a different mode; to suspend work and stop
> the clock until we have an PPMC-endorsed baseline to replan on. ...
>
>
> *    The infrastructure stack is base on a standard Ubuntu server
> LAMP stack as at current LTS (Ubuntu 10.04-3 LTS) which included PHP
> 5.3.2
>
> *    The prod wiki is v1.15.1 that at an N-3 major release level
> (that's 30 months old: two major and 10 minor revisions behind the
> current supported).  This also runs on PHP 5.2.0.
>
> *    We need an reverse-proxy HTTP cache for performance reasons on
> the wiki.  One of the four market leaders in this niche is another
> Apache project: Apache Traffic Server (ATS).  It makes sense to stay
> "in-house" here for both support and referenceability reasons
>
> * *DECISION*: Adopt ATS v3.0.1 as the HTTP cache for the wiki.
> (BTW, this work has been done and the product is excellent).
>
> The PHP 5.3 introduced extra checking to remove an area of tolerance
> the PHP 5.x<3 allowed.  This was to do with when and how parameters
> can be passed by reference under curtain circumstances.  So moving a
> code base from 5.2 to 5.3 involved a lot of work identifying and
> eliminating this mis-codings.  This was done by the MediaWiki team in
> MW v1.16.  I had planned to move to MW v1.15.5 (the last stable
> 1.15.x) as our baseline and I've done this work integrating it with
> Apache Traffic Server (ATS) and our LAMP stack.  This is stable and
> performant enough to show that we are good.  However, I have only
> identified and bug-fixed the main path 5.2->5.3 coding issues.
> During my testing I have subsequently discovered others and there are
> undoubtedly more to find.  I've also discussed this with the MW devs
> on the MW IRC channel.  Given this, the consensus in the @infra team
> (me included) is that we should bite the bullet now and move to
> current MW 1.17.0 even given the extra work. There are some
> performance risks associated with MW 1.17.0 which we need to
> mitigate.  However, given that we've already got a complete
> LAMP+ATS+MV in an ESX hosted VM performing like a dingbat, we really
> only face the 1.15.5 ->  1.17.0 issues in this step.
>
> * *DECISION*: Upgrade the ooo-wiki MediaWiki(MV) + all extensions to
> MW v1.17.0.
>
> * *DECISION*: I have agreed with infrastructure that we will keep 1
> core on "standby" so we can up the VM to a 2-core VM if we are
> seeing unacceptable performance problems with one-core.
>
> * *DECISION*: We will cut over the wiki and the forums with the
> content as-is and implement branding and access control changes
> within the a.o infrastructure when volunteers come on-stream to
> resource this.  This is the standard "transfer then clean-up"
> approach adopted when a migration is time critical.
>
> *CUT-OVER*
>
> There are two facets to cut-over: content move and DNS-based IP
> reassignment.  Clearly we need to freeze update access to the
> services prior to start of content move and continue update-freeze on
> the legacy service.  Bringing the content across involves a backup,
> copy restore which can be rehearsed and scripted, but in the case of
> the wiki, this will be a few hours even if fully automated.
>
> *    There are many way "to skin the cat" of the migration process.
> All will involve some service loss, but the complexity of the
> rehearsal and planning come explode as we reduce this outage to a
> zero.  Complex plans can also go wrong so my instinct is to keep it
> simple: halt the service at a pre-notified time, transfer and start
> new service at  a pre-notified time.
>
> * *DECISION*: Halt the wiki service for a notified (24hr) window
> during cutover.  The migration uses fixed IPs, so  DNP IP
> reassignment is co-incident with service stop.
>
> * *GOAL*: Cut over [wiki] within 14 days from today.  Date TBD by PM.
> I can do the content move.
>
> *     We have some further caching tweaks on the interaction of the
> MediaWiki [application] with the ATS HTTP reverse proxy cache, but
> these are probably nice-to-have than essential.  More to the point
> these need to be done on a system will production load patterns.
>
> * *DECISION*. We will defer such tuning until post go-live.
>
> *** END OF THE WIKI NOTES ***
>

-- 
------------------------------------------------------------------------
MzK

"There's something about the sound of a train
  that's very romantic and nostalgic and hopeful."
                                -- Paul Simon