Search Results
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The asynchronous connection failover mechanism can be used to keep a replica synchronized with multiple MySQL servers or groups of servers that share data. If the new servers are provisioned using MySQL’s clone functionality, this all happens ...
https://dev.mysql.com/doc/refman/8.4/en/replication-channels.html
In MySQL multi-source replication, a replica opens multiple replication channels, one for each source server. For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-select.html
If the destination table exists and IF NOT EXISTS is given, MySQL 8.4 ignores the statement completely; nothing is inserted or logged. SELECT always performs an implicit commit (Section 15.3.3, “Statements That Cause an Implicit Commit”). If the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. Replication of invoked features such ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
Source lists are stored in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables, and can be viewed in the Performance Schema replication_asynchronous_connection_failover table.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids.html
This section discusses the following topics: How GTIDs are defined and created, and how they are represented in a MySQL server (see Section 19.1.3.1, “GTID Format and Storage”). For information about MySQL Server options and variables relating ... This section explains transaction-based replication using global transaction identifiers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slaveinit.html
To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option values with the actual values relevant to your system: mysql> CHANGE REPLICATION SOURCE TO -> SOURCE_HOST='source_host_name', -> ... To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
For example to get progress for update events issue: mysql> SELECT WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current -> WHERE EVENT_NAME LIKE 'stage/sql/Applying batch of row changes (update)' If ... The current progress ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script located in the share directory of your MySQL installation: install_rewriter.sql: Choose this script to install the Rewriter plugin and its associated elements.