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-gtids-auto-positioning.html
The correct approach to recover from this situation is to check manually whether the source and replica have diverged. The alternative SOURCE_LOG_FILE | MASTER_LOG_FILE and SOURCE_LOG_POS | MASTER_LOG_POS options specify the name of the log file and ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
To grant this account the REPLICATION_APPLIER privilege, use the GRANT statement. To connect to a server using a user account that authenticates with this plugin, you must either set up an encrypted connection as described in Section 19.3.1, ... By ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
If the source database contains existing data it is necessary to copy this data to each replica. This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the INSERT ...There are different ways to dump the data from the source ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
For a version of this table that is specific to NDB Cluster, see Section 25.4.2.5, “NDB Cluster mysqld Option and Variable Reference”. This option is dynamic, but should be set only by server. The following table lists all command-line options, ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
They use the = assignment operator, but the := assignment operator is also permitted for this purpose. This takes place even if secure storage through a keyring component is not available on the server instance. It is also possible to make ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
(If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 7, MySQL Server Administration.) This chapter describes the entire process of setting up and using a database. This chapter provides a tutorial ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
The upgrade checker utility carries out the automated checks that are relevant for the specified target release, and advises you of further relevant checks that you should make manually. For more information, see Server Changes, in MySQL 5.7 ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
This option is enabled by default, so it need not be specified explicitly. This certificate can be sent to the client and authenticated against the CA certificate that it has. (The certificate is self-signed if created automatically by the server or ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/windows-choosing-package.html
This format does not include an automated installer, and must be manually installed and configured. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database (PDB) files ...