PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
Performing point-in-time recovery of NDB Cluster tables with NDB Cluster and NDB Cluster Replication can be accomplished using a native NDB data backup (taken by issuing CREATE BACKUP in the ndb_mgm client) and restoring the ndb_binlog_index table ... Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Applications using the cluster and user of those applications must not be permitted to have direct access to the management and data node hosts. In this section, we discuss basic network security issues as they relate to NDB Cluster. It is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
When some code creates a mutex, a row is added to the mutex_instances table. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. Pre-filtering ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
If a user attempts to do so with UNINSTALL PLUGIN, an error occurs. For example, if the plugin implements a storage engine, existing tables for the storage engine become inaccessible, and attempts to create new tables for the storage engine result ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the replication source servers using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication metadata repositories, and provisioned the ...Use ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
server_uuid In MySQL 5.7, the server generates a true UUID in addition to the server_id value supplied by the user. If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary. The following ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing products. Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() ... You can use ...