Cannot create mysql database

[cieslarmichal]

Describe what happened

We are trying to setup mysql database and we encountered two issues:

1. clusterSize does not accept 2 nodes (only 1 or 3), incompatible with Linode API where we can use 1 or 2 or 3 nodes.
2. database cannot be created because of Configuring replication_type is no longer supported error even though we are not providing this option.

Sample program

  const prodDb = new linode.DatabaseMysql("mysql-production-db", {
    label: "mysql-production-db",
    engineId: "mysql/8.0.26",
    region: linodeRegion,
    type: "g6-dedicated-16",
    clusterSize: 3,
    allowLists: [...linodeInstancesIpAddresses, ...appgateFirewallIps],
  });

Log output

Diagnostics:
  linode:index:DatabaseMysql (mysql-production-db):
    error:   sdk-v2/provider2.go:520: sdk.helper_schema: failed to create mysql database: [400] [replication_type] Configuring replication_type is no longer supported; [engine] invalid engine: [email protected]
    error: 1 error occurred:
    	* failed to create mysql database: [400] [replication_type] Configuring replication_type is no longer supported; [engine] invalid engine

  pulumi:pulumi:Stack (stream-dev):
    error: update failed

  linode:index:DatabaseMysql (mysql-staging-db
):
    error:   sdk-v2/provider2.go:520: sdk.helper_schema: failed to create mysql database: [400] [replication_type] Configuring replication_type is no longer supported; [engine] invalid engine: [email protected]

  linode:index:DatabaseMysql (mysql-staging-db):
    error: 1 error occurred:
    	* failed to create mysql database: [400] [replication_type] Configuring replication_type is no longer supported; [engine] invalid engine

Affected Resource(s)

DatabaseMysql

Output of pulumi about

CLI
Version      3.145.0
Go Version   go1.23.4
Go Compiler  gc

Plugins
KIND      NAME        VERSION
resource  aws         6.66.2
resource  kubernetes  4.19.0
resource  linode      4.22.1
language  nodejs      3.145.0

Host
OS       darwin
Version  15.1.1
Arch     arm64

Dependencies:
NAME                              VERSION
@typescript-eslint/parser         8.19.1
@pulumi/kubernetes                4.19.0
@eslint/js                        9.17.0
@pulumi/aws                       6.66.2
@pulumi/linode                    4.30.1
@pulumi/pulumi                    3.144.1
@typescript-eslint/eslint-plugin  8.19.1
eslint                            9.17.0
globals                           15.14.0
@eslint/eslintrc                  3.2.0
eslint-plugin-prettier            5.2.1
@types/node                       22.10.5
typescript                        5.7.2
eslint-config-prettier            9.1.0

Additional context

No response

Contributing

Vote on this issue by adding a 👍 reaction.
To contribute a fix for this issue, leave a comment (and link to your pull request, if you've opened one already).

[VenelinMartinov]

Hey @cieslarmichal. Sorry you've had issues here and thanks for reporting.

Your provider seems quite out of date. Can you please upgrade to the newest version and see if the issue persists?

[godartm]

hey @VenelinMartinov ,
Might the issue be related to : linode/terraform-provider-linode#1669 ?
I also have the same issue with everything up to date.

CLI          
Version      3.145.0
Go Version   go1.23.4
Go Compiler  gc

Plugins
KIND      NAME    VERSION
language  go      3.145.0
resource  linode  4.31.0

Host     
OS       darwin
Version  15.2
Arch     arm64

Dependencies:
NAME                                    VERSION
github.com/pulumi/pulumi-linode/sdk/v4  v4.31.0
github.com/pulumi/pulumi/sdk/v3         v3.146.0

[godartm]

To add more information , i created the database manualy on the linode side and i tried to import it. with :

pulumi import linode:index/databaseMysql:DatabaseMysql xxxxx-xxxx 123456

And i got the following Diagnostics:

Diagnostics:
  linode:index:DatabaseMysql (xxxx-xxxx):
    warning: One or more imported inputs failed to validate. This is almost certainly a bug in the `linode` provider. The import will still proceed, but you will need to edit the generated code after copying it into your program.
    warning: linode:index/databaseMysql:DatabaseMysql resource 'xxxxx-xxxx' has a problem: expected duration to be in the range (1 - 3), got 4. Examine values at 'xxxxx-xxxxx.updates.duration'.
    warning: linode:index/databaseMysql:DatabaseMysql resource 'xxxxx-xxxx' has a problem: expected replication_type to be one of ["none" "asynch" "semi_synch"], got . Examine values at 'xxxxx-xxxxx.replicationType'.

[VenelinMartinov]

Hey @godartm thanks for checking the latest version. You have correctly identified the source of the issue. Unfortunately, there's not much we can do on our side to fix this.

You might be able to work around the issue if you imported as you tried, and then added an ignore_changes for the warnings you got: https://www.pulumi.com/docs/iac/concepts/options/ignorechanges