include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
call mtr.add_suppression("The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
create table t1 (word char(20) not null);
load data infile '../../std_data/words.dat' into table t1;
load data local infile 'MYSQL_TEST_DIR/std_data/words.dat' into table t1;
select * from t1 limit 10;
word
Aarhus
Aaron
Ababa
aback
abaft
abandon
abandoned
abandoning
abandonment
abandons
include/sync_slave_sql_with_master.inc
stop slave;
set password for root@"localhost" = password('foo');
start slave;
set password for root@"localhost" = password('');
create table t3(n int);
insert into t3 values(1),(2);
include/sync_slave_sql_with_master.inc
select * from t3;
n
1
2
select sum(length(word)) from t1;
sum(length(word))
1022
drop table t1,t3;
include/sync_slave_sql_with_master.inc
create table t1 (n int) engine=myisam;
include/sync_slave_sql_with_master.inc
reset master;
stop slave;
reset slave;
include/assert.inc [We should have generated greater than 16 KB relay log]
lock tables t1 read;
start slave;
include/sync_slave_io_with_master.inc
unlock tables;
create table t2(id int);
insert into t2 values(connection_id());
create temporary table t3(n int);
insert into t3 select get_lock('crash_lock%20C', 1) from t2;
update t1 set n = n + get_lock('crash_lock%20C', 2);
select (@id := id) - id from t2;
(@id := id) - id
0
kill @id;
drop table t2;
drop temporary table if exists t3;
Got one of the listed errors
include/wait_for_slave_sql_error.inc [errno=1053]
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
include/start_slave.inc
select count(*) from t1;
count(*)
100
drop table t1;
create table t1 (n int);
insert into t1 values(3456);
insert into mysql.user (Host, User, Password)
VALUES ("10.10.10.%", "blafasel2", password("blafasel2"));
Warnings:
Warning	1364	Field 'ssl_cipher' doesn't have a default value
Warning	1364	Field 'x509_issuer' doesn't have a default value
Warning	1364	Field 'x509_subject' doesn't have a default value
select select_priv,user from mysql.user where user = _binary'blafasel2';
select_priv	user
N	blafasel2
update mysql.user set Select_priv = "Y" where User= _binary"blafasel2";
select select_priv,user from mysql.user where user = _binary'blafasel2';
select_priv	user
Y	blafasel2
include/sync_slave_sql_with_master.inc
select n from t1;
n
3456
select select_priv,user from mysql.user where user = _binary'blafasel2';
select_priv	user
Y	blafasel2
drop table t1;
delete from mysql.user where user="blafasel2";
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
