Destination Mariadb Columnstore: add SSL support

[animer3009]

Tell us about the problem you're trying to solve

Add ssl support for for Mariadb columnstore destination connector. We are using SkySQL cloud Mariadb columnstore cloud database and they do not support connection without ssl.

Describe the solution you’d like

Describe the alternative you’ve considered or used

Additional context

Are you willing to submit a PR?

Remove this with your answer :-)

[natalyjazzviolin]

@animer3009 do you have any ideas for a solution or an alternative you're currently using/have considered using? I've edited the initial comment with our standard template - please feel free to fill it out some more if you've got more details/ideas!

[animer3009]

@natalyjazzviolin Nope, we just asking for SSL support for Mariadb CS destination connector

[natalyjazzviolin]

Got it! I've triaged this to the appropriate team, so they should take it over from here!

[yurii-bidiuk]

MariaDB supports the following SSL modes: disable: Do not use SSL/TLS (default) trust: Only use SSL/TLS for encryption. Do not perform certificate or hostname verification. This mode is not safe for production applications. verify-ca: Use SSL/TLS for encryption and perform certificates verification, but do not perform hostname verification. verify-full: Use SSL/TLS for encryption, certificate verification, and hostname verification

In the scope of this ticket we need to:

• Modify spec.json by adding a drop-down menu with SSL modes described above.
• Implement handling for each mode and certificates generation on the destination side
• Implement integration tests
• Configure the test MariaDB container to enable SSL for the server
• Verify if normalization requires any changes for SSL