2018-12-19 Data Migration to AWS

back to Project

Table of Contents

ACTION ITEMS:

• Greg & Lynette - will explore how to copy solr core from current production to AWS stg (prereq: stable stg)
• Lynette - create a dump of current database
• Greg - copy and import dump to AWS-stg database
• Lynette - update app to support s3
• Greg - copy public/uploads/spotlight to s3

Agenda

• Solr
• Database
• Data (uploaded items)

Meeting Materials

• Project Page

Notes

Solr

• Attempt 1:  try copying the v6 core and plopping it into the v7 solr  (Greg will do this.)
• Attempt 2:  run reindex everything  (Lynette)
• Attempt 3:  create a migration script  (Lynette)

Reference: Importing Solr Cores from One Old Solr to Another

Database

• database dump and import  (Greg will do this.)
  • mysqldump
  • mysql import

Process documented: Porting Database from Current Production to AWS

Data (uploaded items)

• reconfigure spotlight to store all data currently in public/uploads/spotlight in s3  (Lynette)
• copy data from current production to s3 (Greg will do this.)

Misc Files

public/uploads/spotlight/...

Target:  s3

Sysopts defines path and credentials in AWS config parameters.

Access: 

• Carrierwave
• Carrierwave-s3 gem

Question: How to configure location of these files in the app?

• Documented in Best Practices for Rails app using Elasticbeanstalk - Setting up s3 data section

Attendees

• Lynette Rayle
• Jenn Colt
• Melissa Wallace
• Greg Delisle

Absent