Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_heartbeat_ssl.test

raw
1 #############################################################
2 # Author: Serge Kozlov <[email protected]>
3 # Date: 02/19/2009
4 # Purpose: Testing basic functionality of heartbeat over SSL
5 #############################################################
6 --source include/not_group_replication_plugin.inc
7 --source include/master-slave.inc
8 --echo
9
10 #
11 # Testing heartbeat over SSL
12 #
13
14 # Heartbeat over SSL
15 --echo *** Heartbeat over SSL ***
16 --connection master
17 let $master_binlog= query_get_value(SHOW MASTER STATUS, File, 1);
18 --connection slave
19 --source include/stop_slave.inc
20 RESET SLAVE;
21 # Connect to master with SSL
22 --replace_result $MASTER_MYPORT MASTER_PORT $MYSQL_TEST_DIR MYSQL_TEST_DIR $master_binlog MASTER_BINLOG
23 --replace_column 2 ####
24 eval CHANGE REPLICATION SOURCE TO
25 SOURCE_HOST='127.0.0.1',
26 SOURCE_PORT=$MASTER_MYPORT,
27 SOURCE_USER='root',
28 SOURCE_HEARTBEAT_PERIOD=0.1,
29 SOURCE_LOG_FILE='$master_binlog',
30 SOURCE_SSL=1,
31 SOURCE_SSL_CA='$MYSQL_TEST_DIR/std_data/cacert.pem',
32 SOURCE_SSL_CERT='$MYSQL_TEST_DIR/std_data/client-cert.pem',
33 SOURCE_SSL_KEY='$MYSQL_TEST_DIR/std_data/client-key.pem';
34 --source include/start_slave.inc
35 # Check SSL state of slave
36 let $slave_ssl_status= query_get_value(SHOW SLAVE STATUS, Master_SSL_Allowed, 1);
37 --echo Master_SSL_Allowed: $slave_ssl_status
38 # Wait until hearbeat event is received
39 let $status_col_value= query_get_value(select count_received_heartbeats from performance_schema.replication_connection_status, count_received_heartbeats, 1);
40 let $status_col= count_received_heartbeats;
41 let $table=replication_connection_status;
42 let $status_col_comparsion= >;
43 --source include/wait_for_rpl_pfs_status.inc
44 --echo Heartbeat event has received
45 --echo
46 #
47 # Clean up
48 #
49 --echo *** Clean up ***
50 --source include/stop_slave.inc
51 --replace_column 2 ####
52 CHANGE REPLICATION SOURCE TO
53 SOURCE_SSL=0,
54 SOURCE_SSL_CA='',
55 SOURCE_SSL_CERT='',
56 SOURCE_SSL_KEY='';
57 --let $rpl_only_running_threads= 1
58 --source include/rpl_end.inc