Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Therefore we recommend setting group_replication_enforce_update_everywhere_checks=ON on server instances used in multi-primary mode groups to avoid undetected conflicts. Note that the limitations and issues described for multi-primary mode groups ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-verify-transactions.html
This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
You can also cause the server to write checksums for the events using CRC32 checksums by setting the binlog_checksum system variable, to add an extra level of safety to the logs and the replication process. You can also cause the server to write ...
https://dev.mysql.com/doc/internals/en/scripts-directory.html
Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table mysql_secure_installation.sh --- Disallow remote root login, eliminate test, etc. Linux programmers use it ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
Locks may be used to emulate transactions or to get more speed when updating tables. For cascading updates, a shared-nothing write lock (LOCK TABLES WRITE) is taken on related tables that are involved in the operation. WRITE locks normally have ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
If the server_ssl_mode option is set to PREFERRED and the protocol is classic, then connections over Unix domain sockets are unencrypted. The state.json is initialized with InnoDB Cluster Metadata server addresses and the Group Replication ID (the ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
For more information, see the descriptions of the gtid_next system variable and the TRANSACTION_GTID_TAG privilege, as well as Section 19.1.4, “Changing GTID Mode on Online Servers”. (Previously, when MTA was enabled and the user attempted to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-dump.html
To apply these GTIDs on the target MySQL instance for use with replication, use the updateGtidSet option or import them manually, depending on the release of the target MySQL instance and the MySQL Shell release. The default is true if stdout is a ... MySQL Shell's dump loading utility util.loadDump() supports the import into a MySQL HeatWave Service DB System or a MySQL Server instance of schemas or tables dumped using MySQL Shell's Section 12.5, “Instance Dump Utility, Schema Dump Utility, and Table Dump ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
Start the replica, then disable read-only mode on both servers, so that they can accept updates. To enable GTID-based replication, each server must be started with GTID mode enabled by setting the gtid_mode variable to ON, and with the ...For ...