Difference between revisions of "Website 3.0 Migration Plan"

From CCCWiki
Jump to: navigation, search
(Go Live)
 
(2 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
In order to refresh the test enviroment, we need to:
 
In order to refresh the test enviroment, we need to:
 
# Copy the test database to backup database so we have backup of the changes we have made to the test environment.
 
# Copy the test database to backup database so we have backup of the changes we have made to the test environment.
# Copy the test files to the backup environment.
 
# Script changes to tables in the test database that we have been working on.
 
 
# Copy all files from production environment to the test environment without deleting the current files.
 
# Copy all files from production environment to the test environment without deleting the current files.
# Restore a copy of the production database to the test database.
+
# Script changes to tables in the production database that have been made.
 
# Apply scripted changes to the test database.
 
# Apply scripted changes to the test database.
 
# Apply manual changes to the test enviroment via admin interface.
 
# Apply manual changes to the test enviroment via admin interface.
 +
 +
The following tables need be copied:
 +
* ccc_acy*
 +
* ccc_akeeba*
 +
* ccc_contact_details
 +
* ccc_core_log_searches
 +
* ccc_jev*
 +
* ccc_menu*
 +
* ccc_messages*
 +
* ccc_version (does not work)
 +
* ccc_content (only new content)
 +
 +
We need to use these settings:
 +
* Data only
 +
* Truncate table
 +
* Maximum lenght: 5000000
  
 
= Migration Plan =
 
= Migration Plan =
Line 20: Line 34:
  
 
== Go Live ==
 
== Go Live ==
# Manually apply changes made in the last two weeks to test environment.
+
# Manually apply production changes made in the last two weeks to test environment.
 +
## Add noticesheets and newsletters
 
# Backup production environment
 
# Backup production environment
 
# Copy database and files from test enviroment to production.
 
# Copy database and files from test enviroment to production.

Latest revision as of 21:03, 12 August 2015

Strategy

In order to make sure that we can prepare and test the website in the best way possible, we will refresh the test website from the production website every two weeks. In order for this to be viable we will impose a freeze on every major changes from the start to the project and impose a freeze on production changes from two weeks before launch.

Refresh Process

In order to refresh the test enviroment, we need to:

  1. Copy the test database to backup database so we have backup of the changes we have made to the test environment.
  2. Copy all files from production environment to the test environment without deleting the current files.
  3. Script changes to tables in the production database that have been made.
  4. Apply scripted changes to the test database.
  5. Apply manual changes to the test enviroment via admin interface.

The following tables need be copied:

  • ccc_acy*
  • ccc_akeeba*
  • ccc_contact_details
  • ccc_core_log_searches
  • ccc_jev*
  • ccc_menu*
  • ccc_messages*
  • ccc_version (does not work)
  • ccc_content (only new content)

We need to use these settings:

  • Data only
  • Truncate table
  • Maximum lenght: 5000000

Migration Plan

Up To Two Weeks Before Go Live

Refresh test database with changes from production as described above every two weeks.

Two Weeks Before Go Live

Two weeks before go-live, we will institute a freeze on all production environment changes with the exception of the news section so we can test in a stable environment.

Go Live

  1. Manually apply production changes made in the last two weeks to test environment.
    1. Add noticesheets and newsletters
  2. Backup production environment
  3. Copy database and files from test enviroment to production.
  4. Perform checkout.

Manual Steps

The following steps will need to be executed manually as part of the migration:

  • Go to Content > Article Manager > Options and set Linked Titles to No
  • Go to Extentions > Module Manager > Options and set the positions for Search and Smart Search to head-search