Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slavebaseconfig.html
Each replica must have a unique server ID, as specified by the server_id system variable. In addition to binary logging, this replication topology requires the system variable log_replica_updates to be enabled. If you are setting up multiple ...A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
You enable this encryption on a MySQL server by setting the binlog_encryption system variable to ON. The system variable sets encryption on for binary log files and relay log files. If you deactivate encryption by changing the binlog_encryption ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. If this limit is set to zero, the global max_user_connections system variable value determines the number of ...An “account” in this context corresponds to a row in the mysql.user system ...This limits the number of simultaneous connections that can be ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
When you create a FEDERATED table, the table definition is the same, but the physical storage of the data is handled on a remote server. A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
Group Replication is a technique that can be used to implement fault-tolerant systems. A replication group is a set of servers, each of which has a complete copy of the data (a shared-nothing replication scheme), which interact with each other ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
This directory is given by the value of the plugin_dir system variable. This directory is given by the value of the plugin_dir system variable. For the loadable function mechanism to work, functions must be written in C++ and your operating system ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. The MySQL Database Software is a client/server system that consists of a multithreaded SQL server that supports different ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-security.html
If set to "true" then, when establishing secure connections, the driver operates as if the 'sslMode' was set to "VERIFY_CA" or "VERIFY_IDENTITY", i.e., all secure connections require at least server certificate validation, for which a trust store ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-security.html
If set to "true" then, when establishing secure connections, the driver operates as if the 'sslMode' was set to "VERIFY_CA" or "VERIFY_IDENTITY", i.e., all secure connections require at least server certificate validation, for which a trust store ...
https://dev.mysql.com/doc/refman/8.4/en/error-interfaces.html
The warning_count system variable indicates the number of errors, warnings, and notes (with notes excluded if the sql_notes system variable is disabled). Error messages can originate on the server side or the client side, and each error message ...