Bug #96305 cloning: Make CLONE INSTANCE ':port' part optional and default to 3306

• Submitted: 24 Jul 2019 7:42
• Modified: 25 Jul 2019 6:45
• Reporter: Simon Mudd (OCA)
• Status: Verified
• Category: MySQL Server: Clone Plugin
• Severity: S4 (Feature request)
• Version: 8.0.17
• OS: Any
• CPU Architecture: Any

[24 Jul 2019 7:42] Simon Mudd

Description:
The CLONE INSTANCE SYNTAX requires user@host:port as parameters. MySQL has a default port of 3306 so I would suggest that this last part the port) should be optional and default to 3306.

How to repeat:
See: https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html

Current syntax is:

CLONE INSTANCE FROM USER@HOST:PORT
IDENTIFIED BY 'password'
[DATA DIRECTORY [=] 'clone_dir']
[REQUIRE [NO] SSL];

Suggested fix:
Suggestion is to support the syntax:

CLONE INSTANCE FROM USER@HOST[:PORT]
IDENTIFIED BY 'password'
[DATA DIRECTORY [=] 'clone_dir']
[REQUIRE [NO] SSL];

and if not provided use port 3306 (default mysql port) as the default.

[25 Jul 2019 6:45] MySQL Verification Team

Hello Simon,

Thank you for the reasonable feature request!

regards,
Umesh