]]>
]]>

slave_type_conversions_error_on_truncate

This feature provides an extended version of wl5151. For ALL_LOSSY conversion mode you can specify behavior on truncate value - error (new behavior) or work normally (old behavior). Also, it provides a system variable to control that.

Version-Specific Information

Percona-Server Version Comments
12.0 Full functionality available.

Variables Provided

slave_type_conversions_error_on_truncate

TypeSystem and command-line variable
ScopeGlobal
DynamicYes
Possible valuesOFF,ON
DefaultOFF

If you specify

set global slave_type_conversions_error_on_truncate=ON;
set global slave_type_conversions=ALL_LOSSY;

and then try to replicate value with truncate data you will get an error. For example: you have a column 'a' with type SMALLINT on master, and you have a column 'a' with type TINYINT on slave. When you run on master: INSERT INTO t VALUES(128); Slave will fail with Last_error:

Slave SQL: Column 0 of table 'test.t' cannot be converted from type 'smallint' to type 'tinyint(4)' without truncate
Error_code: 1643

This error would be wrote to mysqld-error log, and also available:

SHOW SLAVE STATUS;

Related Reading

Other Information

Author/Origin Percona
Bugs fixed
Dependencies wl5151
 
percona-server/features/special/slave_type_conversions_error_on_truncate.txt · Last modified: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>