Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
On Windows, MySQL Installer interacts with the user and creates a file named my.ini in the base installation directory as the default option file. For non-Windows platforms, no default option file is created during either the server installation or ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden columns that MySQL uses internally and are not accessible ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-single-file.html
Besides the commands for creating and restoring single-file backups (namely, backup-to-image and copy-back-and-apply-log), mysqlbackup provides a number of other commands for you to work with single-file backups. Note image-to-backup-dir only ...To ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encryption.html
The encryption can also be applied when creating a partial, compressed, or incremental single-file backups, and for streaming backup data to another device or server. The encryption is performed with Advanced Encryption Standard (AES) block cipher ... In order to enhance security for backed up data, MySQL Enterprise Backup provides encryption for single-file ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-windows-service.html
The installation is performed using the command prompt (cmd.exe); as with installing or removing any Windows service, it must also be done as a user having sufficient permissions, such the system Administrator account. To install the MySQL Cluster ... Important Installation of the MySQL Cluster Manager agent as a service is ...
https://dev.mysql.com/doc/relnotes/mysql-router/8.4/en/news-8-4-6.html
(Bug #38009073) Users created with a comment in their definition were unable to connect using MySQL Router. Note These release notes were created with the assistance of MySQL HeatWave GenAI. This change affects the auto-generated certificates ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/adding-replicaset-instances.html
When you have created a ReplicaSet, you can use the ReplicaSet.addInstance() operation to add an instance as a read-only secondary replica of the current primary of the ReplicaSet. MySQL Replication is configured between the added instance and the ...The primary of the ReplicaSet must be reachable and available during this ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-overview.html
In addition, AdminAPI supports administration of some MySQL Router related tasks, such as creating or upgrading a user account that works with InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. For example, use the dba.createCluster() method ...AdminAPI is accessed through the dba global variable and its associated ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-requirements.html
The channels created automatically by Group Replication (group_replication_applier and group_replication_recovery) are allowed on a replication group that is being adopted. If you are migrating an existing replication topology to an InnoDB Cluster ... Before installing a production deployment of InnoDB Cluster, ensure that the server instances you intend to use meet the following ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-objects.html
You can define extension objects and make them available as part of user-defined MySQL Shell global objects. When you create and register an extension object, it is available in both JavaScript and Python modes. However, for good management of your ...A member can be a basic data type value, a function written in native JavaScript or Python, or another extension ...