Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
The UUID is the identifier used by the server where the transaction originated, which is normally the value of server_uuid. CREATE FUNCTION GTID_SUBTRACT_UUID(gs LONGTEXT, uuid TEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs, CONCAT(UUID, ':1-', (1 ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
SHOW REPLICAS should be executed on a server that acts as a replication source. Host: The host name of the replica server, as specified on the replica with the --report-host option. User: The replica server user name, as specified on the replica ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Compilation Notes Configuration Notes InnoDB Notes Installation Notes Functionality Added or Changed Bugs Fixed Compilation Notes macOS: It is now possible to compile the server on MacOS using -DWITH_KERBEROS. (Bug #38042758) MySQL Server now ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
In theory, a patched server could be built that would tell the client program to transfer a file of the server's choosing rather than the file named by the client in the LOAD XML statement. In this environment, the client with respect to the MySQL ...As can be seen by the response from the server, 8 rows were imported into the test.person ...The tagname in the optional ROWS IDENTIFIED BY ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-24.html
Typically, the client would see Lost connection to MySQL server during query (CR_SERVER_LOST) or MySQL server has gone away (CR_SERVER_GONE_ERROR). In such cases, the server now writes the reason to the connection before closing it, and client ...If ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-external-auth-ref.html
Figure 15.5 External Authentication Settings: LDAP Table 15.4 LDAP Authentication Name Description Primary Server Hostname and Port Number Hostname or IP address of the primary LDAP directory server, and the Port number of the primary LDAP server.
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server (source) and applies the changes. There are two types of replication channels: Channels over public ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
Naming Conventions for Audit Log Files To configure the audit log file name, set the audit_log_file system variable at server startup. For best security, write the audit log to a directory accessible only to the MySQL server and to users with a ...
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/innodb-table-import.html
There are many reasons why you might want to import tables: To run reports on a non-production MySQL server instance to avoid placing extra load on a production server. To move a data to a server with storage media that is better suited to your ...