https://dev.mysql.com/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/replication-features-sql-mode.html
Using different server SQL mode settings on the master and the slave may cause the same INSERT statements to be handled differently on the master and the slave, leading the master and slave to diverge. For best results, you should always use the ...
https://dev.mysql.com/replication-features-transactions.html
That is, such transactions can lead to master storage engine-specific behavior with the possible effect of replication going out of synchrony. In general, you should avoid transactions that update both transactional and nontransactional tables in a ...
https://dev.mysql.com/replication-features-triggers.html
If under row-based replication the slave applied the triggers as well as the row changes caused by them, the changes would in effect be applied twice on the slave, leading to different data on the master and the slave. With statement-based ...
https://dev.mysql.com/charset-syntax.html
The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results. There are default settings for character sets and collations at four levels: ...
https://dev.mysql.com/charset-unicode-conversion.html
Also, keep in mind the general principle that if a table has different definitions on the master and slave, this can lead to unexpected results. This section describes issues that you may face when converting character data between the utf8mb3 and ...
https://dev.mysql.com/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the slave always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the master. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full ...
https://dev.mysql.com/charset-unicode-sets.html
For _bin collations except utf8mb4_0900_bin, the weight is based on the code point, possibly with leading zero bytes added. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL ...
https://dev.mysql.com/stored-programs-logging.html
Mixed format binary logging (binlog_format=MIXED) uses statement-based binary logging, except for cases where only row-based binary logging is guaranteed to lead to proper results. The binary log contains information about SQL statements that ...
https://dev.mysql.com/faqs-triggers.html
This is because, if both the master and the slave applied the changes from the master and, in addition, the trigger causing these changes were applied on the slave, the changes would in effect be applied twice on the slave, leading to different data ...Where can I find the documentation for MySQL 8.0 triggers? ...
