PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
If any member is running a MySQL Server version between MySQL 8.0.13 and MySQL 8.0.16, this safeguard is not enforced for the group and you can specify any new primary member, but it is recommended to select a primary that is running the lowest ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
The primary cannot remain as the primary unless it is running the lowest MySQL Server version in the group. The group elects a new primary whenever necessary from among the members running the lowest MySQL Server version, following the election ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. To enable read-only mode for an entire MySQL instance, specify the following configuration ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. Permitting multiple MySQL servers to access a common data directory over NFS is a very bad idea. Create a New Data Directory With this method, the data directory is in the same ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
You must perform this step directly on the MySQL server host because persist_only_admin_x509_subject itself cannot be persisted at runtime. SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. If you store values larger than the display width in an integer column that has the ZEROFILL ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/replica-sql-thread-states.html
In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for ... The following list shows the most common states you may see in the State column for a replication SQL thread on a replica ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
The Event Scheduler is controlled by the event_scheduler system variable, which defaults to ON from MySQL 8.0, so events that are active on the original server run by default when the new replica starts up. As an alternative to creating a new ...