Andromeda/Public Server Transfer

All of nottinghack.org.uk will move to a new server, this involves quite a lot of work!

Below is an ordered plan of action

Server Build

Buy the new server, build the OS, install required services (sshd, web server, mysql, etc)

Plan is to base this server on nginx, depending on testing.

Quick list of the planed setup ('RepRap' Matt (talk))

• ClonDNS (to handle all DNS)
• Linode 2gb (with Linode Backup)
• Jungle Disk ( Backups, To cloud files or S3, not sure which yet)
• Debian Wheezy
• IPv4 & IPv6 Enabled and Firewalled
• Ttckeeper (we log all changes to /etc, in a git repo so we know who to blame)
• Nginx (1.4.2 dotdeb maintained)
• PHP5-FPM (5.4 dotbeb maintained)
• Mysql (5.5, wheezy core)
• Postfix
• Dovecot
• OpenDKIM
• RoundCube
• ViMbAdmin (postfix webadmin, i think this will work for us)
• phpMyadmin
• new work press
• new mediawiki
• move content* move email* take backups

Web Root

Before most of the remaining changes can be made, the server will need to have a live webroot. Maybe we can repurpose nottinghack.co.uk temporarily, or register a new domain. Called <new-domain> in steps below.

All the steps below assume that the webroot is in the backup schedule

New Folder layout

The current basic layout of the nottinghack home folder is this:

/home/nottinghack/+
                  |-planet/                 < Planet back end
                  |-public_html/+           < Wordpress install
                  |             |-members/  < members guide pdf (not sure if this is still needed??)
                  |             |-p/        < Planet html files
                  |             |-w/        < Mediawiki install
                  |-www_secure/             < secure web files (dm2tweet)

But looking to move to something a little more separated:

/home/nottinghack/+
                  |-planet/                 < Planet back end
                  |-public_html/+             < Wordpress install
                  |           |-members/    < members guide pdf (not sure if this is still needed??)
                  |-public_planet/          < Planet html files
                  |-public_wiki/            < Mediawiki install
                  |-www_secure/             < secure web files (dm2tweet, Wordpress config, Mediawiki config)

I like this, but seeing as public_wp will actually just be the main site and include things like dm2tweet too, why don't we conform a little and call it public_html? James (talk) 02:18, 21 August 2013 (EST)
Happy to stick with publi_html --'RepRap' Matt (talk) 04:45, 22 August 2013 (EST)

Databaes

On the current server there is just one DB for WP and MW
New config will have three.

nh        < general
nh-wp     < wordpress only
nh-wiki   < media wiki only

Important design is separate DB's for WP and MW, but have also provisioned a third shared DB for other small things that might need it (planet, dm2tweet, instrumentation, HMS.... etc)

Each will have a it's one user, with the same name as the DB.

Planet

Easiest to move, so let's move it first. No actual data is involved.

Files

• Transfer the planet generation files outside of the webroot.
• Create necessary files underneath webroot (call folder "p")
• run generator to check that it is pulling in all blogs.

Set up

• Set "public_planet" as seperate site
• point planet.<new-domain> to point at this site
• Set up cron job to run generator

Final

Point planet.nottinghack.org.uk at site

Wiki

Has a lot of data, but less traffic than the website. Make sure wiki move it announced publicly We could put a temporary banner on the wiki, similar to wikipedia's fund-raising.

First steps

• Set up folder "public_wiki"
• point wiki.<new-domain> at "public_wiki"
• Install mediawiki on new server - version 1.19.2 (to match current)
  • Use wiki-only database
  • Do not set up any additional users
• Set up url rewriting
• Look into APC Cache settings http://www.mediawiki.org/wiki/Manual:$wgMainCacheType
• Install plugins (some of these are part of normal mediawiki install):
  • Interwiki
  • Renameuser
  • Replace Text
  • CSS
  • MagicNumberedHeadings
  • ParserFunctions
  • Poem
  • SyntaxHighlight
  • Widgets
  • ConfirmEdit
  • CategorySortHeaders
  • Vector
  • WikiEditor

Transfer

• point wiki.nottinghack.org.uk at splash page explaining transfer
• Take database dump
• Extract wiki tables
• Transfer media files
• Install database

Final

• Point wiki.nottinghack.org.uk at site
• Put wiki database into backup schedule

Website

First steps

• Update nottinghack.org.uk to latest Wordpress
• Update all plugins

Set up

• Install wordpress on <new-domain> under "public_wiki"
  • Use wordpress-only database
• Install custom theme
• Install wordpress-plugins
  • http://wordpress.org/plugins/w3-total-cache/
  • nginx compatibility http://www.linuxforu.com/2012/02/wordpress-nginx-part-2-domain-vhost-config-migrating-files-fine-tuning-mysql-apc/
• Install custom plugins
• Ensure url-rewriting working correctly

Transfer

We have two options - use the wordpress backup and restore functionality, or dump the database & media files and transfer manually. I suggest we try the backup and restore first, but I seem to remember that this causes a lot of issues with media.

• Put nottinghack.org.uk into maintenance mode

Final

• Point nottinghack.org.uk and www.nottinghack.org.uk at site
• Put wordpress database into backup schedule

Clean up

Other tools, such as dm2tweet will need moving as well. These can't be moved until nottinghack.org.uk is pointing at the new webroot.