PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
To use CHANGE MASTER TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). When this is true for all replicas, they can be reconfigured to the new setup. During this procedure, do not forget to ...The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
When binlog_format=STATEMENT is set, a warning is issued for DML statements inside XA transactions. When binlog_format=MIXED or binlog_format=ROW is set, DML statements inside XA transactions are logged using row-based replication, and the potential ...For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
When binary log events were written in row-based format and you want to read or recover from a replication or database failure you can use this command to read contents of the binary log. For other scenarios, setting slave_exec_mode to STRICT is ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
Communication latency between these processes can directly affect the observed performance and latency of user queries. When setting timeout values such as HeartbeatIntervalDbDb and HeartbeatIntervalDbApi for NDB Cluster, care must be taken care to ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Also see Section 21.4.1, “Quick Test Setup of NDB Cluster”, for configuration examples using HostName with API nodes. We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 21.9 NDB Cluster with ...It ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/option-file-options.html
To work properly, each of these options must be given before other options, with these exceptions: --print-defaults may be used immediately after --defaults-file, --defaults-extra-file, or --login-path. (For information about the order in which ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ...Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. You can copy the files that correspond to a database table into some other location and perform recovery operations on them there. myisamchk ...