Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
The creator of a routine is the account used to execute the CREATE statement for it. The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The ALTER ROUTINE privilege ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
For example, the statement_truncate_len option controls the maximum length of statements returned by the format_statement() function. ROM sys_config | +-----------------------------------+ Subsequent invocations of format_statement() within the ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-format.html
The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.