Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-connection-strings.html
With the exception of the NDB Cluster management server (ndb_mgmd), each node that is part of an NDB Cluster requires a connection string that points to the management server's location. This connection string is used in establishing a connection ...The syntax for a connection string is as follows: [nodeid=node_id, ]host-definition[, host-definition[, ...]] host-definition: host_name[:port_number] node_id is an integer greater than or equal to 1 which identifies a node in ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...In addition, patterns are permitted in instrument names to configure instruments that match the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
The encryption algorithm used for the files, the AES (Advanced Encryption Standard) cipher algorithm, is built in to MySQL Server and cannot be configured. You enable this encryption on a MySQL server by setting the binlog_encryption system variable ... MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating system where they are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
This method can also be used if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. If you are setting up a new replication environment using ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. In this case, the server applies resource limits in this row collectively to all connections by usera from ...This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.encrypted-binlog-relaylog.html
mysqlbackup then copies over from the server the encrypted keyring data file, which contains the replication master key used to encrypt all the passwords for the individual log files, into the meta folder in the backup and names the file keyring_kef. If the server uses a keyring plugin or component other than component_keyring_encrypted_file, mysqlbackup accesses the keyring to obtain the replication master key and uses it to decrypt the individual log files' ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
You can restore your database server to its state at an arbitrary time using the binary log files included in the backups. The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which ...The last backup in the series covers the targeted point in time for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
The restore operations restores the data files from a backup to their original locations on the database server, or to other desired locations. Normally, the restoration process requires the database server to be already shut down (or, at least not ...The option datadir must be specified either in the file specified by the --defaults-file option or as a command-line ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-faq.html
This file represents the InnoDB system tablespace, which grows but never shrinks as a database server operates, and is included in every full and incremental backup. A.6: Can I back up a database server on one OS platform and restore it on another ... This section lists some common questions about MySQL Enterprise Backup, with answers and pointers to further ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.