Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/availability-advisors-ref.html
Default auto-close enabled yes MySQL Server Has Been Restarted To perform useful work, a database server must be up-and-running continuously. It is normal for a production server to run continuously for weeks, months, or longer. If a server has been ...Default frequency 00:05:00 Default auto-close enabled yes MySQL Availability Tracks MySQL availability, by making a full connection to the monitored instance on the configured ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connection-control.html
The connection-control plugin library enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed attempts. The plugin library contains two plugins: ...This ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Installation using RPM packages generates an initial random password, which is written to the server error log. For data directory initialization performed manually using mysqld --initialize, mysqld generates an initial random password, marks it ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
This ID indicates which part of the server produced the message, and is consistent with general query log and slow query log messages, which include the connection thread ID. For example: 2020-08-06T14:25:02.835618Z 0 [Note] [MY-012487] [InnoDB] DDL ... Each error log sink (writer) component has a characteristic output format it uses to write messages to its destination, but other factors may influence the content of the messages: The information available to the log ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-member-actions.html
The member actions configuration for a server can also be reset to the default after it has left the group. You can also configure member actions on a server that is not part of a group, as long as the Group Replication plugin is installed. In that ... Group Replication has the ability to set actions for the members of a group to take in specified ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with ...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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
All MySQL editions provide a component_keyring_file component, which stores keyring data in a file local to the server host. MySQL Enterprise Edition offers additional keyring components and plugins: component_keyring_encrypted_file: Stores keyring ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
Note Do not place comments on the same line as a section heading in the config.ini file; this causes the management server not to start because it cannot parse the configuration file in such cases. [mysqld]: Defines the cluster's MySQL server nodes ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/8.4/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Your MySQL connection id is 3 Server version: 8.4.6 Source ...Due to ...