Search Results
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
Or you might want to give different users access to different mysqld servers that they manage themselves. To achieve better performance, you can specify the following option differently for each server, to spread the load between several physical ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
To do so, create a text file text_file that contains the statements you wish to execute. file_name Sometimes you may want your script to display progress information to the user. The mysql client typically is used interactively, like this: mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-source.html
If you compile MySQL with clustering support, and perform the default installation (using make install as the system root user), mysqld is placed in /usr/local/mysql/bin. In Section 25.3.3, “Initial Configuration of NDB Cluster”, we create ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-source.html
Oracle provides precompiled NDB Cluster binaries for Windows which should be adequate for most users. Once the build process is complete, you can create a Zip archive containing the compiled binaries; Section 2.8.4, “Installing MySQL Using a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-management.html
See Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for more information. Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB Cluster. This is covered in Section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. The values shown in all of the columns ex_req, ex_req_imm_ok, ex_wait_ok, ex_wait_fail, ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgm.html
Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm. --backup-password-from-stdin[=TRUE|FALSE] Command-Line Format --backup-password-from-stdin This option ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
NDB records all changes occurring in all user transactions committing in an epoch (TimeBetweenEpochs, default 100 milliseconds), in one binary log transaction, referred to as an epoch transaction. NDB binary log injector transaction dependency ...To ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Performing point-in-time recovery of NDB Cluster tables with NDB Cluster and NDB Cluster Replication can be accomplished using a native NDB data backup (taken by issuing CREATE BACKUP in the ndb_mgm client) and restoring the ndb_binlog_index table ... Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-networking-issues.html
Applications using the cluster and user of those applications must not be permitted to have direct access to the management and data node hosts. In this section, we discuss basic network security issues as they relate to NDB Cluster. It is ...