Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Permitted values for gtid_mode are listed here, in order, with their meanings: OFF: Only anonymous transactions can be replicated. Before setting the replication mode of an online server, it is important to understand some key concepts of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
On each server, execute this statement: SET @@GLOBAL.enforce_gtid_consistency = ON; On each server, execute the following statement: SET @@GLOBAL.gtid_mode = OFF_PERMISSIVE; The order in which the servers execute this statement makes no difference, ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-verify-transactions.html
For example, if there are three servers A, B, and C, replicating in a circle, so that A replicates to B, B replicates to C, and C replicates to A, do as follows, in the order shown: Perform Step 1 on A, and Step 2 on B. This section explains how to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
You can set the value of gtid_purged in order to record on the server that the transactions in a certain GTID set have been applied, although they do not exist in any binary log on the server. The MySQL Server system variables described in this ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
This means that you must select the default database explicitly with a USE statement in order for a DDL statement to be applied. When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are nondeterministic. For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want to take ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. This section describes the impact of an unexpected halt of a ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Even with this safeguard, it is better to avoid granting the SYSTEM_USER privilege through a role in order to guard against the possibility of privilege escalation. Like user accounts, roles can have privileges granted to and revoked from them. A ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
To create a secure passphrase, ensure that the words and other items in it are not a known phrase or quotation, do not occur in a predictable order, and preferably have no previous relationship to each other at all. Anyone using MySQL on a computer ...