63 lines
2.0 KiB
Plaintext
63 lines
2.0 KiB
Plaintext
--disable_warnings
|
|
|
|
--connect (conn1,127.0.0.1,root,,test,$MYPORT_1)
|
|
--connect (conn2,127.0.0.1,root,,test,$MYPORT_2)
|
|
|
|
--connection conn1
|
|
stop slave;
|
|
change master to master_host = '127.0.0.1', master_port = 7806, master_user = 'repl', master_password = '123456' for channel 'aaa';
|
|
start slave for channel 'aaa';
|
|
stop slave;
|
|
start slave;
|
|
stop slave for channel "aaa";
|
|
start slave for channel "aaa";
|
|
--error ER_CONSENSUS_SERVER_NOT_READY
|
|
stop xpaxos_replication;
|
|
--error ER_CONSENSUS_SERVER_NOT_READY
|
|
start xpaxos_replication;
|
|
stop slave;
|
|
reset slave all for channel 'aaa';
|
|
--connection conn2
|
|
stop xpaxos_replication;
|
|
reset slave;
|
|
#
|
|
# mysql> show consensus logs;
|
|
# +-------------------+-----------+-----------------+
|
|
# | Log_name | File_size | Start_log_index |
|
|
# +-------------------+-----------+-----------------+
|
|
# | master-bin.000001 | 1268 | 1 |
|
|
# | master-bin.000002 | 252 | 5 |
|
|
# +-------------------+-----------+-----------------+
|
|
#
|
|
# --replace_column 1 # 2 # 3 #
|
|
# show consensus logs;
|
|
start xpaxos_replication;
|
|
|
|
--error ER_SLAVE_CHANNEL_DOES_NOT_EXIST
|
|
start slave for channel '';
|
|
--error ER_SLAVE_CHANNEL_DOES_NOT_EXIST
|
|
stop slave for channel '';
|
|
|
|
--let $sql_running= query_get_value("show slave status", Slave_SQL_Running, 1)
|
|
--echo $sql_running
|
|
--let $sql_running= query_get_value("show slave status for channel ''", Slave_SQL_Running, 1)
|
|
--echo $sql_running
|
|
|
|
--enable_warnings
|
|
|
|
|
|
--connection conn1
|
|
--error ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE
|
|
set global relay_log_info_repository='file';
|
|
set global relay_log_info_repository='table';
|
|
select count(1) from mysql.slave_relay_log_info where number_of_workers = (select count(1) from mysql.slave_worker_info);
|
|
|
|
--connection conn2
|
|
--error ER_SLAVE_CHANNEL_MUST_STOP
|
|
set global relay_log_info_repository='file';
|
|
stop xpaxos_replication;
|
|
set global relay_log_info_repository='file';
|
|
set global relay_log_info_repository='table';
|
|
start xpaxos_replication;
|
|
select count(1) from mysql.slave_relay_log_info where number_of_workers = (select count(1) from mysql.slave_worker_info);
|