All Linux HowTo's

Enabling Triggers within RDS (Amazon)

By default, Amazon’s AWS RDS databases don’t permit Triggers. This article explains how to change that.

Source: “http://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/”.

  1. Open the RDS web console.
  2. Open the “Parameter Groups” tab.
  3. Create a new Parameter Group. On the dialog, select the MySQL family compatible to your MySQL database version, give it a name and confirm.
  4. Select the just created Parameter Group and issue “Edit Parameters”.
  5. Look for the parameter ‘log_bin_trust_function_creators’ and set its value to “1”.
  6. Save the changes.
  7. Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”.
  8. Select the just created Parameter Group and enable “Apply Immediately”.
  9. Click on “Continue” and confirm the changes.
  10. Again, open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”.
  11. Dont forget: Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Reboot”.

The last step to restart the database is important. Despite the wording of the RDS web interface, the databases does still need to be restarted.

Similar Posts: