Moving to RDS requires importing your database into theirs. As with any over-the-network database import, there is definitely a time factor involved as I waited for the data to transfer.
Fixed a few problems:
- Support especially long insert queries. With my entire 5G database, only one query exceeded the default maximum query length, but one is enough to justify the adjustment.
- Import the views without access to the SUPER privilege. The key is to remove the DEFINER line. That relies on rules that may not exist in RDS. A simple
egrep -v DEFINERcan remove the (generally unnecessary) line that generates errors:
/*!50013 DEFINER=`cpnp`@`localhost` SQL SECURITY DEFINER */.
- Support larger group_concat() values:
rds-modify-db-parameter-group mydbparam --parameters "name=group_concat_max_len,value=1048576,method=immediate"