PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replace-third-party-yum.html
Note This step is not necessary for an installation that was configured with a Yum repository release package (like Percona) if you are going to remove the release package (percona-release.noarch for Percona), as shown in the uninstall command for ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can replace a third-party distribution of MySQL with the latest GA release (from the MySQL 5.7 series currently) from the MySQL Yum ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transactions.html
When this variable is OFF (the default), logging is as just described. When this variable is ON, logging occurs immediately for nontransactional statements occurring anywhere in the transaction (not just initial nontransactional statements). In ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
This section provides information about restrictions on and limitations of replication with GTIDs. This restriction is due to the fact that updates to tables that use a nontransactional storage engine mixed with updates to tables that use a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
This server ID is used to identify individual servers within the replication topology, and must be a positive integer between 1 and (232)−1. You can change the server_id value dynamically by issuing a statement like this: SET GLOBAL server_id = 2; ... To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. Note The presence of the server_uuid system variable in ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you want to be sure that your replication filters always operate in the same way independently of the binary logging format, which is particularly important if you are using mixed binary logging format, follow the guidance in this topic. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
If row-based replication is enabled, the replica does not know whether a statement occurred within a stored function on the source, so this condition does not apply. Having reached this point, if there are no table options, the replica simply ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
This is where the privilege columns in the grant tables come into play. Values in the scope columns of this table can take the following forms: A blank User value matches the anonymous user. This is similar to db table sorting, but simpler because ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/5.7/en/set-sql-log-bin.html
Set this variable to OFF for a session to temporarily disable binary logging while making changes to the source you do not want replicated to the replica. Setting the session value of this system variable is a restricted operation. Setting this ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
They use the = assignment operator, but the := assignment operator is also permitted for this purpose. This statement assigns a value to a user-defined variable and a system variable: SET @x = 1, SESSION sql_mode = ''; If you set multiple system ...