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/replication-rules.html
On the source, you can control which databases to log changes for by using the --binlog-do-db and --binlog-ignore-db options to control binary logging. For a description of the rules that servers use in evaluating these options, see Section ... If a ...To make it easier to determine what effect a given set of options has, it is recommended that you avoid mixing do-* and ignore-* options, or options containing wildcards with options which do ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Figure 19.1 Using Replication to Improve Performance During ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. The message lists the following statistics for the relevant ... On a ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-elements.html
Otherwise, the plugin returns an error to the client and the statement fails. If the server has a different state when a client sends a statement, the client receives an error. Version Tokens is based on a plugin library that implements these ...
https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. When performing foreign key checks, InnoDB sets shared row-level locks on child ...If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-general-info.html
(Locations where the sources can be obtained are listed later in this section.) Important MySQL NDB Cluster does not support InnoDB Cluster, which must be deployed using MySQL Server 8.0 with the InnoDB storage engine as well as additional ... MySQL ...MySQL Server 8.0 binaries cannot be used with MySQL NDB ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
However, it is important to understand that if one of the group members becomes unavailable, the clients connected to that group member must be redirected, or failed over, to a different server in the group, using a connector, load balancer, router, ...Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
To use this statement, you must have some privilege for the table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
It is important to understand that although the database service is available, in the event of an unexpected server exit, those clients connected to it must be redirected, or failed over, to a different server. To summarize, MySQL Group Replication ... Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of ...