################################################################################ # # WL#12571: Support fully qualified hostnames longer than 60 characters # # This test validates that if the user sets up the member to report # a specific hostname larger then 60 chars, the group replication # performance_schema tables are able to display it. # ################################################################################ --let $group_replication_group_name= `SELECT UUID()` --source include/have_group_replication_plugin.inc --source include/force_restart.inc --let $lengthy_hostname=host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890 --connection server1 --source include/start_and_bootstrap_group_replication.inc --echo ##################################################################### --echo # 1.a Verify that when startup options report-host is not set, its value --echo # shown on MEMBER_PORT value is as defined on rpl_1slave_base.cnf --let $assert_text= The performance_schema.replication_group_members.MEMBER_HOST matches with hostname system variable --let $assert_cond= "[SELECT MEMBER_HOST FROM performance_schema.replication_group_members]" = "127.0.0.1"; --source include/assert.inc --echo ##################################################################### --echo # 2. Verify that when startup options report-host and report-port are --echo # set, performance_schema.replication_group_members.MEMBER_HOST and --echo # MEMBER_PORT are set equal to report-host and report-port. --let $new_host= $lengthy_hostname --let $new_port= 24844 # restart server with report-host and report-port parameters --let $allow_rpl_inited=1 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address` --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds` --let $restart_parameters=restart:--report-host=$new_host --report-port=$new_port --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS --source include/restart_mysqld.inc --let $rpl_connection_name= server1 --source include/rpl_connection.inc --enable_reconnect --source include/start_and_bootstrap_group_replication.inc --let $i=1 while($i>0) { if ($i == 1) { # # 1. Assertion: assert that the hostname reported in SHOW SLAVE STATUS is correct # --let $hostname_read= `SELECT MEMBER_HOST FROM performance_schema.replication_group_members` --let $hostname_source= performance_schema.replication_group_members } --let $assert_cond= "$hostname_read" = "$lengthy_hostname" --let $assert_text= Hostname in $hostname_source matches the one set through CHANGE MASTER TO --source include/assert.inc --dec $i } --source include/stop_group_replication.inc # clean up --let $restart_parameters=