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-multi-source-provision-replica.html
The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the replica. For example: sed '/GTID_PURGED/d' dumpM1.sql > ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
Another important difference in --binlog-do-db handling for statement-based logging as opposed to the row-based logging occurs with regard to statements that refer to multiple databases. Important Before enabling this variable, you must make certain ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the INSERT statements are replayed. Once the data dump has been completed, import this data into the replica ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/updating-yum-repo.html
Among other instructions discussed there, it is especially important to back up your database before the update. Important For important information about upgrading from MySQL 5.6 to 5.7, see Upgrading from MySQL 5.6 to 5.7. For supported Yum-based ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
Important The default setting, --ssl-mode=PREFERRED, produces an encrypted connection if the other default settings are unchanged. However, to help prevent sophisticated man-in-the-middle attacks, it is important for the client to verify the ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
It is also important to check the output being sent back to the client. Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. For NDB tables, it is also possible to change the storage type used for a table or column. row ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
Important By default, rule-based audit log filtering logs no auditable events for any users. This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
The MySQL binary logs are important for recovery because they form the set of incremental backups. This incremental backup is important, so it is a good idea to copy it to a safe place. A full backup (a snapshot of the data at a point in time) can ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
Important To help prevent sophisticated man-in-the-middle attacks, it is important for the replica to verify the server’s identity. ] CHANGE MASTER TO changes the parameters that the replica uses for connecting to the replication source server, ...