Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old primary. Note For a group ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
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/mysql-secure-installation.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type Enumeration Default Value OFF ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Strict mode: Specify whether the mapping takes place during data mapping in strict mode (Enabled) or non-strict mode (Disabled). This parameter overrides the Strict mode setting that you specify in the File parsing settings for CSV files. The ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
This pertains to migration strategy because the way in which the source and destination keystores are managed determines the procedure for performing a given type of key migration: Migration from one keyring plugin to another: The MySQL server has ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online.html
This section describes how to change the mode of replication from and to GTID mode without having to take the server offline.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-replication-standard-rules.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. Source Not Verifying Checksums When ...By ...
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/refman/8.4/en/lock-tables.html
With auto-reconnect disabled, if the connection drops, an error occurs for the next statement issued. Interaction of Table Locking and Transactions LOCK TABLES and UNLOCK TABLES interact with the use of transactions as follows: LOCK TABLES is not ...