750GB big. If you want to restore a mysql dump to an RDS instance, expect to encounter some issues on the first go-round. You’ll likely have to create a custom parameter group. You’ll likely have to increase your max_allowed_packet parameter for the instance.
So, do yourself a favor and create a parameter group up front and search for my.cnf tweaks that optimize the sort of workload your database will see.
By the way, the following error may be that your max_allowed_packet size is too small for your restore:
ERROR 2006 (HY000) at line 1466: MySQL server has gone away mysqldump: Got errno 32 on write
No comments:
Post a Comment