How to Install Appvance IQ results database in Amazon MySQL RDS
Setting parameter group
After creating a MySQL RDS database in Amazon AWS, you need to create a new parameter group by navigating to RDS > Parameter Groups > Create parameter group
After group is created selected and Edit Parameters. Following values should be set:
|
log_bin_trust_function_creators |
1 |
|
bulk_insert_buffer_size |
536870912 |
|
connect_timeout |
10 |
|
max_allowed_packet |
104857600 |
|
max_connections |
500 |
|
max_user_connections |
200 |
|
myisam_use_mmap |
1 |
|
read_buffer_size |
524288 |
|
validate_password |
OFF |
|
wait_timeout |
1080 (AIQ-6619) |
Assign the new parameter group to your database
After creating the new parameter group in the previous step, assign it to the database and reboot it.
Look at the bottom left of the above image and notice the Parameter group assigned.
Then need to connect to the MySQL database using the admin credentials and execute the MySQLInitial.sql and then the MySQLAppvance.sql. No error should be visible in the execution of theses SQL scripts. If an error happens, then review the error message.
Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled
If you get the above error while running the MySQLAppvance.sql script on AWS RDS, make sure that the RDS parameter group has the value 1 (ON) for the log_bin_trust_function_creators parameter. The RDS database MUST be rebooted for parameter changes to take effect.