Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-dashboard-ui-ref.html
If GTID mode and binary logging are disabled, the replica cannot be promoted. Flow Control (Group Replication only) The mode used for flow control. For a replica to be eligible for promotion to source, it must have the same GTID mode as the source.
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-security.html
Default Value false Since Version 5.1.31 sslMode By default, network connections are SSL encrypted; this property permits secure connections to be turned off, or a different levels of security to be chosen. Note that, for all server versions, the ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
If specified at server startup, general_log takes an optional argument of 1 or 0 to enable or disable the log. The general_log and slow_query_log variables indicate whether the general query log and slow query log are enabled (ON) or disabled (OFF).
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Disable password expiration: CREATE USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER; ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER; This expiration option overrides the global policy for all accounts named by the statement. If ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate any ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
To disable or enable the general query log or change the log file name at runtime, use the global general_log and general_log_file system variables. Set general_log to 0 (or OFF) to disable the log or to 1 (or ON) to enable it. You can also rename ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
If you later disable SOURCE_CONNECTION_AUTO_FAILOVER for the channel on the primary, this is also broadcast to the secondary servers, and they change the status of the channel to match. When the mysql_start_failover_channels_if_primary member action ... Asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO statement for the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
If binary logging is disabled on the replica, the GTID is persisted atomically by writing it directly into the mysql.gtid_executed table. If binary logging is disabled on the replica, the mysql.gtid_executed table is also a complete record of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/workbench/en/wb-keys.html
The following tables list keyboard shortcuts for MySQL Workbench commands.