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/group-replication-member-actions.html
If the server where you use the functions to configure a member action is part of a group, it must be the current primary in a group in single-primary mode, and it must be part of the majority. If an error occurs when the member action is being ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html
You must ensure that no warnings are being generated in the error logs before going to the next step. Before you start, ensure that the servers meet the following pre-conditions: All servers in your topology must use MySQL 5.7.6 or later. After this ...This procedure does not require taking the server offline and is suited to use in ... This section describes how to enable GTID transactions, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-source.html
The archived source file should have a name similar to mysql-8.0.43.tar.gz. You must configure the build using the WITH_NDB option in addition to any other build options you wish to use with CMake. This means that, by default, if CMake cannot find ...The procedure for doing this is almost identical to the procedure used to compile the standard MySQL Server binaries for Windows, and uses the same ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slaveinit.html
You must be able to connect to the source MySQL server using TCP/IP. To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. The CHANGE REPLICATION SOURCE TO | CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
} This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT statements that must be executed to duplicate the privilege and role assignments. Each role named in the USING clause must be ...Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER ... SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
Structured variable instances and components follow these naming rules: For a given type of structured variable, each instance must have a name that is unique within variables of that type. The names of the components of each structured variable ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 franchises as shown in the following table. You can cause this type of error to be ignored by ...As in partitioning by RANGE, each partition must be explicitly ... List ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
A member with extra transactions cannot rejoin the group, and the attempt results in an error with the message This member has more executed transactions than those present in the group. A member with extra transactions cannot rejoin the group, and ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
plugin_name must be the name of some plugin that is listed in the mysql.plugin table. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
and db_name.event_name notation, as shown here: ALTER EVENT olddb.myevent RENAME TO newdb.myevent; To execute the previous statement, the user executing it must have the EVENT privilege on both the olddb and newdb databases. (See Section 15.1.13, ...