Search Results
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Important Do not attempt to update or insert rows in the mysql.slave_master_info or mysql.slave_relay_log_info tables manually. A replica server creates two replication metadata repositories, the connection metadata repository and the applier ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. The BLACKHOLE storage engine accepts data but discards it and does not store it. Updates and deletes are handled differently ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-limit.html
Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT statements is unsafe since the order of the rows affected is not defined. (Such statements can be replicated correctly with statement-based replication only if ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
This means that, when you are replicating large column values using row-based replication, you must take care to set max_allowed_packet large enough to accommodate the largest row in any table to be replicated, even if you are replicating updates ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
(Bug #45677) A trigger can have triggers for different combinations of trigger event (INSERT, UPDATE, DELETE) and action time (BEFORE, AFTER), and multiple triggers are permitted. With statement-based replication, triggers executed on the source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Tables are created or their structure modified, and data is inserted, deleted, and updated according to the changes that were originally made on the source. Replication is based on the source server keeping track of all changes to its databases ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the INSERT statements are replayed. If the source database contains existing data it is necessary to copy ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
Upgrade the old source according to the procedure for a single server, and then reinsert it into the topology. For each replica, take out the replica from the topology, wait for it to apply all its relay log, downgrade it following the instructions ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...