MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 301 to 310 of 317 total results

19.5.5 How to Report Replication Bugs or Problems

https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html

For example, if you update the replica outside of the replication threads, the data goes out of synchrony, and you can have unique key violations on updates. When you have determined that there is no user error involved, and replication still ...

19.1.3.5 Using GTIDs for Failover and Scaleout

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html

Each identifier uniquely identifies a set of binary log events that together make up a transaction. There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can ...

19.1.5 MySQL Multi-Source Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html

This is because the server IDs of replicas must be unique in a replication topology. MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in parallel. In a multi-source replication topology, a ...

19.1.6.5 Global Transaction ID System Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html

GTID transactions have a unique identifier that is used to refer to transactions. The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see ...

19.1.6.1 Replication and Binary Logging Option and Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html

The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...

19.3.3.2 Privilege Checks For Group Replication Channels

https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html

Group Replication requires every table that is to be replicated by the group to have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key. From MySQL 8.0.19, as well as securing asynchronous and ...

19.5.4 Troubleshooting Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html

Verify that the server_id system variable was set at startup on both the source and replica and that the ID value is unique on each server. If you have followed the instructions but your replication setup is not working, the first thing to do is ...

19.2.5.4 Replication Channel Based Filters

https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html

This is because the server IDs of replicas must be unique in a replication topology. This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication topology. Before ...

7.6.4.3 Rewriter Query Rewrite Plugin Reference

https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html

Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...

5.3.4.3 Selecting Particular Columns

https://dev.mysql.com/doc/refman/8.0/en/selecting-columns.html

If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.

Displaying 301 to 310 of 317 total results