Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster data. Note For a discussion of MySQL server options for NDB Cluster, see Section ...If no computer or host name is provided, any host can use this SQL or API ...Id Version (or later) NDB 8.4.0 Type or units unsigned Default [...] Range 1 - 255 Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both ...You ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-validation.html
MySQL supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the server terminates with an exit ...If an error is found, the server displays a diagnostic message and terminates with an exit code of ...Warning and information messages may also be displayed, depending on ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
(An optional in-memory key cache may be used as intermediate storage.) Random key generation is performed on the MySQL server side, with the keys subsequently stored to Hashicorp Vault. For example, if you have reconfigured HashiCorp Vault to listen ...No key information is permanently stored in MySQL server local ... Note The keyring_hashicorp plugin is an ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
The syntax is --action_option=action_value with a full list of action options below: Table 2.7 Action Options Action option Shortcut Aliases Type Values Default value Action Condition Description datadir d data-dir, data-directory Path N/A ... MySQL ...help h N/A --help Displays general help or help for the corresponding ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
This minimizes the overhead and expense of establishing and tearing down connections as queries are submitted to the MySQL server. The MySQL Connection Pool has no visibility as to the query handling capabilities or load of the back-end MySQL server. By contrast, the Thread Pool operates on the MySQL server side and is designed to manage the execution of inbound concurrent connections and queries as they are received from the client connections accessing the back-end MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
This is typically the value of the plugin_dir system variable for the local MySQL server. --get-server-public-key Command-Line Format --get-server-public-key Type Boolean Request from the server the public key required for RSA key pair-based ... The ...--component-dir=dir_name Command-Line Format --component-dir=dir_name Type Directory name The directory where keyring components are ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
mysqlx_document_id_unique_prefix Command-Line Format --mysqlx-document-id-unique-prefix=# System Variable mysqlx_document_id_unique_prefix Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
For details on how the MySQL server encrypts and decrypts InnoDB tablespaces, see InnoDB Data-at-Rest Encryption—it explains concepts like master key and tablespace keys, which are important for understanding how MySQL Enterprise Backup works with ...When InnoDB tablespace encryption uses a centralized key management solution, the feature is referred to as “MySQL Enterprise Transparent Data Encryption (TDE).” The following is a brief description on how encrypted InnoDB tablespaces are handled by MySQL Enterprise Backup in backup, restore, and apply-log ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...