Add MySQL flexible server

[x4FF3]

SUMMARY

Add flexible as an option for mysql server.

ISSUE TYPE

• Feature Idea

COMPONENT NAME

azure_rm_mysql*

ADDITIONAL INFORMATION

As we are switching from standalone to flexible servers, it would be very useful to be able to deploy these servers via ansible.
@Fred-sun

[Fred-sun]

@x4FF3 Thank you for submitting this question, it is a very useful feature, we will review it as soon as possible. Thank you very much!

[feiyan-gh]

I also would like this feature

[Fred-sun]

Is doing！

[x4FF3]

Hi, any ETA on this?

[x4FF3]

@Fred-sun any update on this?

[feiyan-gh]

In the end I had to use direct call to azure cli to provision flexible servers. @x4FF3 you could try do the same.

[x4FF3]

Hi,

yes i also used the command module now...

[x4FF3]

@Fred-sun could you please add this feature? as of 16 jan 2023, only flexible servers can be created...

[Fred-sun]

@x4FF3 Ok， I will!

[Fred-sun]

@x4FF3 The SDK on which MySQL Server depends does not support the "flexible" parameter and cannot be added. Thanks!

[x4FF3]

@Fred-sun is the SDK also open source?

[Fred-sun]

@x4FF3 Open resource, relate link https://github.com/Azure/azure-sdk-for-python/tree/main/sdk/rdbms. Thank you very much!

[x4FF3]

the mysql sdk does not support flexible server, but https://github.com/Azure/azure-sdk-for-python/tree/main/sdk/rdbms/azure-mgmt-rdbms/azure/mgmt/rdbms/mysql_flexibleservers should be usable for an azure module?

[Fred-sun]

@x4FF3 Yes, it should be a new module support. Thanks!

[YanekR]

Hello, do we have any update on this. Would be good to have this feature as Single Servers are going to be shutdown soon.

[sicet7]

Hello,
Any update on this? 😅
Because as far as my google searching gets me, September 16, 2024 is the retirement date for the single server, we're getting awfully close 😅

@x4FF3 You mentioned you mentioned something about using the "command module" do you have an example of how one would do that? Thanks 😄

[Fred-sun]

Added by #1586