CSM PK Update investigation / feedback collection

Description

The Courseware Student Module table is going to run out of primary key ids. Our current answer to this problem is to increase the id field from a signed int to an unsigned big int.

A/C:

  • Achieve an understanding of how CSM is accessed

  • Find any additional tables that will need to be have their keys modified

  • Explore alternatives for how to alter the table(s) with minimal impact to learners and no loss of data

  • Write up findings and suggested way forward

  • Gather feedback on findings and suggestion, update the plan as necessary

Steps to Reproduce

None

Current Behavior

None

Expected Behavior

None

Reason for Variance

None

Release Notes

None

User Impact Summary

None

Activity

Show:
Brian Mesick
February 20, 2019, 8:13 PM

This document covers solutions we’ve looked at, and why we picked gh-ost: https://openedx.atlassian.net/wiki/spaces/PLAT/pages/949288994/CSM+Primary+Key+Problems+and+Solutions

And this one is the beginning of a runbook for gh-ost: https://openedx.atlassian.net/wiki/spaces/PLAT/pages/949583895/CSM+-+gh-ost+Runbook

Brian Mesick
February 20, 2019, 5:57 PM

I created this to capture the places that I could find which touch CSM directly: https://openedx.atlassian.net/wiki/spaces/PLAT/pages/948142104/CSM+-+Courseware+Student+Module+Touch+Points

Done

Assignee

Brian Mesick

Reporter

Brian Mesick

Labels

None

Reach

None

Impact

None

Platform Area

None

Customer

None

Partner Manager

None

URL

None

Contributor Name

None

Groups with Read-Only Access

None

Actual Points

5

Category of Work

None

Platform Map Area (Levels 1 & 2)

None

Platform Map Area (Levels 3 & 4)

None

Story Points

5

Priority

Unset