PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. The life cycle of a GTID consists of the following steps: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
Trigger or stored program updates a table having an AUTO_INCREMENT column. The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based format. If this is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
When the system variable replica_exec_mode or slave_exec_mode is IDEMPOTENT, a failure to apply changes from RBL because the original row cannot be found does not trigger an error or cause replication to fail. MySQL uses statement-based logging ...
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-sbr-rbr.html
Note Statements that update the information in the mysql system schema, such as GRANT, REVOKE and the manipulation of triggers, stored routines (including stored procedures), and views, are all replicated to replicas using statement-based ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-rbr-monitoring.html
To see the original query that triggered this event: mysql> SELECT db, processlist_state, processlist_info FROM performance_schema.threads -> WHERE processlist_state LIKE 'stage/sql/Applying batch of row changes%' AND thread_id = N; . The current ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Perform any table repair or rebuilding operations needed to re-create database objects, such as use of REPAIR TABLE or ALTER TABLE, or dumping and reloading tables or triggers. When you upgrade servers that participate in a replication topology, ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/8.0/en/return.html
This statement is not used in stored procedures, triggers, or events. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a ...