Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. If the destination table exists and IF NOT EXISTS is given, MySQL 8.4 ignores the statement completely; nothing is inserted or logged. SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. For example, since MyISAM ignores foreign key constraints, an INSERT or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. It may also cause inserts into ...For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
Example: SELECT asynchronous_connection_failover_add_managed('channel2', 'GroupReplication', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '127.0.0.1', 3310, '', 80, 60); ... The following functions enable you to add or remove replication source servers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
MySQL appends a statement to the transaction to insert the GTID into the table. One GTID is generated for the CREATE TABLE action and one GTID is generated for the row-insert actions. The life cycle of a GTID consists of the following steps: A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Important Before enabling this variable, you must make certain that there are no dependencies between transactional and nontransactional tables; an example of such a dependency would be the statement INSERT INTO myisam_table SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
In order to execute specific replicated transactions from the relay log, or transactions from mysqlbinlog output as required, the PRIVILEGE_CHECKS_USER account must have the following privileges: For a row insertion logged in row format (which are ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Deprecated Yes Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
A view cannot be referenced by a user who does not have the appropriate privilege for it (SELECT to select from it, INSERT to insert into it, and so forth). Stored programs (procedures, functions, triggers, and events) and views are defined prior ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
As an alternative to explicitly escaping special characters, many MySQL APIs provide a placeholder capability that enables you to insert special markers into a statement string, and then bind data values to them when you issue the statement. A ...