bzr push into mysql-5.1 branch (Rafal.Somla:3449 to 3450)

[Rafal Somla]

 3450 Rafal Somla	2010-05-04
      Common infrastructure for testing MEB tools.
      
      This patch contains infrastructure for invoking
      MEB tools from test scripts.
     @ mysql-test/include/have_meb.inc
        File to be included by meb tests. Test will be skipped if
        IBBACKUP or INNOBACKUP variables are not set, will fail if
        they do not point at the tools. Also setups backup directory
        and config file for ibbackup tool.
        
        NOTE: PATH setting is temporary and needs to be reworked.
     @ mysql-test/suite/meb/my.cnf
        Configuration for server instance used in meb
        tests. Innodb options used by MEB tools are 
        explicitly set because these tools do not know
        the details. Relevant settings are also exported to
        the environment.
     @ mysql-test/suite/meb/t/ibb_example.test
        Example showing how to use ibbackup tool in a test.
     @ mysql-test/suite/meb/t/inb_example.test
        Example showing how to use innobackup in a test.

    added:
      mysql-test/include/have_meb.inc
      mysql-test/suite/meb/my.cnf
      mysql-test/suite/meb/t/ibb_example.test
      mysql-test/suite/meb/t/inb_example.test
 3449 Ingo Struewing	2010-05-04
      WL#5322 - Verify data consistency in IHB
      
      This patch contains a couple of include files to use for
      test data creation, selection and cleanup.
     @ mysql-test/suite/meb/include/extreme_data.inc
        WL#5322 - Verify data consistency in IHB
        New include file for test data set up.
     @ mysql-test/suite/meb/include/extreme_drop.inc
        WL#5322 - Verify data consistency in IHB
        New include file for test data clean up.
     @ mysql-test/suite/meb/include/extreme_show.inc
        WL#5322 - Verify data consistency in IHB
        New include file for test data selection.

    added:
      mysql-test/suite/meb/include/extreme_data.inc
      mysql-test/suite/meb/include/extreme_drop.inc
      mysql-test/suite/meb/include/extreme_show.inc
=== added file 'mysql-test/include/have_meb.inc'
--- a/mysql-test/include/have_meb.inc	1970-01-01 00:00:00 +0000
+++ b/mysql-test/include/have_meb.inc	2010-05-04 14:51:06 +0000
@@ -0,0 +1,70 @@
+#
+# Check that MEB is available and prepare for using MEB tools
+# in test scripts.
+#
+
+--disable_query_log
+if (`select '$IBBACKUP'='' OR '$INNOBACKUP'=''`)
+{
+--skip You must set IBBACKUP and INNOBACKUP variables to run this test.
+}
+--enable_query_log
+
+--perl
+if (! -x "$ENV{'IBBACKUP'}")
+{
+  die "Can't find ibbackup tool at \"$ENV{'IBBACKUP'}\"\n";
+}
+if (! -f "$ENV{'INNOBACKUP'}")
+{
+  die "Can't find innobackup tool at \"$ENV{'INNOBACKUP'}\"\n";
+}
+EOF
+
+#
+# Setup environment for using MEB tools.
+#
+
+let $INNOBACKUP= perl -w $INNOBACKUP --ibbackup=$IBBACKUP;
+#
+# Note: Server's my.cnf file is created based on the my.cnf specification
+# in the meb suite directory.
+#
+let $SERVER_CNF= $MYSQLTEST_VARDIR/my.cnf;
+let BACKUP_DIR=  $TMP_DIR/backup;
+let BACKUP_CNF= $TMP_DIR/ib.cnf;
+
+#
+# FIXME: make it portable (windows) and work also in binary distribution
+# where clients are placed in a different path.
+#
+let PATH=../client:$PATH;
+
+--perl
+
+$backup_dir= "$ENV{BACKUP_DIR}";
+
+#
+# Create $BACKUP_DIR if it does not exist.
+#
+unless (-d $backup_dir)
+{
+  mkdir($backup_dir) or die "Can't create backup directory \"$backup_dir\"\n";
+}
+
+#
+# Wtite the .cnf file specyfying backup locations for the ibbackup tool.
+# We use environment variables storing server's innodb settings. These variables
+# are initialized by MTR during server setup, as specified by suite/meb/my.cnf.
+#
+open (CNF, ">$ENV{BACKUP_CNF}") or die "Can't write to \"$ENV{BACKUP_CNF}\"\n";
+
+print CNF "datadir= $backup_dir\n";
+print CNF "innodb_data_home_dir= $backup_dir\n";
+print CNF "innodb_log_group_home_dir= $backup_dir\n";
+print CNF "innodb_data_file_path= $ENV{IDATA_PATH}\n";
+print CNF "innodb_log_files_in_group= $ENV{ILOG_COUNT}\n";
+print CNF "innodb_log_file_size= $ENV{ILOG_SIZE}\n";
+
+close CNF;
+EOF

=== added file 'mysql-test/suite/meb/my.cnf'
--- a/mysql-test/suite/meb/my.cnf	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/meb/my.cnf	2010-05-04 14:51:06 +0000
@@ -0,0 +1,31 @@
+# Use defaults
+!include include/default_my.cnf
+
+[mysqld]
+#
+# Note: it is important to use loose-innodb_data_file_path option
+# because only this overwrites the defaults.
+#
+loose-innodb_data_file_path= ibdata1:10M;ibdata2:10M:autoextend
+innodb_log_file_size= 5M
+innodb_log_files_in_group= 3
+innodb= on
+#
+# Note: these parameters must be set here in the [mysqld] section
+# so that the innobackup script can read them.
+#
+datadir=                   @mysqld.1.datadir
+innodb_data_home_dir=      @mysqld.1.datadir
+innodb_log_group_home_dir= @mysqld.1.datadir
+innodb_data_file_path=     @mysqld.loose-innodb_data_file_path
+
+[mysqld.1]
+innodb_data_home_dir= @mysqld.1.datadir
+innodb_log_group_home_dir= @mysqld.1.datadir
+
+[ENV]
+DATA_DIR=   @mysqld.1.datadir
+TMP_DIR=    @mysqld.1.tmpdir
+IDATA_PATH= @mysqld.innodb_data_file_path
+ILOG_SIZE=  @mysqld.innodb_log_file_size
+ILOG_COUNT= @mysqld.innodb_log_files_in_group

=== added file 'mysql-test/suite/meb/t/ibb_example.test'
--- a/mysql-test/suite/meb/t/ibb_example.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/meb/t/ibb_example.test	2010-05-04 14:51:06 +0000
@@ -0,0 +1,32 @@
+--source include/have_innodb.inc
+--source include/have_meb.inc
+
+--echo "IBBACKUP   is: $IBBACKUP"
+--echo "INNOBACKUP is: $INNOBACKUP"
+--echo "DATA_DIR   is: $DATA_DIR"
+--echo "BACKUP_DIR is: $BACKUP_DIR"
+--echo "SERVER_CNF is: $SERVER_CNF"
+--echo "BACKUP_CNF is: $BACKUP_CNF"
+
+--echo == Preparing test data
+--disable_query_log
+let $ENGINE_1 = MyISAM;
+let $ENGINE_2 = InnoDB;
+let $ENGINE_3 = InnoDB;
+let $ENGINE_3_USES_TABLESPACE = 0;
+--source suite/meb/include/extreme_data.inc
+--enable_query_log
+
+--echo == Running ibbackup
+--exec $IBBACKUP $SERVER_CNF $BACKUP_CNF
+--exec ls -l $BACKUP_DIR
+
+--echo == Applying log
+--exec $IBBACKUP --apply-log $BACKUP_CNF
+--exec ls -l $BACKUP_DIR
+
+# TODO: restart server with restored data.
+
+--echo == DONE ==
+--abort
+--exit

=== added file 'mysql-test/suite/meb/t/inb_example.test'
--- a/mysql-test/suite/meb/t/inb_example.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/meb/t/inb_example.test	2010-05-04 14:51:06 +0000
@@ -0,0 +1,38 @@
+--source include/have_innodb.inc
+--source include/have_meb.inc
+
+--echo "IBBACKUP   is: $IBBACKUP"
+--echo "INNOBACKUP is: $INNOBACKUP"
+--echo "DATA_DIR   is: $DATA_DIR"
+--echo "BACKUP_DIR is: $BACKUP_DIR"
+--echo "SERVER_CNF is: $SERVER_CNF"
+--echo "BACKUP_CNF is: $BACKUP_CNF"
+
+--echo == Preparing test data
+--disable_query_log
+let $ENGINE_1 = MyISAM;
+let $ENGINE_2 = InnoDB;
+let $ENGINE_3 = InnoDB;
+let $ENGINE_3_USES_TABLESPACE = 0;
+--source suite/meb/include/extreme_data.inc
+--enable_query_log
+
+let $inbopts= --no-timestamp;
+let $inbopts= $inbopts --port=$MASTER_MYPORT;
+let $inbopts= $inbopts --user=root; 
+
+# Note: The destination directory $BACKUP_DIR/innobackup must not exist.
+
+--echo == Running innobackup
+--exec $INNOBACKUP $inbopts $SERVER_CNF $BACKUP_DIR/innobackup 2>&1
+--exec ls -l $BACKUP_DIR/innobackup
+
+--echo == Applying log
+--exec $INNOBACKUP $inbopts --apply-log $SERVER_CNF $BACKUP_DIR/innobackup 2>&1
+--exec ls -l $BACKUP_DIR/innobackup
+
+# TODO: restore part (stop server, copy files, restart server).
+
+--echo == DONE ==
+--abort
+--exit


Attachment: [text/bzr-bundle] bzr/[e-mail]