Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--skip-new Command-Line Format --skip-new Deprecated Yes This option disables (what used to be considered) new, possibly unsafe behaviors. By default, read-only mode is disabled, so the mode is read/write. mysqld_safe reads options from the ... When ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
You can enable or disable innodb_strict_mode on the command line when starting mysqld, or in a MySQL configuration file. You can also enable or disable innodb_strict_mode at runtime with the statement SET [GLOBAL|SESSION] innodb_strict_mode=mode, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
If EnablePartialLcp is disabled (false), each LCP uses only a single file and writes a full checkpoint; this requires the least amount of disk space for LCPs, but increases the write load for each LCP. Setting this parameter to false also disables ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
Disabling purging of relay logs when enabling the --relay-log-recovery option risks data consistency and is therefore not crash-safe. For storage engines other than NDB, IDEMPOTENT mode should be used only when you are absolutely sure that ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
To work around this issue, use the --result-file option, which creates the output in ASCII format: mysqldump [options] --result-file=dump.sql It is not recommended to load a dump file when GTIDs are enabled on the server (gtid_mode=ON), if your dump ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special role. Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if ...Group Replication does not handle client-side failover itself, so you need to arrange this using a middleware framework such as MySQL Router 8.4, a proxy, a connector, or the application ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). The replica R1 ...You should not attempt to use these instructions to make a binary backup by copying files directly because the server may still have modified data cached in memory and not flushed to ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. FIPS mode on the server side applies to cryptographic operations performed by the server. FIPS mode also applies to attempts by ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
mysqlbinlog sets the value of pseudo_replica_mode to true before executing any SQL statements. This system variable affects the handling of XA transactions, the original_commit_timestamp replication delay timestamp and the original_server_version ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
3.14.7: I get an ER_NET_PACKET_TOO_LARGE exception, even though the binary blob size I want to insert using JDBC is safely below the max_allowed_packet size. throw sqlEx; } } } } while (!transactionCompleted && (retryCount > 0)); } Note Use of the ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...