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-features-temptables.html
In MySQL 8.0, when binlog_format is set to ROW or MIXED, statements that exclusively use temporary tables are not logged on the source, and therefore the temporary tables are not replicated. For more information about row-based replication and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. If you are planning to use statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Section 19.1.6.2, “Replication Source Options and Variables” provides more detailed ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. A set of quick-reference tables providing basic information about these options and variables is ...Options and variables for use on sources and replicas are covered separately, as are options and variables relating to binary logging and global transaction identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
This also applies to row-based replication for DDL statements, because DDL statements are always logged as statements, without regard to the logging format in effect. The only type of statement that can update both an included and an ignored table ... The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
If you use raw data files (a binary backup) to set up the replica, it is not possible to change the initial table format. For example, instead of: mysql> CREATE TABLE tablea (columna int) Engine=MyISAM; Use this format: mysql> SET ... It does not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
This applies to mixed-format replication as well, since this enables some updates to be replicated using the statement-based format. There may be situations where you have a single source server and want to replicate different databases to ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
Each account name uses the format described in Section 8.2.4, “Specifying Account Names”. Each role name uses the format described in Section 8.2.5, “Specifying Role Names”. [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
For more information about internal credentials storage, see Section 8.2.15, “Password Management”. For more information about password verification by specifying the current password, see Section 8.2.15, “Password Management”. For more ...