PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
With mixed format, when a stored function, stored procedure, trigger, event, or prepared statement contains anything that is not safe for statement-based binary logging, the entire statement is marked as unsafe and logged in row format. The ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
Under the consecutive lock mode, InnoDB can avoid using table-level AUTO-INC locks for “simple insert” statements where the number of rows is known in advance, and still preserve deterministic execution and safety for statement-based replication. This lock mode ensures that, in the presence of INSERT statements where the number of rows is not known in advance (and where auto-increment numbers are assigned as the statement progresses), all auto-increment values assigned by any “INSERT-like” statement are consecutive, and operations are safe for statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
BackupDataDir Version (or later) NDB 8.0.13 Type or units path Default FileSystemPath Range ... For example, if you set the value of BackupDataDir to /var/lib/cluster-data, then all backups are stored under /var/lib/cluster-data/BACKUP. In setting ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html
Notes Before performing any update to MySQL, follow carefully the instructions in Chapter 3, Upgrading MySQL. Among other instructions discussed there, it is especially important to back up your database before the update. Selecting a Target Series ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
Deleting it puts all SQL nodes in read-only mode; in NDB 8.0.24 and later, NDB detects that this table has been dropped, and re-creates it, after which it is possible once again to perform updates. This keeps the source mysqld process updated to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
In a circular or chain replication setting, this allows such updates to propagate to the mysql.ndb_apply_status tables of any MySQL servers configured as replicas of the current mysqld. --ndb-log-empty-epochs=[ON|OFF] Command-Line Format ... This ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. For information about how replication treats ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
For instructions on doing this safely, see Section 20.5.2, “Restarting a Group”. These system variables include group_replication_group_name, group_replication_single_primary_mode, group_replication_force_members, the SSL variables, and the flow ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Should additional training be necessary, switch the group profile to RECORDING mode again, update its allowlist with new statement patterns, then switch it back to PROTECTING mode. Should additional training be necessary, switch the account profile ...Enabling or Disabling the Firewall Assigning Firewall Privileges Firewall Concepts Registering Firewall Group Profiles Registering Firewall Account Profiles Monitoring the Firewall Migrating Account Profiles to Group Profiles Enabling or Disabling the Firewall To enable or disable the firewall, set the mysql_firewall_mode system ...