This is a command-line option for the
mysqld commands (arg: Required).
Configures how data type conversions are handled when row-based binary log events are applied. When set to the empty string, data types must match exactly, and no conversions are allowed.
See also: mariadbd & mysqld for MariaDB Enterprise Server 23.08, in 23.07 ES, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
--slave-type-conversions command-line option configures how data type conversions are handled when row-based binary log events are applied. Statement-based binary log events are not impacted by this system variable.
--slave-type-conversions command-line option can impact anything that uses row-based binary log events, including MariaDB Replication, Galera ClusterGalera Cluster, and Point-in-time recovery (PITR).
All safe conversions (no data loss) are allowed.
All conversions are allowed, both lossy and lossless.
"" (an empty string)
The server returns an error if the table definition between the primary and replica differs and replication stops.
When MariaDB Server (
mariadbd) is started via the command-line, the
--slave-type-conversions command-line option can be specified:
$ mariadbd .. --slave-type-conversions='ALL_NON_LOSSY,ALL_LOSSY' ..