Search Results
https://dev.mysql.com/doc/refman/8.4/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/refman/8.4/en/faqs-mysql-cluster.html
See Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”, and Section 25.5.5, “ndb_mgm — The NDB Cluster Management Client”, for information about these programs. What programming languages and APIs are supported by NDB ...Do I have to learn a new programming or query language to use NDB Cluster? ... In the following section, we answer ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
During this process, the server upgrades metadata for all database objects, including databases, tablespaces, system and user tables, views, and stored programs (stored procedures and functions, triggers, and Event Scheduler events). In-Place ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host.
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its clients. The plugin works with these KMIP-compatible products: Oracle Key Vault Gemalto SafeNet KeySecure ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux Server. Selecting a Release Series Within the MySQL SLES repository, different release series of the ...Adding the MySQL SLES Repository Add or update the official MySQL SLES repository for your system's repository list: Note The beginning part of the configuration file name, such as mysql84, describes the default MySQL series that is enabled for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. On the source and each replica, you must set the server_id system variable to establish a unique replication ID. For each server, you ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
Install the server as a service using this command: C:\> "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqld" --install The service-installation command does not start the server. As a more complex example, consider the following command: C:\> ...A ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-secure-connections.html
Permissions for the data directory enable access only to the mysql account that runs the MySQL server, so client programs cannot use files located there. This section describes configuring the server for secure connections and distributing client ...(MySQL Enterprise Edition is compiled using OpenSSL.) The only requirement is that the --ssl option is enabled, which it is by default, and no other --ssl-* options are ...