mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
611f91605a
- created binlog_encryption test suite and added it to the default list - moved some tests from rpl, binlog and multisource suites to extra so that they could be re-used in different suites - made minor changes in include files
119 lines
3.8 KiB
Text
119 lines
3.8 KiB
Text
include/master-slave.inc
|
|
[connection master]
|
|
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement: insert into t2 set data=repeat.*'a', @act_size.*");
|
|
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement: insert into t1 values.* NAME_CONST.*'n',.*, @data .*");
|
|
set @save_binlog_cache_size = @@global.binlog_cache_size;
|
|
set @save_binlog_checksum = @@global.binlog_checksum;
|
|
set @save_master_verify_checksum = @@global.master_verify_checksum;
|
|
set @@global.binlog_cache_size = 4096;
|
|
set @@global.binlog_checksum = CRC32;
|
|
set @@global.master_verify_checksum = 1;
|
|
include/stop_slave.inc
|
|
include/start_slave.inc
|
|
flush status;
|
|
show status like "binlog_cache_use";
|
|
Variable_name Value
|
|
Binlog_cache_use 0
|
|
show status like "binlog_cache_disk_use";
|
|
Variable_name Value
|
|
Binlog_cache_disk_use 0
|
|
drop table if exists t1;
|
|
create table t1 (a int PRIMARY KEY, b CHAR(32)) engine=innodb;
|
|
create procedure test.p_init (n int, size int)
|
|
begin
|
|
while n > 0 do
|
|
select round(RAND() * size) into @act_size;
|
|
set @data = repeat('a', @act_size);
|
|
insert into t1 values(n, @data );
|
|
set n= n-1;
|
|
end while;
|
|
end|
|
|
begin;
|
|
call test.p_init(4000, 32);
|
|
commit;
|
|
show status like "binlog_cache_use";
|
|
Variable_name Value
|
|
Binlog_cache_use 1
|
|
*** binlog_cache_disk_use must be non-zero ***
|
|
show status like "binlog_cache_disk_use";
|
|
Variable_name Value
|
|
Binlog_cache_disk_use 1
|
|
include/diff_tables.inc [master:test.t1, slave:test.t1]
|
|
begin;
|
|
delete from t1;
|
|
commit;
|
|
flush status;
|
|
create table t2(a int auto_increment primary key, data VARCHAR(12288)) ENGINE=Innodb;
|
|
show status like "binlog_cache_use";
|
|
Variable_name Value
|
|
Binlog_cache_use 1
|
|
*** binlog_cache_disk_use must be non-zero ***
|
|
show status like "binlog_cache_disk_use";
|
|
Variable_name Value
|
|
Binlog_cache_disk_use 1
|
|
include/diff_tables.inc [master:test.t2, slave:test.t2]
|
|
begin;
|
|
delete from t2;
|
|
commit;
|
|
flush status;
|
|
create table t3(a int auto_increment primary key, data VARCHAR(8192)) engine=innodb;
|
|
show status like "binlog_cache_use";
|
|
Variable_name Value
|
|
Binlog_cache_use 1
|
|
*** binlog_cache_disk_use must be non-zero ***
|
|
show status like "binlog_cache_disk_use";
|
|
Variable_name Value
|
|
Binlog_cache_disk_use 1
|
|
include/diff_tables.inc [master:test.t3, slave:test.t3]
|
|
begin;
|
|
delete from t3;
|
|
commit;
|
|
flush status;
|
|
create procedure test.p1 (n int)
|
|
begin
|
|
while n > 0 do
|
|
case (select (round(rand()*100) % 3) + 1)
|
|
when 1 then
|
|
select round(RAND() * 32) into @act_size;
|
|
set @data = repeat('a', @act_size);
|
|
insert into t1 values(n, @data);
|
|
when 2 then
|
|
begin
|
|
select round(8192 + RAND() * 4096) into @act_size;
|
|
insert into t2 set data=repeat('a', @act_size);
|
|
end;
|
|
when 3 then
|
|
begin
|
|
select round(3686.4000 + RAND() * 819.2000) into @act_size;
|
|
insert into t3 set data= repeat('a', @act_size);
|
|
end;
|
|
end case;
|
|
set n= n-1;
|
|
end while;
|
|
end|
|
|
set autocommit= 0;
|
|
begin;
|
|
call test.p1(1000);
|
|
commit;
|
|
show status like "binlog_cache_use";
|
|
Variable_name Value
|
|
Binlog_cache_use 1
|
|
*** binlog_cache_disk_use must be non-zero ***
|
|
show status like "binlog_cache_disk_use";
|
|
Variable_name Value
|
|
Binlog_cache_disk_use 1
|
|
include/diff_tables.inc [master:test.t1, slave:test.t1]
|
|
include/diff_tables.inc [master:test.t2, slave:test.t2]
|
|
include/diff_tables.inc [master:test.t3, slave:test.t3]
|
|
begin;
|
|
delete from t1;
|
|
delete from t2;
|
|
delete from t3;
|
|
commit;
|
|
drop table t1, t2, t3;
|
|
set @@global.binlog_cache_size = @save_binlog_cache_size;
|
|
set @@global.binlog_checksum = @save_binlog_checksum;
|
|
set @@global.master_verify_checksum = @save_master_verify_checksum;
|
|
drop procedure test.p_init;
|
|
drop procedure test.p1;
|
|
include/rpl_end.inc
|