Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-blackhole.html
Updates and deletes are handled differently depending on whether statement based or row based logging is in use. With the statement based logging format, all statements affecting BLACKHOLE tables are logged, but their effects ignored. For this ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-timezone.html
Otherwise, statements depending on the local time on the source are not replicated properly, such as statements that use the NOW() or FROM_UNIXTIME() functions. By default, source and replica servers assume that they are in the same time zone. If ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slaveinit.html
To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option values with the actual values relevant to your system: mysql> CHANGE REPLICATION SOURCE TO -> SOURCE_HOST='source_host_name', -> ... To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the sources using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication applier metadata repositories, and provisioned the replica with data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-stop-replica.html
The STOP REPLICA statement can be used to stop a multi-source replica. By default, if you use the STOP REPLICA statement on a multi-source replica all channels are stopped. To stop all currently configured replication channels: mysql> STOP REPLICA; ...Optionally, use the FOR CHANNEL channel clause to stop only a specific ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If the PRIVILEGE_CHECKS_USER account should have been permitted to execute the transaction, but has been misconfigured, grant the missing privileges to the account, use a FLUSH PRIVILEGES statement or execute a mysqladmin flush-privileges or ... If ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
When the block ends, the source returns to the session, which then can proceed to execute other statements. For statements that do not occur in transactional context (that is, when no transaction has been started with START TRANSACTION or SET ... In ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
Start the replication process again: mysql> START REPLICA; Although the default_storage_engine variable is not replicated, be aware that CREATE TABLE and ALTER TABLE statements that include the engine specification are replicated to the replica ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
Figure 19.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and replicas as normal, and then limiting the binary log statements that each replica processes by using the --replicate-wild-do-table ... There may be situations where you have a single source server and want to replicate different databases to different ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
There are two core types of replication format, Statement Based Replication (SBR), which replicates entire SQL statements, and Row Based Replication (RBR), which replicates only the changed rows. For notes and tips on how different data types and ...