// Conf and builds used [root@cluster-repo mysql-advanced-5.6.23]# more docs/INFO_SRC revision-id: michael.izioumtchenko@oracle.com-20141106152508-nntohvuco3v1rjjx date: 2014-11-06 16:25:08 +0100 build-date: 2014-11-06 18:00:43 +0100 revno: 6243 branch-nick: daily-5.6 MySQL source 5.6.23 [root@cluster-repo mysql-advanced-5.6.23]# more master.cnf slave.cnf :::::::::::::: master.cnf :::::::::::::: #Master [mysqld] pid-file = /data/ushastry/server/mysql-advanced-5.6.23/run/master.pid socket = /data/ushastry/server/mysql-advanced-5.6.23/run/master.sock log-error=/data/ushastry/server/mysql-advanced-5.6.23/log/master.log slow_query_log_file=/data/ushastry/server/mysql-advanced-5.6.23/log/slow.log general_log_file=/data/ushastry/server/mysql-advanced-5.6.23/log/general.log port = 15000 server-id = 1 basedir = /data/ushastry/server/mysql-advanced-5.6.23 datadir = /data/ushastry/server/mysql-advanced-5.6.23/master tmpdir = /tmp log-bin = /data/ushastry/server/mysql-advanced-5.6.23/log/master-bin log-bin-index=/data/ushastry/server/mysql-advanced-5.6.23/log/master-bin.index binlog_format=STATEMENT :::::::::::::: slave.cnf :::::::::::::: #Slave [mysqld] pid-file = /data/ushastry/server/mysql-advanced-5.6.23/run/slave.pid socket = /data/ushastry/server/mysql-advanced-5.6.23/run/slave.sock log-error=/data/ushastry/server/mysql-advanced-5.6.23/log/slave.log port = 15001 server-id = 2 basedir = /data/ushastry/server/mysql-advanced-5.6.23 datadir = /data/ushastry/server/mysql-advanced-5.6.23/slave tmpdir = /tmp relay-log-index = /data/ushastry/server/mysql-advanced-5.6.23/log/slave-relay-bin.index relay-log = /data/ushastry/server/mysql-advanced-5.6.23/log/slave-relay-bin binlog_format=STATEMENT log_slow_slave_statements=ON slow_query_log=ON long_query_time=0 // Setup simple replication(Master->Slave) and follow steps provided in the report master> use test Database changed master> create table t1 (id int auto_increment primary key, i1 int, v1 varchar(100)); Query OK, 0 rows affected (0.31 sec) slave> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed slave> alter table t1 add column i2 int after i1; Query OK, 0 rows affected (0.46 sec) Records: 0 Duplicates: 0 Warnings: 0 master> insert into t1(i1, v1) values(100, 'test'); Query OK, 1 row affected (0.05 sec) master> set binlog_format=row; Query OK, 0 rows affected (0.00 sec) master> insert into t1(i1, v1) values(200, 'test 2'); Query OK, 1 row affected (0.04 sec) slave> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: repl Master_Port: 15000 Connect_Retry: 60 Master_Log_File: master-bin.000001 Read_Master_Log_Pos: 1424 Relay_Log_File: slave-relay-bin.000002 Relay_Log_Pos: 692 Relay_Master_Log_File: master-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1677 Last_Error: Column 2 of table 'test.t1' cannot be converted from type 'varchar(100)' to type 'int(11)' Skip_Counter: 0 Exec_Master_Log_Pos: 1221 Relay_Log_Space: 1068 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 1677 Last_SQL_Error: Column 2 of table 'test.t1' cannot be converted from type 'varchar(100)' to type 'int(11)' Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: c4d1c698-719d-11e4-ad10-00163e44510c Master_Info_File: /data/ushastry/server/mysql-advanced-5.6.23/slave/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 141121 22:28:26 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 1 row in set (0.00 sec) slave> select COLUMN_NAME, ORDINAL_POSITION, COLUMN_TYPE from information_schema.columns where table_name='t1' and table_schema='test'; +-------------+------------------+--------------+ | COLUMN_NAME | ORDINAL_POSITION | COLUMN_TYPE | +-------------+------------------+--------------+ | id | 1 | int(11) | | i1 | 2 | int(11) | | i2 | 3 | int(11) | | v1 | 4 | varchar(100) | +-------------+------------------+--------------+ 4 rows in set (0.00 sec)