Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-two-channels.html
First, the mysqld processes for the primary and secondary replication source servers must be started, followed by those for the primary and secondary replicas. This requires a total of four replication servers, two source servers on the source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
To use semisynchronous replication, the following requirements must be satisfied: The capability of installing plugins requires a MySQL server that supports dynamic loading. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ...If necessary, ... Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous replication available on the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-plugins-overview.html
For a plugin compiled against MySQL 8.4.X, there is no guarantee it will work with a MySQL 8.4.Y server without recompiling for MySQL 8.4.Y. For server plugins, this means that mysqld must be linked dynamically. These conditions apply to plugin ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-configuration-tls.html
TLS Endpoint Configuration MySQL Router accepts the TLS session and opens a new TLS session to the server. To connect a TLS session to a server, MySQL Router verifies the server's certificates using server_ssl_verify, server_ssl_ca, ...The default ... Important This section is a draft and subject to ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-rest-api-reference.html
See Section 6.1, “A Simple MySQL Router REST API Guide” for related information. This is the maximum number (integer) of idling server connections in the connection pool. GET /connection_pool/{name}/status Shows reusedConnections as a count ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON When the server starts, it sees performance_schema and attempts to initialize the Performance Schema. To enable or disable it explicitly, start the server with ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. row *************************** EVENT_NAME: wait/io/socket/sql/server_unix_socket OBJECT_INSTANCE_BEGIN: 4316619408 THREAD_ID: 1 SOCKET_ID: 16 ...Information available in this table provides a real-time snapshot of the active connections to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
To view tablespace file locations, query the Information Schema FILES table: mysql> SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES \G . The innodb_directories variable, which defines directories to scan at startup for tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
At the command line, connect to the server as the MySQL root user, supplying the appropriate password at the password prompt: $> mysql -u root -p Enter password: (enter root password here) After connecting to the server, you can add new accounts.