Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-event-reports.html
By default, the cluster log is saved to a file named ndb_node_id_cluster.log, (where node_id is the node ID of the management server) in the management server's DataDir. Cluster logging information can also be sent to stdout or a syslog facility in ... In this section, we discuss the types of event logs provided by NDB Cluster, and the types of events that are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-configuration.html
The management node needs a config.ini file telling it how many fragment replicas to maintain, how much memory to allocate for data and indexes on each data node, where to find the data nodes, where to save data to disk on each data node, and where ... In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
--pending Command-Line Format --pending Save keys and certificates as pending, rather than active. Management of TLS keys and certificates in implemented in NDB Cluster as the executable utility program ndb_sign_keys, which can normally be found in ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
SET unique_checks=1; For big tables, this saves a lot of disk I/O because InnoDB can use its change buffer to write secondary index records in a batch. SET foreign_key_checks=1; For big tables, this can save a lot of disk I/O. These performance ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
This means the replica's record of the current position read from the source's binary log (in the applier metadata repository) is never ahead of the record of transactions saved in the relay log. This setting, which is the default, ensures that ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
A client user who can connect to the server some other way can use a SHOW STATUS LIKE 'Rsa_public_key' statement and save the returned key value in a file. MySQL provides two authentication plugins that implement SHA-256 hashing for user account ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
The binary log and relay log files are compressed and saved with the .bz extension when being included in a compressed backup. When a backup is not created in a file system (for example, when cloud storage is used to save the backup), or when the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-metadata-options.html
The string is saved in a file meta/comments.txt in the backup. Some metadata is stored in the backup directory, other metadata is stored in tables within the mysql database of the backed-up instance. --no-history-logging Turns off the recording of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
To select specific data to be backed up or restored, use the partial backup and restore options described in this section. For an overview of partial backup and restore, as well as usage examples on the following options, see Section 4.3.5, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
To set up a new replica for this source, restore the backup data on another server, start a replica server on the backup data, and issue a CHANGE REPLICATION SOURCE TO command with the binary log position saved in the ibbackup_replica_info file. To ... These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require special care in backing ...