Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
For example: REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost'; REVOKE 'role1', 'role2' FROM 'user1'@'localhost', 'user2'@'localhost'; REVOKE SELECT ON world.* FROM 'role3'; The host name part of the account or role name, if omitted, defaults to '%'.
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
These statements are subject to rewriting: SELECT, INSERT, REPLACE, UPDATE, and DELETE. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
(For a new inserted row, the lock information is carried by the transaction ID stored in the row; the lock is not separately stored in memory. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Queries, in the form of SELECT statements, perform all the lookup ...