PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
To recover, first we restore the last full backup we have (the one from Sunday 1 p.m.). The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its ... Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Data in use that is held in the binary log transaction and statement caches during a transaction is in unencrypted format in the memory buffer that stores the cache. Because the temporary files are volatile and tied to a single process, they are ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
With MySQL's statement-based replication, there may be issues with replicating stored routines or triggers. For a detailed list of issues, see Section 27.7, “Stored Program Binary Logging”. The following sections provide information about what ...
https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html
With statement-based replication, you may encounter issues with replicating stored routines or triggers. Replication works because events written to the binary log are read from the source and then processed on the replica. The events are recorded ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
Important Before copying, verify that all the files relating to the existing replica actually are stored in the data directory. For example, the InnoDB system tablespace, undo tablespace, and redo log might be stored in an alternative location. You ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, cloning or copying of the data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
If so, and the statement occurs within a stored function, the replica executes the statement and exits. If row-based replication is enabled, the replica does not know whether a statement occurred within a stored function on the source, so this ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
If your database is stored in binary portable files, you can copy the raw data files to a replica. For InnoDB, all tables in all databases are stored in the system tablespace files, unless you have the innodb_file_per_table option enabled. If the ...
https://dev.mysql.com/doc/refman/8.0/en/server-loadable-functions.html
That terminology was something of a misnomer because “user-defined” also can apply to other types of functions, such as stored functions (a type of stored object written using SQL) and native functions added by modifying the server source code.