Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
In the initial handshake, the replica sends a GTID set containing the transactions that it has already received, committed, or both. GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
Note that if a value of 0 was set previously for the server ID, you must restart the server to initialize the source with your new nonzero server ID. To configure a source to use binary log file position based replication, you must ensure that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slavebaseconfig.html
If that server ID value (which was the default in earlier releases) was set previously, you must restart the server to initialize the replica with your new nonzero server ID. Each replica must have a unique server ID, as specified by the server_id ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
You must change the server ID and then restart the server to initialize the replica. The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. Options and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%'; +----------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want to perform, then checks whether your privileges are sufficient. This ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL Account”. If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. If you know the root ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
The Information Schema RESOURCE_GROUPS table exposes information about resource group definitions and the Performance Schema threads table shows the resource group assignment for each thread. Resource group definitions are stored in the ... MySQL ...