Search Results
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The following sections illustrate the syntax for creating both kinds of indexes. Indexes The MEMORY storage engine supports both HASH and BTREE indexes. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
The “something you know” factor type relies on information that is kept secret on both sides of the authentication process. Multifactor authentication can use non-WebAuthn MySQL authentication methods, the WebAuthn authentication method, or a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-shutdown-restart.html
To restart the cluster on Unix platforms, run these commands: On the management host (198.51.100.10 in our example setup): $> ndb_mgmd -f /var/lib/mysql-cluster/config.ini On each of the data node hosts (198.51.100.30 and 198.51.100.40): $> ndbd Use ... To shut down the cluster, enter the following command in a shell on the machine hosting the management node: $> ndb_mgm -e shutdown The -e option here is used to pass a command to the ndb_mgm client from the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
Notes For each running data node in the cluster, the transporters table displays a row showing the status of each of that node's connections with all nodes in the cluster, including itself. This information is shown in the table's status column, ...
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-replication-mta.html
Therefore, for two consecutive epoch transactions to be independent, and possible to apply in parallel, it is required that no row is modified in both epochs. If any single row is modified in both epochs, then they are dependent, and are applied ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner (receive thread or user thread) in NDB. (NDB 8.4.0) If this parameter and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
Both private keys and certificates are labeled as either active (current) or pending. Start ndb_mgmd with the --reload and --config-file options both times to ensure that each of the two configuration file changes is read by the management server.
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
In addition, the source and destination components must differ, and both components must be properly configured so that mysql_migrate_keyring can load and use them. In addition, the source and destination components must differ, and both components ... The mysql_migrate_keyring utility migrates keys between one keyring component and ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
--ignore-table=db_name.tbl_name Command-Line Format --ignore-table=db_name.tbl_name Type String Do not dump the given table, which must be specified using both the database and table names. The RELOAD or FLUSH_TABLES privilege is required with ...