Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
To use semisynchronous replication, the following requirements must be satisfied: The capability of installing plugins requires a MySQL server that supports dynamic loading. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-rawdata.html
To guarantee the integrity of the files that are copied, backing up the raw data files on your MySQL replica should take place while your replica server is shut down. If the MySQL server is still running, background tasks may still be updating the ...With InnoDB, these problems should be resolved during crash recovery, but since the replica server can be shut down during the backup process without affecting the execution of the source it makes sense to take advantage of this ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. The password may be either explicitly ...The statement may also include a password-verification clause that specifies the account current password to be replaced, and a clause that manages whether an account has a secondary ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
SET counter = counter + increment; END WHILE; END; System Variable Assignment The MySQL server maintains system variables that configure its operation. SET can also be used to persist certain system variables to the mysqld-auto.cnf file in the data ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
MySQL also supports a native JSON data type and a set of SQL functions to enable operations on JSON values. mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
Note The more instruments and consumers enabled, the more impact on MySQL server performance. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For use with MySQL HeatWave Service and MySQL HeatWave, where the PRIMARY engine is InnoDB and SECONDARY engine is MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...This ...