Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-single-primary-mode.html
Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group Replication. This section explains how to create a replication group with three MySQL Server instances, each ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
With strict mode disabled, invalid dates such as '2004-04-31' are converted to '0000-00-00' and a warning is generated. Invalid DATE, DATETIME, or TIMESTAMP values are converted to the “zero” value of the appropriate type ('0000-00-00' or ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
MYSQL_OPT_SSL_MODE (argument type: unsigned int *) The security state to use for the connection to the server: SSL_MODE_DISABLED, SSL_MODE_PREFERRED, SSL_MODE_REQUIRED, SSL_MODE_VERIFY_CA, SSL_MODE_VERIFY_IDENTITY. The effect of ... int ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
When the client program connects, the server places the client session in sandbox mode if the device must be registered, so that registration must occur before anything else can be done. Sandbox mode used for FIDO/FIDO2 device registration is ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Workaround: Equality or NULL-safe equality should be present in the JOIN predicate. Error number: 1142; Symbol: HW_ER_AUTOCOMMIT_TURNED_OFF Message: You cannot be offload queries to HeatWave secondary engine because autocommit is disabled. Error ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
This memory is not calculated unless global_connection_memory_tracking is enabled (disabled by default). If the value is greater than zero, it is not safe to shut down the replica; see Section 19.5.1.31, “Replication and Temporary Tables”. When ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-config-metric-sourcestatus-category.html
Lists the Source Status configuration metrics and provides a brief description of each. Table 9.2 Source Status Configuration Metrics NameDescriptionSkip Errors Errors the server should skip. Load Data Temp Directory Directory used for temporary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
When the group is operating in single-primary mode, if you require the primary to remain the same throughout (except when it is being upgraded itself), it should be the last member to be upgraded. The group elects a new primary whenever necessary ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The exception is if you use mysqld to initialize the data directory manually by invoking it with the --initialize or --initialize-insecure option, when binary logging is disabled by default, but can be enabled by specifying the --log-bin option. To ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
Disable Group Replication from starting up automatically so that you can safely connect to the member after upgrading and configure it without it rejoining the group by setting group_replication_start_on_boot=0. The way which you join upgraded ...