Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
Disconnecting to allow Management Server to shutdown $> Because shutting down the management server causes the management client to terminate, you must start the management server from the system shell. This should be similar to what is shown here, ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-start-phases.html
Initialization consists of the following steps: Obtain a node ID Fetch configuration data Allocate ports to be used for inter-node communications Allocate memory according to settings obtained from the configuration file When a data node or SQL node ... This section provides a simplified outline of the steps involved when NDB Cluster data nodes are ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-server-id.html
When invoked with the --read-from-remote-server option, mysqlbinlog connects to a MySQL server, specifies a server ID to identify itself, and requests binary log files from the server. You can use mysqlbinlog to request log files from a server in ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
The following Performance Schema replication tables continue to be populated when the Performance Schema is disabled: replication_connection_configuration replication_connection_status replication_asynchronous_connection_failover ...This is similar ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. Each line that shows when a client connects also includes using connection_type to indicate the protocol used to ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. MySQL uses security based on Access Control Lists (ACLs) for all connections, queries, and other operations that users ...In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. MySQL reserves one extra connection to be used by accounts that have the CONNECTION_ADMIN privilege (or the ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/windows-server-first-start.html
They can use TCP/IP, or they can use a named pipe if the server supports named-pipe connections. MySQL for Windows also supports shared-memory connections if the server is started with the shared_memory system variable enabled. Clients can connect ... This section gives a general overview of starting the MySQL ...