Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a statement produces different errors on the source and the replica, the replication SQL thread ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-floatvalues.html
With statement-based replication, values are converted from decimal to binary. Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. This is true for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a replica: FLUSH LOGS and FLUSH TABLES WITH READ LOCK. The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-fractional-seconds.html
MySQL 8.4 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-json.html
In MySQL 8.4, it is possible to log partial updates to JSON documents (see Partial Updates of JSON Values). The logging behavior depends on the format used, as described here: Statement-based replication. JSON partial updates are not logged as such ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-timeout.html
The global value of the system variable replica_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before stopping. Transactions are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
With statement-based replication, triggers executed on the source also execute on the replica. With row-based replication, triggers executed on the source do not execute on the replica. Instead, the row changes on the source resulting from trigger ...