Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-connections-in-javascript-and-python.html
You can use functions available in JavaScript and Python mode to create multiple session objects of your chosen types and assign them to variables. These modules must be imported before use, which is done automatically when MySQL Shell is used in ...These session objects let you establish and manage concurrent connections to work with multiple MySQL Server instances, or with the same instance in multiple ways, from a single MySQL Shell ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-mode.html
In disabled mode, polices are not enforced, and contexts are not applied to system objects, which makes it difficult to enable SELinux later. Permissive mode allows operations that are not permitted in enforcing mode and logs those operations to the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
For more information about enabling, using, and disabling mysql_native_password, see Section 8.4.1.1, “Native Pluggable Authentication”. For more information, see the descriptions of the gtid_next system variable and the TRANSACTION_GTID_TAG ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndbcluster Command-Line Format --ndbcluster[=value] Disabled by skip-ndbcluster Type Enumeration Default Value ON Valid Values OFFFORCE The NDBCLUSTER storage engine is necessary for using NDB Cluster. If a mysqld binary includes support for the ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
The safest and most convenient way to provision a new instance is through automatic clone provisioning, which will completely overwrite the state of '127.0.0.1:3320' with a physical snapshot from an existing cluster member. The incremental state ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
(See Section 19.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. In such cases, a warning is still issued by this ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. (If strict SQL mode is not enabled, truncation for INSERT is permissible.) ...
https://dev.mysql.com/doc/internals/en/scripts-directory.html
Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table mysql_secure_installation.sh --- Disallow remote root login, eliminate test, etc. Linux programmers use it ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type Enumeration Default Value OFF ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-dump.html
You can also choose to disable index creation during the import, and create the indexes afterwards, for example if you want to make changes to the table structure after loading. For an additional improvement to data loading performance, you can ...