09 April 2011

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:

  1. 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.
  2. 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 DEFINER can remove the (generally unnecessary) line that generates errors: /*!50013 DEFINER=`cpnp`@`localhost` SQL SECURITY DEFINER */.
  3. Support larger group_concat() values: rds-modify-db-parameter-group mydbparam --parameters "name=group_concat_max_len,value=1048576,method=immediate"

blog comments powered by Disqus