Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/replication-privilege-checks.html
You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/server-side-help-support.html
MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP Statement”). This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/windows-installation.html
This installs the MySQL server, an associated MySQL Configurator application, and it adds related MySQL items to the Microsoft Windows Start menu under the MySQL group. Execute it now (recommended) or later, or instead choose to manually configure ... MySQL is available for Microsoft Windows 64-bit operating systems ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/config-file-parameters.html
Within a mysqlbackup option name, dashes (-) and underscores (_) may usually be used interchangeably, similar to mysqld parameters that use this same convention (notice that log-bin is one exception; see Using Options on the Command Line in the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/connection-options.html
The way to create a connection is similar to what is described in Connecting to the MySQL Server Using Command Options of the MySQL 8.4 Reference Manual. When mysqlbackup creates a backup, it sends SQL commands to a MySQL server using a database ...