mysql_replication: CHANGE REPLICATION SOURCE TO statement support

[dennisurtubia]

SUMMARY

Adds CHANGE REPLICATION SOURCE TO statement support.

ISSUE TYPE

• Feature Idea

COMPONENT NAME

community.mysql.mysql_replication module

ADDITIONAL INFORMATION

The CHANGE MASTER TO statement was deprecated. MySQL doc

Example using Group Replication:

CHANGE REPLICATION SOURCE TO SOURCE_USER='rpl_user', SOURCE_PASSWORD='password' \ 
FOR CHANNEL 'group_replication_recovery';

- name: CHANGE REPLICATION TO SOURCE usage 
  community.mysql.mysql_replication:
    mode: changereplication
    primary_user: rpl_user
    primary_password: password
    channel: group_replication_recovery

[Andersson007]

@dennisurtubia hello, thanks for reporting the issue! I'll put the help wanted label to indicate that it's vacant

[laurent-indermuehle]

And yet another MySQL vs MariaDB difference to handle: primary if db_engine == 'mariadb' else source.

[dennisurtubia]

@dennisurtubia hello, thanks for reporting the issue! I'll put the help wanted label to indicate that it's vacant

Hey @Andersson007, Idk if this is a good first issue, but, I would love to work on this

[Andersson007]

@dennisurtubia great, thanks! There's a quick start dev guide that can be handy.
If you have any questions along the way, we'll be happy to help, just post them here

[poyrazus]

Do you also have plans to update getprimary function for mysql 8.4? It's not anymore SHOW MASTER STATUS but SHOW BINARY LOG STATUS. Support for SHOW MASTER STATUS is already removed in 8.4, so it gives error.

[dennisurtubia]

Do you also have plans to update getprimary function for mysql 8.4? It's not anymore SHOW MASTER STATUS but SHOW BINARY LOG STATUS. Support for SHOW MASTER STATUS is already removed in 8.4, so it gives error.

Hello, @poyrazus. I can work on this!

In case, I suggest we create a new mode, something like show_binary_log_status, since this statement is only supported in MySQL >= 8.2.0.

It's make sense @laurent-indermuehle @Andersson007?

[laurent-indermuehle]

@dennisurtubia in mysql_info and mysql_user (from memory, the truth is in the code) we have methods to get the engine (mysql|mariadb) and the version. So we can reliably implement method only for specific version (using the handy is version('8.4','>=')).