**** get master log position for replication slave *** master : prepare for replication File Position Binlog_do_db Binlog_ignore_db it312-35-bin.002 79 **** stop master *** stop mysql with default table type Innodb 2596 pts/0 00:00:00 mysqld 2598 pts/0 00:00:00 mysqld 2599 pts/0 00:00:00 mysqld 2600 pts/0 00:00:00 mysqld 2601 pts/0 00:00:00 mysqld 2602 pts/0 00:00:00 mysqld 2603 pts/0 00:00:00 mysqld 2604 pts/0 00:00:00 mysqld 2605 pts/0 00:00:00 mysqld 2606 pts/0 00:00:00 mysqld 2680 pts/0 00:00:00 mysqld 2842 pts/0 00:00:00 mysqld_safe 2872 pts/0 00:00:01 mysqld 2874 pts/0 00:00:00 mysqld 2875 pts/0 00:00:00 mysqld 2876 pts/0 00:00:00 mysqld 2877 pts/0 00:00:00 mysqld 2878 pts/0 00:00:00 mysqld 2879 pts/0 00:00:00 mysqld 2880 pts/0 00:00:00 mysqld 2881 pts/0 00:00:00 mysqld 2882 pts/0 00:00:00 mysqld 2902 pts/0 00:00:00 mysqld *** stop mysql database server 2596 pts/0 00:00:00 mysqld 2598 pts/0 00:00:00 mysqld 2599 pts/0 00:00:00 mysqld 2600 pts/0 00:00:00 mysqld 2601 pts/0 00:00:00 mysqld 2602 pts/0 00:00:00 mysqld 2603 pts/0 00:00:00 mysqld 2604 pts/0 00:00:00 mysqld 2605 pts/0 00:00:00 mysqld 2606 pts/0 00:00:00 mysqld 2680 pts/0 00:00:00 mysqld **** stop slave if necessary *** stop mysqld2 2596 pts/0 00:00:00 mysqld 2598 pts/0 00:00:00 mysqld 2599 pts/0 00:00:00 mysqld 2600 pts/0 00:00:00 mysqld 2601 pts/0 00:00:00 mysqld 2602 pts/0 00:00:00 mysqld 2603 pts/0 00:00:00 mysqld 2604 pts/0 00:00:00 mysqld 2605 pts/0 00:00:00 mysqld 2606 pts/0 00:00:00 mysqld 2680 pts/0 00:00:00 mysqld *** stop mysql database server 2 **** create replication slave *** create /var/lib/mysql2 for slave *** remove mysql2 at slave db server ls: /var/lib/mysql2: No such file or directory *** create slave from master *** delete old server log files -rw-rw---- 1 mysql root 5996 Oct 29 11:38 /var/lib/mysql2/it312-35-bin.001 -rw-rw---- 1 mysql mysql 79 Oct 29 11:38 /var/lib/mysql2/it312-35-bin.002 -rw-rw---- 1 mysql root 38 Oct 29 11:38 /var/lib/mysql2/it312-35-bin.index -rw-rw---- 1 mysql root 1289 Oct 29 11:38 /var/lib/mysql2/it312-35.err ls: /var/lib/mysql2/it312-*: No such file or directory ls: /var/lib/mysql2/hostname.pid*: No such file or directory *** ensure mysql2 is created total 51300 -rw-rw---- 1 mysql mysql 25088 Oct 29 11:38 ib_arch_log_0000000000 -rw-rw---- 1 mysql mysql 10485760 Oct 29 11:38 ibdata1 -rw-rw---- 1 mysql mysql 20971520 Oct 29 11:38 ib_logfile0 -rw-rw---- 1 mysql mysql 20971520 Oct 29 11:38 ib_logfile1 drwx--x--x 2 mysql root 4096 Oct 29 11:38 mysql drwxr-xr-x 2 mysql root 4096 Oct 29 11:38 test **** start replication slave *** start mysqld2 *** start mysql database server 2 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld **** start master *** restart mysql with default table type Innodb 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld *** stop mysql database server ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld *** start mysql with default table type Innodb 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld 3000 pts/0 00:00:00 safe_mysqld 3030 pts/0 00:00:00 mysqld 3032 pts/0 00:00:00 mysqld 3033 pts/0 00:00:00 mysqld 3034 pts/0 00:00:00 mysqld 3035 pts/0 00:00:00 mysqld 3036 pts/0 00:00:00 mysqld 3037 pts/0 00:00:00 mysqld 3038 pts/0 00:00:00 mysqld 3039 pts/0 00:00:00 mysqld 3040 pts/0 00:00:00 mysqld **** start replication process **** run sql commands at master to create tables *** Initialize overall test **** restart master mysqld *** restart mysql with default table type Innodb 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld 3000 pts/0 00:00:00 safe_mysqld 3030 pts/0 00:00:00 mysqld 3032 pts/0 00:00:00 mysqld 3033 pts/0 00:00:00 mysqld 3034 pts/0 00:00:00 mysqld 3035 pts/0 00:00:00 mysqld 3036 pts/0 00:00:00 mysqld 3037 pts/0 00:00:00 mysqld 3038 pts/0 00:00:00 mysqld 3039 pts/0 00:00:00 mysqld 3040 pts/0 00:00:00 mysqld *** stop mysql database server 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld *** start mysql with default table type Innodb 2973 pts/0 00:00:00 mysqld 2975 pts/0 00:00:00 mysqld 2976 pts/0 00:00:00 mysqld 2977 pts/0 00:00:00 mysqld 2978 pts/0 00:00:00 mysqld 2979 pts/0 00:00:00 mysqld 2980 pts/0 00:00:00 mysqld 2981 pts/0 00:00:00 mysqld 2982 pts/0 00:00:00 mysqld 2983 pts/0 00:00:00 mysqld 3083 pts/0 00:00:00 safe_mysqld 3113 pts/0 00:00:00 mysqld 3115 pts/0 00:00:00 mysqld 3116 pts/0 00:00:00 mysqld 3117 pts/0 00:00:00 mysqld 3118 pts/0 00:00:00 mysqld 3119 pts/0 00:00:00 mysqld 3120 pts/0 00:00:00 mysqld 3121 pts/0 00:00:00 mysqld 3122 pts/0 00:00:00 mysqld 3123 pts/0 00:00:00 mysqld **** master mysqld bug created 031029 11:38:20 mysqld started InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist: InnoDB: a new database to be created! 031029 11:38:20 InnoDB: Setting file /var/lib/mysql/ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031029 11:38:21 InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 20 MB InnoDB: Database physically writes the file full: wait... 031029 11:38:23 InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 20 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 031029 11:38:27 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031029 11:38:52 /usr/sbin/mysqld: Normal shutdown 031029 11:38:53 InnoDB: Starting shutdown... 031029 11:38:55 InnoDB: Shutdown completed 031029 11:38:55 /usr/sbin/mysqld: Shutdown Complete 031029 11:38:55 mysqld ended 031029 11:39:41 mysqld started 031029 11:39:41 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031029 11:39:52 /usr/sbin/mysqld: Normal shutdown 031029 11:39:53 InnoDB: Starting shutdown... 031029 11:40:04 InnoDB: Shutdown completed 031029 11:40:04 /usr/sbin/mysqld: Shutdown Complete 031029 11:40:04 mysqld ended 031029 11:40:14 mysqld started 031029 11:40:15 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.16-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 *** list /var/lib/mysql/master.info cat: /var/lib/mysql/master.info: No such file or directory