| Server IP : 172.67.216.182 / Your IP : 162.158.106.238 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/rpl/t/ |
Upload File : |
# # ==== Purpose ==== # # This test script is created to test how filtering rules act # against CREATE/ALTER/DROP DATABASE commands (CAD commands) # Also it will check that there will be gtid empty transaction # created after these CAD commands are filtered out. # # ==== Implementation ==== # # USE-CASE 1: Test --replication-ignore-db=db1 filter # # S1: Install --replication-ignore-db=db1 filter on slave # S2: Try all three CAD statements (CREATE/ALTER/DROP) # S3: Check that they are filtered and check that there is no gap in # GTID_EXECUTED_SET. # USE-CASE 2: Repeat S1-S3 steps against --replicate-do-db=db2 filter rule. # USE-CASE 3: Repeat S1-S3 steps against --replicate-wild-ignore-table=db1.% # filter rule. # USE-CASE 4: Repeat S1-S3 steps against --replicate-do-db=db2 and # --replicate-wild-ignore-table=db1.t% filter rule. # # ==== References ==== # # Bug#27308751 FILTERED REPLICATION LEAVES GTID HOLES WITH CREATE DATABASE # --source include/have_gtid.inc --source include/have_binlog_format_statement.inc --source include/master-slave.inc --echo # --echo # Test replicate-ignore-db=db1 filter --echo # # # Test replicate-ignore-db=db1 filter rule on # CREATE/ALTER/DROP DATABASE 'db1' command # These commands should be skipped. # --let $rpl_server_number= 2 --let $rpl_start_with_gtids= 1 --let $rpl_server_parameters=--replicate-ignore-db=db1 --skip_slave_start=FALSE --source include/rpl_restart_server.inc --source extra/rpl_tests/rpl_db_stmts_ignored.inc --echo # --echo # Test replicate-do-db=db2 filter --echo # # # Test replicate-do-db=db2 filter rule on # CREATE/ALTER/DROP DATABASE 'db1' command # These commands should be skipped. # --let $rpl_server_number= 2 --let $rpl_start_with_gtids= 1 --let $rpl_server_parameters=--replicate-do-db=db2 --skip_slave_start=FALSE --source include/rpl_restart_server.inc --source extra/rpl_tests/rpl_db_stmts_ignored.inc --echo # --echo # Test replicate-wild-ignore-table=db1.% filter --echo # # # Test replicate-wild-ignore-table=db1.% filter rule on # CREATE/ALTER/DROP DATABASE 'db1' command. # These commands should be skipped. # --let $rpl_server_number= 2 --let $rpl_start_with_gtids= 1 --let $rpl_server_parameters=--replicate-wild-ignore-table=db1.% --skip_slave_start=FALSE --source include/rpl_restart_server.inc --source extra/rpl_tests/rpl_db_stmts_ignored.inc --echo # --echo # Test replicate-wild-ignore-table=db1.% and --replicate-do-db=db2 --echo # filter combination # # Test replicate-wild-ignore-table=db1.% and --replicate-do-db=db2 # filter combination rule on CREATE/ALTER/DROP DATABASE 'db1' command. # These commands should be skipped. # --let $rpl_server_number= 2 --let $rpl_start_with_gtids= 1 --let $rpl_server_parameters= --replicate-do-db=db2 --replicate-wild-ignore-table=db1.t% --skip_slave_start=FALSE --source include/rpl_restart_server.inc --source extra/rpl_tests/rpl_db_stmts_ignored.inc --echo # --echo # Cleanup --echo # --source include/force_restart.inc --source include/rpl_end.inc