Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
Follow this procedure to restart a replication group safely after every member shuts down. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-throttling.html
This means that every member has an established write quota based on the available capacity, in other words a number of transactions it can safely issue for the next period. Based on the metrics gathered across all servers in the group, a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
Group Replication includes compatibility policies that enable you to safely combine members running different versions of MySQL in the same group during the upgrade procedure. This section explains how to upgrade a Group Replication setup. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-networking-issues.html
This network setup is safest because no packets can reach the cluster's management or data nodes from outside the network—and none of the cluster's internal communications can reach the outside—without going through the SQL nodes, as long as the ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise.html
Like MySQL Community Edition, MySQL Enterprise Edition includes MySQL Server, a fully integrated transaction-safe, ACID-compliant database with full commit, rollback, crash-recovery, and row-level locking capabilities. In addition, MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
For example, to set the size for the server to 128MB, add the following lines in an option file: [mysqld] max_allowed_packet=128M It is safe to increase the value of this variable because the extra memory is allocated only when needed. If you ... A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
For a server where GTIDs are in use (gtid_mode is ON), issuing RESET BINARY LOGS AND GTIDS resets the GTID execution history. The behavior of RESET BINARY LOGS AND GTIDS when used while replicas are running is undefined (and thus unsupported), ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. To make FILE-privilege operations a bit safer, files generated with SELECT ... This can be ... When you connect to a MySQL server, you should use a ...