Open epopisces opened 8 months ago
Side note: I know I'm putting a number of issues on the board. I will try to get some time to fork this project and implement some of these fixes for the Terraform side of things, and submit a PR in the near future.
This is an awesome project, and I'd love to see it make others' REDCap journey on Azure smoother and more successful!
@epopisces Thanks for contributing the issues. We are actively discussing the value in maintaining the Terraform code. It's likely we will discontinue it and only maintain the Bicep.
Terraform supports MySQL Flexible server configuration using azurerm_mysql_flexible_server_configuration resources, one for each configuration entry. An addition to the variables.tf file with a supporting variable in addition to the configuration resource using a for_each loop would be ideal.
Example implementation (including locals for universal defaults): variables.tf
main.tf (see #51 & #52 for why these locals could be included as defaults)
While not as familiar with the other deployment options, I assume an analog could be created for those deployment options as well.
This will facilitate a number of other features, including enabling audit logging on the MySQL server, addressing the sql_generate_invisible_primary_key issue with MySQL 8.x (see REDCap community entries on that issue), and others.
Example usage in a tfvars file: