Search Results
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
The optimization occurs because the query sent to the remote server includes the contents of the WHERE clause and is sent to the remote server and subsequently executed locally. This reduces the network traffic that would otherwise request the ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
Automatic loading of loadable functions occurs during the normal server startup sequence: Functions registered in the mysql.func table are installed. With the function no longer registered in the mysql.func table, the server does not load the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-fault-tolerance.html
MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. As such, it requires a majority of servers to be active to reach quorum and thus make a decision. The number ...This has direct impact on the number of failures the system can tolerate without compromising itself and its overall ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
The safest method to reconcile the joining member’s data and GTID set with the members currently in the group is to use MySQL's cloning functionality to transfer the content from a server in the group to the affected server. Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Group Replication cannot be started following a MySQL Server upgrade that uses the MINIMAL option (--upgrade=MINIMAL), which does not upgrade system tables on which the replication internals depend. Global replication filters cannot be used on a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...If a table relies on a feature that is specific to another storage engine, you receive an ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
If (despite this warning) you run multiple servers using the same data directory and they have logging enabled, you must use the appropriate options to specify log file names that are unique to each server. Permitting multiple MySQL servers to ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-services.html
On Windows, a MySQL server can run as a Windows service. To set up multiple MySQL services, you must make sure that each instance uses a different service name in addition to the other parameters that must be unique per instance. For the following ...The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.3.8, “Starting MySQL as a Windows ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The asynchronous connection failover mechanism can be used to keep a replica synchronized with multiple MySQL servers or groups of servers that share data. If the new servers are provisioned using MySQL’s clone functionality, this all happens ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...