PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-single-primary-mode.html
This section explains how to create a replication group with three MySQL Server instances, each running on a different host machine. Figure 17.4 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. Group Replication’s failure detection mechanism is a distributed service which is able to identify that a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-monitoring.html
Replication channels created by the Group Replication plugin are listed here: group_replication_recovery: Used for replication changes related to distributed recovery. Note If you are monitoring one or more secondary instances using mysqladmin, you ... You can use the MySQL Performance Schema to monitor Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
If misused, it could create an artificial split-brain scenario or block the entire system altogether. In that case, forcing a group membership list with s1 and s2 could create an artificial split-brain situation. The group needs to achieve ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
https://dev.mysql.com/doc/refman/5.7/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the INNODB_SYS_COLUMNS table. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-example.html
First, client A creates a table containing one row, and then begins a transaction. The following example illustrates how an error can occur when a lock request causes a deadlock. The lock cannot be granted because it is incompatible with the S lock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
Conversely, the parameter innodb_file_format (which enables a specific format) only determines whether or not a new table can be created in the enabled format and has no effect on whether or not a database can be opened. The file format tag is a ...