Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-schema-standard-rules.html
The following are the MySQL Schema Standard compliance rules: Server-Enforced Data Integrity Checking Disabled Server-Enforced Data Integrity Checking Not Strict Server-Enforced Data Integrity Checking Disabled Description SQL Modes define what SQL ...Note that any client can change its own session SQL mode value at any ...However, to ensure the highest level of confidence for data integrity, at least one of the following should be ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
This is another way to transfer data from one MySQL server to another while performing a migration, and it complements the existing solutions. This avoids the need to traffic all data through MySQL Workbench, or to have a permanent network ... This ...The bundled sakila_full model now uses a dedicated 5.7 version to allow for 5.7 specific features, regardless of the version setting in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump --tab=/tmp db1 The .txt files containing table data are written by the server, so they are owned by the system account used for running the ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-authentication.html
LDAP authentication requires use of a server from a MySQL Enterprise Edition distribution. This package now is required only on hosts where Connector/C++ applications make connections using commercial MySQL server accounts with LDAP authentication.
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
For subsequent server restarts, the loader service loads any components listed in mysql.component during the startup sequence. The loader service also unregisters the components from the mysql.component system table so that the server no longer ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview.html
Thus, in a payroll application storing data in a cluster, if one application updates the salary of an employee, all other MySQL servers that query this data can see this change immediately. NDB Cluster integrates the standard MySQL server with an ...
https://dev.mysql.com/doc/refman/8.4/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. For answers to a number of questions that are often asked concerning the MySQL Database Server and its capabilities, see ...MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed ...MySQL is a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-failover.html
You can use the following query to obtain the needed records from the ndb_binlog_index table on the source: mysqlS'> SELECT -> @file:=SUBSTRING_INDEX(next_file, '/', -1), -> @pos:=next_position -> FROM mysql.ndb_binlog_index -> WHERE epoch = ...This ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
You set and manage source lists using the asynchronous_connection_failover_add_source and asynchronous_connection_failover_delete_source functions to add and remove single replication source servers. To add and remove managed groups of servers, use ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-configuration.html
Server Configuration Client Configuration Client Configuration Example Server Configuration The following are the server trace telemetry configuration variables: telemetry.trace_enabled System Variable telemetry.trace_enabled Scope Global Dynamic ...