Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-user-accounts.html
The member servers in an InnoDB Cluster make use of three types of user accounts. One InnoDB Cluster server configuration account is used to configure the server instances for the cluster. One or more InnoDB Cluster administrator accounts can be ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-rsa-files-using-mysql.html
At startup, the server automatically generates server-side and client-side SSL certificate and key files in the data directory if the auto_generate_certs system variable is enabled, no SSL options are specified, and the server-side SSL files are ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-component-installation.html
To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). Note A keyring component must be enabled on the MySQL server instance if you need to ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-failover.html
GTIDs play a key role in applying changes to the database: the server automatically skips any transaction having an identifier which the server recognizes as one that it has processed before. This poses some challenges when provisioning a new server ... There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-status.html
The extended output adds the status of each member server in each cluster, information about the asynchronous replication channels managed by InnoDB ClusterSet, and other configuration and status information. The command reports the status of ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
If you stop and then restart the server without the --upgrade=MINIMAL option, the server upgrades the system tables automatically, if needed. The following information appears in the Log tab and log file after the upgrade configuration (with system ...Product Catalog MySQL Installer Dashboard Locating Products to Install Upgrading MySQL Server Removing MySQL Server Upgrading MySQL Installer Product Catalog The product catalog stores the complete list of released MySQL products for Microsoft Windows that are available to download from MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-yum-repo.html
See Section 2.5.9, “Managing MySQL Server with systemd” for additional information. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-secure-connections.html
To further harden your deployment, you can use the tls_ciphersuites variable to limit the ciphersuites that the server permits for encrypted connections that use TLSv1.3. Restart the server to apply the configuration changes: $> systemctl restart ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-network-partitioning.html
Set the group_replication_unreachable_majority_timeout system variable for the group members to avoid this situation. The following sections explain what to do if the system partitions in such a way that no quorum is automatically achieved by the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utils-copy.html
Requirements and Restrictions The copy utilities use LOAD DATA LOCAL INFILE statements to upload data, so the local_infile system variable must be set to ON on the target server. The size of these columns therefore must not exceed approximately 0.74 ...It is possible to copy from a source to an MySQL HeatWave Service DB ... This section describes the MySQL Shell copy utilities: About the Utilities Requirements and Restrictions Running the Utilities Options for Copy Control Options for Filtering Examples About the Utilities The copy utilities enable you to copy DDL ...