Bug #96302 cloning: support CIDR notation for clone-valid-donor-list

• Submitted: 24 Jul 2019 6:09
• Modified: 24 Jul 2019 7:37
• Reporter: Simon Mudd (OCA)
• Status: Verified
• Category: MySQL Server: Clone Plugin
• Severity: S4 (Feature request)
• Version: 8.0.17
• OS: Any
• CPU Architecture: Any
• Tags: clone-valid-donor-list

[24 Jul 2019 6:09] Simon Mudd

Description:
When using the new cloning facility it may be that the number of possible clone sources is large. Currently you have to provide and set a variable to allow cloning to happen and this is a list of host:port values.

This is not practical for managing a large fleet.

Adding support for CIDR notation would make this much more convenient.

I am also somewhat confused about the need for the variable in the first place at least for doing adhoc cloning as I need to specify the server:port I want to connect to so why do I also need to specify a clone-valid-donor-list setting?

I am guessing this is for something related to auto setup for group replication but it does not seem to make that much sense to me. Clarifying this in the documentation would be good.

How to repeat:
Checking cloning instructions in the documentation.

Suggested fix:
Rather than just supporting 'host1:port1,host2:port2,...' allow something like:

'network/range:port' as well.

So I could have:

'host1:port1,10.0.0.0/8:3306,172.16.0.0/12:3306,1.2.3.4:3306'

[24 Jul 2019 6:10] Simon Mudd

change to feature request.

[24 Jul 2019 6:12] Simon Mudd

Also I am inclined to think that the port should be optional and if not specified use/assume :3306.

[24 Jul 2019 6:21] MySQL Verification Team

Hello Simon,

Thank you for the reasonable feature request!

regards,
Umesh

[24 Jul 2019 7:37] Simon Mudd

Reference to the variable is here:
* https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-options-variables.html
* https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html