- 6.3.1 Replication Features and Issues
- 6.3.1.1 Replication and AUTO_INCREMENT
- 6.3.1.2 Replication and Character Sets
- 6.3.1.3 Replication and DIRECTORY Statements
- 6.3.1.4 Replication with Floating Point Values
- 6.3.1.5 Replication and FLUSH
- 6.3.1.6 Replication and System Functions
- 6.3.1.7 Replication during a Master Crash
- 6.3.1.8 Replication during a Master Shutdown
- 6.3.1.9 Replication with MEMORY Table Types
- 6.3.1.10 Replication of the System mysql Database
- 6.3.1.11 Slave Errors during Replication
- 6.3.1.12 Replication during a Slave Shutdown
- 6.3.1.13 Replication and Temporary Tables
- 6.3.1.14 Replication Retries and Timeouts
- 6.3.1.15 Replication and Time zones
- 6.3.1.16 Replication and Transactions
- 6.3.1.17 Replication with More Columns on the Slave
- 6.3.1.18 Replication and Variables
- 6.3.1.19 Replication and Views
You may replicate from a master to a slave where the number of columns in the table on the slave is larger than the number of columns in the corresponding table on the master.
When replicating Table T1 from the master to table T2 on the slave, the following must be met:
You must be using row-based replication.
T1 and T2 must have the same database/table name.
T2 may contain additional columns compared to T1, but they must appear sequentially after the corresponding columns in T1.
All the matching columns in T1 and T2 must have the same type.
Every column in T2 but not in T1 must have a default value.
This functionality was added in MySQL 5.1.12.
User Comments
Add your own comment.