Friday 15 March 2013

mysql - configuring max_allowed_packet for Confluence on AWS -



mysql - configuring max_allowed_packet for Confluence on AWS -

i have set confluence on lamp stack on aws instance , need able adjust max_allowed_packet install addons. know aws prohibits editing my.cnf file , i've installed rds client. rds doesn't seem see existing confluence mysql database me assign db grouping larger packet allowance. missing alternative rds see it? there way this?

you can adjust max_allowed_packet modifying existing, or creating new rds parameter group. find many familiar configuration settings in parameter groups. if haven't touched parameter groups before, you'll find yours named default.mysql5.6 (or version equivalent) , need create new 1 customize own settings.

you can create new parameter grouping the:

aws console ("working parameter groups" describes creation of parameter groups , modification of individual settings) cli (docs: create-db-parameter-group) api (docs: createdbparametergroup)

you can modify settings the:

aws console (see above.) cli (docs: modify-db-parameter-group) api (docs: modifydbparametergroup)

when alter default parameter grouping custom parameter group, need reboot rds instance switch take effect. after that, need reboot individual settings if have "static" parameter type. max_allowed_packet dynamic parameter type, means alter take effect 1 time create it.

mysql amazon-web-services rds

No comments:

Post a Comment