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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Clone Plugin Severity:S4 (Feature request)
Version:8.0.17 OS:Any
Assigned to: 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