72 lines
3.1 KiB
Plaintext
72 lines
3.1 KiB
Plaintext
################################################################################
|
|
#
|
|
# 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=
|