Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value false Since Version 5.1.27 ha.enableJMX Enables JMX-based management of load-balanced connection groups, including live addition/removal of hosts from load-balancing pool. Enables JMX-based management of replication connection groups, ... autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Note Global replication filters cannot be set on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. Channel specific ...Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD first (and restarted with START REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.4/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In most cases, a DISTINCT clause can be considered as a special case of GROUP BY. Thus, for more details ... DISTINCT combined with ORDER BY needs a temporary table in many ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
InitialLogFileGroup: Describes log file group that is created during initial start. NodeGroup: Node group to which data node belongs; used only during initial start of cluster. NodeGroupTransporters: Number of transporters to use between nodes in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). The option also causes the removal of all data files associated with Disk Data tablespaces and ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
The table_io_waits_summary_by_table table has these grouping columns to indicate how the table aggregates events: OBJECT_TYPE, OBJECT_SCHEMA, and OBJECT_NAME. The only difference is the additional group column, INDEX_NAME, which corresponds to the ... The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock waits per table 29.12.20.8.1 The table_io_waits_summary_by_table Table The table_io_waits_summary_by_table table aggregates all table I/O wait events, as generated by the wait/io/table/sql/handler ...
https://dev.mysql.com/doc/refman/8.4/en/replication-security.html
For Group Replication, binary log encryption and privilege checks can be used as a security measure on replication group members. You should also consider encrypting the connections between group members, comprising group communication connections ... To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your installation, as described in Chapter 8, ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
Note that the Group Replication applier channel (group_replication_applier) has no replication I/O (receiver) thread, only a replication SQL (applier) thread. The replication channels for Group Replication (group_replication_applier and ...] ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. The maximum number of query threads permitted in a thread group is ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”. Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...