https://dev.mysql.com/replication-features-differing-tables.html
Between any of the decimal types DECIMAL, FLOAT, DOUBLE, and NUMERIC. Source and target tables for replication do not have to be identical. A table on the master can have more or fewer columns than the slave's copy of the table. In addition, ...
https://dev.mysql.com/replication-gtids-concepts.html
This example shows the GTID set stored in the gtid_executed system variable (@@GLOBAL.gtid_executed) of a slave that has applied transactions from more than one master: 2174B383-5441-11E8-B90A-C80AA9429562:1-3, ... A global transaction identifier ...
https://dev.mysql.com/replication-gtids-functions.html
The UUIDs are arranged in alphabetic order and intervals are arranged in numeric order. MySQL includes some built-in (native) functions for use with GTID-based replication. These functions are as follows: GTID_SUBSET(set1,set2) Given two sets of ...
https://dev.mysql.com/replication-options-slave.html
The server creates relay log files in sequence by adding a numeric suffix to the base name. slave_exec_mode Property Value Command-Line Format --slave-exec-mode=mode System Variable slave_exec_mode Scope Global Dynamic Yes SET_VAR Hint Applies No ...
https://dev.mysql.com/reset-master.html
RESET MASTER [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary logging is enabled (log_bin is ON), RESET MASTER ...
https://dev.mysql.com/select.html
LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions: Within prepared statements, LIMIT parameters can be specified using ? placeholder markers. SELECT [ALL | DISTINCT | DISTINCTROW ] ...
https://dev.mysql.com/server-options.html
--tc-heuristic-recover={COMMIT|ROLLBACK} Property Value Command-Line Format --tc-heuristic-recover=name Type Enumeration Default Value COMMIT Valid Values COMMITROLLBACK The type of decision to use in the heuristic recovery process. When you start ...
https://dev.mysql.com/spatial-operator-functions.html
If the first argument is 'point_circle', 'join_round', 'join_miter', or 'end_round', the points_per_circle argument must be given as a positive numeric value. OpenGIS proposes a number of functions that can produce geometries. These functions ...
https://dev.mysql.com/string-comparison-functions.html
Table 12.12 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/string-type-syntax.html
In this case, comparison and sorting are based on numeric character code values. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that ...
