PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
Each replication channel must have a unique (nonempty) name, as explained in Section 19.2.2.4, “Replication Channel Naming Conventions”. This is because the server IDs of replicas must be unique in a replication topology. In MySQL multi-source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...This server ID is used to identify individual servers within the replication topology, and must be a positive integer between 1 and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
There are some generic tasks that are common to all setups: On the source, you must ensure that binary logging is enabled, and configure a unique server ID. On each replica that you want to connect to the source, you must configure a unique server ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 − 1. “Unique” means that each ID must be different from every other ID in use by any other source or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. For each server, you should pick a unique positive integer in the range from 1 to 232 − 1, and each ID must be different from every ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
-DWITH_BUILD_ID=bool On Linux systems, generates a unique build ID which is used as the value of the build_id system variable and written to the MySQL server log on startup. The CMake program provides a great deal of control over how you configure ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
Rows for which duplicate-key conflicts occur on a unique key value are not updated. Suppose that a table t contains a column id that has a unique index. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Because constraint names must be unique per schema (database), the change caused errors due to foreign key index names that were not unique per schema. Before upgrading to MySQL 8.0, review the changes described in this section to identify those ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
To make the statement legal, define the CTEs with unique names: WITH cte1 AS (...), cte2 AS (...) SELECT ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Applications can use the following guidelines to perform SQL-based ...