Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
When the member is in offline mode, connected client users are disconnected on their next request and connections are no longer accepted, with the exception of client users that have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). This exit action prevents both updates and stale reads (with the exception of reads by client users with the stated privileges), and enables proxy tools such as MySQL Router to recognize that the server is unavailable and redirect client ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
Figure 2.6 MySQL Preference Pane: Location The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ directory. macOS uses launch daemons to automatically start, stop, and manage processes and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-general-info.html
Instead, users of NDB Cluster binaries from Oracle should upgrade to the most recent binary release of NDB Cluster for supported platforms—these include RPMs that should work with most Linux distributions. NDB Cluster 8.4 users who build from ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-nodes.html
This is one of: NOTHING, CMVMI, STARTING, STARTED, SINGLEUSER, STOPPING_1, STOPPING_2, STOPPING_3, or STOPPING_4. SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 25.6.6, “NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-nodes-groups.html
(You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are additional constraints on setting it; see the description of MaxNoOfExecutionThreads for more ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates with users by setting the message column of table rows. This plugin also supports a privilege (SKIP_QUERY_REWRITE) that protects a given ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and others. Access control and security within the database system itself, including ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration.html
Windows users may execute Section 2.3.2, “Configuration: Using MySQL Configurator” to help configure a MySQL server installation. This includes tasks such as configuring MySQL users, log files, the Windows service name, and sample databases.
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
User: The replica server user name, as specified on the replica with the --report-user option. SHOW REPLICAS Displays a list of replicas currently registered with the source. SHOW REPLICAS should be executed on a server that acts as a replication ...