Implement init_settings on RDB

[abarbare]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

RDB got an init_settings flag. This flag can only be specified at instance creation and is useful for now only on MySQL.

Could you add a new RDB flag to specify those special settings?

The API doc: https://developers.scaleway.com/en/products/rdb/api/#init-settings-9b8176

New or Affected Resource(s)

• scaleway_rdb_instance

Potential Terraform Configuration

# Copy-paste your Terraform configurations here - for large Terraform configs,
# please use a service like Dropbox and share a link to the ZIP file. For
# security, you can also encrypt the files using our GPG public key.

References

• #0000

[mmaryo]

Hello, This is the error I got

resource "scaleway_rdb_instance" "main" {
  name           = local.name
  node_type      = var.db_type
  engine         = var.db_version
  is_ha_cluster  = true
  disable_backup = true
  user_name      = var.db_username
  password       = random_password.master.result
  settings = {
    "max_connections" = 350
    "lower_case_table_names" = 1
  }
}

Error: scaleway-sdk-go: resource lower_case_table_names with ID is not found

[Monitob]

@mmaryo Thank you for your report. You will find the new flag init_settings on the next release. You will be available to consult the available settings and init_settings by the CLI scaleway.