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/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. Your identity is based on two pieces of ...A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-connections.html
For distributed recovery prior to MySQL 8.0.21, group members offer their standard SQL client connection to joining members, as specified by hostname and port. In MySQL 8.0.21 and later, group members may advertise an alternative list of distributed ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-communication-protocol.html
Versions from MySQL 5.7.14 allow compression of messages (see Section 20.7.4, “Message Compression”). Versions from MySQL 8.0.16 also allow fragmentation of messages (see Section 20.7.5, “Message Fragmentation”). Versions from MySQL 8.0.27 ... The following functions enable you to inspect and configure the Group Replication communication protocol version that is used by a replication ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
REDUNDANT Row Format COMPACT Row Format DYNAMIC Row Format COMPRESSED Row Format Defining the Row Format of a Table Determining the Row Format of a Table REDUNDANT Row Format The REDUNDANT format provides compatibility with older versions of MySQL.
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
Restoring Orphan File-Per-Table ibd Files This procedure describes how to restore orphan file-per-table .ibd files to another MySQL instance. You might use this procedure if the system tablespace is lost or unrecoverable and you want to restore .ibd ... Information about table definitions is stored in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.0/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... The syntax of table_factor is ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
This section describes how to set up a MySQL server to use binary log file position based replication. Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in ...There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source that you want to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-adding-gtid-master.html
Use the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication Channels”). These steps ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...