By default RDS table name is case sensitive. For ClassHub we actually want table names comparison to be case insensitive regardless whether table names are stored as upper or lower case. (Originally ClassHub database was created in a MySQL that stores table names in lower case.)

To do this we need to set the MySQL config:

lower_case_table_names=1

If RDS is Aurora then we need to a new “DB Cluster Parameter Group” and set “lower_case_table_names” to 1. Note, unlike MySQL, we need to do this in a cluster parameter group. Modify cluster to use this new cluster parameter group and stop/start cluster to take effect.

02/06/2020: currently ClassHub database lives in “rds2” on a “db.m1.small” instance. The “m1.small” instance type is expensive and RDS no longer has a reserve instance available for this instance type. Plan to migrate to “db.t3.small” instance type using “Migration from Snapshot” feature.