PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
If a replication channel has gaps, it has the following consequences: The replica database is in a state that may never have existed on the source. Inconsistencies in the sequence of transactions that have been executed from the relay log can occur ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
However, with different filtering on the channels, the database can become inconsistent and replication can hang. GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
uuid: hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh h: [0-9|A-F] interval: n[-n] (n >= 1) mysql.gtid_executed Table GTIDs are stored in a table named gtid_executed, in the mysql database. A global transaction identifier (GTID) is a unique identifier created ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
GTIDs play a key role in applying changes to the database: the server automatically skips any transaction having an identifier which the server recognizes as one that it has processed before. There are a number of techniques when using MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-configuration.html
The replica replicates one database from each of the sources, db1 from source1 and db2 from source2. A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume that you have two ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html
Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only need the replica to replicate it from one source. MySQL multi-source replication enables a replica to receive transactions ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
Log files contain all statements that made any changes, so they can be used to audit the database. 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.0/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. To guarantee the integrity of the files that are copied, backing ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...