16.4.1.13 Replication and Fractional Seconds Support
MySQL 5.7 permits fractional seconds for TIME
, DATETIME
, and TIMESTAMP
values, with up to microseconds (6 digits) precision. See Section 11.2.7, “Fractional Seconds in Time Values”.
There may be problems replicating from a source server that understands fractional seconds to an older replica (MySQL 5.6.3 and earlier) that does not:
For
CREATE TABLE
statements containing columns that have anfsp
(fractional seconds precision) value greater than 0, replication will fail due to parser errors.Statements that use temporal data types with an
fsp
value of 0 will work for with statement-based logging but not row-based logging. In the latter case, the data types have binary formats and type codes on the source that differ from those on the replica.Some expression results will differ on source and replica. Examples: On the source, the
timestamp
system variable returns a value that includes a microseconds fractional part; on the replica, it returns an integer. On the source, functions that return a result that includes the current time (such asCURTIME()
,SYSDATE()
, orUTC_TIMESTAMP()
) interpret an argument as anfsp
value and the return value includes a fractional seconds part of that many digits. On the replica, these functions permit an argument but ignore it.