Search Results
https://dev.mysql.com/doc/refman/9.7/en/federated-storage-engine.html
The FEDERATED storage engine is not enabled by default in the running server; to enable FEDERATED, you must start the MySQL server binary using the --federated option. The FEDERATED storage engine lets you access data from a remote MySQL database ...
https://dev.mysql.com/doc/refman/9.7/en/firewall.html
This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. This is done automatically when you migrate from the firewall plugin ... Note MySQL Enterprise Firewall is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/9.7/en/group-by-handling.html
In this case, the server is free to choose any value from each group, so unless they are the same, the values chosen are nondeterministic, which is probably not what you want. Result set sorting occurs after values have been chosen, and ORDER BY ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-change-primary.html
If all members are not running the same MySQL Server version, you can specify a new primary member that is running the lowest MySQL Server version in the group only. This section explains how to change which member of a single-primary group is the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-compatibility-upgrade.html
During an online upgrade procedure, if the group is in single-primary mode, all the servers that are not currently offline for upgrading function as they did before. The primary cannot remain as the primary unless it is running the lowest MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-launching.html
It is first necessary to ensure that the Group Replication plugin is installed on server s1. Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> ...If you used plugin_load_add='group_replication.so' in the option file then the Group Replication plugin is already installed, and you can proceed to the next ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-offline-upgrade.html
If you have a requirement to allow members at earlier releases to join, you can use the group_replication_set_communication_protocol() function to downgrade the communication protocol version, specifying the MySQL Server version of the prospective ... To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-upgrade-with-mysqlbackup.html
The solution is to restore the backup to a new server instance which is running the same version of MySQL as the member which the backup was taken from, and then upgrade the instance. Deploy a new server instance, which must be running the same ...
https://dev.mysql.com/doc/refman/9.7/en/gtid-functions.html
row *************************** GTID_SUBTRACT('3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57', '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57'): 1 row in set (0.00 sec) WAIT_FOR_EXECUTED_GTID_SET(gtid_set[, timeout]) Wait until the server has applied all ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-session-temp-tablespaces-table.html
Session temporary tablespaces are recreated each time the server is started. Space IDs are not persisted when the server is shut down and may be reused. The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces ...