https://dev.mysql.com/recovery-from-backups.html
| mysql For more information about using mysqlbinlog to process binary log files, see Section 7.5, “Point-in-Time (Incremental) Recovery”. Now, suppose that we have a catastrophic crash on Wednesday at 8 a.m. To recover, first we restore the ...
https://dev.mysql.com/referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/replication-applier-filters-table.html
COUNTER The number of times the replication filter has been used since it was configured. This table shows the replication channel specific filters configured on this slave. Each row provides information on a replication channel's configured type ...
https://dev.mysql.com/replication-applier-status-by-coordinator-table.html
The start timestamp refers to when this thread read the first event of the transaction from the relay log to buffer it to a worker’s queue, while the end timestamp refers to when the last event finished buffering to the worker’s queue. For a ...
https://dev.mysql.com/replication-applier-status-table.html
This table shows the current general transaction execution status on the slave server. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status ...
https://dev.mysql.com/replication-binlog-encryption-key-rotation.html
When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY. You can rotate the binary log master key on a regular basis to comply with ...
https://dev.mysql.com/replication-binlog-encryption-scope.html
Existing binary log files and relay log files that were present on the server when you started encryption are not encrypted. You can purge these files when they are no longer needed. Data in motion in the replication event stream, which is sent to ...
https://dev.mysql.com/replication-binlog-encryption.html
If you activate encryption while the server is running, a new binary log encryption key is generated at that time. From MySQL 8.0.14, binary log files and relay log files can be encrypted, helping to protect these files and the potentially ...
https://dev.mysql.com/replication-connection-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. (CHANGE MASTER TO option: MASTER_CONNECT_RETRY) CONNECTION_RETRY_COUNT The number of times the slave can attempt ... This table shows the configuration parameters used by the slave server for connecting to the master ...
https://dev.mysql.com/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
