Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-multi-source.html
This type of circular replication scheme for NDB Cluster, in which the line of replication (again indicated by the curved arrows in the diagram) is discontinuous, should be possible, but it should be noted that it has not yet been thoroughly tested ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
Note When performing schema changes on NDB tables, applications should wait until the ALTER TABLE statement has returned in the MySQL client connection that issued the statement before attempting to use the updated definition of the table.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-starting.html
Note You can also start the source with --binlog-format=MIXED, in which case row-based replication is used automatically when replicating between clusters. Note Unless you want replication to begin immediately, delay the start of the replication ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as my.ini. It offers two options: Note This upgrade functionality was added in MySQL 8.3.0. Note The existing MySQL server instance must be ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
(See Bug #42849.) Note It is also possible in MySQL 8.4 to use UNIX_TIMESTAMP(timestamp_column) as a partitioning expression for tables that are partitioned by LIST. A table that is partitioned by range is partitioned in such a way that each ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Note Although it is possible to “reset” an expired password by setting it to its current value, it is preferable, as a matter of good policy, to choose a different password. Note The empty password does not count in the password history and is ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
Note If you start the server with the --skip-grant-tables option, authentication plugins are not used even if loaded because the server performs no client authentication and permits any client to connect. Note The mysql_native_password ... When a ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
It is important to note that the replica sets gtid_next in a session context. Note that after you set gtid_next to a specific GTID (in either UUID:NUMBER or UUID:TAG:NUMBER format), and the transaction has been committed or rolled back, an explicit ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
Note that although you can change the server ID dynamically to a nonzero value, doing so does not enable replication to start immediately. Note The presence of the server_uuid system variable does not change the requirement for setting a unique ...