Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-info-table.html
PERSISTED The variable was set from a server-specific mysqld-auto.cnf option file. The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from ...
https://dev.mysql.com/doc/refman/9.7/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. If any plugin ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/9.7/en/privileges-provided.html
Accounts created with the SYSTEM_USER privilege have the AUDIT_ABORT_EXEMPT privilege assigned automatically when they are created. The BACKUP_ADMIN privilege is automatically granted to users with the RELOAD privilege when performing an in-place ...
https://dev.mysql.com/doc/refman/9.7/en/program-options.html
For the server, one exception applies: The mysqld-auto.cnf option file in the data directory is processed last, so it takes precedence even over command-line options. There are several ways to specify options for MySQL programs: List the options on ...
https://dev.mysql.com/doc/refman/9.7/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given program. This works well ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover-source.html
To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this channel. GTID auto-positioning must be in use for the channel (SOURCE_AUTO_POSITION = ...Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover.html
You can use the asynchronous connection failover mechanism to establish an asynchronous (source-to-replica) replication connection to a new source automatically, after the existing connection from a replica to its source fails. The asynchronous ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-transaction-inconsistencies.html
When GTID-based replication is in use (GTID_MODE=ON) and SOURCE_AUTO_POSITION is set for the replication channel using the CHANGE REPLICATION SOURCE TO statement, the old relay logs are not required for the recovery process. Instead, the replica can ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-failover.html
GTIDs play a key role in applying changes to the database: the server automatically skips any transaction having an identifier which the server recognizes as one that it has processed before. This behavior is critical for automatic replication ...