Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Warning --dump-replica should not be used if the server where the dump is going to be applied uses gtid_mode=ON and SOURCE_AUTO_POSITION=1. --set-gtid-purged=value Command-Line Format --set-gtid-purged=value Type Enumeration Default Value AUTO Valid ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of GTID auto-positioning and automatic failover, and use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and Performance Schema tables to monitor replicated transactions (see Section 29.12.11, ... Before ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The missing transactions can be retrieved from the source using GTID auto-positioning, which automatically compares the source's transactions to the replica's transactions and identifies the missing transactions. GTID auto-positioning means the ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation ...This section describes the privileges required for operations that assign values to system variables at ...
https://dev.mysql.com/doc/x-devapi-userguide/en/understanding-automatic-document-ids.html
serial is a per-instance automatically incremented integer serial number value, which is hex encoded and has a range of 0 to 264-1. The initial value of serial is set to the auto_increment_offset system variable, and the increment of the value is ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/understanding-automatic-document-ids.html
serial is a per-instance automatically incremented integer serial number value, which is hex encoded and has a range of 0 to 264-1. The initial value of serial is set to the auto_increment_offset system variable, and the increment of the value is ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/understanding-automatic-document-ids.html
serial is a per-instance automatically incremented integer serial number value, which is hex encoded and has a range of 0 to 264-1. The initial value of serial is set to the auto_increment_offset system variable, and the increment of the value is ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
The following statuses are available: disabled: The event-based incremental load feature is not available. initializing: The event-based incremental load feature is waiting for the server to finish booting and verifying which external tables are set ...Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-backup.html
Various kinds of backups can be performed by adding different options, like using --compress or --incremental for compressed or incremental backups. The backup operations are the most frequently performed tasks by MySQL Enterprise Backup. In most ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Use the technique explained in Creating Incremental Backups Using Only the Redo Log. Only needed if you perform incremental backups using the --incremental-with-redo-log-only option rather than the --incremental option. The size of the InnoDB redo ... Before backing up a particular database server for the first time, gather some information and use it to make some planning decisions, as outlined in the following ...