PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
There are different methods of setting up a data directory for a new instance: Create a new data directory. Even when the preceding precautions are observed, this kind of setup works only with MyISAM and MERGE tables, and not with any of the other ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
To do this, create an option file for each server and tell the server the file name with a --defaults-file option when you run it. Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
The maximum number of channels that can be created on one replica server in a multi-source replication topology is 256. Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
This method is simple and effective, but requires the replica to read the binary log from the source; it can sometimes take a comparatively long time for the new replica to catch up with the source, so this method is not suitable for fast failover ... 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.0/en/replication-multi-source-configuration.html
Create a suitable user account on all the sources that the replica can use to connect. Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which ... A multi-source replication topology requires at least two sources and one replica ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-file.html
Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. This file, with which you should be familiar with from previous work with MySQL, must be accessible by each executable running in ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
The following table lists the base collations of the Unicode character sets for which UCA collations can be defined. It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as ... This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the audit_api_message_emit component, use this statement: UNINSTALL COMPONENT ... As of MySQL 8.0.14, the audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based filtering. Modifications to audit_log_include_accounts or ...Legacy ...