Search Results
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. This means that, for a query that cannot use any indexes and so requires a full table scan, the server ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Most full-text variables described in this section must be set at server startup time. A server restart is required to change them; they cannot be modified while the server is running. For example, to make two-character words searchable, you could ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
Using MySQL Server’s own connection security in place of Group Replication’s implementation. Using the MySQL protocol means that standard methods of user authentication can be used for granting (or revoking) access to the group in place of the ... MySQL 8.4 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
The most common way to deploy Group Replication is using multiple server instances, to provide high availability. The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
In the case of statement-based replication, this means that when an SQL statement is replicated on a replica server, the same values are used for the auto-increment column as on the source server. If auto-increment values generated by multiple ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. After restarting a busy server, there is ...The ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
It is similar to the preceding procedure for local clients, but the server and client hosts are distinct and each has its own nonlocal IPv6 address. The example uses these addresses: Server host: 2001:db8:0:f101::1 Client host: 2001:db8:0:f101::2 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
# file "config.ini" - showing minimal setup consisting of 1 data node, # 1 management server, and 3 MySQL servers. # Data nodes must provide a hostname but MySQL Servers are not required # to do so. [ndbd default] NoOfReplicas= 1 [mysqld default] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-two-channels.html
This requires a total of four replication servers, two source servers on the source cluster and two replica servers on the replica cluster. First, the mysqld processes for the primary and secondary replication source servers must be started, ... In ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the logs. (Direct modification of grant tables is discouraged, anyway.) For the general query log, password rewriting can be ...