PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html
MySQL supports replication from one release series to the next higher release series. However, you might encounter difficulties when replicating from an older source to a newer replica if the source uses statements or relies on behavior no longer ...For example, you can replicate from a source running MySQL 5.6 to a replica running MySQL 5.7, from a source running MySQL 5.7 to a replica running MySQL 8.0, and so ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-optimizer.html
It is possible for the data on the source and replica to become different if a statement is written in such a way that the data modification is nondeterministic; that is, left up the query optimizer. (In general, this is not a good practice, even ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir or replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir ...
https://dev.mysql.com/doc/refman/8.0/en/uln-installation.html
If you are changing your package source to use ULN and not changing which build of MySQL you are using, then back up your data, remove your existing binaries, and replace them with those from ULN. If a change of build is involved, we recommend the ...One of the methods, covered in this section, is installing from Oracle's Unbreakable Linux Network ... Linux supports a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
A GTID transaction can be addressed either by its GTID, or by the name of the file in which it is logged and its position within that file. Before setting the replication mode of an online server, it is important to understand some key concepts of ...An anonymous transaction has no GTID; MySQL 8.0 ensures that every anonymous transaction in a log is preceded by an ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
It must not contain any aggregate functions (whether it is explicitly or implicitly grouped). The statement must not use the STRAIGHT_JOIN join type in the outer query. The number of outer and inner tables together must be less than the maximum ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If column aliases are not used, or if they are the same as the column names, they must be distinguished using the row alias in the ON DUPLICATE KEY UPDATE clause. Column aliases must be unique with regard to the row alias to which they apply (that ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Special characters in database and table names are encoded in the corresponding file system names as described in Section 11.2.4, “Mapping of Identifiers to File Names”. Certain objects within MySQL, including database, table, index, column, ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
Also, with the replica's connection metadata repository and applier metadata repository stored in InnoDB tables, which became the default in MySQL 8.0, the internal state of the data engine transaction is changed following a filtered XA transaction, ... XA transaction support is limited to the InnoDB storage ...For “Internal XA”, storage engines ...For ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
Find the precise binary log event position corresponding to the point in time up to which you want to restore your database. Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data ... The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...